Is there any way NOT to prorate holiday rates on split weekly stays?

BlueMtnCabins
Oct 17, 2017 11:49 AM
Joined Jun, 2016 1133 posts

I have a quote that spans part of 4th of July period and part of regular summer rate. I want only prorate at week rate if they take entire week during holiday period(defined as Jun 30 - Jul 7). But They are taking only part of holiday week. What I see is this:

Rent 5 nights (7/3 - 7/7) during Independence Day adjusted for Week rate at $371.29 per night 1,856.43 $1,856.43 Rate: Week for $2,599.00
Season: Independence Day (Jun 30 - Jul 7, 18)
Rent 2 nights (7/8, 7/9) during Summer Peak adjusted for Week rate at $268.43 per night 536.86 $536.86 Rate: Week for $1,879.00
Season: Summer Peak (Jul 8 - Aug 18, 18)
Surcharge Cleaning Fee based on $150.00 per stay 150.00 $150.00 Surcharge: Cleaning Fee $150.00 per stay
Season: Independence Day (Jun 30 - Jul 7, 18)
Tax TN Sales / Sevier County Lodging Tax 12.75% $324.27 Tax: TN Sales / Sevier County Lodging Tax
Season: Independence Day (Jun 30 - Jul 7, 18)
Surcharge REFUNDABLE Damage Deposit based on $300.00 per stay 300.00 $300.00 Surcharge: REFUNDABLE Damage Deposit $300.00 per stay
Season: Independence Day (Jun 30 - Jul 7, 18)
Total $3,167.56
is there a way to avoid prorating if less than 7 nights are holiday nights? is my setting wrong someplace?

thanks

Chris Hynes
Oct 23, 2017 10:55 AM
OR Team Member Joined Oct, 2012 1401 posts

Just saw this one, sorry for the delay!

What if you set the week rate for the holiday period to prorate up only and put a night rate in? Does that get what you want?

BlueMtnCabins
Oct 23, 2017 10:59 AM
Joined Jun, 2016 1133 posts

Chris Hynes said:

Just saw this one, sorry for the delay!

What if you set the week rate for the holiday period to prorate up only and put a night rate in? Does that get what you want?

Not sure I understand this instruction? how do I set to prorate up?

Chris Hynes
Oct 23, 2017 11:13 AM
OR Team Member Joined Oct, 2012 1401 posts

Go to the rate and select "same or more number of nights" under proration. More here: https://www.ownerrez.com/support/articles/rate-engine#proration

I see you have some at All and some at Extra right now. Let me know if changing them to Extra fixes it. If not, it's probably prorating across both seasons, i.e. for a week long booking that spans 2 seasons, it sees the week and prorates even if the rates in each season have less than a week. To control that, we'd need to add a setting so prorate only works inside a season.

BlueMtnCabins
Oct 23, 2017 11:29 AM
Joined Jun, 2016 1133 posts

I set the Independence day week rate to: "Use this rate for bookings with the same or more number of nights " and rate for the night $379 or with blank.
it is still prorating.


Rent 2 nights (6/28, 6/29) during High Season adjusted for Week rate at $268.43 per night 536.86 $536.86 Rate: Week for $1,879.00
Season: High Season (May 29 - Jun 29, 18)
Rent 5 nights (6/30 - 7/4) during Independence Day adjusted for Week rate at $371.29 per night 1,856.43 $1,856.43 Rate: Week for $2,599.00
Season: Independence Day (Jun 30 - Jul 7, 18)
Surcharge Cleaning Fee based on $150.00 per stay 150.00 $150.00 Surcharge: Cleaning Fee $150.00 per stay
Season: High Season (May 29 - Jun 29, 18)
Tax TN Sales / Sevier County Lodging Tax 12.75% $324.27 Tax: TN Sales / Sevier County Lodging Tax
Season: High Season (May 29 - Jun 29, 18)
Surcharge REFUNDABLE Damage Deposit based on $300.00 per stay 300.00 $300.00 Surcharge: REFUNDABLE Damage Deposit $300.00 per stay
Season: High Season (May 29 - Jun 29, 18)
Total $3,167.56

BlueMtnCabins
Oct 30, 2017 9:14 AM
Joined Jun, 2016 1133 posts

Any update?

Chris Hynes
Oct 30, 2017 11:56 AM
OR Team Member Joined Oct, 2012 1401 posts

Yep, we looked into this and it's going to take a code change to fix. Basically what happens is that prorate takes into account all seasons by default. So we need to add a "only prorate inside this season" option to each season, so you can set and control that behavior on a season by season basis.

Brent's Beach
Nov 16, 2017 8:33 AM
Joined Feb, 2016 2 posts

Any update on when this code fix will be added ?

Chris Hynes
Nov 20, 2017 7:20 PM
OR Team Member Joined Oct, 2012 1401 posts

Should be in the next week or two, depending on holidays.

Chris Hynes
Dec 7, 2017 5:02 PM
OR Team Member Joined Oct, 2012 1401 posts

This has been released. You can now go to a rate, choose Pro-Rate for same or more nights, and pick "only use matching seasons". That will prorate only for the period inside the season, not based on entire booking length.

BlueMtnCabins
Dec 11, 2017 8:04 PM
Joined Jun, 2016 1133 posts

great!> let me try

BlueMtnCabins
Dec 11, 2017 8:18 PM
Joined Jun, 2016 1133 posts

I have set up "Holiday" season Dec 21, 2018 - Jan 4, 2019. But when I try rate tester, it says rate cannot be calculated. Tried dates Dec 21-26, 2018

Chris Hynes
Dec 11, 2017 9:13 PM
OR Team Member Joined Oct, 2012 1401 posts

That's because the no prorate outside season setting is working so it's not using the weekly rate or prorating it, but you don't have any nightly rates for the period -- so no rates apply.

Add a nightly rate to use when the weekly rate doesn't match and it should rate out correctly with that.

BlueMtnCabins
Dec 12, 2017 6:32 AM
Joined Jun, 2016 1133 posts

Perfect, this worked!