I am building a website for a client, who are a very small concert hall (50 seats).
At the start of the project i asked them if all seats would be the same price, in which they said "yes".
So the site is built with Wordpress using Woocommerce to handle the tickets and payments.
When i add a concert, i add the product as a variable product so that i can set various dates for the product. This has all worked fine, however now the client has realised that he needs to charge different prices for different people (Adults, Students, Children).
I am finding it very difficult trying to come up with a solution that will handle this, as usually when you have a varied product, for example a t-shirt that has variations of S, M, L, XL each of the variations (S, M, L, XL) has their own stock level (for example, 10 of each size) which is fine, HOWEVER, considering this is a concert, my variations (Adults, Students, Children) can't have their own stock level, as all of the variations (Adults, Students, Children) need to come out of the overall 50 seats... i can't break up the 50 seats to 20 x Adults, 20 x Children and 10 for Children... as they need to be pooled / combined from the one stock level.
I could create a separate product / concert for each date it is on and then just manage the stock from the top level instead of having to worry about each date, but this is a lot of work for the admin and it will also look very messy on the front end.
Can anyone suggest any ideas to try?