Cross selling wizard request
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Suggestions
Forum Description: ProductCart Suggestions
URL: https://forum.productcart.com/forum_posts.asp?TID=128
Printed Date: 01-October-2024 at 1:16pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Cross selling wizard request
Posted By: geoff
Subject: Cross selling wizard request
Date Posted: 19-February-2006 at 8:30am
I have more than 1300 products in the store that I am putting together and the ability to upload the product database from an Excel file has been essential. Early Impact were first rate in providing me with techincal support to get me through a bump I had on the way. Thanks Guys In my Excel product database, I additionally have information on 3 products that I would like to automatically use to populate as associated cross selling. At the moment it seem v2.76 only supports configuring cross-selling product by product. Is there a way to do this through uploading from an Excel database to the ProductCart database? |
Replies:
Posted By: chris_b
Date Posted: 25-December-2007 at 8:25am
|
I am checking to see what people do to upload cross selling items with thier products? This would be great if there was a way, as we have many products that have cross sell items that need to be added and doing them product by product is very time consuming. Chris |
Posted By: geoff
Date Posted: 25-December-2007 at 9:04am
|
If you know how to use SQl you can do the following: Back up your database. Create a list of SQL statements in excel such as: insert into cs_relationships (idproduct, idrelation, num) values (2429,2430,1) Replace 2429 with the product # and 2430 with the Xsell product. Execute the SQl in Studio Express or similar. |
Posted By: chris_b
Date Posted: 26-December-2007 at 8:30am
|
Thanks for the info Geoff. I am not familiar with SQL, so I will check with my developer to see what he can do. Chris |