Price and Stock based on date, create a product variation for every day or something else?

I'm searching for the right way to manage price and stock based on date.
This is the typical use case for a product like excursion. Every day we can have an excursion and a product display is related to that excursion. Price can change depending on date (for ex. saturday or sunday), and there is a limit for the stock for every excursion.
The easy way should be to create a variation for every day, but it is very complicate to manage and it will cause a lot of data in database (a product variation for every day X number of products).
The solution of rooms is impracticable...

Posted: Apr 8, 2013


keyswebsites on April 8, 2013

Have you looked at http://drupal.org/project/commerce_webform ? This may be enough depending on your needs.

In any case, it seems to me that the date should follow the booking/reservation not the product. So I have an entity that's a product, say coral reef dive trip, that contains images, description, price, etc. Another entity that is the registration which contains the date, participant options (distinct from customer info), and any price adjusters (set with rules or using http://drupal.org/project/commerce_custom_product), and another entity that is the user/customer/booking agent. I will most likely use rules to handle stock and price adjustment by date.

The registration is most likely just the commerce checkout. The user can be the customer, sales staff, or outside booking agent. The display of guest lists, ship manifest, roll call, trips booked, etc. is handled by views using date as a filter.