How to import products in Magento 2?

How to make Magento 2 file upload process more effective?

Magento 2 file upload process could ruin all your time-management plans without CSV. The Comma Separated Value file allows for saving a lot of time spent on importing/exporting a massive amount of data. By using the file, you can easily transfer other types of data like customer data, customer address data, product images, etc.

We will now look at how to import products CSV in Magento 2.


 

Helpful tip: If you want to connect your Magento 2 store with other sales channels, our Product Feed extension can help you automate product data export by generating ready feeds for different platforms.


 

Magento 2 import products with images

  • Log in to the Admin Panel, navigate to System>Import:

magento-2-import-products-tab

  • Choose Products in the Entity Type drop-down menu and click Download Sample File:

magento-2-product-import-download-sample-file

  • The downloaded CSV file looks like this:

magento-2-product-import-sample-file

  • Choose the sample products you need to import and delete all the odd ones. To import product images you need to add the next rows to the Magento product CSV sample file:

base_image;

base_image_label;

thumbnail_image;

thumbnail_image_label;

small_image;

small_image_label.

If one of the rows already exists in the Magento 2 product import CSV sample file, don’t add them again.

  • Then upload the product images to the Magento 2 pub/media/import folder. All the uploaded images should have the same name as in the CSV file.

  • When the CSV with products is ready, you need to upload it to Magento. For this, return to System>Import>Entity Type>Products, choose Add/Update from the Import Behavior drop-down menu:

magento-2-product-import-choose-update

  • Click the Choose file option and type /pub/media/import in the Image File Directory text field. Then choose the Check Data option.

  • Having received the validation results notification, click Import.

  • When the product import is finished go to Products>Catalog and check the products with the images are displayed on the product grid. Don’t forget to make the products live in-store - Enable Product Toggle:

magento-2-product-import-enable-toggle

To manage all the import/export activities effectively, use the Import History tab. For this, navigate to System>Data Transfer>Import History. You will see a separate grid with all the import/export activities:

magento-2-product-import-history

To import products with images in bulk, you need to delete all the sample products from the CSV file and insert your own ones with all the attribute details. To see a complete list of all the attribute references (store_view_code, attribute_set_code, product_type, etc.), follow the link.

If you need to import numerous configurable products, continue with the Magento 2 import configurable products to learn how to make it in 3 easy steps.

How can we help you?

Didn’t you find the answer to your question? We are always happy to help you out.