You can now self-import a spreadsheet of guests with single or couples tickets (note: table tickets cannot be imported.)
Ticketed Guest imports are most appropriate:
- for events that do not charge admission but need to generate bidder numbers and/or track attendance; or
- when the software has been introduced late in the planning process, tickets have already been sold and the details are available in a spreadsheet.
If tickets haven't been sold yet, the built-in ticket feature offers more robust (and intuitive) tools for offering tickets online and/or entering tickets internally.
If you decide to manually enter some, or all, tickets, you can avoid having to enter each guest's contact information by self-importing your spreadsheet as "Users", then selecting the desired user record when assigning tickets.
"Basic"imports create one order per ticket (single or couple) with the guest as their own "ticket buyer". For couple tickets, the first guest listed will become the "ticket buyer".
"Advanced" imports allow tickets that were purchased by a businesses (or other hosts) and/or unassigned tickets to be imported. Preparing a spreadsheet for an Advanced import that contains complete Buyer, Guest and Order data is exponentially more difficult and should only be attempted by data gurus. If working with data is not your day job, you WILL find it faster (and more intuitive) to enter Business ticket purchases directly into the software (and Table tickets must be entered manually anyway).
Note: The importer does not handle diacritics (accent and cedilla signs) - they should be stripped from your spreadsheet prio to upload.
Importing is an automated process. Once you have uploaded your spreadsheet, you will "map" each column to the desired field in the software (Instructions for mapping various formats are provided below). The importer can handle all common formats, in any order, as long as each column contains the same type of data and format. For instance, if a column contains both emails and phone numbers, the column can be mapped to the email OR phone field. To import it correctly, you'll need to add a column on your spreadsheet and separate the email vs phone data.
Each row in your spreadsheet will be issued a ticket.
- If your spreadsheet lists one person per row, you can indicate which guests should share a bidder number by providing the same bidder number for both.
- If your spreadsheet lists couples in the same row, a couple ticket (with shared bidder number) will automatically be issued.
- Bidder numbers can be changed/linked/unlinked after the import, as needed.
An order/shopping cart is created for each ticket generated.
- If you want to track and report ticket revenue from the software, each row of your spreadsheet must contain a price, amount paid, and payment method.
- If you don't provide a price, each ticket will be imported as a $0 ticket.
- If you provide a price, but not an amount paid, each ticket will generate an paid order. If you want an unpaid order, you must specify 0 in the Amount Paid column.
- If you do not provide a payment method, any amount paid data will be imported as an "external" payment.
Note: Some gateways require specific data in order to process credit card transactions. If you'll be using Vanco, SchoolPay or WePay as your gateway, this data should be included in the import or it will have to be manually entered before a transaction:
- Vanco and SchoolPay: Full name and complete billing address
- WePay: Zip code and email address
To Self Import Ticketed Guests:
2. Map Your Columns to Fields
Tip: It's a good idea to review the "Skip" messages in the left column and map the required name columns first. If you need to edit your spreadsheet to add required information, you should do that before proceeding to avoid having to map your columns twice.
How to Map Various Formats
Your spreadsheet columns won't be organized exactly the same as the software fields - so multiple mapping options are provided for names and addresses. For instance, the software uses first and last name fields, but your spreadsheet may list the full name in a single column. Choosing the "Full Name" option from the dropdown will instruct the software to separate your column of names into separate first and last name fields during the import.
Your spreadsheet can be as simple as a list of names (though we recommend importing email addresses if they are available). The examples shown below focus on the name formats and ticket details needed to create the correct orders. For simplicity, we've omitted the common, but straightforward, columns for address and contact info.
You can view a complete list and description of fields/column headers here. You can also import your data into a custom field by choosing "user defined field" from the dropdown. In general, it's better to use existing fields where possible as custom fields have limited reporting tools.
Basic Imports: Each Guest is their own ticketbuyer
Advanced: Separate Buyers; Tables and/or Unknown Guests
Note: Guests can easily be assigned to sit at specific tables at anytime. Table tickets, where one buyer hosts multiple guests on a single ticket requires an advanced import.
Advanced Imports require columns, and data for each row, for:
- Ticketbuyer Name (Business and Individual Names in separate columns)
- Ticket ID (unique number for each row pertaining to a specific ticket). Ticket ID determines which rows/guests are associated with each ticket. If the number admitted is higher than the rows of guest info provided, the remainder will be imported as "unassigned tickets".
- Number Ticket Admits - how many guests can gain admission on this ticket type?
- Ticket Price - total price of the ticket (NOT per person). If no price is provided, ticket will be imported as $0 ticket.
Guest Information can be imported using the same formats shown above in Basic examples.
- If you don't know who will use a ticket, all guest fields in the row should be left blank.
- If some guests are known and others unknown, provide a row for each known guest only. The software will generate unassigned tickets for the remainder of tickets (based on Number Ticket Admits).