Send out tickets in bulk

Modified on Thu, 16 May 2024 at 09:45 AM

The "Import" functionality makes it possible to send tickets in bulk. For this purpose, a CSV must be drawn up (see attachment) which can then be imported under "Tickets" via the "Import" button. This goes as follows:

1. Create the CSV file

In the template in the attachment (see the bottom of this article), each line is an individual ticket. To send multiple tickets to one person, a separate line must be added for each ticket.

The CSV has several columns. These are partly mandatory, and partly optional:

Required fields:

  • firstname = first name
  • lastname = last name
  • street = street (a space may also be entered)
  • city = city (you can also fill in a space)
  • postal = zip code (a space may also be entered)
  • country = country (this must be a two-letter country code, for example "NL" for the Netherlands)
  • email = e-mail address
  • eventId = the unique number of the event for which you want to send a ticket, which can be found in the URL of the "Overview" page of your event (the blue shaded area at the top of the screenshot below):

  • ticketTypeId = the unique number of the ticket type for which you want to send a ticket, which can be found in the gray box next to the ticket type (bottom right in the screenshot below). You can copy this by clicking on the gray frame:

Optional fields:

  • barcode = any barcode you want to provide, this must be unique
  • company = the company name
  • Some fields for assigning seats:
    • gaName = the name of the General Admission section
    • sectionName = the name of the section
    • groupName = the name of the group
    • rowName = the row name
    • seatName = the seat number

2. Importing the file

After the file has been supplemented with all tickets that need to be created, the file can be imported. This goes as follows:

  1. Go to "Tickets"
  2. Click on "Import" at the top right
  3. Give your import a name if necessary and select the CSV file created above
  4. Select "Customer data"
  5. Enable "Send out tickets via E-Mail" if you also want to send tickets directly by email
  6. If personalization is required for the tickets sent out, this can be enabled with "Require personalization and data fields"
  7. Check below whether all columns are linked correctly. If you have kept the top row the same in the CSV provided below, this should automatically go well.
  8. Click on "Import"

The tickets are now being created and sent out. When the import is complete, the status will change to "Completed". If some lines did not go well, part of the bar will turn red. To see what went wrong, you can click on the three dots on the right in the "Output" column, and then download the 'Failed' CSV or XLS. That document shows which rules have failed and also gives a reason for this.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article