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

Weight calculation in cart works only after saving a product manually - VM 3.0.3

Started by Three_d, January 26, 2015, 14:55:48 PM

Previous topic - Next topic

Three_d

Hello,

I've migrated a shop with 1400+ products from VM 1.1.9 to VM 3.0.2 with VM Migrator from Daycounts.com.
It works fine but in the cart the shipping costs aren't calculated the way it should be.
But if I save a product manually the shipping costs are right.
After saving manually there is no visible change but it works. Very strange.

Is there a way to automatically save the 1400+ products so that I don't have to do this manually?

Jeroen

GJC Web Design

something must change  - perhaps the formatting of the weight - or the unit used .
check the products table before and after a save

find the change then do a global query on the table to correct the problem
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

Three_d

In the database I see in table dfes_virtuemart_products at column product_weight_uom a value of kiloGaM which is incorrect.
After manually changing that value in the database to KG solves the problem

How can I automatically change this for al the products?

GJC Web Design

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

Three_d