How to Import Products Data in Magento 2?
Tags magento product import csv sample magento product data magento import csv magento guide magento 2 tutorial magento 2 product import csv sample import products from a csv file import product data magento 2

Today, we’re going to teach you guys how to import products data in Magento 2.

In your Magento 2 store, you can import products data to either add, replace, or update data. This basically saves a lot of hassle and time compared to importing data manually.

That being said, let’s dive into the process of importing products data in Magento 2.

Steps to Import Products in Magento 2

Here are the step-by-step instructions to import products data in Magento 2.

Step #1 - Preparing the Data

Open your admin panel and go to System > Import.

Magento 2 Import

After that, select “Products” in the “Entity Type” in the import settings section.

check data

Then, click on the “Download Sample File” and “Save” to start downloading the file.

Once it is downloaded, open to view the file.

Csv

Now, make sure that your products data file follows the same format as this sample file exactly.

P.S. - Before submitting your data file, confirm that its size does not exceed the limit of 2M.

P.P.S. - If your file includes the path to product images, ensure that image files have been uploaded at the path before submitting the data.

Step #2 - Configuring Import Behavior

The next step of the process is to go to the “Image Behavior” settings, and the action you want when importing your products data file.

There are three options to select from:

  1. Add/Update
  2. Replace Existing Complex Data
  3. Delete Entities

import history

After that, set the next filed to either Skip “Error Entries” or “Stop on Error”.

Now, in the next “Allowed Errors Count” field, enter the number of errors at which you want the import process to pause.

Then, in the “Field Separator” and “Multiple Value Separator” fields, leave the “,” default value as it is because the default separator in a CSV file is a comma.

Step #3 - Specify the Import File

Go to the “File to Import”, click on the “Choose File” button, and then select the products data file you want to import and click “Open”.

Now, if your import data file has paths to product images, enter the path in the “Image File Directory” field as shown below:

var/import

Step #4 - Confirm Data & Finish Importing Process

Go to the upper right corner and click on the “Check Data” button and wait for the process to complete to confirm your products’ data.

After that, if it shows your file as valid, then click on the “Import” button in the “Validation Results”.

As the import process completes, it will notify you with a message.

Step #5 - View Import History

After the data has been imported, it’s time to view the import history.

For this, go to System > Data Transfer > Import History from the admin sidebar.

As you open the import history, it will display a table as shown below with all actions for you to track.

import history

And it’s done!

Conclusion

This is how you can easily import products data in Magento 2.

We hope that you found this tutorial helpful. If you have any doubts regarding this tutorial, please share them in the comments below.

And if you need our professional assistance, feel free to contact us at any time.