Edit quantity in bulk?

25 Sep 2007, 2:31 AM

#1

New Zenner

Join Date:: Sep 2007
Location:: USA
Posts:: 45
Plugin Contributions:: 0

Edit quantity in bulk?

Is there a way to edit the quantity in bulk.
For example if I want to change my quantities from 5 of each to 10 of each have I got to individually edit 300 products or can I edit them all at once to show that I now have 10?
Thanks in advance
H.

25 Sep 2007, 2:35 AM

#2

yellow1912

Totally Zenned

Join Date:: Oct 2006
Posts:: 5,422
Plugin Contributions:: 0

Re: Edit quantity in bulk?

Do you want to change ALL products in the store? Or just in certain categories?

I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

25 Sep 2007, 2:38 AM

#3

hales

New Zenner

Join Date:: Sep 2007
Location:: USA
Posts:: 45
Plugin Contributions:: 0

Re: Edit quantity in bulk?

Guess I should have made that clear huh?
To be honest I'll take Catagories if I can do that for now.
Thanks
H.

25 Sep 2007, 2:58 AM

#4

yellow1912

Totally Zenned

Join Date:: Oct 2006
Posts:: 5,422
Plugin Contributions:: 0

Re: Edit quantity in bulk?

BACK UP your DATABASE FIRST
admin->tools>sql patches

update products set products_quantity = 10 where master_categories_id in (1,2,3)

Replace the numbers in the () by the id of the categories you want to update

I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

25 Sep 2007, 3:44 AM

#5

hales

New Zenner

Join Date:: Sep 2007
Location:: USA
Posts:: 45
Plugin Contributions:: 0

Re: Edit quantity in bulk?

Thank you very much. I'll give that a go.
H.

26 Nov 2007, 9:10 PM

#6

jeronimoh

New Zenner

Join Date:: Sep 2007
Posts:: 7
Plugin Contributions:: 0

Re: Edit quantity in bulk?

Worked perfectly in my store.

30 Nov 2007, 2:51 AM

#7

webfishkis

New Zenner

Join Date:: Jul 2007
Posts:: 5
Plugin Contributions:: 0

Re: Edit quantity in bulk?

thanks it works with my store too:))

and it works with prices too.

UPDATE products SET products_price = 20 WHERE master_categories_id in (10);

15 Jan 2010, 12:25 PM

#8

sushigal

Zen Follower

Join Date:: Mar 2009
Posts:: 435
Plugin Contributions:: 0

Re: Edit quantity in bulk?

This is what I need to do!! How do i do it though?? where do I find this;

UPDATE products SET products_price = 20 WHERE master_categories_id in (10);

?

Many thanks.