Import a List of Products

This feature allows you to upload and import a bulk list of products into your store's catalog. By using a CSV file, you can quickly add multiple products with their details.
A CSV is a simple plain text file. Each line in a CSV file represents a row of data, with individual values separated by commas.
To upload a products list you must:

1. Navigate to Taxonomy > Products in the main menu.
2. Click [ v] at the right of the Create button.
3. Click on Import Products.

4. Select the CSV file from your disk and clic Ok. After uploading the file, the message will be displayed: my_products_file.csv file uploaded successfully.
5. Once the file is processed, an alert will appear at the top, over the bell icon [  ], allowing you to view the results of the process.

Structure of the CSV file

To import a set of products, the CSV file should have the following structure:

• The first line is a comma separated list of fields or columns
• The following lines are the products.

Import format details:

• Empty rows are ignored.
• Empty columns are ignored.
• The first row with data is taken as the headers row.
• Field headers are flexible supporting:
• • Case insensitive. For example: "Tax Code", "tax code", "TAX CODE", "tAX cODe" are equivalent.
  • Non letter or digit characters are accepted but removed. For example: "Tax Rate", "Tax-Rate", "Tax_Rate", "Tax Rate %", "TaxRate" are equivalent.
  • Unknown headers are ignored.

The available columns are:

• type: simple or configurable.
• sku.
• urlKey.
• name.
• description.
• shortDescription.
• enabled.
• categories: a comma separated list of Categories
• images: a comma separated list of Image URLs. Imported images won't have a role, it can be edited later.
• attributeSets: a comma separated list of the Attrinbute Families this product will belong. Attributes and Families are described in the Attributes and Attribute Families section.
• configurableAttrs: in case the product is configurable, a list of variants should be set. The variants will be defined by combining the different configurable attributes.
• taxClass: the Product Tax Class Id.
• useVariantPrices: 'yes' to use Variant prices for configurable products.
• inheritParentPrices: 'yes' to specify that variants which do not have a price, will use the main product price.
• combineVariantTiers: 'yes' to add together the quantities of all variants to determine the total quantity of products.
• related: a comma separated list of the SKUs of related products.
• upsells: a comma separated list of the SKUs of upsell products.
• crosssells: a comma separated list of the SKUs of cross-sell products.
• virtual: 'yes' if the product is virtual.
• giftcard: 'yes' if the product is a giftcard.

By adding the metrics Attribute Set, the following attributes can be included:

• width: width of the product in cm.
• height: height of the product in cm.
• depth: depth of the product in cm.
• volume: volume of the product in cm³.
• weight: weight of the product in Kg.

By adding any other Attribute Set, you can add any custom product attributes as needed, ensuring that the attributes correspond to the selected Attribute Set.