If you sold tickets somewhere else, or you are moving an event to Eventify from another system, you can import ticket orders instead of creating each one by hand. Each imported order appears in your Sales Report next to the orders placed through your Eventify event registration platform.
When to import orders
Use Import Order when:
- tickets were sold offline, by invoice or through another ticketing tool, and you want one sales record;
- you are migrating registrations from a previous platform;
- you have many confirmed orders to add and entering them one by one with New Order would take too long.
The import is for orders that are already confirmed. For a single order, use New Order instead. See How To Create A Ticket Order Manually?.
Open Import Order
- Go to Registration > Tickets > Sales Report.
- Click Import Order at the top right, next to New Order.
- The Import Confirmed Orders window opens.
#image# Sales Report header with the Import Order and New Order buttons
Prepare the file
- In the window, under Download Template, click Sample CSV or Sample XLS.
- Open the file. It holds sample rows that show each kind of line. Replace them with your own orders.
- Save the file as CSV or XLSX.
#image# Import Confirmed Orders window with the upload area, the Download Template links and the notes
The template has these columns. Required columns are marked "(required)":
- Order Number (required), Order Date (required), Currency (required)
- Buyer Name (required), Buyer Email (required), Buyer Company, Buyer Vat, Buyer Address, Buyer City, Buyer Zip, Buyer Country
- Ticket Code (required), Ticket Quantity (required), Per Ticket Price (required)
- Coupon Code, Discount Amount, Tax Name, Tax Rate(%)
- Assigned User Name, Assigned User Email
How rows become orders
One row is one ticket line. Rows that share the same Order Number are imported as one order, so an order with two ticket types has two rows with the same number and buyer.
Ticket Code links the row to one of your tickets. You find a ticket's code when you edit it: it shows as Ticket Code at the top of Ticket Details, and it is also the last part of the ticket's link. Only enabled tickets and tickets set to Enabled,but Hidden are matched. A code that doesn't match any ticket is imported as a separate line on the order, such as an external add-on.
Rules the import checks
- Don't rename, move or delete any column header, even if the column is empty.
- Order Date uses the YYYY-MM-DD format and can't be in the future.
- Currency must be a supported currency and must match the ticket's currency. One order can't mix currencies.
- The same Ticket Code can appear only once per Order Number. Put the total in Ticket Quantity instead.
- Ticket Quantity must be a whole number and can't be lower than the ticket's Min per Booking. If a quantity is too high, the error tells you the maximum allowed.
- Coupon Code and Discount Amount go together: fill both or neither. The discount can't be more than the line's total.
- Tax Name and Tax Rate(%) go together. Enter the rate as a number only, for example 5 for 5%.
- To add a discount to the whole order, add a row with a negative Per Ticket Price, for example -20, a Ticket Quantity of 1 and no coupon, tax or assigned users. The order total can't go below zero.
- Assigned User Name and Assigned User Email list the attendees for that line, separated by commas, in the same order. You can't list more people than the quantity, and names and emails can't repeat.
- For sponsor and exhibitor tickets, Buyer Company is required, and the number of assigned users can be up to the ticket's Attendees Per Ticket.
- Rows for ticket codes that don't match a ticket, and discount rows, can't have assigned users.
Upload and fix errors
- Drag your file onto "Drag and Drop or Click here to upload the completed template", or click the area to choose it.
- Eventify checks every row. If all rows are valid, a preview table appears. Click Import.
- If any row has a problem, only the rows with errors are listed, with the message "The below rows have some data errors; you can check them by hovering your mouse over the exclamation(!) icon." Hover over each ! to read what is wrong.
- Fix those rows in your file, click Retry and upload the file again.
#image# Import preview listing rows with errors and the exclamation icon tooltip showing the problem
The Import button only appears when the whole file is valid. When the import finishes you see "Ticket order imported successfully." If some orders are refused at that stage, the window lists them: "We encountered issues importing the following order(s): ..." Fix those orders and import them again.
If the file can't be read at all, you see "The CSV / XLSX file format is non-compatible or the data is not well formatted. Please refer to the template". An empty file gives "The CSV / XLSX file is empty, Please add some data".
After the import
The imported orders appear in the Sales Report list. Open an order to check the buyer, the ticket lines and the assigned attendees.
People listed in Assigned User Name and Assigned User Email are the attendees for those tickets. Look them up in People > Manage Attendees to confirm they are there before you send event emails.
Common questions
Can I import orders from Eventbrite or another ticketing platform?
Yes. Export your orders from the other platform, copy them into the Eventify template columns, then upload the file with Import Order.
Why is the Import button missing after I upload?
At least one row has an error. Only rows with errors are shown; hover over the ! icon on each row, fix the file and click Retry.
How do I import an order with two different tickets?
Use two rows with the same Order Number, buyer and currency, one row per Ticket Code.
Where do I find the Ticket Code?
Edit the ticket in Registration > Tickets > Manage Tickets. The code shows as Ticket Code on the Ticket Details step.
Related articles
Need more help? Contact Eventify support from the admin panel.
