Changes

Jump to navigation Jump to search

Expedia Mapping

4,435 bytes added, 23 April
no edit summary
*Beds24.com can add a multiplier to prices to convert to a different currency
*View, manage and create promotions
*Check the status of your property at Expedia
*Communicate with guests from the Booking.com Beds24.
Orbitz can also be updated via Expedia EQC. If you want to do this your property should be connected to Expedia first. Please contact Expedia support for details.
 
<span style="color: #f3e504; font-size: 250%;" >{{#fas:lightbulb}} </span>Rev+, Powered by Expedia Group: After you have connected your property to Expedia you can access real-time pricing data and market insights which will help you make smarter decisions via a click on the "Intelligence" button in the CALENDAR.
==Limitations==
*Expedia can not send cancellation fees for cancelled bookings. These must be manually adjusted when you receive notification from Expedia of a cancellation.*Expedia rate plans with with LOS (length of stay) enabled are not supported.*Expedia does not send guests addresses.*If you have multiple room types and make a change which applies to your whole property the updates will send for one room type at a time. This limitation will then apply to all channels you use.*For some Expedia partner sites (affiliates), communication via Beds24 is not possible.
== Before you connect ==
*Expedia supports two pricing models:
**If your pricing model is '''Per Day Pricing''' you will need a price for the maximum room occupancy. Example: If maximum number of guests is 4 you need a ROOM price for four guests. Prices for 1, 2 or 3 guests are not sent. If you use daily prices with "Extra Person" prices your daily price needs to be set for the max occupancy and the "Extra Person" price needs to be added with a negative value so the price for the full occupancy can send.
**If your pricing model is '''Per Occupancy Pricing''' a price for each occupancy defined in Beds24 can be sent. '''Expedia accepts prices for up to 20 guests.''' If you use daily prices the daily price will send including occupancy. Multiple occupancy prices can send on each rate plan. Extra person price will send. If you use rates Fixed Prices 1 person, 2 person and room price will send. Room price will send for specified occupancy. Multiple rates prices with different occupancies can send on same rate plan. Prices for "Extra Person", "Extra child" and discounts set in the "Discounts" tab of the rate Fixed Prices can not be sent. If you use daily prices they daily price will send including occupancy. Multiple occupancy prices can send on each rate plan. Extra person price will send.
'''Bookings'''
Bookings made within 30 days prior to the connection is established can All upcoming bookings will be imported, older bookings must be manually entered into Beds24 via a .csv file to block the dates.
'''Extras and Taxes'''
'''Dorms'''
The price sent to Expedia is the price per bed. You will need a daily price Daily Price or rate Fixed Prices for one guest. If you use rates Fixed Prices enter your bed price as "room price" as well. If required you can ask Expedia support to add extra person fees directly at their end.
==What you will need==
== Set Up==
==='''Step 1 - Select Beds24 as your channel manager in your Expedia===account'''Select Beds24 as channel manager from the "Expedia Connectivity Settings" section in your Exepdia Expedia Extranet
[[Image:expdia_self.jpg|100px|link=]]
Expedia will then send you an email in which you can also see which Pricing Model you are using.
==='''Step 2 - Connect your Expedia accout to Beds24.com===''' In Beds24 go to {{#fas:cog}} (SETTINGS) CHANNEL MANAGER > EXPEDIA  
*Enter your hotel id
*Save
*Select if your Expedia price model is "Per Day Pricing" or "Per Occupancy Pricing". You will find this information in {{#fas:cog}} (SETTINGS) CHANNEL MANAGER > EXPEDIA > ROOMS & RATES and in the activation E-Mail from Expedia.*Select if your Expedia "Akquistion Acquisition type" is "Set by rate plan ID" (if you have both "Sell and "Net" rate plans, - "Net" or "Sell". You will find this information in {{#fas:cog}} (SETTINGS) CHANNEL MANAGER > EXPEDIA > ROOMS & RATES and in the activation E-Mail from Expedia.<span style="color: #f3e504; font-size: 200%;" >{{#fas:lightbulb}} </span> If you have both sell and net rate rate plans set "Acquisition Type" = "Set by Rate plan id" and remove the rate plan id in SETTINGS-> CHANNEL MANAGER > EXPEDIA and make sure you have mapped the mapped the applicable Expedia rate plan in all your prices you want to send to Expedia.
[[Image:hotel-id-expedia.png|500px|link=]]
Mapping:'''Step 3 - Map your rooms and rates '''
<embedvideo service="youtube">https://youtu.be/-SbeMMSk8wc</embedvideo>
Map Rooms:
*Click on the "Get Code" link next to the room type id setting.
*Choose the Expedia room type id you want to map to each Beds24 room and click on it.
*If your price model is "Per Day Pricing" you will need a price for the maximum room occupancy. Example: If maximum number of guests is 4 you need a ROOM price for four guests. Prices for 1, 2 or 3 guests are not sent.
*If your price model is "Per Occupancy Pricing" rates can send a price for Single (1 guest), Double (2 guests) and a room price (for the number of guests you have defined in the rate). If you have more than 3 occupancy levels you can set up additional rates fixed prices or daily prices in Beds24 for each occupancy level and map them in the channel settings of the rate or the daily price. **If you use daily prices you can set the rate code under "Enable" in the Daily Price settings (PRICES >DAILY PRICE SETUPRULES)**If you use rates fixed prices go to the "Channels" tab of the ratefixed price.
The end selling price on Expedia may be different to the price sent, please check if your Expedia account is set for "Sell Rate" or "Net Rate" type and adjust the prices accordingly.
<span style="color: #f3e504; font-size: 250%;" >{{#fas:lightbulb}} </span> Click on the "View Actual Data" Button to check which prices and availability will send. Prices that had already been set in Expedia be overridden but cannot be removed. If no prices have are sent from Beds24, no availability is sent, but the which originally was in Expedia is displayed.
==Multiple Rates at Expedia==Expedia can support more than one price per room and date for example to send prices for different minimum stays, meal options or refundable and non'''Step 4 -refundable prices. There are two options:Enter registration (optional if registration is mandatory)'''
'''1*Click on the "Registration details" button *Click on "Update Registration" to enter you registration details. Derived (Linked) Prices'''
Expedia.com can auto calculate, link and derive rate prices using preset rules. Ask your Expedia.com rep to set this up.
This option means you only need to send one rate from Beds24 to Expedia.com and Expedia.com will auto-calculate the other rate options.
'''2. Multiple Rate Plan IdsStep 5 - Import existing bookings from Expedia '''
Expedia.com can set up multiple rate plan ids *Tick the "Bookings" check box for each mapped room, each with pre-defined booking conditions. Beds24 can map a different Beds24 rate/daily price or offer to each Expedia.com rate plan id. [[Setting_Prices_for_Booking_Channels#Mapping_channel_rate_codes|Please use these instructions]]*SAVE *Click the "Import existing bookings" button.
If you do not have the appropriate rate plan ids you need to request Expedia[[Image:importbookings.com to add thempng|500px|link=]][[Media:importbookings.png|view large]]
== Price Multiplier ==If you want to add Expedia will only send a multiplier to your prices, summary for example because of a different currency to your Beds24 currency, add a * followed by the multiplier number manually imported bookings but modifications to your hotel Idthese bookings will automatically import.
For example a hotel id setting '''123456*1.23''' will multiply all prices by 1.23 sent for hotel id 123456. (i.e. raised by 23%)Lower prices can be sent with a multiplier less than 1, i.e. '''123456*0.85Step 6 - Activate the connection ''' will send a price 85% of the normal price (i.e. lowered by 15%)
To convert the price of *Make sure your inventory is correct in Beds24. Check existing bookings imported from Expedia add a * after the multiplier, for example '''123456*1.23*''' will divide the price of the booking imported and dates blocked by 1.23other sources are blocked in Beds24.
You can also use currency conversion template variable*Enable the connection in Beds24 by ticking "Inventory and Rates" for each mapped room and saving. All currencies supported by the booking page currency selector can The "Bookings" checkbox should already be ticked but tick it as well if it is not ticked and bookings should be usedimported.
Example: *[CONVERT[Image:IDR-EURactivate.png|500px|link=]] will convert Indonesian Rupees to Euros. Example: *[CONVERT[Media:IDR-EURactivate.png|view large][/]0.85 will convert Indonesian Rupees to Euros and divides the price by 0.85 which raises it by circa 15% == Maximum number of accepted bookings ==By default all available rooms are sent to activated channels. In SETTINGS->CHANNEL MANAGER->CHANNEL INVENTORY limit the number of accepted bookings for this channel.
==Activating==Before you activate '''Step 7 - Check the connection you can view the live availability and prices that will be sent to Expedia using the "View actual data" button.Connection '''
*Click on the "View actual data" button to see which prices and availability will send to Expedia
[[Image:actualdata.png|500px|link=]]
[[Media:actualdata.png|view large]]
*Click on "View Status at Expedia" to check the status of your property at Expedias end. If you see an error and do not understand what it means contact Expedia support.
1) Import existing bookings made The connection is working if you are not receiving error messages and the display in the channel is correct. If you are receiving error messages check in the last 30 days from Expedia"Common Errors" section why you are receiving the error and how to fix it.
Make sure the "Bookings" check box for each mapped ==Multiple Rates at Expedia==Expedia can support more than one price per room is ticked and saved date for example to send prices for different minimum stays, meal options or refundable and then click the "Import existing bookings" buttonnon-refundable prices.There are two options:
[[Image:importbookings'''1.png|500px|link=]][[Media:importbookings.png|view large]]Derived (Linked) Prices'''
Expedia will .com can auto calculate, link and derive rate prices using preset rules. Ask your Expedia.com rep to set this up.This option means you only need to send bookings made within the last 30 daysone rate from Beds24 to Expedia.com and Expedia. Modifications to these bookings com will automatically importauto-calculate the other rate options.
Bookings made earlier can be imported via a CSV file and you will need to update these bookings manually'''2.Multiple Rate Plan Ids'''
aExpedia. Export your bookings as CSV from Expedia bcom can set up multiple rate plan ids for each room, each with pre-defined booking conditions. Go Beds24 can map a different Beds24 rate/daily price or offer to https://api.beds24each Expedia.com/csv/putbookingcomcsvrate plan id.php and import the csv file to Beds24. Follow the [[Setting_Prices_for_Booking_Channels#Mapping_channel_rate_codes|Please use these instructions on the page carefully so they import to the correct rooms]].
If this is also unsuccessful, block you do not have the booked dates in the beds24 calendarappropriate rate plan ids you need to request Expedia. Please note that in this case cancellations and modifications will not be imported automaticallycom to add them.
== Price Multiplier ==
If you want to mark your prices up or down or need currency conversion you can add a multiplier to your prices, add a '''*''' followed by the multiplier number in the "Multiplier" field
2) Make sure your inventory is correct in Beds24Examples:*'''*1.23''' will multiply all prices by 1.23 (i.e. Check existing bookings from Expedia imported and dates blocked raised by other sources are blocked in Beds2423%). Dates *Lower prices can be blocked sent with a multiplier less than 1: '''*0.85''' will send 85% of the normal price (i.e. lowered by either entering 15%).*To convert the price of bookings imported from the channel add a booking manually into Beds24 for those dates or using '''*''' AFTER the multiplier. '''*1.23*''' will divide the inventory and override functions on price of the control panel calendar for those datesbooking by 1. Failure to do this could allow new bookings on dates 23.*For currency conversion you are not availablecan also use currency conversion template variables. All available dates in Beds24 currencies supported by the booking page currency selector can be used.**'''*[CONVERT:IDR-EUR]''' will be sent convert Indonesian Rupees to Expedia as available for new bookingsEuros.
3) Enable the connection in Beds24 by ticking "Inventory and Rates" for each mapped room and saving. The "Bookings" checkbox should already be ticked but tick it as well if it is not ticked and == Maximum number of accepted bookings should be imported. [[Image:activate.png|500px|link=]]=[[Media:activateBy default all available rooms are sent to activated channels.png|view large]] 4) New In SETTINGS->CHANNEL MANAGER->CHANNEL INVENTORY limit the number of accepted bookings made after XML is enabled will import to Beds24 automaticallyfor this channel.
== Check Connection ==
The connection is working if you are not receiving error messages and the display in the channel is correct. If you are receiving error messages check in the "Common Errors" section why you are receiving the error and how to fix it.
== Updates and Changes==
== Manage Bookings==
===Virtual Credit Cards ===
Virtual cards can be set to be auto charged at the date they become valid. To use this option *set "Auto Process Virtual Cards" = Yes*make sure your Merchant Category Code (MCC) in Stripe is "Lodging."
Virtual cards can be set to be auto charged at the date they become valid.
===Expedia Collect ===
If Expedia collects the payment from the guest they will send the amount you have to pay to Expedia and not the amout the guest paid. The guest has received the invoice from Expedia so you do not need to invoice them for the room charges.
 
===Send and receive messages ===
You can get communicate with Expedia guest directly from Beds24.
You can view all messages from the "Messages" component on the DASHBOARD and individual communication from the "API Messages" tab in the booking.
 
To use this function you should:
 
1. Add the component "API Messages" to your [[:Category:Dashboard|DASHBOARD]]
 
2. To send Auto Action Emails via messaging set "Send Message" on the "Messaging" tab in the Auto Action to one of the API options. We will remove the HTML from the message because Vrbo does not support HTML. You have the option to add a plain text message for this purpose.
 
Expedia supports attachments in PDF, JPG, PNG, GIF and PDF format.
 
<span style="color:#fe746c;“ >{{#fas:exclamation-triangle}} </span> If you use dependencies you can only assign the bookings in to a room in the same property as the room which is mapped to Expedia.
 
=== Report No-shows, date changes request cancellations or restrict channel modifications ===
*You will see buttons in the "Detail" tab of the bookings which allow you to report changed stay dates, cancellations by guest, no shows, changed cancellation penalties and changed stay prices to Expedia.
**Report invalid cards
**Report date changes
**Report No-shows
**Cancel a reservation as requested by the guest - A lodging partner can request to cancel a reservation and agree to waive (or refund , if applicable) any cancellation fees and other amounts associated with the reservation. Expedia Group will not charge any compensation for these waived amounts.
**Cancel a reservation if the method of payment is invalid (Hotel Collect only)
If the credit card provided by the traveler is invalid, the partner can request to cancel the reservation and agree to waive (or refund, if applicable) any cancellation fees and other amounts associated with the reservation. Expedia Group will not charge any compensation for these waived amounts.
 
*If you want to not allow channel modifications by default you can change the setting for "Allow Channel Modifications" value" in {{#fas:cog}} (SETTINGS) CHANNEL MANAGER.
 
===View and reply to reviews===
If a guest sends you a review, you can view it via the "Mail & Action" tab in the booking in Beds24 and also reply to the guest directly from there.
===Info Codes===
|-
 | AGODACOLLECT| Agoda hotel collect booking|- | AGODACOMSERVICEEXPEDIACOLLECT| Agoda booking with extra service (parking, breakfast)Expedia hat eine virtuelle Karte gesendet
|-
 
|CARDTOSTRIPE
3) "Extra Person" prices cannot be exported but can still be set manually in Expedia.
4) If the room is for more then 2 guests you need a room price for the number of guests the room can accommodate.
==Common Errors==
 
'''Unsupported operation. Message cannot be added to the specified message thread ID ec54f39b-4e10-432a-a121-538ac6b39c4e because the reservation was made on an unsupported point-of-sale. '''
The booking was made on an Expedia partner site for which Expedia does not support messaging.
 
 
If there is an error on an update, the error message returned by Expedia will be emailed to you.
Common errors and their solutions are:
'''Sell Rates are not expected for Merchant rate plan or Net Rate hotels.'''
Change the setting for "Acquisition Type" to "Net".
IIt If you have both sell and net rate rate plans set "Acquisition Type" = "Set by Rate plan id" and remove the rate plan id SETTINGS-> CHANNEL MANAGER > EXPEDIA and make sure you have mapped the mapped the applicable Expedia rate plan in all your prices you want to send to Expedia.
'''The following roomtype id (xxxxx) does not belong to the given hotel: xxxxx'''
You are trying to update rooms which you do not have in Expedia. You can only update IDs which you see when you go to SETTINGS-CHANNEL MANAGER-Expedia and then click on "Get Codes"
 
''' Invalid data in request: Provided id xxx is not integer '''
Please check your mapping. You can only update IDs which you see when you click on and then click on "Get Codes" in SETTINGS-CHANNEL MANAGER > EXPEDIA or the " Channels" tab of the prices.
'''Stop sell outside of Y with remaining base availability '''
A common cause of this error is not having a valid price for the room in Beds24 on the affected dates.
Any date without a price will be closed in Beds24 and we will send an inventory of zero to Expedia.
*Make sure you have valid rates prices for the mentioned dates and no bookings from other sources
*Beds24: change your inventory to send the allotment you have guaranteed Expedia (e.g. by removing bookings from other sources)
*Expedia: Ask Expedia to remove the guaranteed allotment
You can only update IDs which you see when you click on "Get Codes".
You have added a number which is not a valid Expedia rate id into the field in the "Channels" tab of a rate/daily price.
*Go to Prices > Channel Mapping enter the Rate id in the Search box and click on the Rate and make sure the correct Expedia rate id is selected from the 'get codes' list.
*Scroll to Rate id and click 'get codes' ensure you select a valid code from the list.
*Open your rates fixed prices (Channel Tab) and make sure the correct Expedia rate id is selected from the 'get codes' list.
*Open your daily prices (Enable list) and make sure the correct Expedia rate id is selected from the 'get codes' list.
 
'''Room is not active OR ROOM_NOT_ACTIVE'''
You can only update IDs that you see when you click on "Get Codes".
*Scroll to Room id and click 'get codes' to ensure you select a valid code from the list.
'''Non-existent rate plan and rate level pair provided'''
You can only update IDs which you see when you click on "Get Codes". Check all codes entered in SETTINGS-CHANNEL MANAGER-EXPEIDA, the "Channels" tab of your rates fixed prices(if rates fixed prices are used) and your daily prices.
'''Inactive rate plan for restriction or rate updated'''
You are sending a wrong rate plan id. Check your You can only update IDs which you see when you click on "Get Codes". You have added a number which is not a valid Expedia rate plan ids in SETTINGS->CHANNEL MANAGER->EXPEDIA and id into the field in the "Channels" tab of your ratesa rate/daily price. *Go to Prices > Channel Mapping enter the Rate id in the Search box and click on the Rate and make sure the correct booking.com rate id is selected from the 'get codes' list. *Scroll to Rate id and click 'get codes' ensure you select a valid code from the list. *Open your fixed prices. Please use (Channel Tab) and make sure the correct Expedia rate id is selected from the function 'get codes' list. *Open your daily prices (Enable list) and only use make sure the correct Expedia rate ids id is selected from the drop-down 'get codes' list.
'''MinLOS value (x) exceeds Extranet auto-approval threshold (y) for length of stay.'''
'''The value '' of attribute 'username' on element 'Authentication' is not valid with respect to its type'''
The username/and or password you entered are wrongEnter wrong. Enter your Expedia Quick connect username and password which Expedia sent you by Email (NOT your normal Expedia username and password)
'''LOS restriction conflict - Min Nights Greater Than Max Nights.'''
Expedia is not accepting the minimum stay you are sending because you have a maximum stay in your Expedia extranet which is lower than the minimum stay you are sending. You have 2 options fix this:
1. Log into your Expedia extranet and raise or remove the maximum stay.
2. Set the "Maximum Stay" in the rates fixed prices you are sending to Expedia to 28 or lower.
'''Access denied'''
'''Inventory date 201x-xx-xx; Room Type ID xxxxxx; Rate Plan ID xxxxxx ; Inactive Rate Plan'''
You are trying to update an inactive rate plan. You can only map rate plans update IDs which are available you see when you click on "Get Codes". Please remove this ID from SETTINGS->CHANNEL MANAGER->EXPEDIA and/or You have added a number which is not a valid Expedia rate id into the field in the "Channels" tab of a rate/daily price. *Go to Prices > Channel Mapping enter the Rate id in the Search box and click on the Rate and make sure the correct booking.com rate id is selected from the 'get codes' list. *Scroll to Rate id and click 'get codes' ensure you select a valid code from the list. *Open your rates fixed prices (Channel Tab) and make sure the correct Expedia rate id is selected from the 'get codes' list. *Open your daily prices(Enable list) and make sure the correct Expedia rate id is selected from the 'get codes' list.
'''Rate Plan ID XXXXXXX Occupancy X; Occupancy exceeds maximum allowed value'''
'''Length of stay has to be provided for the Rate Plans with LOS enabled.'''
Expedia rate plans with with LOS (length of stay) enabled are not supported. Please ask Expedia to change your rate plans.
'''Room Type ID 1231234234; Rate Plan ID 1231234234; Occupancy x; Occupancy exceeds maximum Room Type Person Count Y'''
You are trying to send a price for a higher occupancy than what the room is set up in Expedia for. Please correct the maximum number of guests either in Expedia or in Beds24.
'''The restrictions of restrictionId are derived and cannot be updated ''' OR '''The rates of rateId are derived and cannot be updated ''' Your rates fixed prices have restricitons which restrictions that are linked in Expedia therefore Expedia does not allow us to update them. Contact Expedia support and ask them to remove all linkages for restrictions.
'''7028 (India only)'''
=== What to do when I receive an overbooking?===
*Check if you are receiving error messages by email or in the potential issues menu. Error messages need to be addressed immediately because they can mean the channel manger manager is able to make updates.
*Entering the same Expedia room code in multiple rooms in Beds24 can cause overbookings. Check your set up for warnings.

Navigation menu