deej Posted December 7, 2004 Posted December 7, 2004 I have a shop with INTENSE attribut pricing. I need to increase the costs of my products by 10% across the board. Is there any way to do this besides altering all of my attributes?
TomThumb Posted December 7, 2004 Posted December 7, 2004 From PHPMyAdmin or your favorite SQL editor run this sql query update `products_attributes` set `options_values_price` = `options_values_price` * 1.1 while (!succeed) {try()}; GMT -6:00
deej Posted December 7, 2004 Author Posted December 7, 2004 From PHPMyAdmin or your favorite SQL editor run this sql query update `products_attributes` set `options_values_price` = `options_values_price` * 1.1 <{POST_SNAPBACK}> I tried this....It worked but in the wrong direction. All of my attributes give quantity pricing. All of the attributes have (-) modifiers, not (+) ones. I need to have less of a negative modifier. This query actually lowered my prices. How do I need to change this query to affect that? THanks... Check out Signexperts.com to see what I'm talking about.
Rob123 Posted December 7, 2004 Posted December 7, 2004 Try the following (after backing up your dB first)... update `products_attributes` set `options_values_price` = `options_values_price` * .9 HTH, Robert
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.