Three Digit Country Codes Table Current for Magento 1.7

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:

 

AFAfghanistanAF – AFGAFG
ALAlbaniaAL – ALBALB
DZAlgeriaDZ – DZADZA
ASAmerican SamoaAS – ASMASM
ADAndorraAD – ANDAND
AOAngolaAO – AGOAGO
AIAnguillaAI – AIAAIA
AQAntarcticaAQ – ATAATA
AGAntigua and BarbudaAG – ATGATG
ARArgentinaAR – ARGARG
AMArmeniaAM – ARMARM
AWArubaAW – ABWABW
AUAustraliaAU – AUSAUS
ATAustriaAT – AUTAUT
AZAzerbaijanAZ – AZEAZE
BSBahamasBS – BHSBHS
BHBahrainBH – BHRBHR
BDBangladeshBD – BGDBGD
BBBarbadosBB – BRBBRB
BYBelarusBY – BLRBLR
BEBelgiumBE – BELBEL
BZBelizeBZ – BLZBLZ
BJBeninBJ – BENBEN
BMBermudaBM – BMUBMU
BTBhutanBT – BTNBTN
BOBoliviaBO – BOLBOL
BABosnia and HerzegoviBA – BIHBIH
BWBotswanaBW – BWABWA
BVBouvet IslandBV – BVTBVT
BRBrazilBR – BRABRA
IOBritish Indian OceanIO – IOTIOT
VGBritish Virgin IslanVG – VGBVGB
BNBruneiBN – BRNBRN
BGBulgariaBG – BGRBGR
BFBurkina FasoBF – BFABFA
BIBurundiBI – BDIBDI
KHCambodiaKH – KHMKHM
CMCameroonCM – CMRCMR
CACanadaCA – CANCAN
CVCape VerdeCV – CPVCPV
KYCayman IslandsKY – CYMCYM
CFCentral African RepuCF – CAFCAF
TDChadTD – TCDTCD
CLChileCL – CHLCHL
CNChinaCN – CHNCHN
CXChristmas IslandCX – CXRCXR
CCCocos [Keeling] IslaCC – CCKCCK
COColombiaCO – COLCOL
KMComorosKM – COMCOM
CGCongo – BrazzavilleCG – COGCOG
CDCongo – KinshasaCD – CODCOD
CKCook IslandsCK – COKCOK
CRCosta RicaCR – CRICRI
HRCroatiaHR – HRVHRV
CUCubaCU – CUBCUB
CYCyprusCY – CYPCYP
CZCzech RepublicCZ – CZECZE
CICôte d’IvoireCI – CIVCIV
DKDenmarkDK – DNKDNK
DJDjiboutiDJ – DJIDJI
DMDominicaDM – DMADMA
DODominican RepublicDO – DOMDOM
ECEcuadorEC – ECUECU
EGEgyptEG – EGYEGY
SVEl SalvadorSV – SLVSLV
GQEquatorial GuineaGQ – GNQGNQ
EREritreaER – ERIERI
EEEstoniaEE – ESTEST
ETEthiopiaET – ETHETH
FKFalkland IslandsFK – FLKFLK
FOFaroe IslandsFO – FROFRO
FJFijiFJ – FJIFJI
FIFinlandFI – FINFIN
FRFranceFR – FRAFRA
GFFrench GuianaGF – GUFGUF
PFFrench PolynesiaPF – PYFPYF
TFFrench Southern TerrTF – ATFATF
GAGabonGA – GABGAB
GMGambiaGM – GMBGMB
GEGeorgiaGE – GEOGEO
DEGermanyDE – DEUDEU
GHGhanaGH – GHAGHA
GIGibraltarGI – GIBGIB
GRGreeceGR – GRCGRC
GLGreenlandGL – GRLGRL
GDGrenadaGD – GRDGRD
GPGuadeloupeGP – GLPGLP
GUGuamGU – GUMGUM
GTGuatemalaGT – GTMGTM
GGGuernseyGG – GGYGGY
GNGuineaGN – GINGIN
GWGuinea-BissauGW – GNBGNB
GYGuyanaGY – GUYGUY
HTHaitiHT – HTIHTI
HMHeard Island and McDHM – HMDHMD
HNHondurasHN – HNDHND
HKHong Kong SAR ChinaHK – HKGHKG
HUHungaryHU – HUNHUN
ISIcelandIS – ISLISL
INIndiaIN – INDIND
IDIndonesiaID – IDNIDN
IRIranIR – IRNIRN
IQIraqIQ – IRQIRQ
IEIrelandIE – IRLIRL
IMIsle of ManIM – IMNIMN
ILIsraelIL – ISRISR
ITItalyIT – ITAITA
JMJamaicaJM – JAMJAM
JPJapanJP – JPNJPN
JEJerseyJE – JEYJEY
JOJordanJO – JORJOR
KZKazakhstanKZ – KAZKAZ
KEKenyaKE – KENKEN
KIKiribatiKI – KIRKIR
KWKuwaitKW – KWTKWT
KGKyrgyzstanKG – KGZKGZ
LALaosLA – LAOLAO
LVLatviaLV – LVALVA
LBLebanonLB – LBNLBN
LSLesothoLS – LSOLSO
LRLiberiaLR – LBRLBR
LYLibyaLY – LBYLBY
LILiechtensteinLI – LIELIE
LTLithuaniaLT – LTULTU
LULuxembourgLU – LUXLUX
MOMacau SAR ChinaMO – MACMAC
MKMacedoniaMK – MKDMKD
MGMadagascarMG – MDGMDG
MWMalawiMW – MWIMWI
MYMalaysiaMY – MYSMYS
MVMaldivesMV – MDVMDV
MLMaliML – MLIMLI
MTMaltaMT – MLTMLT
MHMarshall IslandsMH – MHLMHL
MQMartiniqueMQ – MTQMTQ
MRMauritaniaMR – MRTMRT
MUMauritiusMU – MUSMUS
YTMayotteYT – MYTMYT
MXMexicoMX – MEXMEX
FMMicronesiaFM – FSMFSM
MDMoldovaMD – MDAMDA
MCMonacoMC – MCOMCO
MNMongoliaMN – MNGMNG
MEMontenegroME – MNEMNE
MSMontserratMS – MSRMSR
MAMoroccoMA – MARMAR
MZMozambiqueMZ – MOZMOZ
MMMyanmar [Burma]MM – MMRMMR
NANamibiaNA – NAMNAM
NRNauruNR – NRUNRU
NPNepalNP – NPLNPL
NLNetherlandsNL – NLDNLD
ANNetherlands AntillesAN – ANTANT
NCNew CaledoniaNC – NCLNCL
NZNew ZealandNZ – NZLNZL
NINicaraguaNI – NICNIC
NENigerNE – NERNER
NGNigeriaNG – NGANGA
NUNiueNU – NIUNIU
NFNorfolk IslandNF – NFKNFK
KPNorth KoreaKP – PRKPRK
MPNorthern Mariana IslMP – MNPMNP
NONorwayNO – NORNOR
OMOmanOM – OMNOMN
PKPakistanPK – PAKPAK
PWPalauPW – PLWPLW
PSPalestinian TerritorPS – PSEPSE
PAPanamaPA – PANPAN
PGPapua New GuineaPG – PNGPNG
PYParaguayPY – PRYPRY
PEPeruPE – PERPER
PHPhilippinesPH – PHLPHL
PNPitcairn IslandsPN – PCNPCN
PLPolandPL – POLPOL
PTPortugalPT – PRTPRT
PRPuerto RicoPR – PRIPRI
QAQatarQA – QATQAT
RORomaniaRO – ROUROU
RURussiaRU – RUSRUS
RWRwandaRW – RWARWA
RERéunionRE – REUREU
BLSaint BarthélemyBL – BLMBLM
SHSaint HelenaSH – SHNSHN
KNSaint Kitts and NeviKN – KNAKNA
LCSaint LuciaLC – LCALCA
MFSaint MartinMF – MAFMAF
PMSaint Pierre and MiqPM – SPMSPM
VCSaint Vincent and thVC – VCTVCT
WSSamoaWS – WSMWSM
SMSan MarinoSM – SMRSMR
SASaudi ArabiaSA – SAUSAU
SNSenegalSN – SENSEN
RSSerbiaRS – SRBSRB
SCSeychellesSC – SYCSYC
SLSierra LeoneSL – SLESLE
SGSingaporeSG – SGPSGP
SKSlovakiaSK – SVKSVK
SISloveniaSI – SVNSVN
SBSolomon IslandsSB – SLBSLB
SOSomaliaSO – SOMSOM
ZASouth AfricaZA – ZAFZAF
GSSouth Georgia and thGS – SGSSGS
KRSouth KoreaKR – KORKOR
ESSpainES – ESPESP
LKSri LankaLK – LKALKA
SDSudanSD – SDNSDN
SRSurinameSR – SURSUR
SJSvalbard and Jan MaySJ – SJMSJM
SZSwazilandSZ – SWZSWZ
SESwedenSE – SWESWE
CHSwitzerlandCH – CHECHE
SYSyriaSY – SYRSYR
STSão Tomé and PríncipST – STPSTP
TWTaiwanTW – TWNTWN
TJTajikistanTJ – TJKTJK
TZTanzaniaTZ – TZATZA
THThailandTH – THATHA
TLTimor-LesteTL – TLSTLS
TGTogoTG – TGOTGO
TKTokelauTK – TKLTKL
TOTongaTO – TONTON
TTTrinidad and TobagoTT – TTOTTO
TNTunisiaTN – TUNTUN
TRTurkeyTR – TURTUR
TMTurkmenistanTM – TKMTKM
TCTurks and Caicos IslTC – TCATCA
TVTuvaluTV – TUVTUV
UMU.S. Minor Outlying UM – UMIUMI
VIU.S. Virgin IslandsVI – VIRVIR
UGUgandaUG – UGAUGA
UAUkraineUA – UKRUKR
AEUnited Arab EmiratesAE – AREARE
GBUnited KingdomGB – GBRGBR
USUnited StatesUS – USAUSA
UYUruguayUY – URYURY
UZUzbekistanUZ – UZBUZB
VUVanuatuVU – VUTVUT
VAVatican CityVA – VATVAT
VEVenezuelaVE – VENVEN
VNVietnamVN – VNMVNM
WFWallis and FutunaWF – WLFWLF
EHWestern SaharaEH – ESHESH
YEYemenYE – YEMYEM
ZMZambiaZM – ZMBZMB
ZWZimbabweZW – ZWEZWE
AXÅland IslandsAX – ALAALA

 

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

4 Comments

  1. Ricard Torres May 30, 2013 2:58 pm  Reply

    Thanks for linking back to my article! Not everybody does that 😉

    • ned June 1, 2013 1:24 pm  Reply

      It was a valuable resource Ricard, I appreciate when folks do great things on the internet 🙂

  2. Jay December 10, 2013 9:22 am  Reply

    Awesome, you saved me a lot of time, very useful!

    thankyou!

    • ned December 23, 2013 1:00 pm  Reply

      Here to help Jay! 🙂

Leave a Reply

7 − 5 =