Coupons can be used to apply the discount to the entire order. If you want to apply the discount for specific products, check our Discount Voucher manual.
For example, if you want to apply a 10% discount on the entire order.
Coupons can be uploaded in the Codes section in the menu. Go to the Coupons tab and click on the choose a file button below.
Index
- 1. Uploaded Discount Vouchers
- 2. Uploaded the Wrong File?
- 3. Code Reactivation Time
- 4. Letters with Diacritical Marks
1. Uploaded Discount Vouchers
Discount vouchers can be uploaded via Codes within the left-hand side menu. Go to the Coupons tab and click on the choose a file button below.
Coupons should be stored in a CSV formatted file. Here are the guidelines for making a csv file:
- Fields should be separated by a comma
- Every record should be stored in a separate line
- The first line of the file, must be a header line with a list of column names in the file
- Make sure the header list is delimited the same way as the rest of the file
- Make sure your file is encoded in UTF-8 format
The header line must have these columns:name, code, valid_from, valid_to, percentage_reduction, flat_reduction, reseller, max_uses, remainder_usable, validity_period_from, validity_period_to
name
Can be the same as code.
code
Can be any combination of numbers and letters of at least 4 characters.
Coupons are case sensitive.
valid_from
Has to be in YYYY-MM-DD format
valid_to
Has to be in YYYY-MM-DD format
percentage_reduction
number without % sign (50 = 50%, 100 = 100%)
flat_reduction
number without a currency. We will use your default currency.
Use a point for fractions.
reseller
Can be left empty.
max_uses
Max redemptions attempts allowed, leave empty or put 0 for unlimited.
remainder_usable
Put a 1 if you want the remainder of the voucher to be usable and a 0 if it should not be usable. This means if a customer uses 100 euro coupon to purchase 60 euros worth of tickets, a new 40 euro coupon will be generated. The new remainder coupon will be part of the ticket download. Be aware: To enable this, coupons must be limited-use.
validity_period_from
in YYYY-MM-DD format, defines restriction based on the visit date
validity_period_to
in YYYY-MM-DD format, defines restriction based on the visit date.
! Do not mix currencies in a file. For us the flat_reduction is in the default currency. If your default currency is Euro, 10 will be 10 Euro. 2.5 will be 2,50 euro.
To clarify, here is an example of file:
In this example the reduction for the Reopening 2021 campaign includes the code POSTOPENINGFIESTA is valid from the 01. of May till the 31. of May, has no percentage reduction but a flat reduction 15 Euro and is not applicable for resellers. It can be used twice and if not used entirely, its remainder will also be reusable.
In case you have different locations set up with Convious please submit us 1 file per venue and put the venue name in the file name.
NOTE: We recommend that you use Google Sheets for this purpose. If you still would like to use Excel, please note that the separator, in this case, the comma, is based on the locale/region that your device is set up in and, thus, may be different.
If you are using Excel, we found comprehensive instructions for Windows users to follow in this case:
- Make sure Excel is closed
- Open Control Panel*on your Windows computer!
- This can be done by hitting win+r and writing “Control Panel” in the Run-window
- Select Region
- Click the Additional Settings
- Find the List separator and change it to a comma (“,”).
- Click OK -> OK -> exit Control Panel
- Open the Excel file you want to export to a comma-delimited file
- Select File, Save As
- Change the ‘Save as type’ to ‘CSV (Comma delimited)(*.csv)’
- Change the name and file extension if you want, by default stays as csv even though a different delimiter
- Click Save -> OK -> Yes
____________________________________________________________________________________________________________
2. Once you choose the correct file to upload from your computer your then uploaded file will appear in the list of files and will be marked as Successfully processed. If it’s pending for more than a minute, try refreshing the page.
DONE!
2. Uploaded the Wrong File?
You can now always delete your previously uploaded files via the trash icon.
3. Code Reactivation Time
Voucher, coupon, reservation, and discount codes are temporarily blocked while the system waits for payment confirmation. If no confirmation is received, the system automatically frees up the capacity.
3.1 Standard Reactivation Time
- By default, codes are held for 4 hours before being reactivated.
3.2 New Option: 60-Minute Reactivation
To improve the customer experience, you can reduce the reactivation window to 60 minutes. Switching to this shorter reactivation time:
- Speeds up code availability for users.
- Reduces pressure on support teams by minimizing inquiries about blocked codes.
We recommend updating your settings to the 60-minute window. For help adjusting these settings, contact our support team at support@convious.com.
4. Letters with Diacritical Marks
We don't support diacritical marks on letters. So the combinates below are not supported
-
Acute Accent (´):
á, é, í, ó, ú -
Grave Accent (`):
à, è, ì, ò, ù -
Circumflex (^):
â, ê, î, ô, û -
Tilde (~):
ã, ñ, õ -
Umlaut or Diaeresis (¨):
ä, ë, ï, ö, ü, ÿ -
Cedilla (¸):
ç -
Macron (¯):
ā, ē, ī, ō, ū -
Breve (˘):
ă, ĕ, ĭ, ŏ, ŭ -
Caron or Háček (ˇ):
č, š, ž -
Dot Below (·):
ȧ, ḃ, ċ -
Dot Above (·):
ẇ, ṗ, ṡ -
Ring (˚):
å, å̄