Magento Commerce, 2.2.x

Import

Data for all product types can be imported into the store. In addition, you can import products, advanced pricing data, customer data, customer address data, and product images. Import supports the following operations:

  • Add/Update
  • Replace
  • Delete

The size of the import file is determined by the settings in the php.ini file on the server. The system message on the Import page indicates the current size limit.

Special characters — such as the equal sign, greater and less than symbols, single and double quotes, backslash, pipe, and ampersand symbols — can cause problems during data transfer. To ensure that such special characters are correctly interpreted, they can be marked as an “escape sequence.” For example, if the data includes a string of text such as code=”str”,code=”str2”, choosing to enclose the text in double quotes ensures that the original double quotes are understood to be part of the data. When the system encounters a double set of double quotes, it understands that the outer set of double quotes is enclosing the actual data.


Import

  • Import Behavior

    Operation

    Description

    Add/Update

    New product data is added to the existing product data for the existing entries in the database. All fields except sku can be updated.

    New tax classes that are specified in the import data are created automatically.

    New product categories that are specified in the import file are created automatically.

    New SKUs that are specified in the import file are created automatically

    Replace

    The existing product data is replaced with new data.

    Exercise caution when replacing data because the existing product data will be completely cleared and all references in the system will be lost.

    If a SKU in the import data matches the SKU of an existing entity, all fields, including the SKU are deleted, and a new record is created using the CSV data. An error occurs if the CSV file references a SKU that does not exist in the database. You can Check Data to display error.

    Delete

    Any entities in the import data that already exist in the database are deleted from the database.

    Delete ignores all columns in the import data, except for SKU. You can disregard all other attributes in the data.

    An error occurs if the CSV file references a SKU that does not exist in the database. You can Check Data to display error.