We have a scenario where we sell a Product that can be made up in different ways of varying underlying components, but there would be far too many possible combinations to list every kit variation possible.
E.g. Someone wants to buy 5000 /Generic Widgets/....we stock 2000 types of Widgets, with varying quantities, and they all qualify as 'Generic Widgets'...so the Customer wants one line that says 'Generic Widgets' - Quantity 5000 on their invoice, but in fulfilling the order we need to make up the quantity of 5000 from the stock we hold across the 2000 different widgets types (e.g. 10 of type A, 30 of type B, 200 of type C, none of type D and so on and so forth).
The next time someone orders 'Generic Widgets' the make up will be different (e.g. they might not have any of Type A, a different proportional quantity of type B....all dependant on what we can gain access to at the time).
Is it possible, and if so how, to structure Items in this kind of way so we don't lose the 'Generic Widget' item from the Product Catalogue that we sell, but can manage our fulfilment and inventory across the different stock items we hold, where it is important to make the differentiation at the more granular level than just 'Generic Widgets'?
Massive thanks in advance for anyone that can help/clarify what's possible.
