I know this is going to be complicated and may confuse some people but I'm wondering if anyone out there can assist in the thought process/work-around.
I work at a Botanic Garden, we are having a festival in our Japanese Garden. Because of COVID we have to limit the number of people attending. We are selling a per hour quantity. Here comes the wrinkle...
Matrix Items with Grid Extension will look like this:
The capacity per TIME (regardless of the Ticket-Type sold) is 400. My problem is that I have 35 items to sell, the combination of 5 items (the ticket-types) cannot exceed 400 per hour.
My only thought I can come up with is to have a total of 400 per item (all 35 items), and when someone purchases anything I would have a workflow that would adjust my inventory down.
EXAMPLE
John Smith buys 2 adults, 3 children, & 1 senior for 10am I would reduce the inventory for each of the five 10am items by 6 making each of the 10am items now reflect 394, then Lynn Jones buys 6 adults, 11 children, 3 seniors, and 2 babies for 10am. Now my workflow would reduce 10am by 22 making the new capacity for each of the five 10am items 382. And so on.
Does anyone out there know if I can get a workflow based on the Quantity of items within a sales order to adjust inventory??
Fun brainteaser that I hope can be solved. I am fearful my Workflow skills do not match my logic skills.