Changing PRODUCT weight en masse

[Chadduck]

We sell over 500 window decals.  These decals a light weight, wieghing less than 1 oz.  When originally entered the weight was incorrectly identified as 0.1 pounds.  They should have been identified as 0.0625 pounds.

IS there a SQL sequence that can be used to change the weight of these products en masse?

OR perhaps some other method?

BJ

[pandrei]

On 8/17/2023 at 5:20 PM, Chadduck said:

We sell over 500 window decals.  These decals a light weight, wieghing less than 1 oz.  When originally entered the weight was incorrectly identified as 0.1 pounds.  They should have been identified as 0.0625 pounds.

IS there a SQL sequence that can be used to change the weight of these products en masse?

Try this SQL:

UPDATE products SET products_weight = 0.0625 * 0.45359237, weight_cm = 0.0625 * 0.45359237, weight_in = 0.0625

 

[Chadduck]

Thank you for the input @pandrei