franquero Posted February 7, 2013 Share Posted February 7, 2013 Hello. I am working in a new Prestashop installation. The store have thousands products, so I have an external application that updates the table ps_products everyday to set the quantity and price of them. My problem is that if the application updates ps_product.price field, when I go to my back office to check, I see the base price have been successfully changed, but the the price tax exc and price tax incl haven't been updated How can I get all prices updated? are there others database tables involved in the price control? Thank youy very much in advance. 1 Link to comment Share on other sites More sharing options...
franquero Posted February 7, 2013 Author Share Posted February 7, 2013 I shouldn't have been so fast asking . Sorry. I found the table ps_product_shop. That's the table I have to update. 3 Link to comment Share on other sites More sharing options...
bector Posted April 19, 2013 Share Posted April 19, 2013 i just run this sql i have to change the price form 1.66 to 2.25 in my shop http://fashionvogues.com and its work UPDATE `ps_product_shop` SET `wholesale_price` = 2.25 WHERE `wholesale_price` = 1.66 UPDATE `ps_product_shop` SET `price` = 2.25 WHERE `price` = 1.66 you can update in one sql and similar sql should be run for table ps_product 1 Link to comment Share on other sites More sharing options...
vekia Posted April 21, 2013 Share Posted April 21, 2013 i just run this sql i have to change the price form 1.66 to 2.25 in my shop http://fashionvogues.com and its work UPDATE `ps_product_shop` SET `wholesale_price` = 2.25 WHERE `wholesale_price` = 1.66 UPDATE `ps_product_shop` SET `price` = 2.25 WHERE `price` = 1.66 you can update in one sql and similar sql should be run for table ps_product thanks for your solution im convinced that it will be heplfull in this case so i can go ahead and mark this thread as solved regards Link to comment Share on other sites More sharing options...
higorvaz Posted April 10, 2014 Share Posted April 10, 2014 If I can, would like to share a screencast: https://www.youtube.com/watch?v=1Jy-erUuiRk Link to comment Share on other sites More sharing options...
wmh90 Posted July 16, 2014 Share Posted July 16, 2014 Very useful, thanks! Link to comment Share on other sites More sharing options...
jorgeferpas Posted January 22, 2015 Share Posted January 22, 2015 I don't think you have to say sorry, franquero. Seeing your self-answered question saved a lot of time to me. Thanks!! Link to comment Share on other sites More sharing options...
sondiva Posted August 26, 2015 Share Posted August 26, 2015 Hello, I updated rates and wholesale price to zero in backend (mysql) but i still see old rates coming on product list , i deleted cache also but still the old rates are showing up Any help will be appriciated Link to comment Share on other sites More sharing options...
dformica2 Posted January 20, 2017 Share Posted January 20, 2017 It seems there are 2 product tables: "ps_product" being the main one and this "ps_product_shop"I was going crazy trying to update "additional_shipping_cost". Once I updated the values in "ps_product_shop" as well problem solved! Link to comment Share on other sites More sharing options...
joraColea Posted February 6, 2017 Share Posted February 6, 2017 It seems there are 2 product tables: "ps_product" being the main one and this "ps_product_shop" I was going crazy trying to update "additional_shipping_cost". Once I updated the values in "ps_product_shop" as well problem solved! It worked for me! 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