VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: Three_d on January 26, 2015, 14:55:48 PM

Title: Weight calculation in cart works only after saving a product manually - VM 3.0.3
Post by: Three_d on January 26, 2015, 14:55:48 PM
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
Title: Re: Weight calculation in cart works only after saving a product manually - VM 3.0.3
Post by: GJC Web Design on January 26, 2015, 22:35:27 PM
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
Title: Re: Weight calculation in cart works only after saving a product manually - VM 3.0.3
Post by: Three_d on January 27, 2015, 13:42:31 PM
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?
Title: Re: Weight calculation in cart works only after saving a product manually - VM 3.0.3
Post by: GJC Web Design on January 27, 2015, 15:40:09 PM
google mysql find and replace
Title: Re: Weight calculation in cart works only after saving a product manually - VM 3.0.3
Post by: Three_d on January 28, 2015, 13:43:59 PM
Thanks GJC Web Design.
I've solved it for al the products.