Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

is this available.


Guest

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.

 

Hth,

Matt

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...