How do I upload offline registrations/tickets?

Even when you set up online registration/ticketing, you may need to collect registrations offline through cash, check, or other form of payment. With our bulk upload tool, you’ll be able to add all your offline registrants into your database.

Note: Registrations/Tickets, along with additional purchases, can be uploaded regardless of remaining purchases or other restrictions you may have created for your online registrants. 

To enable the Bulk Attendee Upload option, please start by contacting us at [e-mail]. Once enabled, you can use the following steps to add offline registrations to your event.

1. Log In to your Events.com account and select the event for which you wish to do the upload.
2. Click on PEOPLE in the left navigation, and then select Attendees.
   
   
   
3. From the right, select the ATTENDEE ACTIONS and Bulk Attendee Upload
   
   
   
   
4. Then, Download your custom template. Using this template ensures that the data will have the correct format for upload.
5. Open the downloaded template and fill in the data for the orders you want to generate.
   • Each row represents an offline registrant or ticket holder, and will generate a new Registration/Ticket and order for your event.
   • Many of the columns on the template are optional to complete. However, a few are required in order to successfully upload the orders:
     • Buyer First Name
     • Buyer Last Name
     • Buyer Email
     • Registration/Ticket Type
     • Attendee First Name
     • Attendee Last Name
     • Attendee Email
6. After saving the template with all your data, you will need to upload it to Events.com. Click BROWSE to choose the file you just created.
7. If you want to send each registrant or ticket holder a confirmation email, switch the Send confirmation emails toggle to YES.
   • The email will be the same as though the recipient just completed an order through your page.
8. Click CONTINUE to start the upload.
   
   
   
   
9. Status and details of completed uploads will be viewable in the Upload History section.

Pro Tips

Formatting

• When you open a .CSV file in Excel, make sure to use the “Import Data as Text” function so that formatting is not lost. Check out this article.
• Upload errors may be caused by blank rows or certain characters in the upload template, including quotation marks and colons. 
• Date of Birth values must be formatted as MM/DD/YYYY.
• Price paid values can be formatted as XXX.XX (with decimal) or XXX (with no decimal) format. 

Allowed Values

• Values in Registration/Ticket Type must match EXACTLY to a Registration Name or Ticket Name in the event.
• Values in Additional Purchase or Form Question columns must match EXACTLY to a corresponding Option Name for the item. Their quantities must be set as 1.
• Values for Country must match EXACTLY one of the Country names in the attached PDF document.
• Values for State/Region/Province must match EXACTLY one of the names in the attached PDF document and be associated with the same Country listed for the registrant/ticket holder.
• If a waiver was signed, place “Signed” in the waiver name column for the registrant/ticket holder.
• Quantity values must be numerical.

Prices

• If the value is left blank for Price Paid for a Registration/Ticket or an included Additional Purchase, the Price Paid will be imported as $0.
• Price paid values are not required for upload, but will be added to the org revenue if included.  

Note: Review your file before uploading to make sure that all the information is correct. Turn on text wrap (expand the columns to display the full content), to ensure proper data import. Offline orders cannot be removed.