linked stok control of products or combinations

[avathar]

Hi,

i need such a functionality.

 

For example i'm selling product called Mixture.

Mixture has 3 options: potion1, potion2, potion3.

If someone will buy potion1, qty must be reduced from potion1,potion2 and potion3, but when someone will buy potion2, qty must be reduced from potion2 and potion1. At last if someone will buy potion3, qty must be reduced from potion3 and potion1.

Why is that ? because these three potions are dependant.

 

So what i need is dependance between Combinations quantity.

Is there any suitable module ? If not, will it be much effort to write such a module ?

Regards,

Tom

[avathar]

ok, i did it in this way.

-i added two columns at ps_stock_available table

-then created mysql procedure to update qty according to information in these two columns

-then added function which start procedure and is executed when order is completed