An easy way to reset stock of all products to a certain number?

3 Oct 2006, 11:15 PM

Totally Zenned

Join Date:: Mar 2005
Location:: California
Posts:: 628
Plugin Contributions:: 0

An easy way to reset stock of all products to a certain number?

Does anyone know if there's an easy way for setting the quantity of all the products in my store to a certain number like 0 or 50, perhaps through an sql statement(not sure if that's what it's called)?

Thanks.

4 Oct 2006, 1:32 AM

swguy

Administrator

Join Date:: Feb 2006
Location:: Tampa Bay, Florida
Posts:: 10,746
Plugin Contributions:: 56

Re: An easy way to reset stock of all products to a certain number?

update products set products_quantity = 50;

It's always a good idea to make a backup before hitting your database with SQL commands. On the off chance that you sprout ten thumbs all of a sudden! :)

Good luck,
Scott

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.

5 Oct 2006, 4:02 PM

tj1

Totally Zenned

Join Date:: Mar 2005
Location:: California
Posts:: 628
Plugin Contributions:: 0

Re: An easy way to reset stock of all products to a certain number?

Thank you so much. :)