Magento Open Source 2.3.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. The default size is 2MB.

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.

When importing product data, new product data is added to existing product data entries in the database. All fields except SKUStock Keeping Unit: A number or code assigned to a product to identify the product, options, price, and manufacturer. can be updated through import. All existing product data is replaced with the imported new data. Exercise caution when replacing data. All existing product data will be completely cleared and all references in the system will be lost.


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

    For products, you can update all fields except SKU through import.

    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.