Jump to content

Mass Update Of Current Specific Prices


simas.nnn

Recommended Posts

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

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

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

  • 6 months later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...