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.
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. Use the same or similar names as the mapping step uses. The mapping step is described in the field mapping section. This practice makes the mapping step quicker and easier. Those fields are more likely to be mapped by default.
Header row
The first row must be column names. Use these when mapping the fields.
Note re Required fields
See the list of columns to import in the field mapping section.
- All fields apart from Capacity are required fields.
- A file cannot be imported if any of them are not included.
- The import of a record will fail if any of them have no value.
Save the file
Save the file as a CSV file. The first row contains the column headings, which are the field names.
Sample CSV file
Sample CSV File: promo code import sample csv file
Right-click this file name to save a sample CSV file with columns for all the fields. Note: 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. Upload it. 1. In the pop-up window, map the columns in the import file to the data fields, which are as listed below. 1. Click Import. 1. Your import is queued. 1. You receive an email as soon as it is processed. 1. The promo codes are then available for use.
Map fields in the import file
- 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 doesn't 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 doesn't exist (with exactly the same code).
You can import discounts in advance: Discount Import Wizard
- Capacity – The maximum number than can be used by attendees.
It is 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
See Also
- Quick Guide to Promo Codes (PDF)
- Promo Codes (including the Promo Code List and Promo Code Wizard)
- Import Discounts
- Promo Code Form Section
- Form Logic actions "Display Promo Code" and "Assign promo Code"
- Report Setup report type "Registration Groups with Promo Codes"