Discount codes can be used to apply the discount to selected products at the checkout. If you want to apply the discount to the whole cart, you can upload coupons.

For example, if you want the discount to be applied exclusively to adult tickets (but not children one).

1. Discount vouchers can be uploaded via Codes within the Venue section. Go to the Vouchers tab and click on the Choose a file button below. 

Vouchers 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:

code, valid_from, valid_to, percentage_reduction, flat_reduction, article_id, unlimited, amount, remainder_usable, validity_period_from, validity_period_to

Whereas:

code               Can be any combination of numbers and letters of at least 4 characters 

valid_from  in YYYY-MM-DD format

valid_to       in YYYY-MM-DD format

percentage_reduction number without the % sign as in 50 = 50%, 100 = 100%

flat_reduction number without a currency and please use a point for fractions

article_id list of product ID's separated by | (pipe)

unlimited Unlimited by putting a 1 if this is true or 0 if this is false.

amount    This parameter indicates the number of articles to which the code applies. The number of articles depends on the articles identified in the article_id field. For example, if you have added 1 product ID in article_id and the amount is set to 1, the discount will be applied to the selected product. However, if you have added 5 product IDs in article_id and the amount is still 1, the discount will be applied to all 5 products.

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. The new remainder voucher will be part of the ticket download.
Be aware: To enable remainder_usable, the voucher must be limited-use and can not be unlimited. Additionally, remainder_usable only works with flat reductions and not with percentage reductions.

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.

If a voucher code can be used for multiple products, separate the IDs with a pipe.

Make sure that there are no duplicate codes in your file, as this will result in an error. In order to avoid this, we strongly suggest that you run a quick check by using the 'remove duplicates' function in Google Sheets. Simply go to 'Data' on the top menu and then find 'remove duplicates'. 

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 Euros. 2.5 will be 2,50 euro. 

We can validate multiple article IDs for one barcode. Therefore, you can include your product IDs as 2035|2036.

You can find the corresponding product IDs from the “I already have tickets” or “I already have season pass” flows in the same section. 


To clarify, here is an example of a file:

In this example, the voucher has the code POSTOPENINGFIESTA, is valid from the 01. of May till the 31. of May, has a 15% percentage reduction and no flat reduction on the article with the ID 2091, can be used for an unlimited amount of times and its remainder is not usable.  

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 are recommending you to use Google Sheets for this purpose. If you still would like to use Excel, note that it can choose a separator based on the locale.

If you are using Excel anyway, we found comprehensive instructions for Windows users to follow in this case:

  1. Make sure Excel is closed
  2. Open the Control Panel on your Windows computer!
  3. This can be done by hitting win+r and writing “Control Panel” in the Run-window
  4. Select the Region
  5. Click the Additional Settings 
  6. Find the List separator and change it to a comma (“,”).
  7. Click OK -> OK -> exit Control Panel
  8. Open the Excel file you want to export to a comma-delimited file
  9. Select File, Save As
  10. Change the ‘Save as type’ to ‘CSV (Comma delimited)(*.csv)’
  11. Change the name and file extension if you want, by default stays as CSV even though a different delimiter
  12. Click Save -> OK -> Yes
______________________________________________________________________________________________________________


2. Once you choose the correct file to upload from your computer your 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!

 

Letters with diacritical marks

We don't support diacritical marks on letters. So the combinates below are not supported

  1. Acute Accent (´):
    á, é, í, ó, ú

  2. Grave Accent (`):
    à, è, ì, ò, ù

  3. Circumflex (^):
    â, ê, î, ô, û

  4. Tilde (~):
    ã, ñ, õ

  5. Umlaut or Diaeresis (¨):
    ä, ë, ï, ö, ü, ÿ

  6. Cedilla (¸):
    ç

  7. Macron (¯):
    ā, ē, ī, ō, ū

  8. Breve (˘):
    ă, ĕ, ĭ, ŏ, ŭ

  9. Caron or Háček (ˇ):
    č, š, ž

  10. Dot Below (·):
    ȧ, ḃ, ċ

  11. Dot Above (·):
    ẇ, ṗ, ṡ

  12. Ring (˚):
    å, å̄