Zen Cart Logo
Forums / General Questions / Mass Update Quanity

Mass Update Quanity

Locked

Views: 1,112

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
18 Aug 2007, 1:20 AM
#1
cntgifts avatar

cntgifts

Totally Zenned

Join Date:
Sep 2005
Posts:
836
Plugin Contributions:
0

Mass Update Quanity

Is there a sql query or somethign that i can update all the quanity on the items to say 100

18 Aug 2007, 2:13 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Mass Update Quanity

easy populate is designed for this

18 Aug 2007, 3:01 AM
#3
cntgifts avatar

cntgifts

Totally Zenned

Join Date:
Sep 2005
Posts:
836
Plugin Contributions:
0

Re: Mass Update Quanity

theres no query you can run? would be a helluva lot quicker

18 Aug 2007, 3:21 AM
#4
ajeh avatar

ajeh

Oba-san

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

Re: Mass Update Quanity

If you want ALL Products to have a products_quantity of 100 ...

First make a backup for when you change your mind ...

Then in the Tools ... Insert SQL Patches you can run:

UPDATE products SET products_quantity = 100;

Now every single Product has a products_quantity of 100 ...

18 Aug 2007, 3:41 AM
#5
cntgifts avatar

cntgifts

Totally Zenned

Join Date:
Sep 2005
Posts:
836
Plugin Contributions:
0

Re: Mass Update Quanity

ahh thanks alot for that