Okay. I have an inventory system built into a CMS. I want to runs an issue by you guys and see if anyone can come up with some logical advise for me.
The Problem:
Client needs to be able to add into the product, a specific number of each size that is on hand for that particular product (ex:She has a product called ‘Red Shirt’ and has 2 Smalls, 1 Medium, 4 Large). Thea reason behind this is, she cannot order more of some of her items…Some of them are a one time only thing. The inventory system, as is, will allow her to add a total amount of on hand quantity of any particular item, but it will not differentiate between the sizes. In other words, using the previous example, when she creates the product of ‘Red Shirt’ She would just select all the appropriate sizes, and set the ‘quantity on hand’ to 7. So when someone buys a red shirt online, it would take that total quantity from 7 down to 6, but it will have no effect on the sizes. So, using that same example again, if someone online orders 2 mediums, the system would allow it, even though she only has 1 available.
So, would any of you happen to have coded something similar to what I am talking about and have any advise on the logic that would need to take place. Or even better, have an example to show me 