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...