Site Wide - Change All Product Weights to a Minimum

Instead of updating hundreds of items individually to a minimum weight is there a trick to doing it site wide?

Example: all 1oz items become 3oz.

Thank you in advance.

SQL:

UPDATE products SET products_weight=3 where products_weight=1;

... assuming all your weights are only in oz and NOT in lbs. If you're using another weight formula, change the numbers accordingly.

webskipper:

Instead of updating hundreds of items individually to a minimum weight is there a trick to doing it site wide?

Example: all 1oz items become 3oz.

Thank you in advance.

Couple of ways...

One shot deals would use sql statements.

update products set products_weight=3 where products_weight=1

Could be entered into the install sql script field provided in admin panel tools. Remember though that weights are entered as either lbs or kgs, so the appropriate conversion factor should be applied to address the weight(s).

Another is to use a tool such as EasyPopulate or apsona. Those may require other prerequisites to be met to work for you.

Thanks for sql patch it worked!