The Rates & Availability Calendar is a great way to update or change specific days or when the settings vary per day. On many occasions, the same value(s) will apply for longer periods of times and for that purpose, the Bulk Update is available.

In the Bulk Update the changes are set for the date range, multiple changes can be done at the same moment, and executed on the calendar in one go.
The first part is establish which “products” need to be changed for which period, the second part will establish the actual changes which will be applied.

Part 1: setting channel, room types and period.

Select Channels

  1. Select the Channels to be updated, by checking the corresponding checkbox(es)
    1. Selected checkboxes will be marked blue
    2. At least one Channel needs to be selected, or no updates can be executed

Select room types

  1. Select the Room Types to be updated, by checking the corresponding checkbox(es)
    1. Selected checkboxes will be marked blue
    2. At least one Room Type needs to be selected, or no updates can be executed

Select Rate plans

  1. Select the Rate plans to be updated, by checking the corresponding checkbox(es)
    1. Selected checkboxes will be marked blue
    2. At least one Rate Plan needs to be selected, or no updates can be executed

Select Period

  1. If desired, change/select the ‘From’ date by clicking on the calendar icon in the ‘From’ Field
    1. The From date will be adjusted to the newly selected date.
    2. The ‘Number of days’ will be adjusted, based on the ‘To’ date
    3. If the new ‘From’ is after the set ‘To’ date, the ‘To’ date will be set to the same date and the Number of days to 1
  2. If desired, change/select the ‘To’ date by clicking on the the calendar icon in the ‘To’ field
    1. The To date will be adjusted to the newly selected date.
    2. The ‘Number of days’ will be adjusted, based on the ‘From’ date
    3. If the new ‘To’ date is before the set ‘From’ date, the ‘From’ date will be set to the same date and the Number of days to 1
  3. Select the days of the week to be updated, by checking the corresponding checkbox(es)
    1. Selected checkboxes will be marked blue

Part 2: setting the changes.

Update rates

When rates are changed, the price per day (for the selected period, Rate Plans and/or Room Types in part 1) will be adjusted.

  1. To activate the ‘Update Rates’, check the checkbox
    1. The checkbox will turn blue
    2. Changing the Update method, amount or Currency will also auto activate the rate update (the checkbox will be checked)
  2. Choose the desired Rate Update Method, by using the arrow to open the drop-down (see table below)
  3. Type in the Amount or percentage
    1. The Rate Update Method can be an amount or a percentage
  4. If desired, change the Currency for the Rate Update
    1. Changing can be done to any active Currency, prices will be adjusted in the R&A with use of the current Exchange Rate.
    2. The default currency used here is the Default Rate Currency.

Name Description Remarks
Add to current rate Adds a set amount to the existing price Use to increase the rates with a fixed amount
Subtract from current rate Subtract a set amount from the existing price Use to decrease the rates by a fixed amount
Add % to current rate Add a percentage to the existing price Use to increase the rates by a percentage (calculated over the existing rates)
Subtract % from current rate Subtracts a percentage from the existing price Use do decrease the rates by a percentage (calculated over the existing rates)
Replace current rate with Replaces the existing prices by the new price No calculation done, use to replace the price with a new price

Update Availability

When the Availability is changed, the available number of rooms (for the selected period, Rate Plans and/or Room Types in part 1) will overwrite the value on the calendar and with this the auto setting is no longer active for the changed date(s).

  1. To activate the ‘Update Availability’, check the checkbox
    1. The checkbox will turn blue
    2. Changing the Quantity will also auto activate the Update Availability (the checkbox will be checked)
  2. Set the desired new number of rooms available, by typing in the ‘Quantity’.

Single Use price

When Single Use price is changed, the price for Single use (as sent to the channels) is changed (for the selected period, Rate Plans and/or Room Types in part 1).

  1. To activate the ‘Single use Price’, check the checkbox
    1. The checkbox will turn blue
    2. Changing the Amount or Currency will also auto activate the Single use Price (the checkbox will be checked)
  2. Set the desired new price for the Single use Price, by typing in the ‘Amount’
    1. The current Price for on the R&A Calendar will be overwritten by the new price
  3. If desired, set the Currency for the Single Use Price
    1. Updating can be done in any active Currency, prices will be adjusted in the R&A with use of the current Exchange Rate.
    2. The default currency is the Default Rate Currency

Stop Sell

  1. To activate the ‘Stop Sell’, check the checkbox
    1. The checkbox will turn blue
    2. Changing the Stop Sell (from on -> off or off->on) will also auto activate the Stop Sell (the checkbox will be checked)
    3. The new value (on or off) will be set in the R&A Calendar for the selected period, Rate Plans and/or Room Types in part 1.

Closed to arrival

  1. To activate the ‘closed to arrival’, check the checkbox
    1. The checkbox will turn blue
    2. Changing the Closed to arrival (from on -> off or off->on) will also auto activate the Closed to arrival (the checkbox will be checked)
    3. The new value (on or off) will be set in the R&A Calendar for the selected period, Rate Plans and/or Room Types in part 1.

Closed to departure

  1. To activate the ‘closed to departure’, check the checkbox
    1. The checkbox will turn blue
    2. Changing the Closed to departure (from on -> off or off->on) will also auto activate the Closed to departure (the checkbox will be checked)
    3. The new value (on or off) will be set in the R&A Calendar for the selected period, Rate Plans and/or Room Types in part 1.

Min LOS based on arrival

  1. To activate the ‘Min LOS based on arrival’, check the checkbox
    1. The checkbox will turn blue
    2. Changing the Min LOS based on arrival (from on -> off or off->on) will also auto activate the Min LOS based on arrival (the checkbox will be checked)
    3. The new value (on or off) will be set in the R&A Calendar for the selected period, Rate Plans and/or Room Types in part 1.

Part 3: Update

  • after setting all desired changes, click ‘Update’
  • The Bulk Update will close
  • On the R&A calendar, all days that have a change will be indicated with a red bar on top of the screen
  • All prices that have a change (on rate and/or restrictions) will be indicated with a red bar in it
  • Click ‘Save’ to process all changes
    • The green bar on top is shown, indicating saving was succesful
    • The red bars will be removed
    • The save button is disabled

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment