Michał Modzelewski Posted August 1, 2014 Share Posted August 1, 2014 Hello! I will try to make this as clear as possible I want to make one product affect other products stocks. When I sell product A it will change stock of product B, product C and product D. We are making audio cables, but we also sell components as separate parts. I want to be sure that we can't sell more products then we have parts for at the moment. I tried making it as packs, but firstly it appears later as few products, I want it to be one product, secondly I can't connect it with attributes(customers can choose length of a cable) Is it possible to do? I'm trying to solve this problem for few days now, and I feel like I'm nowhere near the solution :/ Greetings Michal Link to comment Share on other sites More sharing options...
musicmaster Posted August 2, 2014 Share Posted August 2, 2014 Mysql supports database triggers. You could solve it that way. Link to comment Share on other sites More sharing options...
vekia Posted August 2, 2014 Share Posted August 2, 2014 but not neach hosts allows to use triggers, unfortunately . have you got phpmyadmin database manager? if so, do you see there "triggers" tab ? Link to comment Share on other sites More sharing options...
Michał Modzelewski Posted August 8, 2014 Author Share Posted August 8, 2014 I have phpmyadmin, but I was hoping for ready solution(module). Unfortuattly person that is responsible for sales, products, stoc etc. don't know anything about databases, so as I was afraid it won't be possible for him to do it as new products will be added. Anyway, thank you for your help, if I ever do everything I want to do in the shop I'll try to find some time and maybe write module for this Michal Link to comment Share on other sites More sharing options...
Recommended Posts