Day of week/time of day/date/multi-day pricing
There are several Dynamic Pricing Rule conditions designed to accommodate pricing based on the valid date of an item and multi-day discounts. While the majority of this type of a pricing can be accommodated by using the standard Salesware rate schedules, there are situations when using Dynamic Pricing Rules to configure these types of programs may be useful such as:
• There are not enough date ranges and/or rate schedules available to accommodate an item’s varying price throughout the year.
• An item’s price is based on the time of day.
• An item is given a discount based on an advance purchase of X days.
• Multi-day discounts may vary based on whether or not the item is valid during a portion of a peak season.
• The benefit of updating multiple item prices by editing a single rule as opposed to editing each item.
Sample programs:
1. A 5% discount is given to all tickets that are not valid on a Saturday or Sunday.
• Possible Rule: IF(DOW(MON-FRI), DISCOUNT(5))
• Result: If any portion of a multi-admission ticket is valid over the weekend, only the non-weekend portion of the ticket receives the 5% discount.
2. A 10% discount is given to all tickets that are not valid during a holiday season.
• Possible Rule: IF(NOT DATE(12/20/2012-01/05/2013),DISCOUNT(10))
• Result: If any portion of a multi-admission ticket is valid during 12/20/2012-01/05/2013, only the portion of the ticket that does not fall into the date range specified receives a 10% discount.
3. A ticket costs $20 if purchased between 9:00 AM and 11:00 AM, $15 if purchased between 11:01 AM and 1:00 PM, $10 if purchased between 1:01 PM and 3:00 PM and $5 if purchased between 3:01 PM and 5:00 PM.
• Possible Rule:
IF(TIME(09:00-11:00),SETPRICE(20))
IF(TIME(11:01-13:00),SETPRICE(15))
IF(TIME(13:01-15:00),SETPRICE(10))
IF(TIME(15:01-17:00),SETPRICE(5))
• Result: The ticket price varies every two hours throughout the day. Tickets such as these would typically not be multi-day (multi-admission) tickets.
4. A multi-day discount of 15% per day is offered on tickets when at least three or more days fall outside of a holiday season.
• Possible Rule: IF(DAYCOUNT(NOT DATE(12/20/12-01/05/2013),>=3),DISCOUNT(15))
• Result: At least three admissions on a multi-admission item need to be valid outside of the 12/20/05-01/05/06 date range. If this condition is met, those days (admissions) that are outside of the specified date range is discounted by 15%.
5. A ticket is discounted by 20% when purchased at least thirty days in advance, 10% when purchased at least fourteen days in advance and no discount is offered when purchased less than fourteen days prior to arrival (less than fourteen days prior to the valid date of the ticket).
• Possible Rule:
IF(ADVANCE(>=30),DISCOUNT(20))
IF(ADVANCE(14-29),DISCOUNT(10))
• Result: A ticket added to a sale on 6/3/2012 receives no discount if the start date of the ticket is anywhere between 6/3/12 and 6/16/2012 – it receives a 10% discount if the start date is between 6/17/2012-7/2/2012 – it receives a 20% discount if the start date is 7/3/2012 or beyond.