Coupons: Sheet Coupons

Before you begin

This section describes the XLSX stucture for importing coupons.

Follow these guidelines to properly structure your coupon file. To follow along, feel free to download an example file.

Important
  • This sheet is required for Coupons 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: Coupons

Spreadsheet structure

Here is a list of every column in the sheet Coupons.

To follow along, feel free to download an example file.

Column Letter Column Name Extra Info Allowed Values Required
A Coupon ID If you have an existing coupon in your store with this Coupon ID, it will be overwritten. If left empty, the coupon will be imported as a new coupon. Integer number
Minimum: -2147483647
Maximum: 2147483647
(Conditional)*
B Coupon Name The name of your coupon. It helps you identify the coupon in the OpenCart admin panel. Text Yes
C Code The code your customers enter in the shopping cart. Text
From 1 to 20 characters.
Yes
D Type Set P for percentage coupon, or F for fixed-price coupon. No other values are allowed. P, F Yes
E Discount Decimal point must be a dot, not a comma. Example: 10.99 Floating point number No
F Total Amount Decimal point must be a dot, not a comma. Example: 10.99 Floating point number No
G Customer Login Any value different than Yes will be regarded as No Yes / No No
H Free Shipping Any value different than Yes will be regarded as No Yes / No No
I Products Comma-separated Product ID's. Example: 10,42 Refer to Column A from a product export for allowed values. No
J Categories Comma-separated Category ID's. Example: 8,33,15 See Meta sheet, column A for allowed values. No
K Date Start Example: 2017-01-31 Date
Format: yyyy-mm-dd
No
L Date End Example: 2017-01-31 Date
Format: yyyy-mm-dd
No
M Uses Per Coupon Integer number
Minimum: -2147483647
Maximum: 2147483647
No
N Uses Per Customer Integer number
Minimum: -2147483647
Maximum: 2147483647
No
O Status Any value different than "Enabled" will disable the coupon. Enabled / Disabled No
P 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.