Attributes: Sheet Attributes

Before you begin

This section describes the XLSX stucture for importing attributes and attribute groups.

Follow these guidelines to properly structure your attribute file. To follow along, feel free to download an example file.

Important
  • This sheet is required for Attributes and Attribute Groups import.
  • All columns must be present in the sequence specified below.
  • Do not change/translate the names of the columns.
  • Allowed names for this sheet: Attributes

Spreadsheet structure

Here is a list of every column in the sheet Attributes.

To follow along, feel free to download an example file.

Column Letter Column Name Extra Info Allowed Values Required
A Attribute ID If you have an existing attribute in your store with this Attribute ID, it will be overwritten. If left empty, the attribute will be imported as a new attribute. Integer number
Minimum: -2147483647
Maximum: 2147483647
(Conditional)*
B Attribute Name Text Yes
C Attribute Group A valid Attribute Group ID. See Attribute Groups sheet, column A for allowed values.

Integer number
Minimum: -2147483647
Maximum: 2147483647
Yes
D Sort Order Integer number
Minimum: -2147483647
Maximum: 2147483647
No
Note* (Conditional) fields accept empty values for the purposes of an ExcelPort import. There are cases when you might need a value for this field. More information in column Extra Info.