How to transfer products from Magento 1 to Magento 2

Advanced store management possibilities available in Magento 2 attract more and more users. Consequently, transferring product data from Magento 1 to Magento 2 becomes a common issue.

How to Migrate Products from Magento 1 to Magento 2?

The migration of products can be accomplished by the way of exporting products from Magento 1 and uploading them to Magento 2. You can use this tutorial to guide you through the export and import procedures in a step-by-step manner.

1. From Magento 1 panel go to 'System => Import/Export => Export'.




2. Select 'Products' entity from 'Export settings' dropdown.




3. Scroll down and check product attributes that you want to be exported. You can quickly find necessary attribute using filters.




4. When you are done with checking attributes, press 'Continue' at the bottom of the page.

Attributes & Attribute Sets

Before importing products to Magento 2, make sure to create there attributes and attribute sets identical to the ones that you use on Magento 1. If they don't match, there may arise multiple errors.

Bundle products

During product export in Magento 1, bundle products lose their product relations. Thus, you will need to add simple product options in manual way.

Also, Magento 1 does not export bundle product attributes including price_type, sku_type, weight_type, price_view, shipment_type, so you will have to add them manually to the CSV. Or you can avoid manual work if migrating with Store Manager for Magento.

In Magento, titles of some columns are changed, so before importing products to the newer version, you should first download Magento 2 sample import file and adjust the exported CSV to new requirements.

Here how you can download CSV sample:

1. From Magento 2 admin go to 'System' and under 'Data transfer' select 'Import'.




2. In the 'Import settings' select products entity type and click on 'Download sample file' button.

Compare the file with exported products from Magento 1 to the downloaded sample and modify it correspondingly.

1. From Magento 2 admin go to 'System' and under 'Data transfer' select 'Import' (look at the screenshot above).
2. In the 'Import settings' select 'Products' entity type.
3. Choose 'Import Behavior' option:





Add / Update - generate new products and update the existing ones
Replace - replace products whose SKUs match the ones included in CSV
Delete - remove items whose SKUs match the ones from the import file


4. Specify whether the import process should stop in case an error occurs. If yes, set the number of errors allowed before the import stops.




5. Specify the field separator, multiple value separator and empty attribute value constant.





It is a good idea to check 'Fields enclosure' box to avoid incorrect data import. With this option enabled, such characters as space, equal sign etc. will be enclosed by Magento into additional double quotes.

6. Choose the file to import.





To upload products with images, input the path to folder with media into 'Images File Directory' field.

7. Press 'Check data' button in the right upper corner.




8. If you get 'File is valid' message, press 'Import' to launch the process.




9. Once you receive the 'Import successfully done' message, then the products were correctly transferred from Magento 1 to Magento 2.