Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / global stock update

global stock update

Locked

Views: 978

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
22 Dec 2008, 10:59 PM
#1
bigbadboy avatar

bigbadboy

Totally Zenned

Join Date:
Apr 2008
Location:
London
Posts:
557
Plugin Contributions:
0

global stock update

Can't find the answer to this anywhere so I thought I'd ask.

What's the easiest way to globally update the stock quantity.
I have around 500 products.
The products will never run out or will have different quantities so the easiest is to set all to '1'

What I don't want to do is go through each one individually and update the quantity.

Is there a way to do this via PHPMyAdmin (easy populate doesn't work for some reason).

23 Dec 2008, 2:58 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: global stock update

You could run this in the Tools ... Install SQL Patches ...

This will set all Product Quantity to 1:

UPDATE products SET products_quantity = 1;
23 Dec 2008, 3:56 PM
#3
bigbadboy avatar

bigbadboy

Totally Zenned

Join Date:
Apr 2008
Location:
London
Posts:
557
Plugin Contributions:
0

Re: global stock update

Ah! Excellent (as usual).

Thanks loads.