News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Mass Change Kilogram to Pounds

Started by samlf3rd, November 19, 2018, 20:59:41 PM

Previous topic - Next topic

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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'
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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

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!