Need Help On Product Qty Units

[countrycharm]

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.

[countrycharm]

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.

[tino.schlegel]

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.

[countrycharm]

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.

It's actually this but thank you so much.

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

[countrycharm]

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

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

where XX is the master_categories_id of these Products ...

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