Hi,
I am using VM3 and have the shipping rates for the Dutch language for all different European countries. How can I import these into another language.
Looking at the import template, it mentioned Primary Language to Translation Language.
How does this work?
And what are the minimum required fields for this import file of shipping rates?
Accepted Answer
Pending Moderation
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.
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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?

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?
Attachments (1)
Accepted Answer
Pending Moderation
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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=""|
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=""|
Accepted Answer
Pending Moderation
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.
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.
Attachments (1)
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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
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
Accepted Answer
Pending Moderation
Hello,
You are correct, I missed something, attached is an updated patch. That should be fine.
You are correct, I missed something, attached is an updated patch. That should be fine.
Attachments (1)
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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.)
Accepted Answer
Pending Moderation
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

Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »