Bulk update quantity by category

[jmsnyder23]

Hi,

I have 150+ print books in 6 categories available for sale from my site. I want to update ALL the products from quantity 1 to quantity 100.

Can I do this using a series of SQL commands? I tried but apparently couldn't figure it out because I got an error and the quantities didn't update.

Any help would be appreciated.

Thank you in advance!

J.M. Snyder

[Ajeh]

To update ALL Products that currently have products_quantity 1 to be products_quantity 100, you can post this in the Tools ... Install SQL Patches ...

UPDATE products SET products_quantity = 100 WHERE products_quantity = 1;