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 in Magento 2

  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 Store Manager for Magento

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. Select Import Export Products Wizard Option

  3. Select 'Import' action.

  4. Choose Import Action

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

  6. Choose the CSV file to Be Imported

  7. Set up the delimiters to separate fields data


  8. Select the delimiters for file details separation

  9. Specify Delimiters For File Details Separation

    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.


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

  11. Check Storeviews to Update

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

  13. Configure Date And Time Formats and Separators

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

  15. Select Product Identification Method

    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 Fileds to CSV Columns

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

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

  17. Preview File Before Import

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

    Choose Import Method

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


    Reindex Data During Product Import


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

  20. Save Import Settings Configuration

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

When you're done with Magento 2 product import, you might consider uploading custom options as well. You can use this Custom Options Import guide to accomplish the operation in an errorless manner.

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:


Card image

Why Products Are Not Showing Up After Magento 2 Import?

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

Card image

How to Import Categories to Magento 2

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

Card image

How Import Configurable Products to Magento 2

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

Card image

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



COMMENTS
Be the first to comment.