We sell in both full cases and individual packs on our website Mashers UK.
Would anyone have any experience with how to manage stock online for such a setup (we are about to build a new magento site).
e.g. if we have in stock 5 full cases of product1 which contains 12 individual pieces of product1p, we then have available to sell either 5 full cases or 12 pieces x 5 = 60 pieces.
In terms of stock management how would we keep track of this mixture of quantities, if for example 2 packs were sold we effectively no longer have 5 full cases available, likewise, if 1 full case was sold we no longer have 60 individual packs available to sell.
Is there any extension or perhaps just a simple technique which could efficiently keep track of stock if items are sold in both wholesale and retail quantities from the same catalogue.