- Download the template CSV file from (this link) or from the console (Manage -> Coupons -> Import/Export)
- Fill in the coupons in the correct columns and rows using the below format.
CSV Template Details
| Title | Description | Required? | Sample Data |
|---|---|---|---|
| discount reference | Reference to the discount that will be applied with this coupon. You should create an order level discount first from Manage > Discounts. |
Yes | d001 |
| name | The name of the coupon. | Yes | 10% Off |
| code | The code that will be used by the customers to redeem the coupon. The code can only contain letters and numbers. | Yes | Off10 |
| is active | Whether this coupon can be used or not. | Yes |
YES or No
|
| maximum uses | The maximum number of times this coupon can be used. | Yes | 25 |
| from date | The start date in which the coupon will be valid. Must follow the format “YYYY-MM-DD”. | Yes | 2020-07-30 |
| to date | The expiration date of the coupon. Must follow the format “YYYY-MM-DD”. | Yes | 2020-08-03 |
Saving Import files as CSV / UFT-8 Format
In the program you're using (e.g. Microsoft Excel) Choose Save As, then select Save as CSV UTF-8 (.csv) file format.
> Important: You must insure the Character Set Encoding is UTF-8.
Otherwise, some characters that are created with Microsoft Software may not display correctly, due to incorrect Character Set Encoding. For example you may see:
- Café, Instead of Café
If you see these invalid Characters in your CSV file then save your file in UFT-8 Format, or Upload your Modifier Options then Edit Option Names in Foodics to replace the incorrect characters from the console.
Import your CSV file to The Console in (Manage > Coupons)