Krisz1 Posted January 9, 2007 Share Posted January 9, 2007 Hello I have a store of over 300 items and I need to increase prices in 10% for all products. Can anyone be so kind to tell me what's the mysql query I should type in phpmyadmin ? I'd rather ask than screw the db up Thanks! Link to comment Share on other sites More sharing options...
davidinottawa Posted January 10, 2007 Share Posted January 10, 2007 Hello I have a store of over 300 items and I need to increase prices in 10% for all products. Can anyone be so kind to tell me what's the mysql query I should type in phpmyadmin ? I'd rather ask than screw the db up Thanks! update `products` set `products_price` = (`products_price` * 1.1) Link to comment Share on other sites More sharing options...
davidinottawa Posted January 10, 2007 Share Posted January 10, 2007 Hello I have a store of over 300 items and I need to increase prices in 10% for all products. Can anyone be so kind to tell me what's the mysql query I should type in phpmyadmin ? I'd rather ask than screw the db up Thanks! update `products` set `products_price` = (`products_price` * 1.1) Link to comment Share on other sites More sharing options...
rusty1001 Posted January 10, 2007 Share Posted January 10, 2007 update `products` set `products_price` = (`products_price` * 1.1) Interesting..... is that price before taxes...? seems a very simple way! anyway there is a module 'quick price updater' or similar, I have seen but not used in the contributions, cheers russell Rusty ------------------------------------------- Link to comment Share on other sites More sharing options...
davidinottawa Posted January 10, 2007 Share Posted January 10, 2007 Hello I have a store of over 300 items and I need to increase prices in 10% for all products. Can anyone be so kind to tell me what's the mysql query I should type in phpmyadmin ? I'd rather ask than screw the db up Thanks! update `products` set `products_price` = (`products_price` * 1.1) Link to comment Share on other sites More sharing options...
davidinottawa Posted January 10, 2007 Share Posted January 10, 2007 Interesting..... is that price before taxes...? seems a very simple way! anyway there is a module 'quick price updater' or similar, I have seen but not used in the contributions, cheers russell yes - ths is the price before taxes. I've not seen the module to do this - but this sql statement will do exactly what the op asked for. d Link to comment Share on other sites More sharing options...
Krisz1 Posted January 14, 2007 Author Share Posted January 14, 2007 yes - ths is the price before taxes.I've not seen the module to do this - but this sql statement will do exactly what the op asked for. d Thank you very much :-) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.