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/

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).

UPDATE `products` SET `products_price` = 2.99 where `products_price` = 2.96 ;  

UPDATE products SET products_quantity= 100 WHERE 1 ;

Cheers
Rod

ps "WHERE 1"  effectively means "match all"

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/

anyone?:smile: