Mass Change Kilogram to Pounds

[samlf3rd]

VM3.4.2
Hello, we have a site that has over 700 products, and all the products have the weight set as Kilograms-and we need it to be set to Pounds instead.

I have tried setting the default in the admin panel to pounds-which didn't work, I then tried setting it to ounces (then save)-then to pounds (then save), but it doesn't change any of the 700 products. I looked in admin/vmcfg, but it doesn't look like it is in there.
Any help would be very much appreciated!
Sam

[GJC Web Design]

are u expecting them to be converted?

They are just number fields and unit fields (label) ...  there is no calc

you will need to do some fancy sql calc direct in the db if u want conversion or export to xls and convert and reimport

[samlf3rd]

I just want all the products to be set as Pounds instead of Kilograms. The weight is set fine, it was an import problem I guess. The actual weight is fine, as it is in pounds already not kilograms. It's 1.25. I don't need the numbers to change-just the drop-down from kilogram to pounds is all.

[GJC Web Design]

there is an entry for each product weight unit

field product_weight_uom

you need to do an update in the table

something like

UPDATE `#__virtuemart_products` SET `product_weight_uom`= 'KG'

[Studio 42]

you can mass update it using VM Be Pro(you can batch process 1000 products per page maximum)
See https://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm

[samlf3rd]

there is an entry for each product weight unit

field product_weight_uom

you need to do an update in the table

something like

UPDATE `#__virtuemart_products` SET `product_weight_uom`= 'KG'

Thank you so much, this did the trick! Have a great week and holiday!
Thread Closed!