Total Posts:
27
Karma:
131
Joined:
11/21/2012
Location:
United States
Is there any way to put related products on excel spreadsheet? Replace a column title for example.
Total Posts:
89
Karma:
535
Joined:
7/10/2009
Location:
United States
I find it way faster to just use the SQL SMS to insert For example: --------------------------- INSERT INTO [nop].[dbo].[RelatedProduct] ([ProductId1] ,[ProductId2] ,[DisplayOrder]) VALUES (1 ,2, 1), (1 ,3, 2), (1 ,4, 3), (1 ,5, 4), (1 ,6, 5) GO --------------------------- So in this scenario, product id 1 will be related to 2-6. In excel, you can create a formula something like this: ="("&A1&","&B1&","&C1&"),"
Total Posts:
27
Karma:
131
Joined:
11/21/2012
Location:
United States
Thanks Par6, Please direct me to the SQL SMS.
Total Posts:
89
Karma:
535
Joined:
7/10/2009
Location:
United States
http://www.microsoft.com/en-us/download/details.aspx?id=8961
Total Posts:
27
Karma:
131
Joined:
11/21/2012
Location:
United States
But there isn't a column for related products.
Total Posts:
590
Karma:
5284
Joined:
2/9/2010
Location:
United Kingdom
it is a table called RelatedProduct
Total Posts:
27
Karma:
131
Joined:
11/21/2012
Location:
United States
daveb, I am a true novice at this. Can you explain more about the "table"? Is that a part of the excel?
Total Posts:
590
Karma:
5284
Joined:
2/9/2010
Location:
United Kingdom
It's a table in the database. You cannot export related products to an excel spreadsheet ot of the box. You would need to add code to do that.
Total Posts:
7
Karma:
35
Joined:
11/28/2012
Location:
United States
This is a helpful solution to add related products. But my question is there a way you can download/export the product id in excel so it's easier to build the related products in an excel file. When I try exporting the products in excel using the admin tool, it doesn't give me the product id. Thanks.