1. ptrouw
  2. RO CSVI
  3. Tuesday, 06 January 2015
  4.  Subscribe via email
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.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
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?
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
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=""|
  1. more than a month ago
  2. RO CSVI
  3. # 4
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.
Attachments (1)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,

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
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
thx it works
  1. more than a month ago
  2. RO CSVI
  3. # 8
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.)
  1. more than a month ago
  2. RO CSVI
  3. # 9
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 :) 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.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!