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!
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!
This can be run via the Tools ... Insert SQL Patch ...UPDATE products SET products_quantity=10000;
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!
Thanks Ajeh,
Thanks for tips, I will try it and report back here.