If you take orders in person, or market your event on other platforms, you can later import those tickets in bulk to your existing Ticket Tailor event, to manage everything simply and all in one place.
How to import tickets
Before you import tickets, you'll need
An existing event to import the tickets into.
Existing ticket types that you'd like to import tickets to.
Enough capacity for each ticket type to add the extra tickets to.
(For example, if I want to import 200 VIP tickets to my event, I'll need to make sure that I have a general admission ticket type with at least 200 tickets remaining).
A .csv file for each ticket type you want to import.
And finally, either a positive ticket credit balance or payment details set up.Tickets must be imported to an existing event or an occurrence.
How to import tickets
Open your event or occurrence, and click ‘Issued tickets’ from the left-hand menu.
Click ‘Import tickets’ at the top-right of the import tickets page.
Select ‘Choose file’ or drag and drop your .csv file into the importer, and click ‘Upload’.
Review your imported data. Any errors will be highlighted in red so that you can fix them and re-upload your file.
Click ‘Next’ if you're happy to import the tickets in your columns.
Select the ticket type to add your imported tickets to from the dropdown and click 'Import tickets'.
Your tickets will now appear in your ‘Issued ticket’ list for your event, with an import icon next to them so you can easily distinguish them from your orders.
How to organise your data for your .csv upload
Your CSV should have:
One ticket type per .csv.
One ticket per line.
Columns in the following order: attendee name, email (optional), reference (optional), barcode (optional).
You can leave optional columns blank if you don't wish to use them
If you leave the barcode column blank, we'll auto-generate a unique barcode for each ticket.
Your CSV can have a maximum of 1,000 rows.
Here is an example of what your CSV should look like:
Name | Reference | Ticket Code | |
Monica Life | Imported Order 1 | Barcode_01 | |
Erica Side | Imported Order 2 | Barcode_02 | |
Rita Need | Imported Order 3 | Barcode_03 | |
Tina See | Imported Order 4 | Barcode_04 | |
Sandra Sun | Imported Order 5 | Barcode_05 | |
Mary Long | Imported Order 6 | Barcode_06 | |
Jessica Hereiam | Imported Order 7 | Barcode_07 |
If you haven’t collected attendee emails, or don’t want to specify an external reference, you should leave the column blank. See an example below:
Name | Reference | Ticket Code | |
Monica Life | Imported Order 1 | Barcode_01 | |
Erica Side |
| Imported Order 2 | Barcode_02 |
Rita Need |
| Barcode_03 | |
Tina See | Imported Order 4 |
| |
Sandra Sun | Imported Order 5 | Barcode_05 | |
Mary Long |
|
|
|
Jessica Hereiam | Imported Order 7 | Barcode_07 |
How to import custom details with your tickets
To import custom details to your tickets, you can add extra columns to your CSV before you import it.
Your custom questions will be visible in the check-in app, and if you fetch your issued tickets via the API. Your custom details won't be available on the doorlist.
Here's an example of a CSV with custom details added:
Name | Reference | Ticket Code | Job title | When do you mambo? | |
Monica L | Imported Order 1 | Barcode_01 | Singer | In my life | |
Erica S | Imported Order 2 | Barcode_02 | Dancer | By your side | |
Rita N | Imported Order 3 | Barcode_03 | Performer | When you need | |
Tina S | Imported Order 4 | Barcode_04 | Actress | So you see | |
Sandra S | Imported Order 5 | Barcode_05 | Roadie | In the sun | |
Mary L | Imported Order 6 | Barcode_06 | Lyricist | All night long | |
Jessica H | Imported Order 7 | Barcode_07 | Instrumentalist | Here
|
How imported tickets can be used
They'll appear on your doorlist.
They'll appear in your check-in app.
Their barcodes can be scanned using your check-in app.
They'll appear in your total ticket counts.
You can send new ticket vouchers to your imported attendees using an email broadcast, or as you import them.
What imported tickets can't do
Add to your event revenue — you should account for this revenue separately.
Show on your ‘Orders’ page — you can access imported tickets in the Issued Tickets list.
Be included in a broadcast email to all attendees — if you want to do this, you'll need to make a copy of an existing broadcast and set the recipients as 'imported ticket holders'.
Be sold as seated tickets — you can take these off-sale manually from your 'Seating chart' tab in your event, and add the orders as a 'hidden' ticket type.
💡 Things to note
It costs 1 credit or PAYG charge for every 1 ticket imported, regardless of the price of the tickets.