Changes

Jump to navigation Jump to search

Upsell Items

9,553 bytes added, 14:56, 28 August 2019
[[Category:How to]]
[[Category:Invoice]]
[[Category:Enhanced_Selling]]
''This page is about the menu SETTINGS->PROPERTIES->UPSELL ITEMS''
 
 
Upsell Items are shown on the booking page after the guest has selected their room or rooms.
The items can be used to show and allow booking of optional items and services or to add compulsory fee's like taxes and charges.
A selector is available Up to add the Upsell Items to existing bookings in the control panel on the bookings "Charges and Payments" tab20 upsell items can be created per property.
Up Note: Upsell Items can not be exported to 20 upsell items OTAs. If required you can be created per propertyset them up directly in the channel.
=== Type of Item===
Upsell items of the following types can be created. The Description can be entered in each language. The description can contain HTML tags to enhance the on screen display. These tags will not show in emails, rate description and invoice fields. You can add a picture which has been uploaded by adding the "Image Tag" from SETTINGS -> BOOKING PAGE -> PICTURES.
Upsell items of the following types can be createdExample: <nowiki><p>Spa Treatment</p></nowiki> <img src="https://media.xmlcal.com/pic/p0000/3103/01.png" alt="Extra" width="200" height="141">
==== Optional ====
 
The optional item type is selected by a check box on the booking page.
The Per and Period values are used to calculate how many of the items are required.
The Description can be entered in each language. The description can contain HTML tags to enhance the on screen display. These tags will not show in emails, rate description and invoice fields. You can add a picture which has been uploaded by adding the "Image Tag" from SETTINGS -> BOOKING PAGE -> PICTURES   ===== Optional Quantity =====
The optional quantity type works like the optional type except the guest can select the quantity they would like using a selector.
 ===== Optional Percentage =====
The optional percentage is calculated and added to invoice when the item is selected.
==== Obligatory ====
 
The obligatory type is like an optional type except it is added automatically to the booking and cannot be removed.
An example would be a cleaning charge or fee.
Per = Booking The percentage is calculated on the room price plus all selected extras defined before this one. Extra items defined after this will not be included in the percentage calculation. This could be used to add tax free items after the tax calculation.  Per = Room The percentage is calculated on the room price only. ===== Obligatory Percentage (Tax) Cleaning =====This fee will be applied to the booking page. It will not send to OTAs. Some OTAs allow to send cleaning fees. For information where to set this up see the channels help pages.
===== Obligatory Percentage =====
The obligatory percentage type is like the Optional Percentage type except it is always calculated and added to the booking and cannot be removed.
The setting Per Room means the value is calculated as a percentage of the room price and not other upsell items.
The setting Per Booking means the value is calculated as a percentage of the room price plus all selected items appearing before this one. See "Order of the Items" for more information.
 
===== Obligatory Percentage Tax =====
The obligatory percentage tax type is like the Obligatory Percentage type except it that it will be added to the "Price" field and the "Tax" field in the "Charges and Payments" tab the booking.
 
==== Refundable====
Under "Period" upsell items can be set to be "Refundable". Refundable upsell items work like obligatory upsell items but are not sent to comparison sites like Trivago or Tripadvisor.
 
=== Description ===
The Description can be entered in each language. The description can contain HTML tags to enhance the on screen display. These tags will not show in emails, rate description and invoice fields. You can add a picture which has been uploaded by adding the "Image Tag" from SETTINGS -> BOOKING PAGE -> PICTURES.
 
Example:
<nowiki><p>Spa Treatment</p></nowiki>
<img src="https://media.xmlcal.com/pic/p0000/3103/01.png" alt="Extra" width="200" height="141">
 
====Status====
You can show an invoice sume for certain upsell items only, exclude upsell items from thetotal, or group specific items in reports.
To do this you use the status. You set the status field of the invoice item include a pipe symbol | between the description text and the status text. For example Description of item | Status.
=== Order of the Items ===
 
The order the items are defined in the control panel is important for percentage calculations.
=== Voucher Codes ===
 
Voucher code discount values can also be affected by the order upsell items are created. Voucher code discounts are not applied to any items from or after the first compulsory percentage item.
=== VAT ===
 
Each item can be assigned it's own VAT rate if for example some items are VAT free or have discounted VAT rates.
Note: VAT is generally the tax already included in the price and should not be confused with a tax added by an obligatory percentage value.
 
=== Adding an Upsell Item to a Booking ===
A selector is available to add the Upsell Items to existing bookings in the control panel on the bookings "Charges and Payments" tab.
 
[[Image:Upsell1.png|550px|link=]]
[[Media:Upsell1.png|view large]]
=== Rates and Limiting availability of items ===
Upsell items can be enabled/disabled for individual rates. When a booking is made only those upsell items enabled for any rate involved in the booking will be offered to the guest.
 
[[Image:Upsell2.png|550px|link=]]
[[Media:Upsell2.png|view large]]
Optional upsell items can be enabled/disabled for individual rates. When a booking is made only those optional Upsell items enabled for any rate involved in the booking will be offered to the guest.
If a combination of Daily Prices and Rates is offered then all Upsell items will be offered.
Obligatory If you have extras you only sell on site you can set them up as "Invoice Items" in SETTINGS->GUEST MANAGEMENT->INVOICING. ===Different upsell items for different rooms===Upsell items are always enabled created on property level. However, you can activate an upsell item for a rate, and cannot the rate can be disabled by specific for a room. Create your different upsell items. In the rate menu go to the upsell tab and activate/deactivate the upsell you want for the room that is attached to the rate. == Display prices including obligarory fees on the first screen on your booking page==To do this, you use a ratethat already contains the fees.
Example: The price per night is €100. € 50 cleaning fee apply regardless on how long the guest stays.
"Summary" tab of the rate:*Room Price =150 "Discounts" tab of the rate:*Nights =2*Per night = Custom Reports ===50
Note: Discounts set in the "Discounts" tab of the rate do not send to OTAs. Check the help page of the OTAs you are using for information on how fees are handled.
 
===Reports and Templates===
The value or quantity of each individual item can be added as columns in custom reports.
The columns are called "Upsell 1 Value" and "Upsell 1 Qty" etc. where the number is the order they have been created.
 
[[Template Variables|Template Variables]] can be used to display invoice charges in invoices, booking templates or Email templates.
=== Activities ===
 
If you want to offer extras separate to the booking and manage and/or display availability through the system have a look here: [[Sell Extras like Activities or Car Rental]]
 
=== Limitations ===
 
If you allow "Multiple Room Bookings" the system will apply obligatory extras to all rooms and allow optional extras for all rooms.
Upsell Items can not be sent to OTAs. If you want to set up extras for bookings from a channel you will need to do this in the channels extranet.
=== Examples ===
'''Example 1''': An obligatory cleaning fee of 50 applies once to all bookings.
 
Go to SETTINGS->PROPERTIES->UPSELL ITEMS and add the cleaning fee as an "Upsell Item" with the settings
 
Type = obligatory
 
Description = Cleaning Fee (if multiple languages are activated enter the description in all languages)
 
Amount = 50
 
Per = booking
 
Period = one time
 
Vat % = if applicable enter the VAT rate
 
 
'''Example 2''': A guest house offers an optional breakfast costing 10 per day. 19% VAT are included in the price for the breakfast.
 
Go to SETTINGS->PROPERTIES->UPSELL ITEMS and add breakfast as an "Upsell Item" with the settings
 
Type = optional
 
Amount = 10
 
Per = person
 
Period = daily
 
Vat % = 19
 
 
'''Example 3''': A lodging needs to charge 5% city tax on all bookings.
 
Go to SETTINGS->PROPERTIES->UPSELL ITEMS and add the tax as an "Upsell Item" with the settings
 
Type = obligatory % tax
 
Description = City Tax (if multiple languages are activated enter the description in all languages)
 
Amount = 5
 
Per = booking
Period = one time Vat % = if applicable enter the VAT rate  '''Per Person or per night Taxes based on ageExample 4'''Example: City tax only applies to children over 10 years of age.
Go to SETTINGS->BOOKING PAGE -> DEVELOPERS "Custom Text" and exchange the default text for children:
Child|Child under 10
Then set your tax as "obligatory" "per day" or "per booking" "per adult".
'''Example 5''': Add additional charges for children. Go to SETTINGS->PROPERTIES->UPSELL ITEMS and add the charges as an "Upsell Item" with the settings (1) Children under 2 go Free  Type = optional Description = Children under 2- Free (if multiple languages are activated enter the description in all languages) Amount = 0 Per = Child Period = Daily Vat % = if applicable enter the VAT rate  (2) Children between age 3- tax which is included 6 years old  Type = optional Description = Children between 3-6 (if multiple languages are activated enter the description in all languages) Amount = 5 Per = Child Period = Daily Vat % = if applicable enter the price'''VAT rate (3) Children over 6 years old  Type = optional Description = Children over 6 (if multiple languages are activated enter the description in all languages) Amount = 10 Per = Child Period = Daily
If your prices include VAT you can set Vat % = if applicable enter the VAT rate in SETTINGS->PROPERTIES->BOOKING RULES.
To show included taxes in Create an Upsell item for each age level with the invoice use the template variables [INVOICETABLEVAT] or [INVOICETABLEVAT2] appropriate prices.
''' Reports '''
In REPORTS->CUSTOM REPORTS you can create custom reports which show Upsell Items (additional taxes) and VAT.
'''Example 16''': 7% VAT are included in the room price. The lodging offers breakfast as an extra. 19% VAT are included in the price for the breakfast. Additionally the lodging needs to charge 5% city tax on which 7% VAT applies
Go to SETTINGS->PROPERTIES->BOOKING RULES and set "Vat Rate %" = 7
1) add breakfast as an "Upsell Item" with "Vat %" = 19
2) add city tax as an obligarory % tax "Upsell Item"  To show VAT change your confirmations (SETTINGS->GUEST MANAGEMENT->CONFIRMATION MESSAGES) and invoice template (SETTINGS->GUEST MANAGEMENT->INVOICING) to use the template variable [INVOICETABLEVAT]. == Offer Extras after the Guest has Booked ==You use a property with a special set up to sell extras to guests that have already made a booking. They will need to enter their accommodation booking number when the make the booking so the owner can ‘group’ the bookings. Set upAdjustments for your lodging property Add a Custom Question to your Booking page SETTINGS -> PROPERTIES-> BOOKING QUESTIONS so a guest can enter the original booking id so you can link the bookings together. '''1. Set up "Extras" property''' *Go to SETTINGS -> PROPERTIES and click on ADD NEW PROPERTY.**Click on EDIT and you will get to PROPERTIES -> DESCRIPTION. Enter the name (e.g. Extras – after booking) and the currency you accept. Set the "Type of Booking" to "Activity".*Go to SETTINGS -> PROPERTIES-> ROOMS ->SETUP**enter in “Name” the name of your extra (i.e. Welcome Hamper)**set the "Quantity" = the number you want to sell in advance, this can be based on the number of rooms per day (i.e. one hamper per unit)**set "Unit Allocation" = One per Booking**set Collect Number of Guests = No**Maximum Guest = 1**set "Maximum Stay" = Single Day Activity**enter "Accommodation Type" = Welcome Hamper**Enter in "Accommodation Type" what the guest books e.g. "Welcome Hamper” Repeat (1) above for the number of Extras you want to offer to your Guests.  Create individual Rooms/Units for each Extra you want to offer (e.g. different prices or types – Large Hamper, Gourmet Hamper, Champagne Hamper, Cooking course, Spa Day) If you need to collect the number of guests for example Evening meals, you will need to setup the Room/unit slightly differently as you may allow your guests to book per person/adult/child *Go to SETTINGS -> PROPERTIES->ROOMS ->SETUP **enter “Name” – the name of your extra (i.e. Welcome Dinner)**set the "Quantity" = the number you want to sell in advance, number of guests**set "Unit Allocation" = One per booking**set Collect Number of Guests = Yes**Maximum Guests = Number of guests per booking**Maximum Adults = Number of Adults per booking, should be the same as the ROOM types you have (may need to be higher if you have a mix of room types)**Maximum Children= Number of children if you offer different prices for Adult/Child meals **set "Maximum Stay" = Single Day Activity**enter "Accommodation Type" = Welcome Meal *Go to SETTINGS -> BOOKING PAGE->DEVELOPERS and exchange all phrases which refer to accommodation. Enter for example the following in "Custom Text" Check in|Purchase Date Book Multiple|Buy Multiple Book|Buy Guest|Hamper Guests|Hamper Click to Book Now|Click to Buy Now Confirm Booking|Buy Now Guest Details|Details Click here to make another booking|Click here to make another purchase Click here to make another booking|Click here to make another purchase '''2. Set prices for your Extras''' For Single items, like Welcome Hamper etc, Daily Prices will work as you are likely to be selling 1 item per booking.
To show VAT change your confirmations (SETTINGS->PROPERTIES->CONFIRMATION MESSAGES) For Meals etc, we suggest you setup RATES as you can add Single, Extra Person and invoice template (SETTINGS->GUEST MANAGEMENT->INVOICING) to use the template variable [INVOICETABLEVAT]Extra Child prices.
'''Example 23. Further settings''': 13% VAT are included in the room price which is 95 per night. The lodging offers and obligatory breakfast as an extra costing a fixed 5% of the room price. 23% VAT are included in the price for the breakfast. Additionally the lodging needs to charge 5% city tax on the price net lodging price and on the net breakfast price.
*Go to SETTINGS->PROPERTIES->BOOKING RULES and QUESTIONS > CUSTOM QUESTION add a question – Please enter your Accommodation Booking id, set "Vat Rate %" = 13Obiligatory
*Go to SETTINGS->PROPERTIES->UPSELL ITEMS PAYMENT COLLECTION and set up payment collection or use payment requests.
1) add breakfast with *Go to SETTINGS -> GUEST MANAGEMENT -> CONFIRMATION MESSAGES and customise the confirmation message for the settings "obligatory %" "Amount" = 5 "Per" = Room "Period" = Daily "Vat % Extras" = 23property.
2We suggest at least delete everything from the default that refers to accommodation. Ensure you have the details of the Custom Question (Original Accommodation Booking id) add city tax with so that you and the guest have reference to the original booking. (you will need this to ‘group’ the extras to the settings "obligatory %" original booking id. NOTE: You may want to create a new Property for each Extra that you offer to your guests, for example, Food, Experiences, Travel (pickups) "Amount" ='''4.4 "Per" = Booking "Period" = Daily "Vat % " = 0Optional'''
If you want to offer options to your Guests to select prior to their arrival, for example if you offer Evening meals and you would like you guests to select the number of each dish with their booking, then you should add UPSELL items that will show on the guest booking page.
Go to SETTINGS > PROPERTIES > UPSELL ITEMS
*Create an Upsell item for each item
*Type = Optional
*Description = Roast Chicken dinner (for example)
*Amount = 0
*Per = Booking
*Period =Daily
*VAT % = 0
Then go to your Rates (Upsell tab) Daily Price (Upsell items) for this Extra (Evening Meals), then tick the items that should be shown for these items.
'''Manage extras and bookings'''
To show VAT change We suggest that the original booking is your confirmations (SETTINGS->PROPERTIES->CONFIRMATION MESSAGES) Master, then open the Extras Booking, go to “Detail” tab and invoice template copy the value in your Custom Question – Original booking id (SETTINGS->GUEST MANAGEMENT->INVOICINGpoint 7 above) to use the template variable [INVOICETABLEVAT].
In another window, paste the booking id in to the Booking Search box (top right of most pages), click on the booking and then go to the Invoice Tab, scroll down to ‘Add New Booking to Group’ enter the Booking id of the Extras Booking, and click enter, this will create a ‘group booking’ and add the extra to the "Invoice" tab of the booking.
Keywords: '''extras'''*Set up an Auto Action to confirm to the Guest their ‘Extras’ has been received an linked to their Accommodation booking, '''VAT''', '''tax''', '''city tax''', '''taxes''', '''breakfast''', '''meals'''using the Booking ids from both bookings in the email. *Setup an Auto Action to send Payment Request if you have not collected payment at the time of the booking.
770

edits

Navigation menu