Lost password?    Lost username?    Create an account
OverviewDownloadsForumSupport
CSV Improved

CSV Improved

Import VirtueMart 2 shipping rates

Requirements

  • CSVI 4.3.1+
  • VirtueMart 2.0.2+
  • Joomla 2.5+
  • PHP 5.3+

Choosing the fields

To import shipping rates the following fields are required:

  • shipment_name
  • shipment_logos
  • countries
  • zip_start
  • zip_stop
  • weight_start
  • weight_stop
  • weight_unit
  • nbproducts_start
  • nbproducts_stop
  • orderamount_start
  • orderamount_stop
  • cost
  • package_fee
  • tax_id / tax
  • free_shipment
shipment_name

This is the name of the shipping rate. The name must be unique and is used to determine if a shipping rate already exists or not.

shipment_logos

Specify one or more logos to show for the shipping rate. Multiple logos can be added by seperating them with a comma e.g. logo1.jpg,logo2.jpg. The logos must be placed in the folder images/stories/virtuemart/shipment.

countries

Specify one or more countries the shipping rate applies to. Multiple countries can be added by seperating them with a comma e.g. Netherlands,Spain.

zip_start

Specify the zip range start.

zip_stop

Specify the zip range end.

weight_start

Specify the lowest weight.

weight_stop

Specify the highest weight.

weight_unit

Specify the weight unit.

nbproducts_start

Specify the minimum number of products.

nbproducts_stop

Specify the maximum number of products.

orderamount_start

Specify the minimum order amount.

orderamount_stop

Specify the maximum order amount.

cost

Specify the shipment cost.

package_fee

Specify the package fee.

tax_id / tax

tax_id: Specify the tax id of the tax rate you want to use
tax: Specify the name of the tax rate you want to use. The name can be found under Taxes & Calculation rules.

You cannot use both fields at the same time, choose between tax_id or tax

free_shipment

Specify the minimum amount for free shipment.

Additional fields

The shipping plugin for which the field are going to be imported can be selected in the template or the field shipment_element can be used. The value to use for shipment_element can be found in the Joomla! plugin manager.

Shipment plugin

The name under Element is what is needed, in this case that is weight_countries. In your CSV file you can add the column:

shipment_element
weight_countries

Further reading

Other good sources of information are: