ExcelPort Orders: Sheet Options
Before you begin
This section describes the XLSX stucture for importing order options.
Follow these guidelines to properly structure your order file. To follow along, feel free to download an example file.
Important
- This sheet is required for Orders 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: Options
Structure of the sheet
Here is a list of every column in the sheet Options.
To follow along, feel free to download an example file.
| Column Letter | Column Name | Extra Info | Allowed Values | Required |
|---|---|---|---|---|
| A | Order Option ID | If you have an existing order option in your store with this Order Option ID, it will be overwritten. If left empty, the order option will be imported as a new order option. | Integer number Minimum: -2147483647 Maximum: 2147483647 |
(Conditional)* |
| B | Order ID | A valid Order ID. See Orders sheet, column A for allowed values. Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes | |
| C | Order Product ID | A valid Order Product ID. See Products sheet, column A for allowed values. Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes | |
| D | Product Option ID | A valid Product Option ID. You may do a Product export to see all available Product Option IDs. Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes | |
| E | Product Option Value ID | A valid Product Option Value ID. You may do a Product export to see all available Product Option Value IDs. Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes | |
| F | Option Name | Text | Yes | |
| G | Option Value | Text | Yes | |
| H | Option Type | One of the following: select / radio / checkbox / text / textarea / file / date / time / datetime |
Yes |
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.