{"id":311,"date":"2016-03-22T10:12:29","date_gmt":"2016-03-22T14:12:29","guid":{"rendered":"http:\/\/www.e-registernow.com\/support\/?p=311"},"modified":"2018-03-01T13:43:34","modified_gmt":"2018-03-01T18:43:34","slug":"custom-template-variables","status":"publish","type":"post","link":"https:\/\/e-registernow.com\/support\/custom-template-variables\/","title":{"rendered":"eTicket Custom Template Variables"},"content":{"rendered":"<p>All the following variables will be replaces with the appropriate data. They must be enclosed between &#8220;%% %%&#8221; to work (e.g. %%amount_paid%%).<\/p>\n<h4>Variables<\/h4>\n<p>&nbsp;<\/p>\n<table class=\"variables\" style=\"height: 2228px;\" width=\"1375\">\n<tbody>\n<tr>\n<th>Variable<\/th>\n<th>Variable Definition in eTickets<\/th>\n<\/tr>\n<tr>\n<td>total_amount_paid<\/td>\n<td>The total amount charged to credit card or other payment type.<\/td>\n<\/tr>\n<tr>\n<td>amount_paid<\/td>\n<td>The event amount charged to credit card or other payment type.<\/td>\n<\/tr>\n<tr>\n<td>barcode_image<\/td>\n<td>barcode as a *.jpg file (e.g. ABC123.jpg)<\/p>\n<p>Note: The barcode number will appear below the image.<\/td>\n<\/tr>\n<tr>\n<td>barcode_number<\/td>\n<td>The code the barcode represents. (e.g. ABC123)<\/td>\n<\/tr>\n<tr>\n<td>blurb_file<\/td>\n<td>Name of the file whose contents are dumped into the eticket.<\/td>\n<\/tr>\n<tr>\n<td>confirmation_number<\/td>\n<td>e-RegisterNow&#8217;s reference number (e.g. 1234567)<\/td>\n<\/tr>\n<tr>\n<td>dateconfirmed<\/td>\n<td>The date the transaction occurred. (e.g. 2004-12-25 00:23:00)<\/td>\n<\/tr>\n<tr>\n<td>datetime<\/td>\n<td>A timestamp of the date and time now. (e.g. 2004-12-25 00:23:00)<\/td>\n<\/tr>\n<tr>\n<td>datetime_yearlater<\/td>\n<td>A timestamp of the date and time one year later. ( 2005-12-25 00:23:00)<\/td>\n<\/tr>\n<tr>\n<td>date<\/td>\n<td>A timestamp of the date and time now. (e.g. 2004-12-25)<\/td>\n<\/tr>\n<tr>\n<td>date_yearlater<\/td>\n<td>A timestamp of the date and time one year later. (e.g. 2005-12-25)<\/td>\n<\/tr>\n<tr>\n<td>date_MDY<\/td>\n<td>A timestamp of the date and time one year later. (e.g. December 24, 2005)<\/td>\n<\/tr>\n<tr>\n<td>date_MDY_yearlater<\/td>\n<td>A timestamp of the date and time now. (e.g. December 24, 2004)<\/td>\n<\/tr>\n<tr>\n<td>date_MMMDDYYYY<\/td>\n<td>A timestamp of the date and time now. (e.g. Dec 25, 2004)<\/td>\n<\/tr>\n<tr>\n<td>date_MMMDDYYYY_yearlater<\/td>\n<td>A timestamp of the date and time one year later. (e.g. Dec 25, 2005)<\/td>\n<\/tr>\n<tr>\n<td>date_YYYYMMMDD<\/td>\n<td>A timestamp of the date and time now. (e.g. 2004Dec25)<\/td>\n<\/tr>\n<tr>\n<td>date_YYYYMMMDD_yearlater<\/td>\n<td>A timestamp of the date and time one year later. (e.g. 2005Dec25)<\/td>\n<\/tr>\n<tr>\n<td>description<\/td>\n<td>A long description of the transaction.<\/td>\n<\/tr>\n<tr>\n<td>effective_date[<strong>date_format<\/strong>][<strong>yyyymmdd<\/strong>]<\/td>\n<td>return the date yyyymmdd (date in the second blacket) if registration date is prior to that date. if not, return the registration date.<br \/>\ne.g.) effective_date[date_format][20160812] reg date Aug 10, 2016 and the date in the variable Aug 12, 2016 -&gt; return Aug 12, 2016<br \/>\nSee Date Format Section below for [date_format]<\/td>\n<\/tr>\n<tr>\n<td>email<\/td>\n<td>Ticketholder&#8217;s email.<\/td>\n<\/tr>\n<tr>\n<td>event_badgename<\/td>\n<td>Event&#8217;s course badgename.<\/td>\n<\/tr>\n<tr>\n<td>event_categories<\/td>\n<td>Event&#8217;s course categories, (e.g. camps~sports~day)<\/td>\n<\/tr>\n<tr>\n<td>event_code<\/td>\n<td>Event&#8217;s course code.<\/td>\n<\/tr>\n<tr>\n<td>event_enddate<\/td>\n<td>Event&#8217;s end date. (e.g. Jun. 30, 2006)<\/td>\n<\/tr>\n<tr>\n<td>event_endtime<\/td>\n<td>Event&#8217;s end date and time.<\/td>\n<\/tr>\n<tr>\n<td>event_instructor<\/td>\n<td>Event&#8217;s instructor&#8217;s name.<\/td>\n<\/tr>\n<tr>\n<td>event_location<\/td>\n<td>Event&#8217;s location.<\/td>\n<\/tr>\n<tr>\n<td>event_name<\/td>\n<td>Event&#8217;s name.<\/td>\n<\/tr>\n<tr>\n<td>event_startdate<\/td>\n<td>Event&#8217;s start date. (e.g. Jun. 30, 2006)<\/td>\n<\/tr>\n<tr>\n<td>event_startdate_yearlater[<strong>date_format<\/strong>]<\/td>\n<td>One year from Event&#8217;s start date. See Date Format Section below for [date_format]<\/td>\n<\/tr>\n<tr>\n<td>event_starttime<\/td>\n<td>Event&#8217;s start date and time.<\/td>\n<\/tr>\n<tr>\n<td>event_qty[eid]<\/td>\n<td>Quantity of the event.<\/td>\n<\/tr>\n<tr>\n<td>fullname<\/td>\n<td>Ticketholder&#8217;s full name<\/td>\n<\/tr>\n<tr>\n<td>message1<\/td>\n<td>Event Message 1<\/td>\n<\/tr>\n<tr>\n<td>message2<\/td>\n<td>Event Message 2<\/td>\n<\/tr>\n<tr>\n<td>message3<\/td>\n<td>Event Message 3<\/td>\n<\/tr>\n<tr>\n<td>paymethod<\/td>\n<td>Ticketholder&#8217;s payment method (e.g. visa)<\/td>\n<\/tr>\n<tr>\n<td>question_field=<b>xxx<\/b><\/td>\n<td>Response to a custom question, where &#8220;<b>xxx<\/b>&#8221; represents the custom question&#8217;s field name (e.g. question_field=age)<\/td>\n<\/tr>\n<tr>\n<td>question_field_date=<b>xxx<\/b><\/td>\n<td>Response to a custom question, where &#8220;<b>xxx<\/b>&#8221; represents the custom question&#8217;s field name (e.g. question_field=birthdate).\u00a0 Use this when the response is of datetype.\u00a0 (e.g. %M %d, %Y)<\/td>\n<\/tr>\n<tr>\n<td>\u00a0question_field_date_yearlater=<b>xxx<\/b><\/td>\n<td>\u00a0Response to a custom question, where &#8220;<b>xxx<\/b>&#8221; represents the custom question&#8217;s field name (e.g. question_field=birthdate).\u00a0 Use this when the response is of datetype.\u00a0 (e.g. %M %d, %Y)<\/td>\n<\/tr>\n<tr>\n<td>registrant_business_name<\/td>\n<td>Company name where registrant works.<\/td>\n<\/tr>\n<tr>\n<td>registrant_business_address_1<\/td>\n<td>Company&#8217;s address line 1.<\/td>\n<\/tr>\n<tr>\n<td>registrant_business_address_2<\/td>\n<td>Company&#8217;s address line 2.<\/td>\n<\/tr>\n<tr>\n<td>registrant_business_city<\/td>\n<td>Company&#8217;s city address.<\/td>\n<\/tr>\n<tr>\n<td>registrant_business_country<\/td>\n<td>Company&#8217;s country<\/td>\n<\/tr>\n<tr>\n<td>registrant_business_province<\/td>\n<td>Company&#8217;s province<\/td>\n<\/tr>\n<tr>\n<td>registrant_business_postal<\/td>\n<td>Company&#8217;s postal code.<\/td>\n<\/tr>\n<tr>\n<td>registrant_business_phone<\/td>\n<td>Company&#8217;s phone number<\/td>\n<\/tr>\n<tr>\n<td>registrant_business_jobtitle<\/td>\n<td>Registrant&#8217;s job title at the company.<\/td>\n<\/tr>\n<tr>\n<td>registrant_home_address<\/td>\n<td>Registrant&#8217;s home address<\/td>\n<\/tr>\n<tr>\n<td>registrant_home_city<\/td>\n<td>Registrant&#8217;s home city<\/td>\n<\/tr>\n<tr>\n<td>registrant_home_province<\/td>\n<td>Registrant&#8217;s home province\/state.<\/td>\n<\/tr>\n<tr>\n<td>registrant_home_postal<\/td>\n<td>Registrant&#8217;s home postal code\/zip code.<\/td>\n<\/tr>\n<tr>\n<td>registrant_home_country<\/td>\n<td>Registrant&#8217;s home country.<\/td>\n<\/tr>\n<tr>\n<td>registrant_home_phone<\/td>\n<td>Registrant&#8217;s home phone number.<\/td>\n<\/tr>\n<tr>\n<td>registration_date<\/td>\n<td>Date this ticket was purchased.<\/td>\n<\/tr>\n<tr>\n<td>row<\/td>\n<td>Seat row.\u00a0 (e.g. A)<\/td>\n<\/tr>\n<tr>\n<td>seat<\/td>\n<td>Seat number.\u00a0 (e.g. 5)<\/td>\n<\/tr>\n<tr>\n<td>section<\/td>\n<td>Seat section.\u00a0 (e.g. North)<\/td>\n<\/tr>\n<tr>\n<td>serialnumber<\/td>\n<td>Ticket&#8217;s serial number<\/td>\n<\/tr>\n<tr>\n<td>series_no<\/td>\n<td>The number of the ticket in the series of tickets purchased.<\/td>\n<\/tr>\n<tr>\n<td>series_total<\/td>\n<td>The total number of tickets purchased.<\/td>\n<\/tr>\n<tr>\n<td>seriesprice<\/td>\n<td>The total price of the ticket series.<\/td>\n<\/tr>\n<tr>\n<td>subtotal<\/td>\n<td>Equals amount paid minus the taxes<\/td>\n<\/tr>\n<tr>\n<td>tax1amount<\/td>\n<td>The dollar amount attributed to tax 1.<\/td>\n<\/tr>\n<tr>\n<td>tax2amount<\/td>\n<td>The dollar amount attributed to tax 2.<\/td>\n<\/tr>\n<tr>\n<td>tax3amount<\/td>\n<td>The dollar amount attributed to tax 3.<\/td>\n<\/tr>\n<tr>\n<td>tax4amount<\/td>\n<td>The dollar amount attributed to tax 4.<\/td>\n<\/tr>\n<tr>\n<td>tax5amount<\/td>\n<td>The dollar amount attributed to tax 5.<\/td>\n<\/tr>\n<tr>\n<td>tendertype<\/td>\n<td>The type of tender used for the payment (e.g. VISA, CASH)<\/td>\n<\/tr>\n<tr>\n<td>testmode<\/td>\n<td>Testmode status, OFF, ACK, or NAK<\/td>\n<\/tr>\n<tr>\n<td>ticketname<\/td>\n<td>The name of the eTicket series.\u00a0 e.g. Semi-final Basketball Playoff Game 1<\/td>\n<\/tr>\n<tr>\n<td>ticketprice<\/td>\n<td>The ticket price.<\/td>\n<\/tr>\n<tr>\n<td>ticketlist<\/td>\n<td>Displays, &#8216;Please print each of your tickets. Use the browser&#8217;s BACK button to return to print more tickets.&#8217;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h5><\/h5>\n<h5>Date Format<\/h5>\n<table>\n<tbody>\n<tr>\n<th>Number<\/th>\n<th>Date Format Sample<\/th>\n<th>mySQL format mask<\/th>\n<\/tr>\n<tr>\n<td>0<\/td>\n<td>August 1st, 2016<\/td>\n<td>%M %D, %Y<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>August 1, 2016<\/td>\n<td>%M %e, %Y<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Aug. 1, 2016<\/td>\n<td>%b. %e, %Y<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Aug 1, 2016<\/td>\n<td>%b %e, %Y<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Aug\/01\/2016<\/td>\n<td>%b\/%d\/%Y<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Aug\/01\/16<\/td>\n<td>%b\/%d\/%y<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>08\/01\/2016<\/td>\n<td>%m\/%d\/%Y<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>08\/01\/16<\/td>\n<td>%m\/%d\/%y<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>2016-08-01<\/td>\n<td>%Y-%m-%d<\/td>\n<\/tr>\n<tr>\n<td>9<\/td>\n<td>16-08-01<\/td>\n<td>%y-%m-%d<\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>2016<\/td>\n<td>%Y<\/td>\n<\/tr>\n<tr>\n<td>none of above<\/td>\n<td>use this as format mask<\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>All the following variables will be replaces with the appropriate data. They must be enclosed between &#8220;%% %%&#8221; to work (e.g. %%amount_paid%%). Variables &nbsp; Variable Variable Definition in eTickets total_amount_paid The total amount charged to credit card or other payment type. amount_paid The event amount charged to credit card or other payment type. barcode_image barcode [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[98],"tags":[56,187,198,188],"class_list":{"0":"post-311","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-etickets","7":"tag-branding","8":"tag-etickets-variables","9":"tag-morph","10":"tag-variables","11":"entry"},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7kUZg-51","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/posts\/311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/comments?post=311"}],"version-history":[{"count":7,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/posts\/311\/revisions"}],"predecessor-version":[{"id":1122,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/posts\/311\/revisions\/1122"}],"wp:attachment":[{"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/media?parent=311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/categories?post=311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/e-registernow.com\/support\/wp-json\/wp\/v2\/tags?post=311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}