what is sql code to change all my quantities to 100?
thanks.
what is sql code to change all my quantities to 100?
thanks.
Is this for all products? Some products? Every other product? Could you be a tad more vague?
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: v1.5.5]
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!
Yes all products.what is sql code to change all my quantities to 100?
You could use this in the Tools ... Install SQL Patches ...
This will change the products_quantity on every single Product in your shop to be 100 ...PHP Code:
UPDATE products SET products_quantity = 100;
NOTE: backing up your database is always a good plan before doing things like this ...
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: v1.5.5]
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!
worked perfectly! Thank you.
Bookmarks