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/

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"

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: