Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Add a percentage to the price on update


boimonster

Recommended Posts

I would like to quickly add a certain percentage, say 10% on all the products prices in the store, either through Easy Populate or some other module.

I have tried the contrib "Quick Updates" but the problem is that I have over 10,000 products that need an update at once. I changed the above contrib to display all those products at once, but it takes forever to display them all and update them all.

 

How do I quickly raise all the prices in the store at once by one command?

Link to comment
Share on other sites

Run this SQL command on your database:

 

UPDATE products set products_price=ROUND(products_price*1.1,2);

 

The percentage is in the multiplier, 1.1 is ten percent, 1.2 is twenty percent, etc..

The ,2 sets the round function to two decimal places.

 

Always a good idea to backup your db prior to applying wholesale changes like this!

 

HTH,

Jeremy

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...