Skip to main content
Mailjet Variables

Mailjet variables help you customise Mailjet templates with reusable Ventrata content.

Lucia Burin Sestakova avatar
Written by Lucia Burin Sestakova
Updated over 4 months ago

Booking Details

  • {{var:BOOKING_ACTIVE_FROM_ISO8601:““}} - shows since when the booking is active in ISO 8601 format

  • {{var:BOOKING_ACTIVE_TO_ISO8601:““}} - shows until when the booking is active in ISO 8601 format

  • {{var:BOOKING_CANCELLED_AT:““}} - shows when the booking was cancelled in dd/mm/yyyy format

  • {{var:BOOKING_CARD_TOTAL:““}} - shows total value based on the used payment form

  • {{var:BOOKING_CASH_TOTAL:““}} - shows total value based on the used payment form

  • {{var:BOOKING_CHARITY_ROUNDUP:““}} - shows the charity roundup

  • {{var:BOOKING_COMMISSION:““}} - shows the commission on a booking

  • {{var:BOOKING_CODE:““}} - use for imported booking codes

  • {{var:BOOKING_COST:““}} - shows the cost of the booking

  • {{var:BOOKING_CREATED_AT:““}} - shows the time the booking was created

  • {{var:BOOKING_CREATED_AT_DOW:““}} - shows the day of the week of booking creation tx/ticket/group

  • {{var:BOOKING_CREATED_AT_TIME:““}} - shows the time of booking creation tx/ticket/group

  • {{var:BOOKING_DATE:““}} - shows the travel date

  • {{var:BOOKING_DISCOUNT:““}} - shows the discount on a booking if applied

  • {{var:BOOKING_DROPOFF_TIME:““}} - shows the drop-off time based on booking preferences

  • {{var:BOOKING_DURATION:““}} - shows the booking duration in minutes / hours / days

  • {{var:BOOKING_MARGIN:““}} - shows the margin on a booking

  • {{var:BOOKING_MEETING_POINT:““}} - shows the meeting point

  • {{var:BOOKING_MEETING_TIME:““}} - shows the meeting time

  • {{var:BOOKING.NOT_REDEEMED_WARNING:““}} - this should only show on tickets, so that drivers/sellers know that they shouldn’t accept anyone boarding with this ticket as it:

  1. has not yet been redeemed

  2. may be a discarded redeemed ticket and the ticket has already been redeemed

  • {{var:BOOKING_OPEN_DATED:““}} - indicates whether it is an open dated booking (yes / no)

  • {{var:BOOKING_OPENING_HOURS:““}} - shows the opening hours based on product settings

  • {{var:BOOKING_OTHER_TOTAL:““}} - shows the total value based on the used payment form

  • {{var:BOOKING_PASS:““}} - if the product is inside a pass this returns the reference of the pass

  • {{var:BOOKING_PDF_URL:““}} - dynamic variable; generates a download page url which contains the order ID

  • {{var:BOOKING_PKPASS_URL:““}} - dynamic variable; generates a download page url which contains the order ID

  • {{var:BOOKING_PICKUP_NOTES:““}} - shows any notes regarding pickup

  • {{var:BOOKING_PICKUP_TIME:““}} - shows pickup time (for bookings with pickups)

  • {{var:BOOKING_PICKUP_REQUESTED:““}} - indicates whether the customer requested a pickup (yes / no)

  • {{var:BOOKING_PRIMARY:““}} - indicates whether it is the primary product (the first one that was added) in an order (yes / no)

  • {{var:BOOKING_PRIVATE_NOTES:““}} - shows private notes added by concierge / reseller agents

  • {{var:BOOKING_PUBLIC_NOTES:““}} - shows notes added by concierge / reseller agents when booking on behalf of a client (eg a vegetarian option for lunch)

  • {{var:BOOKING_PURCHASES:““}} - shows booking purchases

  • {{var:BOOKING_QUESTION_ANSWERS:““}} - shows answers to assigned questions

  • {{var:BOOKING_REDEEMED_AT:““}} - shows the date of redemption in the dd/mm/yyyy format

  • {{var:BOOKING_REDEEMED_AT_DOW:““}} - shows on which day of the week was the booking redeemed

  • {{var:BOOKING_REDEEMED_AT_TIME:““}} - shows the time of redemption

  • {{var:BOOKING_REFERENCE:““}} - Ventrata generated unique identifier for the booking

  • {{var:BOOKING_RESELLER_REFERENCE:““}} - Ventrata generated unique identifier for the booking reseller

  • {{var:BOOKING_RESOURCE_ALLOCATIONS:““}} - shows allocated resources

  • {{var:BOOKING_STATUS:““}} - shows the bookings status in Ventrata

  • {{var:BOOKING_SIZE:““}} - shows the number of adults, children, etc. for one ticket per booking

  • {{var:BOOKING_TICKETS:““}} - shows the count of tickets by tier

  • {{var:BOOKING_TIERS:““}} - shows the number of individual booking tiers

  • {{var:BOOKING_TOTAL:““}} - shows the total price for a booking

  • {{var:BOOKING_TOTAL_NO_TAX:““}} - shows the booking total without tax applied

  • {{var:BOOKING_TOUR_GROUP:““}} - shows the name of the tour group

  • {{var:BOOKING_UPDATED_AT:““}} - shows when the booking was updated in dd/mm/yyyy format

  • {{var:BOOKING_UNITS:““}} - shows the number of individual booking units

  • {{var:BOOKING_UPGRADES:““}} - shows booking upgrades

  • {{var:BOOKING_VOUCHER_TOTAL:““}} - shows the total value based on the used payment form

  • {{var:BOOKING_VALID_FROM:““}} - shows booking validity start date

  • {{var:BOOKING_VALID_UNTIL_DATE:““}} - valid until a date

  • {{var:BOOKING_VALID_FROM_DATE:““}} - valid from a date

  • {{var:BOOKING_VALID_UNTIL_TIME:““}} - valid until which time

  • {{var:BOOKING_VALID_FROM_TIME:““}} - valid from which time

  • {{var:BOOKING_VALID_UNTIL_DOW:““}} - valid until day of week

  • {{var:BOOKING_VALID_FROM_DOW:““}} - valid from day of week


Customer

  • {{var:CUSTOMER_FULL_NAME:““}} - name and surname of the customer

  • {{var:CUSTOMER_FIRST_NAME:““}} - first name of the customer

  • {{var:CUSTOMER_LAST_NAME:““}} - last name of the customer

  • {{var:CUSTOMER_EMAIL:““}} - valid email address

  • {{var:CUSTOMER_MOBILE:““}} - phone number, preferably in international format

  • {{var:CUSTOMER_COMPANY:““}} - name of the company the customer works for

  • {{var:CUSTOMER_NOTES:““}} - notes entered by the customer

  • {{var:CUSTOMER_LANGUAGE:““}} - preferred language of the customer

  • {{var:CUSTOMER_COUNTRY:““}} - customer’s country of residence

  • {{var:CUSTOMER_ADDRESS:““}} - street name, number and city where the customer resides

  • {{var:CUSTOMER_POSTAL_CODE:““}} - postal code of the city where the customer resides


Pickups

  • {{var:DROPOFF_NAME:““}} - name of the drop-off

  • {{var:DROPOFF_INSTRUCTIONS:““}} - instructions for drop-off

  • {{var:PICKUP_NAME:““}} - name of the pickup

  • {{var:PICKUP_ADDRESS:““}} - street name, number and city of the pickup location

  • {{var:PICKUP_DIRECTIONS:““}} - directions to pickup location

  • {{var:HOTEL_NAME:““}} - name of the hotel, if listed as pickup location


Product

(You can add a product logo)

  • {{var:OPTION_CODE:““}} - code of the option

  • {{var:OPTION_DESCRIPTION:““}} - brief summary of the option

  • {{var:OPTION_LANGUAGE:““}} - language of the option

  • {{var:OPTION_MEETING_POINT:““}} - meeting point of the option

  • {{var:OPTION_MEETING_TIME:““}} - meeting time of the option

  • {{var:OPTION_NAME:““}} - option name

  • {{var:PRODUCT_BOOKING_TERMS:““}} - booking terms of the product; scroll down the product page to locate the appropriate text fields

  • {{var:PRODUCT_CANCELLATION_POLICY:““}} - the cancellation policy of the product; scroll down the product page to locate the appropriate text fields

  • {{var:PRODUCT_CAPTION:““}} - a short one sentence marketing caption; scroll down the product page to locate the appropriate text fields

  • {{var:PRODUCT_CODE:““}} - product code

  • {{var:PRODUCT_DESCRIPTION:““}} - a short one paragraph description; scroll down the product page to locate the appropriate text fields

  • {{var:PRODUCT_DESTINATION:““}} - destination to which product belongs to

  • {{var:PRODUCT_INCLUSIONS:““}} - product inclusions

  • {{var:PRODUCT_MEETING_POINT:““}} - meeting point of the product

  • {{var:PRODUCT_MEETING_TIME:““}} - meeting time of the product

  • {{var:PRODUCT_NAME:““}} - product name

  • {{var:PRODUCT_OPERATOR_ADDRESS:““}} - the operator address

  • {{var:PRODUCT_OPERATOR_EMAIL:““}} - the operator email

  • {{var:PRODUCT_OPERATOR_MOBILE:““}} - the operator mobile

  • {{var:PRODUCT_REDEMPTION_INSTRUCTIONS:““}} - instructions to redeem a pass for the product; scroll down the product page to locate the appropriate text fields

  • {{var:PRODUCT_USAGE_INSTRUCTIONS:““}} - instructions on the correct usage of the product; scroll down the product page to locate the appropriate text fields

  • {{var:PROMOTION_NAME:““}} - name of the applied promotion

  • {{var:PROMOTION_CODE:““}} - code of the applied promotion

  • {{var:PROMOTION_DISCOUNT:““}} - discounted value after the promotion

  • {{var:TOUR_TIME:““}} - time of the tour

  • {{var:TOUR_CODE:““}} - unique name or identifier of the tour, for example, flight number

  • {{var:DATE:““}} - day and date of the tour

  • {{var:TOUR_MEETING_POINT:““}} - meeting point of the tour

  • {{var:TOUR_MEETING_TIME:““}} - meeting time of the tour


Reseller

  • {{var:AGENT_NAME:““}} - the name of the concierge agent (for reseller sales)

  • {{var:RESELLER_NAME:““}} - the reseller name


Other

  • Big Text will print a larger font size (so it stands out more)

  • You can add images, such as discount badges to be presented or sponsor logos, like Calem

  • Split text will format left-justified column text and an adjacent right-justified column of text

  • When adding a map, enter an address and it will print a picture of a map with a pin showing a location. This can be added to online or reseller’s vouchers and tickets (eg the location to redeem voucher)


Did this answer your question?