ExcelPort Orders: Sheet Vouchers
Before you begin
This section describes the XLSX stucture for importing order vouchers.
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: Vouchers
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 Voucher ID | If you have an existing order voucher in your store with this Order Voucher ID, it will be overwritten. If left empty, the order voucher will be imported as a new order voucher. | Integer number Minimum: -2147483647 Maximum: 2147483647 |
(Conditional)* |
| B | Order ID | The order to which this voucher is associated. | See Orders sheet, column A for allowed values. Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes |
| C | Voucher ID | The database ID of an existing voucher. Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes | |
| D | Description | Text | No | |
| E | Code | Visit OpenCart Admin > Sales > Vouchers and see column Code for allowed values. | Yes | |
| F | From Name | Text | Yes | |
| G | From E-mail | A valid e-mail address. | Yes | |
| H | To Name | Text | Yes | |
| I | To E-mail | A valid e-mail address. | Yes | |
| J | Voucher Theme ID | The database ID of an existing voucher theme. Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes | |
| K | Message | Text | Yes | |
| L | Amount | Decimal point must be a dot, not a comma. Example: 10.99 | Floating point number | 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.