Toggle Nav
My Cart 0

How to Import and Export Magento 2 Products using CSV ?

How to Import and Export Magento 2 Products using CSV ?

Are you having trouble in importing or exporting CSV products in Magento 2? We have come up with detail explanantion for this topics.

In this post we will provide you detail guide for:

(1) Magento 2 products csv import

(2) Magento 2 products csv export


Magento 2 products csv import

#1 Login to your magento admin.

#2 Go to SYSTEMImport.

magento 2 product import1

#3 Select Products from Entity Type Dropdown and then click on Download Sample link.

magento 2 product import2
magento 2 product import3

Your downloaded sample file will look like this :

CSV Sample

#4 Now add apropriate information for your new product in each row.

#5 For Products Images add the following rows in your CSV: Base_image, base_image_label, thumbnail_image, thumbnail_image_label, small_image, small_image_label.

#6 Upload all the images of the product in your Magento 2 pub/media/import folder.

Note: Make sure all the images that you upload have the same name as in CSV.

#7 Navigate to SYSTEMImport from the admin panel, select Products from Entity Dropdown, and Add/Update from Import Behaviour Dropdown.

magento 2 product import7

#8 Select the CSV file by clicking on choose file and enter /pub/media/import in the Image File Directory text field. Now just click on Check Data.

magento 2 product import7

#9 After your csv file will get checked you will see File valid message and one import button.

#10 Once you get to import successfully, go to PRODUCTSCatalog and you will see all your products.


Magento 2 products csv export

#1 Login to your magento admin.

#2 Go to SYSTEMExport.

magento 2 product export1

#3 Select Products from Entity Type Dropdown and CSV from Export File Format.

magento 2 product export2

#4 Exclude the unnecessary attributes from the list by selecting them and then click on Continue from the bottom of the page.

#5 Now you can upload this exported CSV to another store by following the steps mentioned in the Import Products part.

July 20, 2017
Did you like this post?
0
0