Edit quantity in bulk?

[hales]

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.

[yellow1912]

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

[hales]

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

[yellow1912]

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

[hales]

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

[jeronimoh]

Worked perfectly in my store.

[webfishkis]

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);

[Sushigal]

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.