simas.nnn Posted March 20, 2016 Share Posted March 20, 2016 Hello, we don't know what to do. Please someone help us, what should we do to update all of the current specific prices, we need it to increase by 21 %. Probably the easiest way would be through mysql, we tried this:UPDATE ps_product_shop SET specific_price = specific_price*1.21 But this doesn't worked, can someone please lead us to the right way, it look very simple to do, but we are lost Thanks in advance ! Link to comment Share on other sites More sharing options...
simas.nnn Posted March 20, 2016 Author Share Posted March 20, 2016 Please someone, its very important to us, our running shop is stopped now Link to comment Share on other sites More sharing options...
riras Posted March 20, 2016 Share Posted March 20, 2016 There are modules to do that. you also can import your products as a csv file. Then open the file on excell multiple the collun and export back, Make sure to ignore all coluns but price. It should work. Link to comment Share on other sites More sharing options...
simas.nnn Posted March 20, 2016 Author Share Posted March 20, 2016 Which module could do the thing ? Thank you for your answr Link to comment Share on other sites More sharing options...
riras Posted March 20, 2016 Share Posted March 20, 2016 Which module could do the thing ? Thank you for your answr http://addons.prestashop.com/en/search?search_query=mass%20price https://www.prestashop.com/forums/topic/121053-modulemass-price-update-v21-ps-1216/?hl=%20mass%20%20price or just go the foruns and search for "MASS PRICE" like I did Link to comment Share on other sites More sharing options...
simas.nnn Posted March 20, 2016 Author Share Posted March 20, 2016 Thank you for your answer, however we still cant find module to do the right work. We have around 6000 products in our shop and every of them already have specific price, we only need to increase those specific prices by 21%. All of those modules offering to add bulk new specific prices what isn't that what we need..Maybe anyone could write a sql query to do that, it looks so simple, we tried this : UPDATE ps_specific_prices SET specific_price = specific_price*1,21 , but it doesn't recognize the specific_price after the word SET. Maybe anyone have any ideas ? Link to comment Share on other sites More sharing options...
simas.nnn Posted March 20, 2016 Author Share Posted March 20, 2016 (edited) No one ?EDIT: We found the query we were looking for, posting it here if someone will need it in future:UPDATE ps_specific_price SET reduction = reduction*(your amount to update) Edited March 20, 2016 by simas.nnn (see edit history) 2 Link to comment Share on other sites More sharing options...
Iryna Posted March 21, 2016 Share Posted March 21, 2016 Which module could do the thing ? Hello If you are looking for module to update specific prices you may consider Store Manager for PrestaShop - http://addons.prestashop.com/en/2937-store-manager-for-prestashop.html It allows to overwrite existing specific prices with new one, as it is described here in tutorial - https://www.prestashopmanager.com/useful-articles/how-to/how-to-make-bulk-updates-of-specific-prices/ Link to comment Share on other sites More sharing options...
Ayojewel Posted October 5, 2016 Share Posted October 5, 2016 will this statement increase only current specific prices? Link to comment Share on other sites More sharing options...
musicmaster Posted October 6, 2016 Share Posted October 6, 2016 (edited) You can use Prestools for that kind of jobs. It is free - although not for specific prices. Edited October 6, 2016 by musicmaster (see edit history) 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