| TYPICAL GUEST INFO |
|
|
Bidder Number
|
Optional. Used to indicate guests on different rows that share a bidder number. Bidder numbers can be edited individually or to a different range after import. |
Accepts any number, as long as it hasn’t already been assigned to another guest. |
| Guest First Name |
|
John |
| Guest Last Name |
|
Doe |
| Guest Full Name |
Use if your spreadsheet contains guest names in a single column/cell. |
John Doe; Doe, John |
| Address |
Number and street name |
125 Main St. |
| City |
|
Portland |
| State |
|
Oregon |
| Zip |
Accepts any format (including Postal Codes). If your spreadsheet contains NE zipcodes beginning with zero, verify that they display on your spreadsheet before upload. Some Excel number formats omit initial zeroes. |
97211 |
| City State Zip |
Use if your spreadsheet contains these in a single column. |
Portland, OR 97211 |
| Full Address |
Use if your spreadsheet contains full address in a single column. |
125 Main St. Portland, OR 97211 |
| Email Primary |
Primary Email for first guest on Row |
john@doefamily.com |
| Phone Primary |
Primary Phone for first guest on Row, accepts any format |
503-555-1212 |
| IF COUPLES LISTED IN SAME ROW |
|
|
| Guest 2 First Name |
|
Jane |
| Guest 2 Last Name |
|
Doe |
| Guest 2 Full Name |
Use if your spreadsheet contains couples on the same row, and the second guest’s full name is listed in a single column/cell. |
Jane Doe |
| Guest 1 and 2 First Names |
Use if couples first names are listed in a single column/cell. |
John and Jane; John,Jane; John/Jane |
| Guest 1 and 2 Full Names |
Use if couples full names are listed in a single column/cell. |
John and Jane Doe; John & Jane Doe; John/Jane Doe; Doe, John and Jane; Doe, John & Jane; Doe, John/Jane. |
| Guest 2 Email Primary |
Email for second guest on row. |
jane@doefamily.com |
| Guest 2 Phone Primary |
Phone for second guest on row, accepts any format |
503-555-3434 |
| ORDER INFO |
|
|
| Ticket Type or Name |
Ticket name to display on Order. If none provided, will display as guest_1 for singles and guest_2 for couples |
accepts any alphanumeric text |
| Ticket Price |
For Basic imports, list price per person. For Advanced imports, list price per ticket. Optional, if not provided, imported as $0 ticket. |
50 |
| Amount Paid |
Optional. If not provided, imported as paid in full. To specify unpaid, list 0 on your spreadsheet. |
accepts numbers only (no $) |
| Payment Method |
Optional. If not provided, payments are imported as “external" |
Must be one of three valid options: Cash, Check, External. |
| MORE |
|
|
| User Defined Field |
Creates a custom field for data that doesn’t fit into existing fields. |
accepts any data for reporting purposes only. |
| Table Name or Number |
For assigning table/seating assignments. Can be bulk edited after import, as needed. |
Accepts any alphanumeric text.
|
| Seat Assignment |
Can be bulk edited after import, as needed. |
Accepts numbers only.
|
| Address Line 2 |
Additional Address line for first guest on row. |
Suite 340 |
| Email Secondary |
Additional Email for first guest on row. |
john@mybiz.com |
| Phone Secondary |
Additional phone for first guest on row. |
800-456-7890 |
| Relationship to Org |
Available for reporting purposes only, no programming effect. |
Accepts any alphanumeric text. |
| ADVANCED |
|
|
| Number Ticket Admits |
Number of guest spots provided by the ticket |
Accepts any number. |
| Ticket ID |
Provide the same unique ID for each guest/row associated with a single ticket. Ticket ID dictates which guests are included on the same ticket in the ticketbuyer’s order. |
Accepts any number. |
| Ticket Buyer Business Name |
Used for Business Buyers. Business and Individual Ticket Buyer Names must be in separate columns. If they aren’t, add a new column on your spreadsheet and cut/paste to separate them. |
Community Bank |
| Ticket Buyer Contact Person |
Name of the individual representing the business. |
Jill; Jill Meyer; Meyer, Jill |
| Ticket Buyer First Name |
For non-business ticket buyers. |
Joanne |
| Ticket Buyer Last Name |
For non-business ticket buyers.
|
Johnson |
| Ticket Buyer Full Name |
For non-business ticket buyers, when name is contained in a single column/cell. |
Joanne Johnson; Johnson, Joanne |
| Ticket Buyer Address |
Number and street name. |
1 Main St |
| Ticket Buyer City |
|
Portland |
| Ticket Buyer State |
|
OR |
| Ticket Buyer Zip |
Accepts any format (including Postal Codes). If your spreadsheet contains NE zipcodes beginning with zero, verify that they display on your spreadsheet before upload. Some Excel number formats omit initial zeroes.
|
97211 |
| Ticket Buyer City State Zip |
Use if your spreadsheet contains these in a single column/cell. |
Portland, Or 97211 |
| Ticket Buyer Full Address |
Use if your spreadsheet contains the full address in a single column/cell. |
1 Main St Portland, OR 97211 |
| Ticket Buyer Email Primary |
Email for Ticket Buyer or Contact Person |
meyerj@communitybank.com |
| Ticket Buyer Phone Primary |
Phone for Ticket Buyer or Contact Person. Accepts any format. |
503-555-6789 |