Can Magento bulk import related products?

[pracjen]

We have a "you might also like" functionality on the product page but at the moment it is done manual.

Is there a way that the Magento enterprise can do a bulk upload, when you upload the product you can specify the related products?

It would make life alot easier!

Thanks  

[magento_wire]

first, yes this can be done with Magento's Dataflow without the use of any extension.

Second, I would recommend taking one product, adding some related products to it in the Magento Admin, saving the product then exporting to CSV (System -> Import/Export -> Export).

You will notice two columns; _links_related_sku and _links_related_position

You will need to fill in those columns with the appropriate SKU. Please remember that each related product will need to be entered in a separate row (see screenshot).

This can be also done for cross-sells and upsells.

[pracjen · Accepted solution]

Great! that works - thank you! 

[juandejp]

Hi,

I have some doubts about this... hope the community can help me!

When I do the test and I export the CSV, products that have more than one related product (up to 4) dont appear in the spreadsheet, just one does it. Moreover, there are no additional columns to search for them. 

Do I have to create new columns for each related product? If a certain product already have a related product and I live it empty when importing the CSV... will that remove the previous related product? And the last one, do I need to import back all the information (columns) from the product or just create a CSV with the columns I would like to edit?

I apologise for so many questions but we have a database with more than 4000 products and I do not want to mess it up...

Thank you very much,

Juan.

[amee panchal]

Hello @pracjen 

First and mainly, without the usage of any extensions, this can be accomplished using Magento's Dataflow. Second, I recommend picking one product, adding some related items in Magento Admin, saving the product, and then exporting to CSV.

Import and export basic Magento 2

1. Choose the entity type to specify what kind of data will be imported/exported.
2. Decide how imported data will behave towards the store data (make sure to limit possible errors to keep default settings intact)
3. Upload a CSV file to import from, or Choose a CSV file type for data export.

I hope it will help you!