How to Import Products in Magento 2


Magento 2.0 allows you to Import Products data to add or update the products, replace existing data and delete entities. This feature helps to save a lot of time compared with manual configuring. It is a fact that almost all of data in Magento is concluded in CSV file (Comma Separated Value file) which appears similar to Excel file but simpler. Therefore, we recommend you to become familiar with CSV file to import and export other types of data besides of products such as customer data, customer address data, and product images. And the following is the instruction to import products to your Magento store. Let’s begin!

Import Products

  • Step 1: Prepare the Data
  • Step 2: Configure Import Behavior
  • Step 3: Specify the Import File
  • Step 4: Check the Data and Finish the Importing
  • Step 5: View the Import History.

Step 1: Prepare the Data

  • On the Admin sidebar, choose System > Data Transfer > Import.
  • In the Import Settings section, set Entity Type to “Products” as you are importing product data.
  • After selecting the Entity Type, click Download Sample File. If you are prompted, click Save to start downloading the file.
  • Open to view the sample file.
  • Make sure that your CSV import file exactly follows the sample file.
  • Confirm that the size of your import file does not exceed the limit shown in the message which is usually informed to be 2M.
  • If the import data includes paths to product images, make sure that the image files have been uploaded to the appropriate location. The default location on the Magento server is pub/media/import. If the images reside on an external server, make sure that you have the full URL to the directory that contains the images. Import Products

Step 2: Configure Import Behavior

  • In the Import Behavior section, choose the action you want when importing data in the Import Behavior field: “Add/Update”, “Replace Existing Complex Data” or “Delete Entities”. Then set the following field to “Stop on Error” or “Skip Error Entries”.
  • In the Allowed Errors Count field, enter a number of errors to pause import process.
  • In the Field separator and Multiple value separator fields, leave the default as “,” since the default separator in CSV file is a comma. Import Products

Step 3: Specify the Import File

  • In the File to Import section, click on the Choose File button and choose your import data file, then click Open.
  • If the import data contains paths to product images, in the Images File Directory field, enter:
    • The path to the uploaded images on the Magento server. For example: var/import.
    • Or the full URL to the images on another server. For example: Import Products

Step 4: Check the Data and Finish the Importing

  • In the upper-right corner, click Check Data and wait for the process to complete.
  • If the file is valid, click the Import button shown in the Validation Results. Contrarily, correct the problem informed in the message and try again.
  • When the importing completes, there will be a message to notice you.

Step 5: View the Import History.

  • On the Admin sidebar, choose System > Data Transfer > Import History.
  • The import history detail table will show all the action of import/export for you to track. Import Products
Mageplaza One Step Checkout helps reduce the abandonment rate as well as increase the conversion rate dramatically. Mageplaza Layered Navigation brings a list of filters to help your customers search and get the favourite products in the shortest way. Mageplaza Social Login (FREE) supports 11+ types of social networks.

It comes to the end of tutorial: How to Import Products in Magento 2.

Please leave comments if you have any questions, feedbacks.

Comments for How to Import Products in Magento 2

You also may like these Magento 2 Extensions

One Step Checkout

18 reviews

Layered Navigation

11 reviews

Store Locator

2 reviews

Shop By Brand

no review

Zoho CRM

no review


10 reviews

Better Blog

7 reviews


7 reviews