Hisin Posted June 19, 2016 Share Posted June 19, 2016 Hi Everyone, Somehow i cannot modify the q'ty on product detail page. After I modify, it came back to the original data. http://imageshack.com/i/pocoXvJcp Which database control the q'ty by the way? It is okay with other product and I dont know whether it is related to ASM or not? I enabled and disable after i found there is problem with supply orders. Pls kindly advice. Thanks. Link to comment Share on other sites More sharing options...
musicmaster Posted June 21, 2016 Share Posted June 21, 2016 The database table used for product quantities is ps_stock_available. 1 Link to comment Share on other sites More sharing options...
Hisin Posted June 21, 2016 Author Share Posted June 21, 2016 Hi Musicmaster Thanks for your reply! It is very kind of you. I didnt fix the issue but i found more. What is q;ty on product_attribute table? Why it is 0 or 7 on my case. http://imageshack.com/i/poimRMiVp On stock_available table, what are q;ty and depends on stock and out of stock? http://imageshack.com/i/pmItjvWDp Thank so much for your help! Link to comment Share on other sites More sharing options...
musicmaster Posted June 21, 2016 Share Posted June 21, 2016 Prestashop has a policy to maintain fields when they are no longer used. That applies also to qty in the ps_product_attribute table. If I remember well depends_on_stock tells you that it uses warehouses, out_of_stock tells you what to do when the product is out of stock (sell or not). Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now