ExcelPort Products in Bulk Mode: Sheet Option
Before you begin
This section describes the XLSX stucture for importing products in Bulk mode. Note that you may also use Basic mode, or Grouped mode.
- Using this sheet is not obligatory. ExcelPort will work even if this sheet is missing, as long as you have a sheet for Products.
- If this sheet is missing, ExcelPort will not alter existing product options. On the other hand, if this sheet exists and has no rows, all product options (for products contained in the sheet Products) will be deleted!
- All columns must be present in the order specified below.
- Do not change/translate the names of the columns.
- Allowed names for this sheet: Option
Structure of the sheet
Here is a list of every column in the sheet Option.
To follow along, feel free to download an example file.
| Column Letter | Column Name | Extra Info | Allowed Values | Required |
|---|---|---|---|---|
| A | Product ID | The value here must correspond to column A from the Products sheet. This field is required only for the rows having an Option in column B. For more info, refer to the examples below. | Integer number Minimum: -2147483647 Maximum: 2147483647 |
(Conditional)* |
| B | Option | This field is required to associate an option with a Product ID in column A. Leave this field empty for every subsequent row containing option values in column D. For more info, refer to the examples below. | A valid Option name. See Meta sheet, column O for allowed values. | (Conditional)* |
| C | Required | Any value different than "Yes" will be regarded as "No". | Yes / No | No |
| D | Option Value | If the main option type is either Select, Radio or Checkbox, make sure all of your option values already exist in your store. To see the available option values for each option, visit Admin > Catalog > Options. | Use a valid Option Value name if the main option type is either Select, Radio or Checkbox. Insert textual data if the main option type is either Text, Textarea, File, Date, Time or Date & Time |
(Conditional)* |
| E | Quantity | Integer number Minimum: -2147483647 Maximum: 2147483647 |
No | |
| F | Subtract Stock | Any value different than "Yes" will be regarded as "No". | Yes / No | No |
| G | Price | Decimal point must be a dot, not a comma. Example: -10.99 | Floating point number. It can be preceded by either + (plus) or - (minus). | No |
| H | Points | Integer number Minimum: -2147483647 Maximum: 2147483647 It can be preceded by either + (plus) or - (minus). |
No | |
| I | Weight | Decimal point must be a dot, not a comma. Example: -10.99 | Floating point number. It can be preceded by either + (plus) or - (minus). | No |
Example #1: All option values in a single option
Notice that column A (Product ID), B (Option) and C (Required) are empty on rows 3, 4 and 5. This is becase there are corresponding option values in column D.
Example #2: More than one option with option values
Notice that column A (Product ID), B (Option) and C (Required) are empty on rows 3 and 5. This is becase there are corresponding option values in column D.
"Checkbox 1" and "Checkbox 2" are imported as option values for the option "Checkbox" in B2.
"Checkbox 3" and "Checkbox 4" are imported as option values for the option "Checkbox" in B4.
Example #3: Option with text for an option value
If the main option type is either Text, Textarea, File, Date, Time or Date & Time, you may insert textual data as the option value:
