Event Promo Code Import Wizard

To open the Event Promo Code Import Wizard, click the Import Promo Codes button in the top right corner of the Promo Code List page (see Plan > Promo Codes).

The wizard enables you to import promo codes into your event from a CSV file, in these two steps:

A: Prepare an Import File
B: Import Your Data

A. Prepare an Import File

Start by preparing a .CSV file containing the data to be imported.

Best practice: Keep the columns in the same order, and use the same or similar names as used in the mapping step. The mapping step is described below. Those fields are more likely to be mapped by default. This makes the mapping step quicker and easier.
Header Row: The first row must be column names. You will use these when mapping the fields.
Note re Required fields: See the list of columns to import, below.
All fields apart from Capacity are required fields.
A file cannot be imported if any required fields are not included.
The import of a record will fail if any required fields have no value.
Save the file as a .CSV file. The first row contains the column headings (the field names).
Sample CSV File: promo_code_import_sample_csv_file

You can right-click this file name to save a sample CSV file with columns for all the fields.

Note: Be sure to replace the sample data with your own data to import.

B. Import Your Data

Once you have a CSV file of Promo Codes to import, step through the Event Promo Code Import Wizard to import it.

Import Promo Codes

1. Browse to select a file to upload, and Upload it.

2. In the pop-up window, map the columns in the import file to the data fields. The data fields are listed below.

See the Promo Codes help topic for full details of these fields.

Promo Name – (Required)
Promo Code – (Required) Must be unique to the event.

Caution: If the Promo Code already exists, the import will update the record.

Attendee Type Code(s) – (Required) Must be existing Attendee Type(s).

If more than one, separate them with | (“pipe”) symbols.

Caution: Ensure the spelling is exactly right. The promo code will not be imported if an attendee type does not match precisely.

Discount Code(s) – (Required) The discount code(s) to be applied when the promo code is used.

If more than one, separate them with | (“pipe”) symbols.

Caution: Must already exist in the event (as negative fees in Event Setup > Agenda). The promo code will not be imported if a discount code does not exist (with exactly the same code).

You can import discounts in advance: see the Discount Import Wizard.

Capacity – The maximum number that can be used by attendees; an integer from 0 to 999999.

Note: Blank or 0 means unlimited capacity.

Start Date Availability – (Required) Format mm/dd/yyyy
Start Time Availability – (Required) Format 9:00 AM
End Date Availability – (Required) Format mm/dd/yyyy
End Time Availability – (Required) Format 9:00 AM

3. Click Import. 4. Your import is queued. You receive an email as soon as it is processed. The promo codes are then available for use.