Resolved Shipping rates import

Hello,

The required fields for shipping rates are explained in the Import VirtueMart 2 shipping rates document.

The management of a multi-language VirtueMart site is explained in the [url=http://www.csvimproved.com/en/support/questions-and-answers/220-virtuemart/879-setting-up-a-virtuemart-2-multi-language-shop]Setting up a VirtueMart 2 multi-language website.

Sorry, I did search, but not good enough

I don't want to override my shipping rates. My default joomla language is set to Dutch.
But In VM I just added 4 languages in no particular order (screenshot).
So if I want to import my Dutch shipping rated to English. I select Dutch and for Translation language English. Correct?

No worries

So if I want to import my Dutch shipping rated to English. I select Dutch and for Translation language English. Correct?

Correct. Since you are sort of testing, let me advice to make a backup before you start.

Shipping rates import doesn't seem to work, I am missing the shipment_cost?
My record:
cost^countries^free_shipment^orderamount_start^orderamount_stop^nbproducts_start^nbproducts_stop^package_fee^published^shared^shipment_desc^shipment_element^shipment_jplugin_id^shipment_logos^shipment_name^tax_id^virtuemart_vendor_id^weight_start^weight_stop^weight_unit^zip_start^zip_stop
21.48760^Italy^""^""^""^0^0^0.00^1^1^1 - 15 kg (IT - North)^weight_countries^10024^""^DHL^3^1^1.000^15.000^KG^5000^6123

So far so good.
This is the inserted in the SQL field, shipment_params:
countries=["105"]|zip_start="5000"|zip_stop="6123"|weight_start="1.000"|weight_stop="15.000"|weight_unit="KG"|nbproducts_start="0"|nbproducts_stop="0"|cost="21.48760"|package_fee="0.00"|tax_id="3"|

It seems cost is not the right field. It is not displaying any value. If I then edit this row within VM shipping method, the field shipment_cost is used for the amount.

The changed SQL field shipment_params reads:
shipment_logos=""|show_on_pdetails="1"|countries=["105"]|zip_start="5000"|zip_stop="6123"|weight_start="1.000"|weight_stop="15.000"|weight_unit="KG"|nbproducts_start=0|nbproducts_stop=0|orderamount_start=""|orderamount_stop=""|shipment_cost="21.48760"|package_fee="0.00"|tax_id="3"|free_shipment=""|

Hello,

You are correct, that is a mistake. Attached is the patch file that fixes this. You can load the patch file from the maintenance menu. After that the import should work as expected.

Hi Roland,

Thx for the quick reply. But it doesn't seem to work. Below you can see the SQL field, no cost in it. Neither Cost or Shipment_cost!

countries=["222"]|zip_start="0"|zip_stop="99999"|weight_start="7.001"|weight_stop="15"|weight_unit="KG"|nbproducts_start="0"|nbproducts_stop="0"|package_fee="0.00"|tax_id="3"|

This is the import file:

cost^countries^shipment_name^weight_start^weight_stop^free_shipment^nbproducts_start^nbproducts_stop^orderamount_start^orderamount_stop^package_fee^published^shared^shipment_element^shipment_jplugin_id^shipment_logos^tax_id^virtuemart_vendor_id^weight_unit^zip_start^zip_stop
18.1818181818182^United Kingdom^DHL | 7 - 15 kg (GB)^7.001^15^""^0^0^""^""^0.00^1^0^weight_countries^10024^""^3^1^KG^0^99999

Hello,

You are correct, I missed something, attached is an updated patch. That should be fine.

thx it works

Thanks. A separate question: I got errors "No shipping plugin found", which I figured out was being generated by lines that I'd deleted in the import file. It seems the end of file was not bumped up when I deleted the second half of the file, is there a way to properly mark the end of file when I delete records? (I am building the csv files using Excel.)

is there a way to properly mark the end of file when I delete records? (I am building the csv files using Excel.)

I would almost say that is a question for Microsoft The only way I have found to keep it clean is to select the rows and columns with the correct data and copy-paste it into a new Excel sheet, that way you are sure nothing is left.