Related products

Is there any way to put related products on excel spreadsheet?
Replace a column title for example.

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&"),"

Thanks Par6,
Please direct me to the SQL SMS.

http://www.microsoft.com/en-us/download/details.aspx?id=8961

But there isn't a column for related products.

it is a table called RelatedProduct

daveb,
I am a true novice at this.  Can you explain more about the "table"?
Is that a part of the excel?

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.

Check nopAdmin plugin

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.