ExcelPort Orders: Sheet Products
Before you begin
This section describes the XLSX stucture for importing order products.
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: Products
Structure of the sheet
Here is a list of every column in the sheet Products.
To follow along, feel free to download an example file.
| Column Letter | Column Name | Extra Info | Allowed Values | Required |
|---|---|---|---|---|
| A | Order Product ID | If you have an existing order product in your store with this Order Product ID, it will be overwritten. If left empty, the order product will be imported as a new order product, and it will be linked with any entries from the rest of the sheets (Options and Downloads). | Integer number Minimum: -2147483647 Maximum: 2147483647 |
(Conditional)* |
| B | Order ID | Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes | |
| C | Product ID | A valid Product ID. You may do a Product export to see all available Product IDs. Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes | |
| D | Product Name | Text | Yes | |
| E | Product Model | Text | Yes | |
| F | Product Quantity | Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes | |
| G | Product Price | Decimal point must be a dot, not a comma. Example: 10.99 | Floating point number | Yes |
| H | Product Total | Decimal point must be a dot, not a comma. Example: 10.99 | Floating point number | Yes |
| I | Product Tax | Decimal point must be a dot, not a comma. Example: 10.99 | Floating point number | No |
| J | Product Reward | Not used in OpenCart 1.5.1.3 | 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.