Reduction of ALL weights by 2 oz

**Yolanda** · 19 Jul 2012, 05:08 PM

We have a cart with about 2500 products. They need to bring down EACH weight in the cart by 2 oz. Is there a way to do this with a script or some way other than manually? I'd really appreciate some suggestions since this will be a lot of work otherwise.
Thanks as always
Yolanda

**Ajeh** · 19 Jul 2012, 05:12 PM

2 ounces is 0.125 pounds ...

So, you could use in the Tools ... Install SQL Patches ...

Code:

UPDATE products SET products_weight = products_weight - 0.125 WHERE products_weight > 0;

This would reduce all weights of Products with Product Weights greater than 0 by 2 ounces ...

NOTE: Be sure to backup your database before trying this ...