ExcelPort Coupons: Sheet History
Important
Using this sheet is optional. ExcelPort will work even if this sheet is missing, as long as you have a sheet for Coupons.
Structure of the sheet
Here is a list of every column in the sheet History.
To follow along, feel free to download an example file.
| Column Letter | Column Name | Extra Info | Allowed Values | Required |
|---|---|---|---|---|
| A | Coupon ID | The ID of the coupon for which this history entry applies. | Integer number See Coupons sheet, column A for allowed values. |
(Conditional)* |
| B | Order ID | If this coupon was used in an order, you may fill in the Order ID here. | Integer number Refer to Column A from an order export for allowed values. |
No |
| C | Customer ID | If this coupon was used by a register customer, you may fill in their ID here. | Integer number Refer to Column A from an customer export for allowed values. |
No |
| D | Amount | Decimal point must be a dot, not a comma. Example: 10.99 | Floating point number | No |
| E | Date Added | Example: 2017-01-31 | Date Format: yyyy-mm-dd |
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.