Upload Your CSV in the Orders Tab
Updating organization names and job titles are common use case for bulk updates, and it can be efficiently managed by uploading a CSV that includes the attendees' ticket number and all the other information that needs to be updated. You can conveniently do this from the Orders tab > Actions > Update Ticket Holder Information.
Important Notes:
Ticket Number column - this will identify which registration must be updated. This is the only required column.
Email addresses will not be updated, but you can include it in your CSV for reference
The ticket buyer information will not be updated, this update is only for ticket holders
Updating an Image and Conditional Question Field will not work through CSV upload.
If your event uses a custom field for company names, note that this data will not sync to the native "Company" profile field in the attendee's profile.- To ensure accurate updates, the field name in Accelevents must be "Organization".
Note that if the "Organization" is updated in the order, it does not automatically update all of the attendees' profiles, it will only update if the attendee has never logged in to any event in Accelevents. Learn more about auto-populating order form answers to the attendee profile.
1. Get the Ticket Number
The Ticket Holder data report will include the attendee's ticket number, which you'll need to include in the CSV you upload. This is the unique identifier that will allow the system to know which registration to update. The downloaded report will also include all the ticket holder fields, so you can also use the downloaded file as your CSV, just make sure to remove all the columns you don't need to update.
Go to Attendees > Orders
Click Download > Ticket Holder Data
Note: You can also find the ticket number in the order by looking at the Registration ID under the ticket holder.
2. Format Your Answers
Note: If the order is cancelled or refunded, it will not be updated.
Once you have all the columns for the fields you want to update, make sure that the values you add are in the correct format.
Field | Format | Will it update if I enter the incorrect format? |
Ticket Id | This is a required field, you can get the ticket id values from the Ticket Holder report's Ticket Number column | ❌ No, it will not update, the rest will be updated. |
First Name and Last Name | First Name and Last Name should have a maximum of 50 characters | ❌ No, it will not update, the rest will be updated. |
⚠️ Email will not be updated when you include in your CSV. | ❌ No, it will not update, the rest will be updated. | |
Profile Image URL | ⚠️ This cannot be updated, the mapping does not exist.
You can only do this when you're uploading attendees.
You can upload the images in Attendee Management instead.
| ❌ No, it will not update, the rest will be updated. |
Cell Phone |
Sample acceptable formats: 19175825511 +19175825511 +1(917)5825511 +1-917-5825511 | ❌ No, it will not update, the rest will be updated. |
Country | The Country should be displayed in full and not abbreviated, and should follow the same values found in Accelevents. | ❌ No, it will not update, the rest will be updated.
|
State | You cannot upload just States, you must include the Country.
Both should be displayed in full and not abbreviated, and should follow the same values found in Accelevents. | ❌ No, it will not update, the rest will be updated.
⚠️ You will NOT get a warning that this field will not be updated. |
Billing and Shipping Fields | This field is composed of 6 fields.
Address|Address 2|City |State|Zipcode|Country
Example:
2 Franklin Road|Apartment 6|Beverly Hills|California|90210|US | ❌ No, it will not update, the rest will be updated.
⚠️ You will NOT get a warning that this field will not be updated. |
Upload Field | ⚠️ This cannot be updated.
| ❌ No, it will not update, the rest will be updated.
⚠️ You will NOT get a warning that this field will not be updated. |
Image Field | You’ll need a direct image URL that ends in a file type like
⚠️ Google Drive Links will not work. Google Drive links don’t work as direct image URLs because they’re not actual file paths — they’re view links that require authentication or page loading. | ❌ No, it will not update, the rest will be updated. ❌ This field will have errors.
⚠️ When you open the order or the report, the image and URL will be broken, and you will NOT get a warning that this field will be updated with errors. |
Birthday / Date Question | The Birthday / Date should be MM/DD/YYYY format (e.g. 12/25/1995) | ❌ No, it will not update, the rest will be updated. |
Number Question | Numbers cannot contain commas | ❌ No, it will not update, the rest will be updated. |
Dropdown Question | The value should be identical in the order form field | ❌ No, it will not update, the rest will be updated. |
Multiple Choice Question | Multiple answers for a Multiple Choice question should be separated by a | without any extra spaces. (e.g., Answer 1|Answer2|Answer3)
The answer must be identical to the choices in Accelevents | ❌ No, it will not update, the rest will be updated. |
Single Checkbox question | The Single Checkbox value should be | ❌ No, it will not update, the rest will be updated. |
3. Upload Your CSV File
After formatting your CSV, you can upload it.
Go to Attendees > Orders
Click Actions > Update ticket holder information
Upload your CSV file
Map the fields and click Next. Tip: Make sure your column headers are the same as the ticket holder fields so it would automatically map.
Review your data before importing. If there's invalid data, that attendee will be excluded from the import. Click Confirm Import.
You will see an Update in Progress pop-up after your confirm. You can close that pop-up.
When the update is done, you'll see a notification at the bottom of the page.
