If you’re creating a shipping option for Magento that is determined by # of items vs destination, you’ll need to enter in country codes for each country you want to have available for your customers to select from. Because you want to include most of the countries in the world to buy from your store, it’s a smart idea to quote a shipping price for each country in the world.
To do this, you need to export csv file from Magento which produces a files called tablerates.csv. When you open this file, it will be an empty file for you to fill in. Typically I fill in country with the code below, 1 items, and price. I then copy all the countries and paste it below the countries/prices I just made for 1 item, and duplicate it for two items… on and on as many times as necessary. I find it easier this way than inserting rows for the 2nd, 3rd, and 4th items etc.
To manually find and enter in each of the country codes is a big pain in the ass. I have compiled a list for you:
| CAN |
| USA |
| AND |
| ARE |
| AFG |
| ATG |
| AIA |
| ALB |
| ARM |
| ANT |
| AGO |
| ATA |
| ARG |
| ASM |
| AUT |
| AUS |
| ABW |
| ALA |
| AZE |
| BIH |
| BRB |
| BGD |
| BEL |
| BFA |
| BGR |
| BHR |
| BDI |
| BEN |
| BLM |
| BMU |
| BRN |
| BOL |
| BRA |
| BHS |
| BTN |
| BVT |
| BWA |
| BLR |
| BLZ |
| CCK |
| COD |
| CAF |
| COG |
| CHE |
| CIV |
| COK |
| CHL |
| CMR |
| CHN |
| COL |
| CRI |
| CUB |
| CPV |
| CXR |
| CYP |
| CZE |
| DEU |
| DJI |
| DNK |
| DMA |
| DOM |
| DZA |
| ECU |
| EST |
| EGY |
| ESH |
| ERI |
| ESP |
| ETH |
| FIN |
| FJI |
| FLK |
| FSM |
| FRO |
| FRA |
| GAB |
| GBR |
| GRD |
| GEO |
| GUF |
| GGY |
| GHA |
| GIB |
| GRL |
| GMB |
| GIN |
| GLP |
| GNQ |
| GRC |
| SGS |
| GTM |
| GUM |
| GNB |
| GUY |
| HKG |
| HMD |
| HND |
| HRV |
| HTI |
| HUN |
| IDN |
| IRL |
| ISR |
| IMN |
| IND |
| IOT |
| IRQ |
| IRN |
| ISL |
| ITA |
| JEY |
| JAM |
| JOR |
| JPN |
| KEN |
| KGZ |
| KHM |
| KIR |
| COM |
| KNA |
| PRK |
| KOR |
| KWT |
| CYM |
| KAZ |
| LAO |
| LBN |
| LCA |
| LIE |
| LKA |
| LBR |
| LSO |
| LTU |
| LUX |
| LVA |
| LBY |
| MAR |
| MCO |
| MDA |
| MNE |
| MDG |
| MAF |
| MHL |
| MKD |
| MLI |
| MMR |
| MNG |
| MAC |
| MNP |
| MTQ |
| MRT |
| MSR |
| MLT |
| MUS |
| MDV |
| MWI |
| MEX |
| MYS |
| MOZ |
| NAM |
| NCL |
| NER |
| NFK |
| NGA |
| NIC |
| NLD |
| NOR |
| NPL |
| NRU |
| NIU |
| NZL |
| OMN |
| PAN |
| PER |
| PYF |
| PNG |
| PHL |
| PAK |
| POL |
| SPM |
| PCN |
| PRI |
| PSE |
| PRT |
| PLW |
| PRY |
| QAT |
| REU |
| ROU |
| SRB |
| RUS |
| RWA |
| SAU |
| SLB |
| SYC |
| SDN |
| SWE |
| SGP |
| SHN |
| SVN |
| SJM |
| SVK |
| SLE |
| SMR |
| SEN |
| SOM |
| SUR |
| STP |
| SLV |
| SYR |
| SWZ |
| TCA |
| TCD |
| ATF |
| TGO |
| THA |
| TJK |
| TKL |
| TLS |
| TKM |
| TUN |
| TON |
| TUR |
| TTO |
| TUV |
| TWN |
| TZA |
| UKR |
| UGA |
| UMI |
| URY |
| UZB |
| VAT |
| VCT |
| VEN |
| VGB |
| VIR |
| VNM |
| VUT |
| WLF |
| WSM |
| YEM |
| MYT |
| ZAF |
| ZMB |
| ZWE |
These country codes are associated with the following two letter country codes, that I believe can also be used in Magento also:
AF Afghanistan AF – AFG AFG AL Albania AL – ALB ALB DZ Algeria DZ – DZA DZA AS American Samoa AS – ASM ASM AD Andorra AD – AND AND AO Angola AO – AGO AGO AI Anguilla AI – AIA AIA AQ Antarctica AQ – ATA ATA AG Antigua and Barbuda AG – ATG ATG AR Argentina AR – ARG ARG AM Armenia AM – ARM ARM AW Aruba AW – ABW ABW AU Australia AU – AUS AUS AT Austria AT – AUT AUT AZ Azerbaijan AZ – AZE AZE BS Bahamas BS – BHS BHS BH Bahrain BH – BHR BHR BD Bangladesh BD – BGD BGD BB Barbados BB – BRB BRB BY Belarus BY – BLR BLR BE Belgium BE – BEL BEL BZ Belize BZ – BLZ BLZ BJ Benin BJ – BEN BEN BM Bermuda BM – BMU BMU BT Bhutan BT – BTN BTN BO Bolivia BO – BOL BOL BA Bosnia and Herzegovi BA – BIH BIH BW Botswana BW – BWA BWA BV Bouvet Island BV – BVT BVT BR Brazil BR – BRA BRA IO British Indian Ocean IO – IOT IOT VG British Virgin Islan VG – VGB VGB BN Brunei BN – BRN BRN BG Bulgaria BG – BGR BGR BF Burkina Faso BF – BFA BFA BI Burundi BI – BDI BDI KH Cambodia KH – KHM KHM CM Cameroon CM – CMR CMR CA Canada CA – CAN CAN CV Cape Verde CV – CPV CPV KY Cayman Islands KY – CYM CYM CF Central African Repu CF – CAF CAF TD Chad TD – TCD TCD CL Chile CL – CHL CHL CN China CN – CHN CHN CX Christmas Island CX – CXR CXR CC Cocos [Keeling] Isla CC – CCK CCK CO Colombia CO – COL COL KM Comoros KM – COM COM CG Congo – Brazzaville CG – COG COG CD Congo – Kinshasa CD – COD COD CK Cook Islands CK – COK COK CR Costa Rica CR – CRI CRI HR Croatia HR – HRV HRV CU Cuba CU – CUB CUB CY Cyprus CY – CYP CYP CZ Czech Republic CZ – CZE CZE CI Côte d’Ivoire CI – CIV CIV DK Denmark DK – DNK DNK DJ Djibouti DJ – DJI DJI DM Dominica DM – DMA DMA DO Dominican Republic DO – DOM DOM EC Ecuador EC – ECU ECU EG Egypt EG – EGY EGY SV El Salvador SV – SLV SLV GQ Equatorial Guinea GQ – GNQ GNQ ER Eritrea ER – ERI ERI EE Estonia EE – EST EST ET Ethiopia ET – ETH ETH FK Falkland Islands FK – FLK FLK FO Faroe Islands FO – FRO FRO FJ Fiji FJ – FJI FJI FI Finland FI – FIN FIN FR France FR – FRA FRA GF French Guiana GF – GUF GUF PF French Polynesia PF – PYF PYF TF French Southern Terr TF – ATF ATF GA Gabon GA – GAB GAB GM Gambia GM – GMB GMB GE Georgia GE – GEO GEO DE Germany DE – DEU DEU GH Ghana GH – GHA GHA GI Gibraltar GI – GIB GIB GR Greece GR – GRC GRC GL Greenland GL – GRL GRL GD Grenada GD – GRD GRD GP Guadeloupe GP – GLP GLP GU Guam GU – GUM GUM GT Guatemala GT – GTM GTM GG Guernsey GG – GGY GGY GN Guinea GN – GIN GIN GW Guinea-Bissau GW – GNB GNB GY Guyana GY – GUY GUY HT Haiti HT – HTI HTI HM Heard Island and McD HM – HMD HMD HN Honduras HN – HND HND HK Hong Kong SAR China HK – HKG HKG HU Hungary HU – HUN HUN IS Iceland IS – ISL ISL IN India IN – IND IND ID Indonesia ID – IDN IDN IR Iran IR – IRN IRN IQ Iraq IQ – IRQ IRQ IE Ireland IE – IRL IRL IM Isle of Man IM – IMN IMN IL Israel IL – ISR ISR IT Italy IT – ITA ITA JM Jamaica JM – JAM JAM JP Japan JP – JPN JPN JE Jersey JE – JEY JEY JO Jordan JO – JOR JOR KZ Kazakhstan KZ – KAZ KAZ KE Kenya KE – KEN KEN KI Kiribati KI – KIR KIR KW Kuwait KW – KWT KWT KG Kyrgyzstan KG – KGZ KGZ LA Laos LA – LAO LAO LV Latvia LV – LVA LVA LB Lebanon LB – LBN LBN LS Lesotho LS – LSO LSO LR Liberia LR – LBR LBR LY Libya LY – LBY LBY LI Liechtenstein LI – LIE LIE LT Lithuania LT – LTU LTU LU Luxembourg LU – LUX LUX MO Macau SAR China MO – MAC MAC MK Macedonia MK – MKD MKD MG Madagascar MG – MDG MDG MW Malawi MW – MWI MWI MY Malaysia MY – MYS MYS MV Maldives MV – MDV MDV ML Mali ML – MLI MLI MT Malta MT – MLT MLT MH Marshall Islands MH – MHL MHL MQ Martinique MQ – MTQ MTQ MR Mauritania MR – MRT MRT MU Mauritius MU – MUS MUS YT Mayotte YT – MYT MYT MX Mexico MX – MEX MEX FM Micronesia FM – FSM FSM MD Moldova MD – MDA MDA MC Monaco MC – MCO MCO MN Mongolia MN – MNG MNG ME Montenegro ME – MNE MNE MS Montserrat MS – MSR MSR MA Morocco MA – MAR MAR MZ Mozambique MZ – MOZ MOZ MM Myanmar [Burma] MM – MMR MMR NA Namibia NA – NAM NAM NR Nauru NR – NRU NRU NP Nepal NP – NPL NPL NL Netherlands NL – NLD NLD AN Netherlands Antilles AN – ANT ANT NC New Caledonia NC – NCL NCL NZ New Zealand NZ – NZL NZL NI Nicaragua NI – NIC NIC NE Niger NE – NER NER NG Nigeria NG – NGA NGA NU Niue NU – NIU NIU NF Norfolk Island NF – NFK NFK KP North Korea KP – PRK PRK MP Northern Mariana Isl MP – MNP MNP NO Norway NO – NOR NOR OM Oman OM – OMN OMN PK Pakistan PK – PAK PAK PW Palau PW – PLW PLW PS Palestinian Territor PS – PSE PSE PA Panama PA – PAN PAN PG Papua New Guinea PG – PNG PNG PY Paraguay PY – PRY PRY PE Peru PE – PER PER PH Philippines PH – PHL PHL PN Pitcairn Islands PN – PCN PCN PL Poland PL – POL POL PT Portugal PT – PRT PRT PR Puerto Rico PR – PRI PRI QA Qatar QA – QAT QAT RO Romania RO – ROU ROU RU Russia RU – RUS RUS RW Rwanda RW – RWA RWA RE Réunion RE – REU REU BL Saint Barthélemy BL – BLM BLM SH Saint Helena SH – SHN SHN KN Saint Kitts and Nevi KN – KNA KNA LC Saint Lucia LC – LCA LCA MF Saint Martin MF – MAF MAF PM Saint Pierre and Miq PM – SPM SPM VC Saint Vincent and th VC – VCT VCT WS Samoa WS – WSM WSM SM San Marino SM – SMR SMR SA Saudi Arabia SA – SAU SAU SN Senegal SN – SEN SEN RS Serbia RS – SRB SRB SC Seychelles SC – SYC SYC SL Sierra Leone SL – SLE SLE SG Singapore SG – SGP SGP SK Slovakia SK – SVK SVK SI Slovenia SI – SVN SVN SB Solomon Islands SB – SLB SLB SO Somalia SO – SOM SOM ZA South Africa ZA – ZAF ZAF GS South Georgia and th GS – SGS SGS KR South Korea KR – KOR KOR ES Spain ES – ESP ESP LK Sri Lanka LK – LKA LKA SD Sudan SD – SDN SDN SR Suriname SR – SUR SUR SJ Svalbard and Jan May SJ – SJM SJM SZ Swaziland SZ – SWZ SWZ SE Sweden SE – SWE SWE CH Switzerland CH – CHE CHE SY Syria SY – SYR SYR ST São Tomé and Príncip ST – STP STP TW Taiwan TW – TWN TWN TJ Tajikistan TJ – TJK TJK TZ Tanzania TZ – TZA TZA TH Thailand TH – THA THA TL Timor-Leste TL – TLS TLS TG Togo TG – TGO TGO TK Tokelau TK – TKL TKL TO Tonga TO – TON TON TT Trinidad and Tobago TT – TTO TTO TN Tunisia TN – TUN TUN TR Turkey TR – TUR TUR TM Turkmenistan TM – TKM TKM TC Turks and Caicos Isl TC – TCA TCA TV Tuvalu TV – TUV TUV UM U.S. Minor Outlying UM – UMI UMI VI U.S. Virgin Islands VI – VIR VIR UG Uganda UG – UGA UGA UA Ukraine UA – UKR UKR AE United Arab Emirates AE – ARE ARE GB United Kingdom GB – GBR GBR US United States US – USA USA UY Uruguay UY – URY URY UZ Uzbekistan UZ – UZB UZB VU Vanuatu VU – VUT VUT VA Vatican City VA – VAT VAT VE Venezuela VE – VEN VEN VN Vietnam VN – VNM VNM WF Wallis and Futuna WF – WLF WLF EH Western Sahara EH – ESH ESH YE Yemen YE – YEM YEM ZM Zambia ZM – ZMB ZMB ZW Zimbabwe ZW – ZWE ZWE AX Åland Islands AX – ALA ALA
Thanks to Genius Moments for the table of associated values for this. And Code Ground for the initial list I modified.
Hope this helps you complete your store!
AF – Afghanistan
AL – Albania
DZ – Algeria
AS – American Samoa
AD – Andorra
AO – Angola
AI – Anguilla
AQ – Antarctica
AG – Antigua and Barbuda
AR – Argentina
AM – Armenia
AW – Aruba
AU – Australia
AT – Austria
AZ – Azerbaijan
BS – Bahamas
BH – Bahrain
BD – Bangladesh
BB – Barbados
BY – Belarus
BE – Belgium
BZ – Belize
BJ – Benin
BM – Bermuda
BT – Bhutan
BO – Bolivia
BA – Bosnia and Herzegovina
BW – Botswana
BV – Bouvet Island
BR – Brazil
IO – British Indian Ocean Territory
VG – British Virgin Islands
BN – Brunei
BG – Bulgaria
BF – Burkina Faso
BI – Burundi
KH – Cambodia
CM – Cameroon
CA – Canada
CV – Cape Verde
KY – Cayman Islands
CF – Central African Republic
TD – Chad
CL – Chile
CN – China
CX – Christmas Island
CC – Cocos [Keeling] Islands
CO – Colombia
KM – Comoros
CG – Congo – Brazzaville
CD – Congo – Kinshasa
CK – Cook Islands
CR – Costa Rica
HR – Croatia
CU – Cuba
CY – Cyprus
CZ – Czech Republic
CI – Côte d’Ivoire
DK – Denmark
DJ – Djibouti
DM – Dominica
DO – Dominican Republic
EC – Ecuador
EG – Egypt
SV – El Salvador
GQ – Equatorial Guinea
ER – Eritrea
EE – Estonia
ET – Ethiopia
FK – Falkland Islands
FO – Faroe Islands
FJ – Fiji
FI – Finland
FR – France
GF – French Guiana
PF – French Polynesia
TF – French Southern Territories
GA – Gabon
GM – Gambia
GE – Georgia
DE – Germany
GH – Ghana
GI – Gibraltar
GR – Greece
GL – Greenland
GD – Grenada
GP – Guadeloupe
GU – Guam
GT – Guatemala
GG – Guernsey
GN – Guinea
GW – Guinea-Bissau
GY – Guyana
HT – Haiti
HM – Heard Island and McDonald Islands
HN – Honduras
HK – Hong Kong SAR China
HU – Hungary
IS – Iceland
IN – India
ID – Indonesia
IR – Iran
IQ – Iraq
IE – Ireland
IM – Isle of Man
IL – Israel
IT – Italy
JM – Jamaica
JP – Japan
JE – Jersey
JO – Jordan
KZ – Kazakhstan
KE – Kenya
KI – Kiribati
KW – Kuwait
KG – Kyrgyzstan
LA – Laos
LV – Latvia
LB – Lebanon
LS – Lesotho
LR – Liberia
LY – Libya
LI – Liechtenstein
LT – Lithuania
LU – Luxembourg
MO – Macau SAR China
MK – Macedonia
MG – Madagascar
MW – Malawi
MY – Malaysia
MV – Maldives
ML – Mali
MT – Malta
MH – Marshall Islands
MQ – Martinique
MR – Mauritania
MU – Mauritius
YT – Mayotte
MX – Mexico
FM – Micronesia
MD – Moldova
MC – Monaco
MN – Mongolia
ME – Montenegro
MS – Montserrat
MA – Morocco
MZ – Mozambique
MM – Myanmar [Burma]
NA – Namibia
NR – Nauru
NP – Nepal
NL – Netherlands
AN – Netherlands Antilles
NC – New Caledonia
NZ – New Zealand
NI – Nicaragua
NE – Niger
NG – Nigeria
NU – Niue
NF – Norfolk Island
KP – North Korea
MP – Northern Mariana Islands
NO – Norway
OM – Oman
PK – Pakistan
PW – Palau
PS – Palestinian Territories
PA – Panama
PG – Papua New Guinea
PY – Paraguay
PE – Peru
PH – Philippines
PN – Pitcairn Islands
PL – Poland
PT – Portugal
PR – Puerto Rico
QA – Qatar
RO – Romania
RU – Russia
RW – Rwanda
RE – Réunion
BL – Saint Barthélemy
SH – Saint Helena
KN – Saint Kitts and Nevis
LC – Saint Lucia
MF – Saint Martin
PM – Saint Pierre and Miquelon
VC – Saint Vincent and the Grenadines
WS – Samoa
SM – San Marino
SA – Saudi Arabia
SN – Senegal
RS – Serbia
SC – Seychelles
SL – Sierra Leone
SG – Singapore
SK – Slovakia
SI – Slovenia
SB – Solomon Islands
SO – Somalia
ZA – South Africa
GS – South Georgia and the South Sandwich Islands
KR – South Korea
ES – Spain
LK – Sri Lanka
SD – Sudan
SR – Suriname
SJ – Svalbard and Jan Mayen
SZ – Swaziland
SE – Sweden
CH – Switzerland
SY – Syria
ST – São Tomé and Príncipe
TW – Taiwan
TJ – Tajikistan
TZ – Tanzania
TH – Thailand
TL – Timor-Leste
TG – Togo
TK – Tokelau
TO – Tonga
TT – Trinidad and Tobago
TN – Tunisia
TR – Turkey
TM – Turkmenistan
TC – Turks and Caicos Islands
TV – Tuvalu
UM – U.S. Minor Outlying Islands
VI – U.S. Virgin Islands
UG – Uganda
UA – Ukraine
AE – United Arab Emirates
GB – United Kingdom
US – United States
UY – Uruguay
UZ – Uzbekistan
VU – Vanuatu
VA – Vatican City
VE – Venezuela
VN – Vietnam
WF – Wallis and Futuna
EH – Western Sahara
YE – Yemen
ZM – Zambia
ZW – Zimbabwe
AX – Åland Islands
Thanks for linking back to my article! Not everybody does that 😉
It was a valuable resource Ricard, I appreciate when folks do great things on the internet 🙂
Awesome, you saved me a lot of time, very useful!
thankyou!
Here to help Jay! 🙂