Configuring a shipping table () in #Magento for a foreign country can be tricky, but here you’ll find some very useful tips.

The mayor difficulty resides in configuring different shipping costs according to different provinces, states, regions and postal codes. In this example, we’ll configure 2 shipping types (Shipping to branch and Home delivery), and the cost depends on each method, package weight and shipping distance.

We’ve used WebShopApps MatrixRate extension in order to get more flexibility when configuring shipping table rates. This extension allows you to upload a .csv file with all the costs and shipping variables. However, you may find this error when trying to import this file:

This error message is produced because Magento doesn’t have all provinces/regions/states of all countries in the database, so we have to add this values directly in the corresponding database table. So, navigate to your databse admin (for example phpmyadmin) then pass this values:

This query will add the necessary values in your database in order to have set (in this example) the Argentinian provinces in your Magento installation. Changing the values can be very useful for any country. Then you must configure the Shipping Cost Table and its variables, here’s an example:

.

País

Región/Estado

Ciudad

Zip/Postal Code From

Zip/Postal Code To

Weight From

Weight To

Precio de envío

Delivery Type

.

AR

BA

*

*

*

0

100

51

Envio a domicilio

.

AR

BA

*

*

*

100

300

55

Envio a domicilio

.

AR

SA

*

*

*

0

100

55

Envio a domicilio

.

AR

SA

*

*

*

100

300

61

Envio a domicilio

.

AR

CA

*

*

*

0

100

55

Envio a domicilio

.

AR

CA

*

*

*

100

300

61

Envio a domicilio

.

AR

CH

*

*

*

0

100

51

Envio a domicilio

.

AR

CH

*

*

*

100

300

55

Envio a domicilio

.

AR

UT

*

*

*

0

100

55

Envio a domicilio

.

AR

UT

*

*

*

100

300

61

Envio a domicilio

.

AR

CO

*

*

*

0

100

51

Envio a domicilio

.

AR

CO

*

*

*

100

300

55

Envio a domicilio

.

AR

CT

*

*

*

0

100

51

Envio a domicilio

.

AR

CT

*

*

*

100

300

55

Envio a domicilio

.

AR

ER

*

*

*

0

100

51

Envio a domicilio

.

AR

ER

*

*

*

100

300

55

Envio a domicilio

.

AR

FO

*

*

*

0

100

55

Envio a domicilio

.

AR

FO

*

*

*

100

300

61

Envio a domicilio

.

AR

JU

*

*

*

0

100

55

Envio a domicilio

.

AR

JU

*

*

*

100

300

61

Envio a domicilio

.

AR

LP

*

*

*

0

100

55

Envio a domicilio

.

AR

LP

*

*

*

100

300

61

Envio a domicilio

.

AR

LR

*

*

*

0

100

55

Envio a domicilio

.

AR

LR

*

*

*

100

300

61

Envio a domicilio

.

AR

ME

*

*

*

0

100

55

Envio a domicilio

.

AR

ME

*

*

*

100

300

61

Envio a domicilio

.

AR

MI

*

*

*

0

100

55

Envio a domicilio

.

AR

MI

*

*

*

100

300

61

Envio a domicilio

.

AR

NE

*

*

*

0

100

55

Envio a domicilio

.

AR

NE

*

*

*

100

300

61

Envio a domicilio

.

AR

RO

*

*

*

0

100

55

Envio a domicilio

.

AR

RO

*

*

*

100

300

61

Envio a domicilio

.

AR

SJ

*

*

*

0

100

55

Envio a domicilio

.

AR

SJ

*

*

*

100

300

61

Envio a domicilio

.

AR

SL

*

*

*

0

100

55

Envio a domicilio

.

AR

SL

*

*

*

100

300

61

Envio a domicilio

.

AR

SF

*

*

*

0

100

51

Envio a domicilio

.

AR

SF

*

*

*

100

300

55

Envio a domicilio

.

AR

SE

*

*

*

0

100

51

Envio a domicilio

.

AR

SE

*

*

*

100

300

55

Envio a domicilio

.

AR

TR

*

*

*

0

100

55

Envio a domicilio

.

AR

TR

*

*

*

100

300

61

Envio a domicilio

.

AR

TU

*

*

*

0

100

55

Envio a domicilio

.

AR

TU

*

*

*

100

300

61

Envio a domicilio

.

AR

BA

*

*

*

0

100

31

Envio a Sucursal

In this case, we’ve configured:

Weight: packages between 0kg and 1kg have a cost and packages between 1kg and 3kg have a different cost.

Destination: provinces bordering the province of origin have a specific value.

Shipping type: home delivery and shipping to Mailing branch.

Last thing, we must upload our shipping table rates .csv file to Magento. First you must have active Webshopapps Matrix rates extension in your default store-view, then select your Magento main website and you’ll be able to upload your own tables file. System/Configuration/Shipping Methods/Matrix Rates/Import/select file: