How to Import Products in Magento 2

magento-2-tutorial
import
products

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: http://domain.com/images. 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


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

$199
17 reviews

Layered Navigation

$149
7 reviews

Affiliate

$149
7 reviews

FAQ

$149
10 reviews

Zoho CRM

$249
no review

Store Locator

$199
no review

Shop By Brand

$99
no review

Better Blog

FREE
7 reviews