The enhanced product import possibilities of Magento 2 allow to upload goods in a faster and more flexible manner, than in the previous version. Nevertheless, It is a good idea to use a Magento 2 product import tutorial to ensure the process goes smoothly.
You can use this article to learn how to import products in Magento 2.
To avoid CSV errors, download sample import file and prepare the file according to the required format.
Bear in mind, that it is not necessarily to include the whole list of fields contained in the CSV sample. Product import is also possible, if you add only the required ones.
The file size limit is determined by settings in the php.ini file on your server. Magento default import file size is 2MB.
Import Behavior Settings
Select Import Behavior action:
Add/Update - create new products or update the existing ones (you can update any product detail except SKU)
Replace - replace the existing products data with data contained in the import file
Delete - remove the products whose SKUs match products from the spreadsheet
Specify whether you want the import process to pause, if an error occurs. Also, set the number of errors allowed before the import stops.
After that, select Field separator, Multiple Value Separator and Empty attribute value constant.
It is recommended to check 'Fields Enclosure' box to prevent incorrect data import. For example, such characters as equal sign, space, ampersand, etc can cause some troubles during import. Though if you check the box, Magento will enclose them into additional double quotes.
File Upload
Press on 'Choose file' button and select the prepared CSV.
In case you want to upload images
as well, enter the path to folder with media into 'Images File Directory' field.
CSV Validation
Press 'Check data' button for Magento to validate the CSV format.
Once you get the 'File is valid' message, tap on 'Import' button.
The 'Import successfully done' message means that the products were successfully added/ updated in your Magento 2.
In case you bumped into an error, you can find solution in this article - Magento Import: 101 Questions and Answers.
Store Manager simplifies Magento 2 product import with the help of Import Wizard. The tool guides you through the process in a step-by-step manner allowing to easily move back and forth the import stages. Also, it allows to preview the file just before uploading it to the database.
To upload products to Magento 2 using Store Manager, follow these steps:
From Store Manager toolbar press on Import/Export wizard and select Products from the dropdown.
Launch Import Wizard with Store Manager
Select 'Import' action.
Select Products Import
Choose the file with products from directory and select the file charset
Select File for Import with Store Manager
Set up the delimiters to separate fields data
Import File Delimiters
Select the delimiters for file details separation
Set Fields Delimiters
It is possible to import images along with products. To do that, input the path to file with images into Local directory with images field.
Check to what storeviews you want to import products.
Select Store View for Import
In case you import date and time values, configure their formats and separators. If not, you can leave them as they are.
Date and Time Format Options
For Store Manager to understand whether a product already exists in the database or need to be created, specify how to identify products and their relations.
Import Identifiers Options
After that, map CSV columns to database fields. Here how you can do this: click on the database field on the left and after that click on the column name on the right. You can check whether the filed is assigned if you look at 'csv col' filed - it should contain the number of the columns assigned.
Assign Database Fields to csv Columns during Import
To autolink all fields to columns or unlink all of them, use the corresponding buttons.
At the Preview Import step check how the configured CSV looks like. If you notice some errors, move back to previous steps and check the configuration.
Preview Import Step
Select import method:
Add and modify - add new products and modify the existing ones
Add only - only add new goods and do not update existing ones
Modify only - update existing products and do not create new
Just add - create new products and do not search the existing ones
Select Import Methods
To reindex product data during the import, check the corresponding box and select the reindex method.
Check Reindex Options
Store Manager has an outstanding capability to automatically perform specific operations with the products after the import is finished by running SQLs. You can tell the application what to do by adding SQL tasks or choosing among the offered actions.
Run Custom SQL after Import Option
If necessary, you can save the import configuration and upload it during the next import.
Save Import Configuration
To start running import, press 'Import' button.
The import configuration that you saved at this step can be used to set up automated product import. For more information on how to set up automated scheduled import, check the documentation.
You can test Store Manager import possibilities by getting a free trial 14-days version.
Try importing products with Store Manager for free - Try Now
