Rating 0 stars - 0 votes

How to import products in Magento 2

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.

How to Import Products with the Default Magento 2 Importer

  1. From Magento 2 admin go to System => Import

  2. Product Import dashboard

    Import Settings & CSV Preparation

  3. Select entity type: Products

  4. Select Entity Type for Import

    To avoid CSV errors, download sample import file and prepare the file according to the required format.

    Download Product Import CSV Sample

    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

  5. 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

    Select Product Import Behavior Option

  6. Specify whether you want the import process to pause, if an error occurs. Also, set the number of errors allowed before the import stops.

  7. Specify Whether to Stop Import If Error Occurs

  8. After that, select Field separator, Multiple Value Separator and Empty attribute value constant.

  9. Specify CSV Product Import Separators

    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

  10. Press on 'Choose file' button and select the prepared CSV.

  11. Select CSV Import File

    In case you want to upload images as well, enter the path to folder with media into 'Images File Directory' field.

    CSV Validation

  12. Press 'Check data' button for Magento to validate the CSV format.

  13. Check CSV before performing Import

  14. Once you get the 'File is valid' message, tap on 'Import' button.

  15. File is Valid Message

  16. The 'Import successfully done' message means that the products were successfully added/ updated in your Magento 2.

  17. Import Successfully Done Message

Import products via the Store Manager for Magento Import Wizard

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:

  1. From Store Manager toolbar press on Import/Export wizard and select Products from the dropdown.

  2. Launch Import Wizard with Store Manager
    Launch Import Wizard with Store Manager

  3. Select 'Import' action.

  4. Select Products Import
    Select Products Import

  5. Choose the file with products from directory and select the file charset

  6. Select File for Import with Store Manager
    Select File for Import with Store Manager

  7. Set up the delimiters to separate fields data

  8. Import File Delimiters
    Import File Delimiters

  9. Select the delimiters for file details separation

  10. Set Fields Delimiters
    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.

  11. Check to what storeviews you want to import products.

  12. Select Store View for Import
    Select Store View for Import

  13. In case you import date and time values, configure their formats and separators. If not, you can leave them as they are.

  14. Date and Time Format Options
    Date and Time Format Options

  15. 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.

  16. Import Identifiers Options
    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
    Assign Database Fields to csv Columns during Import

    To autolink all fields to columns or unlink all of them, use the corresponding buttons.

  17. 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.

  18. Preview Import Step
    Preview Import Step

  19. 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
    Select Import Methods

    To reindex product data during the import, check the corresponding box and select the reindex method.

    Check Reindex Options
    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
    Run Custom SQL after Import Option

  20. If necessary, you can save the import configuration and upload it during the next import.

  21. Save Import Configuration
    Save Import Configuration

  22. To start running import, press 'Import' button.

  23. 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

    Related Articles:

    Why Products Are Not Showing Up After Magento 2 Import

    Why Products Are Not Showing Up After Magento 2 Import?

    Reasons of missing products after Magento import and their solutions. Read More...

    How to Perform Category Import to Magento 2 Tutorial

    How to Import Categories to Magento 2

    Detailed guide on Magento 2 category import withh CSV sample. Read More...

    how import configurable products to magento 2 article

    How Import Configurable Products to Magento 2

    Learn how to create configurable products / update them and assign existing simple products to configurable. Read More...

    How to Import Product Images to Magento 2 via Admin Tutorial

    How to Import Product Images to Magento 2

    Images import CSV sample and instructions on import of images from externatl URLs or local server. Read More...

    Be the first to comment.
Live Chat