How can I upload a list of sales?

IWannaTicket allows you to upload a bulk CSV guest list into your event to more easily manage guest lists and ticket distribution. This is helpful if you have complimentary tickets you'd like to send out via email and don't want to create them one at a time.

To upload your guest list, go to your event. First check you have more tickets available for the tickets types you are uploading than you need to issue.

On the lower left side of your screen, under ‘actions’ you’ll see an ‘upload sales’ icon. Click into this.

To upload sales with multiple ticket types or if you want to capture information about each guest you need to create a CSV file in the following format.

Header

In the first row create your header. Your header row MUST include T (all in caps) in the first column. Next you MUST include the Ticket Id, followed by Quantity in the following column. This is followed by the additional fields which relate to the Sale (the payee), these are not compulsory but will help you identify who each sale belongs to. The standard fields are first name, last name, email and phone, if you have custom fields on the Payee level these can be included as well. In the following columns you can put additional fields required for each ticket type (if any).

Your finished header row will look something like this:

Data rows

Next you need to fill in the data you want to upload under each of these headings. 

T - This can be any alphanumeric code to indicate a new sale. They can be a basic sequence or if you’re transferring data from another system like a cms you can use an identifying code. This will form a searchable reference number (multiref) on the final order.

Each cell containing data will start a new sale, blank cells will be treated as another ticket within the sale above. In the example below the first and last sale have multiple tickets while the last sale just has one.

Payee Fields - The first set of fields relate to the sale, only the first row of answers is recorded, other rows can be left blank

TICKET - This needs to contain either the ticket type ID which you can find by clicking into your the reports menu for your and downloading the ticket types report, or if your ticket names are unique you can use the ticket name. Cells in the column cannot be left blank

Ticket fields - these are the details for each ticket. If a field relates to only one ticket type it only needs to be filled in for those tickets.

Your file should look like the below:

This will create 3 sales. Sale 1 will contain 2 tickets, will appear in the orders area under the name ‘Kate Test’ and the tickets in that order will be named ‘Kate Test’ and ‘Alex Test’. This order will also have a note that it was created via upload under the notes tab.

You will note we are only collection DOB for one ticket type.

When you have finished creating your file save it as a CSV and upload it using the uploader box. Your file will upload and process each sale individually so if you're uploading a large file it may take some time to process. You can close the uploader box and check the progress in the orders area.

If you require any further assistance, please get in touch via support@iwannaticket.com.au and your Account Manager will be able to provide additional information.