Need Help On Product Qty Units

How would I go about changing my whole cart Product Qty Units to 5 without going through each product individually. I have 2100 products and this will be very time consuming without a code or something. Thanks in advance.

Ajeh do you know if there is a code I can insert to update my whole store instead of doing it one by one. Thank you.

You can try to update your product quantity in the database manually.

UPDATE `products` SET `products_quantity` = '5';

BACKUP your database before you try this.

tino.schlegel:

You can try to update your product quantity in the database manually.

UPDATE products SET products_quantity = '5';

It's actually this but thank you so much.

 > UPDATE `products` SET `products_quantity_order_units` = '5';

I have another question though, is it possible just to change products_quantity_order_units just for a particular category instead of changing the whole store, or do I have to do it manually. If I can how do I do it like that. Thank in advance.
UPDATE products SET products_quantity_order_units = '5';

If the Products all use the same master_categories_id you could use:

UPDATE products SET products_quantity_order_units = 5 WHERE master_categories_id = XX;

where XX is the master_categories_id of these Products ...

NOTE: be sure to backup your database before making global changes like this ...

Ajeh:

If the Products all use the same master_categories_id you could use:

UPDATE products SET products_quantity_order_units = 5 WHERE master_categories_id = XX;

> 
> NOTE: be sure to backup your database before making global changes like this ...

Thanks Ajeh that worked out great. Saved me a lot of time.