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
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
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.
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'
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
Quote from: GJC Web Design on November 19, 2018, 22:32:41 PM
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!