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

[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

[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]

google mysql find and replace

[Three_d]

Thanks GJC Web Design.
I've solved it for al the products.