Options: Sheet Options

Before you begin

This section describes the XLSX stucture for importing options.

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

Important
  • This sheet is required for Option import.
  • All columns must be present in the order specified below.
  • Do not change/translate the names of the columns.
  • Allowed names for this sheet: Options
  • This sheet must contain all of your store options.

Spreadsheet structure

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

Column Letter Column Name Extra Info Allowed Values Required
A Option ID If you have an existing option in your store with this Option ID, it will be overwritten. If left empty, the option will be imported as a new option. Integer number
Minimum: -2147483647
Maximum: 2147483647
(Conditional)*
B Option Name Insert a value to mark the beginning of a new group of option values. For more information, see the examples below. Text (Conditional)*
C Option Type Insert a value only on rows containing an Option Name. See examples below. One of the following:

Select / Radio / Checkbox / Image / Text / Textarea / File / Date / Time / Date and Time
(Conditional)*
D Option Sort Order Insert a value only on rows containing an Option Name. See examples below. Integer number
Minimum: -2147483647
Maximum: 2147483647
No
E Option Value ID If you have an existing option value in your store with this Option Value ID, it will be overwritten. If left empty, the option value will be imported as a new option value.

This option value will be associated with the closest Option Name. See examples below.
Integer number
Minimum: -2147483647
Maximum: 2147483647
(Conditional)*
F Option Value Name This field is required if the main option is one of the following types: Select / Radio / Checkbox Text (Conditional)*
G Option Value Image If your image file is placed in image/catalog/product/theimage.JPEG, insert catalog/product/theimage.JPEG (case-sensitive) Image path, relative to your image/ directory. The field is case-sensitive. No
H Option Value 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.

Example #1: All option values in a single option

Notice that column A (Option ID), B (Option Name), C (Option Type) and D (Option Sort Order) are empty on rows 3 and 4. This is becase there are corresponding option values in columns E:H.

option_combined

Example #2: More than one option with option values

Notice that column A (Option ID), B (Option Name), C (Option Type) and D (Option Sort Order) are empty on rows 3 and 5. This is becase there are corresponding option values in columns E:H.

"Small" (F2) and "Large" (F3) are imported as option values for the option "Radio" in B2.

"Medium" (F4) and "Large" (F5) are imported as option values for the option "Radio" in B4.

option_separate

Example #3: Options with no option values

If the main option type is either Text, Textarea, File, Date, Time or Date and Time, you do not need to specify option value entries in columns E:H.

option_no_value