ExcelPort Orders: Sheet Totals
Before you begin
This section describes the XLSX stucture for importing order totals.
Follow these guidelines to properly structure your orders 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: Totals
Structure of the sheet
To follow along, feel free to download an example file.
| Column Letter | Column Name | Extra Info | Allowed Values | Required |
|---|---|---|---|---|
| A | Order Total ID | If you have an existing order total in your store with this Order Total ID, it will be overwritten. If left empty, the order total will be imported as a new order total. | Integer number Minimum: -2147483647 Maximum: 2147483647 |
(Conditional)* |
| B | Order ID | The order to which this total is associated | See Orders sheet, column A for allowed values. Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes |
| C | Code | This text depends on the extensions you have installed in Admin > Extensions > Totals. Common values are: sub_total, shipping, total, tax Other values are possible too depending on the installed extensions. | Text A valid OpenCart Total Code. |
Yes |
| D | Title | The title of the order total. | Text | Yes |
| E | Text | A textual representation of the price with the appropriate currency symbol. Example: $286.00 | Text | Yes |
| F | Value | The actual monetary value of the total, as a floating point number. Decimal point must be a dot, not a comma. Example: 286.00 | Floating point number | Yes |
| G | 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.