Combinations To Influence Stock Of Other Products

[GranWizard]

Hi There,

I am running into a kind of problem and I hope I am able to describe it, since I haven't find anything on the forums similar.

I have the following products:

15 types of the same Lighting units with different lengths
These units all have combinations for customers to combine the package with accessories they need:

Lighting: (Choose Color 5, colors combinations)

Power supply (Watt 2 combinations, but important: normal product, also possible to not include in the pack)
Mounting: (sealing, brackets etc. 5 combinations to choose from, but all are also available as unique products)

Cables accessory (2 types to choose from, but also available as unique product)


Al these result in a lot of product combinations.

The problem is I can't set the Stock for the combinations, like when I have 2 cables in stock, they can be used for 100+ combinations. (If I sell one, they are still available in the 100+ other combinations.) And these cables can also be used for the other 15 types of Lighting units.

What would be the best solution?
Should I be using a product pack? Which one? It needs to make combinations possible and select or deselect products from the pack?
Or is there a way to set the general stock number for a combination product item?

My guess would be to give the unique product a reference number and editable reference for use in combined products or something, to be used in combinations, so that when a combined product is sold, the stock of the unique item is to be changed. That way it is easier to manage stock levels. Problem is off course that the unique product can be combined product too.

Anyone got a good idea or solution?

 

Edited January 5, 2016 by GranWizard (see edit history)