boimonster Posted April 14, 2005 Share Posted April 14, 2005 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 More sharing options...
Jeremy at oddly enough Posted April 14, 2005 Share Posted April 14, 2005 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.