How to bulk import complimentary tickets "free tickets"

Introduction

The bulk ticket import feature allows you to upload large quantities of free tickets directly into the system in a single process, streamlining bulk ticket management.

Note: Only free tickets are imported via the ticket import. An additional payment request or the documentation of ticket prices is therefore not possible via a ticket import.

Important: Before starting any bulk ticket imports, please consult with your account manager. There are a few key considerations to review before proceeding. This may include creating a Secret Shop for distribution to ensure accurate reporting. Your account manager will also provide the correct fields required for your import:

eventId
underShopId
ticketTypeId

Summary

Please find the link below to download the Bulk Ticket Import Template. This template contains all required fields needed to successfully upload your complimentary tickets into the system.

Help Guide

Step 1. Completing the Bulk Ticket Import Template Correctly

Before completing the ticket import template, please consult with your account manager. We will need to ensure the ticket types are set up correctly, confirm whether a Secret Shop is required (and therefore if an underShopID needs to be provided), and supply you with the correct ticketTypeIDs before you begin.

Download the template Bulk Ticket Import Template
Columns highlighted in green are optional and can be deleted if not required.
Columns highlighted in red are mandatory and must not be deleted, if these are unknown, we suggest using the event details and completing each line accordingly.
One line must correspond to a single ticket. If several tickets are to be sent to the same customer, the tickets must still be stored in individual lines, including all mandatory data.
Download / save file as .csv

Important:

Country column must be completed with the correct country code

AU = Australia
US = United States of America

Each field that is stored in the file must be filled in. For example, if the Company is missing for some tickets, the field must be filled in with a placeholder (**)

Example:

In the example below:

Company name is not relevant for Peter Smith (line 3), so I used the placeholder ** to complete this field for a successful import.
Street, City, and Postal information were unknown, so I used the event details and made these the same for each ticket holder.

Step 2. Completing the bulk import process

Before you begin, double-check that your data is correctly completed and saved as a .csv file.

Via the Tickets module, click the Import button to open a new window
Name your import to identify the import job later (optional but strongly recommended)
Next to 'please choose a file first' click select and choose your import file (reminder: must be .csv)
CSV Separator (update only if required)
From the two options provided click customer data
Toggle Send out tickets via E-mail on. (Optionally, if you don’t want tickets emailed, you can leave this off.)
Optionally, toggle Import to CRM and Require personalisation and data fields on or off. (Generally, we suggest leaving these off.)
Optionally, click the Message field to enable a dropdown box, where you can customise a message
Connect the mandatory fields of your CSV file with the mandaory internal fields. If the fields of your CSV have already been named with the same wording, the mapping will be done automatically.
Grouping can aggregate rows, we suggest using email
Check all settings, especially the Send out tickets via E-mail option.
Click Import to complete

Note: to locate these Jobs later, open your user account settings (click your name in the bottom-left corner of the dashboard) then select Jobs.