extra cost per person in condition of duration
I am looking to set up a sightseeing bookable product with the following rules:
• Booking duration: minimum of two hours but it can be up to three hours with 15-min intervals from 2 to 3 hours (2, 2:15, 2:30, 2:45, and 3)
• Base cost: $210 for 2 hours and $260 for all other options (2:15, 2:30, 2:45 and 3)
• Persons: from 1 to 15. You set up an extra $25 cost per person to include an entrance fee + a bike rental fee.
This is how my bookable product settings look like so far:
General – https://prnt.sc/12fijdg
Availability – https://prnt.sc/12fikg9
Costs – https://prnt.sc/12fim4j
Persons – https://prnt.sc/12finf3
Resources – https://prnt.sc/12fio43
The issue is that I would like to add an extra bike rental fee per person if the booking duration is over 2 hours (2:15, 2:30, 2:45, and 3).
The complexity relies on the fact that I would need to set up a conditional rule between the cost per person and the base cost per number of blocks select in the Costs, which is not something that can be done with the built-in Bookings functionality.
Edit: it could be solved adding a column in the price table like this: https://prnt.sc/12ve95v
Last updated: May 6, 2021