Import ticket data for a single event

You are able to import ticket orders data for a single event via the Events menu.

Before you get started

• You must first prepare the CSV file to import
• *Custom Fields also be mapped when importing Events + Orders (Bulk) and also Orders into a specific event.
• Please note, that contacts are not automatically added to a list when manually imported into an event, and manual imports do not auto-unsubscribe individuals from all lists upon import. Typically, integrations handle this process and provide opt-out information during syncing, which then adds only opted-in contacts to a designated list.
• To handle opt-outs, follow the best practices outlined below:
  1. Check with your ticketing provider to ensure that opt-out information is included in the file.
     
  2. Import the entire file, including the Opt-In / Opt-out information as a tag, into the event.
  3. Remove those contacts who have opted-out before importing the file into a list.

How to import ticket orders/sales for a single event

• Navigate to the Events menu
• Search for the event to import ticket orders for, and click the ⋮ icon in the top right corner of the event image
• Select Import ticket orders

• Select the Date format of the CSV file, Timezone, Currency and Ticket Provider 
• Click Continue

• Drag & drop the saved file into the drop box, or click to browse and upload the file from your saved location

• Map the fields to the corresponding column headings in your CSV file, then click Next

• Fix any errors within the file, check out How to fix errors & bulk delete
• Then click Import. *The time it takes to import depends on the size of your file*
• Once the import has been completed, the order tally will appear in the Events menu

• By clicking into the event, you can see more detailed information on the Ticket Sales tab

Compulsory fields for import

Email    
First name    
Last name    
Ticket type    
Total Paid|
Ticket Quantity    
Order Created    
Order ID    

Optional fields for import
Gender    

Date of Birth    

Street Address    

City/Suburb    

State    

Country    

Zip/post code    

Discount code

Defining fields

Event ID - The id (usually number) of an Event associated to an Event Name (eg - Event Name: Big Party. Event ID: 01234)
Order ID - The id of the recipient (fan) order for buying a ticket/s to that Event
Show ID - This one seems like it can be attached to a column that makes the most sense for the Promoter to use. They might have a column called 'Event' that has both the Event name and ID in it, so they could map this to Show ID

Still need help?

Contact us at support@audiencerepublic.com