Import File Specification
- J Cobb (Unlicensed)
- Daniel Weisbaum
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. If the value within a field contains double quotes you should escape those double quotes by double-double quoting them, e.g: "Kenny ""Babyface"" Edmonds with Special Guest Brandy".
Supported Columns
The supported columns and the proper formatting of them is below in alphabetical order. Header names are case-insensitive and the order of columns does not matter.
Additional columns may be included, but will be ignored.
Header | Format | Description | Presence | Empty Allowed | Max Length |
|---|---|---|---|---|---|
| azdiamondbacks@example.com | The email address for the MLB/ProVenue account in which these tickets are located or the parent account. If you are an MLB Authorized Broker for this team | Optional | Yes |
|
| AAAA1111BBBB|CCCC2222DDDD | A list of the barcodes for each ticket in this ticket group. The barcodes should be separated by a | (“vertical bar”). When
| Optional | Yes |
|
| 122.00 | The price in US dollars that you are charging for each ticket in this ticket group | Required | No |
|
| 23.5 | Indicates a percentage discount that should be applied to TEvo's retail partners (non-B2B sales). Any amount less than 20% will be passed to all of TEvo's retail partners while a discount of 20.00% or more will only be shown to our Opaque Network. If you would like to know more about participating in our Sales Booster program please contact us. | Optional | Yes |
|
| One of: | Use the Indicates whether this ticket group is a PDF Eticket that will be uploaded. | Optional | Yes |
|
| New Orleans Saints or Atlanta Hawks at New Orleans Saints | Either the performer name or the name of the actual event. If your listing is for parking passes the Event must still include the name of the Event. | Required | No |
|
| 09/27/2015 | US formatted date mm/dd/yyyy. Dates more than 2 years in the future will be ignored. | Required | No | |
|
| The ID of the event in the Point of Sale |
|
|
|
|
| The Source of the provided EventID. One of
|
|
|
|
| 6:05PM | A string that can be parsed to indicate time. Generally either a 12 hour formatted time with the period indicator (AM|PM) or a 24 hour time format. Times that parse to the following values are all considered to be “TBA”, which in our system is indicated by 00:00:00:
| Required | Yes | |
| 75.50 | The the established price charged by the operator of a place of entertainment that is printed or endorsed on the face of each ticket. | Optional | Yes |
|
|
tm_mobile | One of:
| Optional | Yes |
|
| 08/22/2015 | US formatted date (mm/dd/yyyy) indicating the earliest date that these tickets will be transferred, 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 |
|
|
| 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 |
|
|
| Text that will be displayed to Users within your Office | Optional | Yes |
|
|
| 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 preceding
Wheelchair Hot Words
Eticket Hot Words:
Paperless Hot Words
Flash Seats Hot Words
TM Mobile Transfer Hot Words
TM Mobile Screenshot/QR Code Hot Words
| Required | Yes |
|
|
| Currently unused | Optional | Yes |
|
| 12 | An integer representing the number of seats together for this ticket group | Required | No |
|
| 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 | Yes |
|
| 22 | The row indicator as printed on the ticket. Include | Required | No | 100 |
| 3 | The low & high seat numbers if you wish to indicate the seat numbers available. | Required | Yes | |
| 14 | Required | Yes | ||
| 109 | The section indicator as printed on the ticket | Required | No | 100 |
| 122.00 | The cost the seller paid in US dollars for each ticket in this ticket group.
| Optional | Yes |
|
| One of:
|
|
| ||
| The | Only applicable for the
Note: This value type has a 40 character limit in this column |
|
| |
| 100.00 | The per-ticket amount in US dollars on which tax was previously been paid. | Optional | Yes |
|
| 54687951 | The unique ID of this ticket group in your Point of Sale or inventory management system. | Required | No |
|
| 1783953623382|654851351564 | A list of the MLB/ProVenue ticket_ids for each ticket in this ticket group. The TicketIDs should be separated by a | (“vertical bar”). When
| Optional | Yes |
|
| Mercedes-Benz Superdome | The venue name | Required | No | 255 |
| ANGELS-REGULAR-4068-3XTC4X7ZSR2LYYZBIXVXW4HI|ANGELS-REGULAR-4068-7JWV4X7ZSR2LHQYBIXVXW4HI | A list of the MLB/ProVenue Verification IDs for each ticket in this ticket group. The Verification IDs should be separated by a | (“vertical bar”). When
| Optional | Yes |
|
Example File
"Event","Venue","EventDate","EventTime","Quantity","Section","Row","SeatFrom","SeatThru","Notes","Cost","TicketID","Eticket","InHandDate","Instant"
"Atlanta Hawks at New Orleans Saints","Mercedes-Benz Superdome","09/27/2015","6:05PM","12","109","22","3","14","Wheelchair seats. Includes free valet parking.","122.00","54687951","Y","08/22/2015","Y"
"Steel Panther with Rock Sugar","House of Blues - Sunset Strip","02/29/2020","8:00PM","10","FLOOR","GA","","","General Admission Floor.","29.00","54687983","N","02/22/2015","N"
"Kenny ""Babyface"" Edmonds with Special Guest Brandy","Portsmouth Pavilion","09/21/17","7:30PM","4","GOLD L","C","","","","85","3849359","N","07/23/2015","N"