Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

is this available.


Recommended Posts

i would like to update my prices through admin by lowering or rasing by percentage. all at once so if i wanted to lower my prices 15% all in one shot i could just enter the % and bam done. if not can this be done in excell. if so please tell me how to do this.


thanks you very much for your time.

Link to comment
Share on other sites

In phpMyAdmin or other MySQL administration software, run the following query:

update products set `products_price` = `products_price` * (1 - .15);

to reduce all prices by 15%. Backup before you try. Note: replace products with products_attributes and products_price with options_values_price to do this for attributes.




Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...