投稿総数:
27
カルマ:
131
参加:
2012/11/21
ロケーション:
United States
Is there any way to put related products on excel spreadsheet? Replace a column title for example.
投稿総数:
89
カルマ:
535
参加:
2009/07/10
ロケーション:
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&"),"
投稿総数:
27
カルマ:
131
参加:
2012/11/21
ロケーション:
United States
Thanks Par6, Please direct me to the SQL SMS.
投稿総数:
89
カルマ:
535
参加:
2009/07/10
ロケーション:
United States
http://www.microsoft.com/en-us/download/details.aspx?id=8961
投稿総数:
27
カルマ:
131
参加:
2012/11/21
ロケーション:
United States
But there isn't a column for related products.
投稿総数:
590
カルマ:
5284
参加:
2010/02/09
ロケーション:
United Kingdom
it is a table called RelatedProduct
投稿総数:
27
カルマ:
131
参加:
2012/11/21
ロケーション:
United States
daveb, I am a true novice at this. Can you explain more about the "table"? Is that a part of the excel?
投稿総数:
590
カルマ:
5284
参加:
2010/02/09
ロケーション:
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.
投稿総数:
7
カルマ:
35
参加:
2012/11/28
ロケーション:
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.