Reservations are essential for your venue. They are used either for Business-to-Business reservations, undated tickets or for season pass or member pass reservations. Here, you can upload those codes in a CSV file that should be used to check if a reservation is valid.
In the case of ticket reservations, you need to upload the barcodes of your undated tickets.
For season passes or member cards, you need to upload the season pass or member numbers you issued.
For B2B reservations, you need to upload the codes you handed out to your business partners.
If you want to upload discount codes for an entire card, you need to upload coupons and for certain articles read more about vouchers.
You can upload & delete your codes via Codes in the Venue section within the menu on the left-hand side.
1. Go to the Reservations tab and click on the choose a file below.
Reservation codes 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:
barcode, valid_from, valid_to, article_id, unlimited
The Barcodes 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
article_id being the product ID of the Convious product of when it should be valid on
We can validate multiple article IDs for the one barcode. Therefore, you can include you product IDs as 2035 | 2036.
unlimited should be 1 for unlimited usage, such as season passes, and 0 for one-time use, such as day tickets
You can find the corresponding product IDs from “I already have tickets” or “I already have season pass” flows in the same section.
To clarify, here is an example of an excellent CSV file with the correct input:
But as you can see in Reservations, you can also download an example file to double-check yourself.
Further, please also make sure your CSV file is separated by commas and 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:
- 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 chose 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.
Uploaded the wrong file?
You can now always delete your previously uploaded files via the trash icon.
You might also be interested in: