ExcelPort 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
Structure of the sheet
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 IDs. Example: 10,42 | Refer to Column A from a product export for allowed values. | No |
| J | Categories | Comma-separated Category IDs. 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.