Bulk update quantity by category

18 Jun 2013, 10:37 AM

Zen Follower

Join Date:: Jan 2010
Location:: Richmond, Virginia, United States
Posts:: 122
Plugin Contributions:: 0

Bulk update quantity by category

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

18 Jun 2013, 3:52 PM

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Bulk update quantity by category

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;