New Zenner
- Join Date:
- Mar 2010
- Posts:
- 10
- Plugin Contributions:
- 0
how to do global change of several variables for all products?
using v1.3.9b of zen cart
i would like to make some global changes to the database, and think it can be done with the menu item Tools - install sql patches option. I just need the code line to put in there to do 2 things:
-
I would like to set quantity = 1 for ALL products in the database.
-
If product item = 'Out of Stock' then set quanity = 0 for ALL products in the database.
thanks in advance for your help.
Betsy