How to update Quantity for all products?

6 Oct 2006, 8:39 PM

Zen Follower

Join Date:: Apr 2005
Posts:: 199
Plugin Contributions:: 0

How to update Quantity for all products?

Hi,

I have about hundred of product and quantity are reduced day by day, some of them are close to zero, I would like to update all of products to 10000, does anyone know how to do it in Mysql PHPadmin area?

thank you in advance!

6 Oct 2006, 8:56 PM

ajeh

Oba-san

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

Re: How to update Quantity for all products?

UPDATE products SET products_quantity=10000;

This can be run via the Tools ... Insert SQL Patch ...

NOTE: it will adjust if you are using table prefixes automatically via the Insert SQL where as in phpMyAdmin you would need to manually fix this yourself ...

NOTE: Backup before attempting to run this command ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

6 Oct 2006, 9:05 PM

doubletiger

Zen Follower

Join Date:: Apr 2005
Posts:: 199
Plugin Contributions:: 0

Re: How to update Quantity for all products?

Thanks Ajeh,

Thanks for tips, I will try it and report back here.