Magento Open Source 2.1.x

Import

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

  • Add/Update
  • Replace Existing Complex Data
  • Delete Entities

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.


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 Existing Complex Data

    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 Entities

    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.