Importing Coupons using CSV

  1. Download the template CSV file from (this link) or from the console (Manage -> Coupons -> Import/Export)
  2. 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)

Leave a Reply

Related Posts