Product CSV structure
A full export of the product database contains information about each product in the catalog, and the relationships between them. Each record has fixed selection of columns that corresponds to the attributes in the catalog, although the order of the attributes is ignored during the import process.
The first row of the table contains the names of each attribute, which are used as column headers. The remaining rows describe the individual product records. Any row that begins with a value in the SKU column is the beginning of a new product record. A single product might include several rows that contain information about multiple images or product options. The next row that has a value in the SKU column begins a new product.
The category column contains a path for each category to which the product is assigned. The path includes the root category, followed by a forward slash (/
) between each level. By default, the comma ,
character is used to separate different category paths. (You can specify a different separator character with the Multiple value separator option.) For example:
Default Category/Gear,Default Category/Gear/Bags
To import data, you need to include only the SKU and any columns with changes. Any blank columns are ignored during the import process. It is not possible to add attributes during the import process. You can include only existing attributes.
For a detailed description of each product attribute, see Product CSV File Structure.
Column name | Description |
---|---|
_<name> | Column headers that begin with an underscore contain service entity properties or complex data. Service columns are not product attributes. |
<attribute_name> | Column headers with an attribute code or field name identify the column of data. A column might represent a system attribute, or one that was created by the store administrator. |