enkelhandel Posted July 25, 2012 Share Posted July 25, 2012 In which table is the attribute quantities stored? The table ps_product_attribute has a column quantity but it is 0 even though I've set quantities for the respective attributes (shown correctly in front end). Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 25, 2012 Share Posted July 25, 2012 Hi enkelhandel, That is the correct table for product attribute quantities, can you please post a screenshot of both your settings and this table so that we can try to figure out why it isn't displaying properly for you? -Mike Link to comment Share on other sites More sharing options...
enkelhandel Posted July 25, 2012 Author Share Posted July 25, 2012 Hi enkelhandel, That is the correct table for product attribute quantities, can you please post a screenshot of both your settings and this table so that we can try to figure out why it isn't displaying properly for you? -Mike I tried adding a new product without attributes (to eliminate possible bugs there). It showed up in ps_product correctly. It showed up in front end. I set quantity to 5 in backend. Updated, and quantity 5 was set in backend. Checked front end, also there quantity 5. But in table ps_product, under column quantity its still 0 and no other field has 5. How is that possible. (cache is empty etc. even tried to change the reference, which updated the table so all other changes works, it must be stored elsewhere) Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 25, 2012 Share Posted July 25, 2012 Can you please post the requested screenshots so that we can look into this for you? -Mike Link to comment Share on other sites More sharing options...
enkelhandel Posted July 25, 2012 Author Share Posted July 25, 2012 Can you please post the requested screenshots so that we can look into this for you? -Mike Sorry for not posting screenshots, but the forum-solution for posting images is really timeconsuming (print-screen, upload via FTP, link to URL here) Anyway, the stocks are in table ps_stock_available for each attribute AND the total stock for each product is there too. It creates plenty of confusion since there is a quantity column both in product- and attribute tables. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 25, 2012 Share Posted July 25, 2012 Sorry for not posting screenshots, but the forum-solution for posting images is really timeconsuming (print-screen, upload via FTP, link to URL here) Have you tried our attachment system under More Reply Options? -Mike Link to comment Share on other sites More sharing options...
enkelhandel Posted July 25, 2012 Author Share Posted July 25, 2012 Have you tried our attachment system under More Reply Options? -Mike No but now I will use it much more voluntarily! Thanks! Link to comment Share on other sites More sharing options...
rmatcar Posted August 25, 2012 Share Posted August 25, 2012 (edited) Hi all, So...if i want to update my stock via SQL. Which table should I update? ps_stock_available, ps_products, ps_product_attribute, all of them? I suposse Prestashop uses the qty of ps_products for something, right? Moreover, if I want to send an email to the customers with the new status of the product. Which hook Should I exec after the update? hookActionProductOutOfStock, hookActionUpdateQuantity, hookActionProductAttributeUpdate.anything else? Thanks! Regards! Edited August 25, 2012 by rmatcar (see edit history) Link to comment Share on other sites More sharing options...
chetwyn Posted September 14, 2012 Share Posted September 14, 2012 I have the same question lol. can anyone help here ? Link to comment Share on other sites More sharing options...
[email protected] Posted January 16, 2014 Share Posted January 16, 2014 Hi, has anyone You found solution? Link to comment Share on other sites More sharing options...
Recommended Posts