How to import Attendee Types

You can create all of an event's attendee types at once by uploading a CSV file instead of adding them one at a time. The import sets up names, codes, and registration settings. It doesn't set up fees. Plan to add fees by hand after the import finishes.

Location: Plan > Event Setup > Attendee Types

Fees are not imported

The import file has no fee columns. Every attendee type you import comes in with no registration fees and no cancellation fees.

Before you open registration, go to each imported attendee type and add its fees by hand. See Add fees manually after the import. If you skip this step, registrants in paid attendee types won't be charged.

Prepare your import file

Build a .CSV file with one row per attendee type. The first row must hold the column names below, in this order. Only Name is required. Leave any other cell blank if you don't need it.

ColumnRequiredWhat to enter
NameRequiredThe attendee type name shown on confirmations, badges, and reports (for example, Member or Exhibitor). Up to 255 characters.
CodeRequiredA short abbreviation of the name (for example, MEM). It appears on reports, so pick something readable. Defaults to the Name if blank.
Sort OrderOptionalA number that sets the display order on the registration form. Type 1 shows before type 2.
Display for Reg FormOptionalThe label registrants see in the Attendee Type section of the form. Defaults to the Name if blank.
PasscodeOptionalA code that auto-assigns registrants to this type. Your form must start with the Entry page for passcodes to work.
CapacityOptionalThe maximum registrations for this type. Leave blank or enter 0 for unlimited.
Default StatusOptionalThe registration status a new registration starts in, such as New or Invited. Must match a status already in the event.
TagsOptionalTags your administrator has already set up for the Attendee Types object. Leave blank if your account doesn't use them.
Attendee Type GroupOptionalA label that groups similar types on reports (for example, Speakers or Partners).

Save the file as .CSV. If your data includes international or special characters, check the file's encoding before you upload it.

Sample file

Download the attached sample file and replace the values with your own. You can also copy the sample csv below. It shows a mix of required and optional columns, including two passcodes and two capacity limits. There are no fee columns.

NameCodeSort OrderDisplay for Reg FormPasscodeCapacityDefault StatusTagsAttendee Type Group
AttendeeATT1Attendee––New–General
MemberMEM2Member––New–General
Non-MemberNONMEM3Non-Member––New–General
StudentSTU4Student––New–General
SpeakerSPK5SpeakerSPEAK2026–New–Speakers
ExhibitorEXH6Exhibitor–50New–Partners
SponsorSPN7Sponsor––New–Partners
MediaMED8Press / Media––New–Guests
VIP GuestVIP9VIP GuestVIPGUEST25Invited–Guests
StaffSTF10Event Staff––New–Internal

Import the file

1. Open your event and go to Plan > Event Setup > Attendee Types.

2. If the event already has attendee types, click Export first and save a copy. You'll have a backup if the import needs to be undone.

3. Click Import to open the import wizard.

4. Click Choose File and select your .CSV file, or drag it into the upload box. Click Next.

5. Map each column in your file to a Certain field. Columns named exactly as in the sample usually map on their own. Set any column you don't want to bring in to Don't upload.

6. Click Complete Import.

7. Return to Plan > Event Setup > Attendee Types and confirm every row from your file appears with the right name, code, and sort order.

Add fees manually after the import

Do this for every imported attendee type that charges a fee. Each type can hold up to five date-based registration fees (for example, Early Bird, Regular, and On-site) and up to five cancellation fees.

1. Go to Plan > Event Setup > Attendee Types and click the attendee type to open it.

2. Scroll to Registration Fees and set Fee Type to Fixed Fee/Discount.

3. Fill in the fee details:

4. Repeat step 3 for each additional fee tier.

5. Add Cancellation Fees the same way if you keep part of the payment when someone cancels. Cancellation fees are always positive amounts.

6. Click Save, then move to the next attendee type.

A fee only expires when another fee is set to take its place. If you want a type to become free after a date, add a second fee of $0.00 for the period after the first one expires.

Tips and troubleshooting

A row didn't import

Check that its Name cell isn't empty and that the Default Status matches a status that exists in the event.

Using event waitlisting?

Leave Capacity blank. Attendee type capacity and event waitlisting can't be used together.

Passcode isn't working

The registration form has to begin with the Entry page.

Need to change a fee later?

Editing an existing fee amount doesn't update registrations already charged. Add a new fee, expire the old one, then adjust existing registrations directly.

Can't delete an imported type?

Remove it from any promo code or registration group first.

Related articles

Questions? Email Certain Support at help@certain.com.

Source: https://platform-support.certain.com/hc/en-us/articles/43725073346711-How-to-import-Attendee-Types

Keywords: Attendee Types, CSV import, registration fees, cancellation fees