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.


Spreadsheet structure

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.