How to update Quantity for all products?

[doubletiger]

Hi,

I have about hundred of product and quantity are reduced day by day, some of them are close to zero, I would like to update all of products to 10000, does anyone know how to do it in Mysql PHPadmin area?

thank you in advance!

[Ajeh]

UPDATE products SET products_quantity=10000;

This can be run via the Tools ... Insert SQL Patch ...

NOTE: it will adjust if you are using table prefixes automatically via the Insert SQL where as in phpMyAdmin you would need to manually fix this yourself ...

NOTE: Backup before attempting to run this command ...

[doubletiger]

Thanks Ajeh,

Thanks for tips, I will try it and report back here.