Bulk Product Prices & Quantity Increases
Hi everyone,
As always I browse through the forums first before posting but could not find exactly what I needed.
Using the "SQL Query Executor" I need the lines necessary for the following:
changing all prices from $2.96 to $2.99 (not a percentage increase)
and
changing all stock level quantities to 100 pieces (or whatever i will need).
In summary....I need to change all prices to $2.99 and increase my on hand quantities to 100 for all products in all categories.
Thanks for your help.....:)
http://treefreegreetingcards.com/
Re: Bulk Product Prices & Quantity Increases
Quote:
Originally Posted by
RetailProductsGroup
Using the "SQL Query Executor" I need the lines necessary for the following:
changing all prices from $2.96 to $2.99 (not a percentage increase)
and changing all stock level quantities to 100 pieces (or whatever i will need).
Code:
UPDATE `products` SET `products_price` = 2.99 where `products_price` = 2.96 ;
Code:
UPDATE `products` SET `products_quantity`= 100 WHERE 1 ;
Usual caveats apply. Use at your own risk. Make backups first.
Cheers
Rod
ps "WHERE 1" effectively means "match all"
Re: Bulk Product Prices & Quantity Increases
OK......
this line worked perfectly:
UPDATE `products` SET `products_quantity`= 100 WHERE 1 ;
however, this line had no effect:
UPDATE `products` SET `products_price` = 2.99 where `products_price` = 2.96 ;
Any thoughts?
I appreciate the help.....:)
Thanks,
Garry
http://treefreegreetingcards.com/
Re: Bulk Product Prices & Quantity Increases