Migrating the old shipping rates

[callumgilhooly]

Hi, Has anyone managed to successfully move their old shipping rates (standard shipping module) from the old version to the new version of Virtuemart?

I have a client who is looking to upgrade their VM site but they ship worldwide and have a lot of different product weights which means they have around 17,000 individual shipping rates.

The rest of the migration has gone OK (ish) but looking at the new table structure of _virtuemart_shipmentmethods, I can't see an easy way of mapping this over.

Anyone any ideas or know of any tool / script that can do this?

Many thanks for looking

Callum

[alatak]

Hi,

Yes , it is not very easy to do.

because in VM1 there was 2 tables, one for the carrier, and one for the shipping rate.
In VM2 we have 2 tables one for the language, and one for everything that is language independent.

You have to look in this table: xxx_virtuemart_shipmentmethods_en_gb, shipment name could be the shipping rate name.
and in this table:xx_virtuemart_shipmentmethods , in the shipment_params, you can add the weigth and the rate , and the tax id.

Code Select Expand

shipment_logos=""|countries=""|zip_start=""|zip_stop=""|weight_start=""|weight_stop=""|weight_unit="KG"|nbproducts_start=""|nbproducts_stop=""|orderamount_start=""|orderamount_stop=""|cost=""|package_fee=""|tax_id="1"|free_shipment=""|

I don't know about any tools to do it.

[callumgilhooly]

Thanks for your reply Alatak.

I noticed the different structure. It probably makes sense from a coding point of view

I can map across the fields into xxx_virtuemart_shipmentmethods_en_gb as they have a related field in the old table.

What I'm stuck on is how to combine all the fields from the old table into xx_virtuemart_shipmentmethods in the format that's required. I've tried doing it in a spreadsheet but can't get the shipment_params correct so just gets rejected by phpmyadmin.

If anyone has an idea it would be most appreciated (and I'm sure there are others that must need this?)

Thanks again

Callum