Ticket Evolution supports inventory files exported from any of the major Point of Sale systems. Your file should be either a comma separated file (.csv) or a tab separated file (.txt) with the first row being a header row defining the fields. The newline character should be a Line Feed ('\n', 0x0A, 10 in decimal) and the contents of each field should be wrapped in double quotes.
Supported Columns
The supported columns and the proper formatting of them is below. Additional columns may be included, but will be ignored.
Column | Format | Description | Presence | Empty Allowed | Max Length |
---|---|---|---|---|---|
Event |
or
| Either the performer name or the name of the actual event | Required | No | |
Venue |
| The venue name | Required | No | |
EventDate | 09/27/2015 | US formatted date mm/dd/yyyy. Dates more than 10 years in the future will be ignored. | Required | No | |
EventTime | 6:05PM | 12 hour formatted time with the period indicator (AM|PM). The following values are all considered to be “TBA”, which in our system is indicated by 00:00:00:
| Required | Yes | |
Quantity | 12 | An integer representing the number of seats together for this ticket group | Required | No | |
Section | 109 | The section indicator as printed on the ticket | Required | No | |
Row | 22 | The row indicator as printed on the ticket | Required | No | |
SeatFrom | 3 | The low & high seat numbers if you wish to indicate the seat numbers available. The following values will be ignored:
| Required | Yes | |
SeatThru | 14 | The high seat number if you wish to indicate the seat numbers available | Required | Yes | |
Notes | Text explaining any restrictions or inclusions with this ticket group that will be displayed to everyone. These notes will also be parsed for certain “hot word” indicators that are used to indicate additional properties of the ticket group. Any of these ”hot words” can be negated by a preceeding “not ”. Wheelchair Hot Words
Eticket Hot Words:
Paperless Hot Words
Guest List Hot Words
Flash Seats Hot Words
TM Mobile Hot Words
| Required | Yes | ||
Cost |
| The price in US dollars that you are charging for each ticket in this ticket group | Required | No | |
TicketID | 54687951 | The unique ID of this ticket group in your Point of Sale or inventory management system. | Optional | Yes | |
| One of: Y, N, y, n, 1, 0 | Indicates whether this ticket group is a PDF Eticket that will be uploaded. PDFAvail or Edelivery_ind or edelivery are also accepted for the column header. | Optional | Yes | |
InHandDate | 08/22/2015 | US formatted date (mm/dd/yyyy) indicating the earliest date that these tickets will be shipped or uploaded. To indicate that the tickets are currently in hand use a date that is today’s date or earlier. Leaving this field empty will cause the In Hand Date to be set as the latest date we allow, currently two days before the event. | Required | No | |
Instant | One of: Y, N, y, n, 1, 0 | Indicates whether these tickets are available for Instant Delivery. In order for your tickets to actually be marked as Instant Delivery three things must exist:
| Optional | Yes | |
actual_cost | 122.00 | The face value in US dollars for each ticket in this ticket group | Optional | ||
retail | 122.00 | The retail price in US dollars you wish to charge on your TEvo-powered website for each ticket in this ticket group | Optional | ||
internal_notes | Text that will be displayed to Users within your Office | Optional | |||
barcodes | AAAA1111BBBB|CCCC2222DDDD | A list of the barcodes for each ticket in this ticket group. The barcodes should be separated by a | (“vertical bar”) | Optional | ||
partnership | 1 or 0 | A boolean indicator that this ticket group should be discounted to Ticket Evolution Partners. Please contact us to set this up for your account. | Optional |
...