Magento Commerce, 1.14.x

Import

Importing is available for all product types, except bundle, gift card, and downloadable products. You can import customer data, product data, and product images.

File Validation

During the file validation process, all attribute values are checked for conformance with the required data type (decimal, integer, varchar, text, datetime). Complex data, service data, and attributes with values from a defined set (such as a drop-down or multiple select), are checked to ensure their values exist in the defined sets.

For new entities, the presence of the required attribute values is checked. For existing entities, the presence of required attributes values is not checked, but if a required value is specified, it is validated by the attribute type.

To import customer or product data:

1. On the Admin menu, select System > Import/Export > Import. Then, do the following:
Import Settings
Import Settings
a. Set Entity Type to one of the following:
  • Products
  • Customers
b. Set Import Behavior to the way you want complex data to be managed if imported records already exist in the database.
  • Complex data for products includes categories, websites, custom options, tier prices, related products, up-sells, cross-sells, and associated products data.
  • Complex data for customers includes addresses.
c. Choose one of the following options:
  • Append Complex Data

    The new complex data will be added to the existing complex data for the existing entries in the database.

    Replace Existing Complex Data

    The existing complex data for the existing entities will be replaced.

    Delete Entities

    If entities that are imported already exist in the database, they will be deleted from the database.

d. At the Select File to Import field, click the Choose File button. Then, select the CSV file that you have prepared for import.
2. Click the Check Data button in the upper-right corner of the page. The system validates the file. If the file is valid, the corresponding message and the Import button appear. If some of the rows in the imported file are not valid and cannot be imported, the corresponding information is included to the message, but you can proceed with importing. The invalid rows will be skipped.
3. If needed, make corrections to the CSV file.
4. Click the Import button to import the data into the database.