Cross selling wizard request

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?

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.

Edited by geoff - 25-December-2007 at 10:32am