File Format - Item Option Value
Item Option-Value File Format
The first line of an Option Value CSV file must be the header row.
An option value instance is a group of rows in the CSV file that are sequential and include the same required fields. The first row of an option value instance must include fields specified under Base Headers and Multi-Column Headers. Additional rows of an option value instance may only include fields specified under Multi-Row Headers.
Required Headers
To successfully import an option value CSV file, the following columns must be included in the header row:
| Column Name | Description | Type |
|---|---|---|
Option Value ID (Required)* | Identification string for an option value. | string |
| Groups | May be required | See below |
Base Headers
The following headers are optional. Fields for these columns must be specified in the first row of an option value instance, otherwise data will be lost.
| Column Name | Description | Type |
|---|---|---|
Option Type ID | ID of the option type of which this is a possible value | string |
Sort Order | Sort order of the option type | integer |
Value | Value associated with this option value | string |
Category | ID of the option type category | string |
Category or Category N (Multi-Column) | ID of the option type category | string |
Groups
A group is a class of headers that relate to one another, and may allow for multiple pieces of information to be presented. For example, a customer can have multiple emails, addresses, phone numbers, and more.
Item option value groups include:
Localized Data (Required)
There are two ways that localized data can be formatted in your CSV file: A Multi-Row Approach or Multi-Column Approach.
Multi-Row Approach
In this approach, one set of column headers is used alongside multiple rows of data. To allow for multiple rows of data, additional rows must include the same Required Headers fields.
Multi-Column Approach
In this approach, multiple sets of column headers may be used alongside one row (the first row) of an option value instance. To use these columns multiple times, an identifying number must exist for N and be unique for every new set of columns.
Columns from the Multi-Row Approach cannot be mixed with columns from the Multi-Column Approach in a CSV file for the Localized Data group.
The following columns may be included:
| Multi-Row Approach Column Name | Multi-Column Approach Column Name | Description | Type |
|---|---|---|---|
Localized Presentation(Required)* | Localized Presentation N | Actual text displayed for the option value localized to the specified language | string |
Localized Language ID(Required)* | Localized Language ID N | ID of the language in which the record appears. Integers will be resolved to internal identifiers | integer, string |
Localized Name(Required)* | Localized Name N | Name of the option value localized to the specified language | string |
Where N is some positive integer.
Custom Attributes
There are two ways that custom attributes can be formatted in your CSV file: A Multi-Row Approach or Multi-Column Approach.
Multi-Row Approach
In this approach, one set of column headers is used alongside multiple rows of data. To allow for multiple rows of data, additional rows must include the same Required Headers fields.
Multi-Column Approach
In this approach, multiple sets of column headers may be used alongside one row (the first row) of an option value instance. To use these columns multiple times, an identifying number must exist for N and be unique for every new set of columns.
Columns from the Multi-Row Approach cannot be mixed with columns from the Multi-Column Approach in a CSV file for the Custom Attributes group.
The following columns may be included:
| Multi-Row Approach Column Name | Multi-Column Approach Column Name | Description | Type |
|---|---|---|---|
Custom Attribute ID | Custom Attribute N ID | Identifier of the custom attribute | string |
Custom Attribute Value | Custom Attribute N Value | Value of the attribute | string |
Custom Attribute Language ID | Custom Attribute N Language ID | Language of the attribute. Integers will be resolved to internal identifiers | integer, string |
Where N is some positive integer.
Option Values CSV Example
See the following Option Type CSV sample file.