Magento Country codes for table rate

I was getting mad trying to figure out how to know the Magentro Country Codes.

When you want to upload a Shipping Table Rate (csv file) you need to enter those codes in your file.

Looks like they don’t give the info in a easy way. Luckily, I’ve found a dirty solution that just works.

I went to the admin section and I got the code from one of those “Specific Countries” select input.

Here’s the list, enjoy 😉

2 and 3 letter relation

Maybe the 2 letters code is not working for you.

Here you have the 3 letter code:

104 Responses to “Magento Country codes for table rate”

  1. satya sembiring June 4, 2010 at 8:31 am #

    dear.
    i need your help
    I want added more information on checkout step
    that information about container loading.
    i like to show to customer or buyer
    when they do checkout and they can see how many loading container they have.
    in this case I have to information: 1 is 20 ft container and second is 40 ft container.

    calculation container base for volume product.
    example 1 chair length 12 cm high 12, tall 12 cm; volume is LxHxt

    we make sample our customer buy 10 product..and that volume total is

    0,9 % load contariner 20ft.

    can you help how i can show that information in checkout step?

    thk before
    im satya from indonesia.

  2. satya sembiring June 5, 2010 at 6:04 am #

    thk quicoto
    thank

  3. Nicole June 16, 2010 at 1:54 pm #

    I only have three kinds of shipping rate for countries according to regions — Netherlands, Europe, and rest of the world. Is there an easy way to set up the rates without inputting so many countries? Thank you.

    • quicoto June 16, 2010 at 1:58 pm #

      Sure you can set:

      ESP,*,*,0.0000,14.9000

      And then an other rule for the rest of the world

      *,*,*,0.0000,50.0000

      Let me know if that helps 😉

  4. Nicole June 16, 2010 at 2:09 pm #

    Wow, thank you so much for the quick reply. I am a newbie of Magento. Parden me if I ask stupid questions. Does ESP refers to Europe? Really appreciate. You are very professional.

    • quicoto June 16, 2010 at 3:12 pm #

      Hi Nicole.

      “ESP” was ment for SPAIN.

      When you import a table rate (CSV file) the default format is:

      “Country”,”Region/State”,”Zip/Postal Code”,”Weight (and above)”,”Shipping Price”

      You can use * it will take all from that field.

      US,*,*,0,3.000

      That means: for USA, all States, all Zip codes, from weight 0 will cost 3.

      If you have any other questions not from table rates, feel free to post them in our Forum

      Regards.

  5. Nicole June 16, 2010 at 4:56 pm #

    It really helps. Thank you! 🙂
    Does Magento allow my customers to choose courier?
    For example, my customers from the rest of the world have two courier choices: shipping fee €25 by TNT Express, and €50 by UPS. If not, I will only go for UPS.

    • quicoto June 16, 2010 at 4:59 pm #

      Well you can test it.

      In the checkout process you can choose as many methods as you’re allowed to.

      If you have set UPS for all countries it will show it there.

      You have to set up in the “System -> Configuration -> Shipping Methods” the allowed countries 😉

      Regards

  6. Nicole June 17, 2010 at 7:01 am #

    Hi quicoto,

    It took me a while to get my csv file work. I had to use three letter country codes, also I couldn’t use Excel to open my csv and edit.

    Your suggestion for using multiple methods is great. I solved my two-courier problem by enable Flat rate, since my rate for UPS is the same for countries outside Europe. I don’t need to enable UPS XML.

    Thank you again! 🙂

    • quicoto June 17, 2010 at 8:18 am #

      So my country list didnt work? 😕

      I always edit the CSV files with a text editor, never use Excel 😉

  7. Nicole June 17, 2010 at 10:44 am #

    I tested again with two-letter country codes. It works. 😛

    I found that if the csv file was opened by Excel, it wouldn’t work anymore. Even I opened it with text editor later. It’s not the problem of country codes. Sorry for my misjudgment.

  8. Ed August 4, 2010 at 1:17 pm #

    Look under the database tables directory_country etc.

    Happy Magento’ing

    Ed
    Jabez Networks, Inc.

  9. Mark Brown September 17, 2010 at 5:25 pm #

    Hi,

    This forum seems to be a great help, however I need to set up some rates for UK, Europe and Rest of World and I’m still a little confused about how I do this within Magento and this CSV file?

    Could you help me and paste a small example, as I’m worried I might have to go through and type every country code hundreds of times?

    Thanks
    Mark

    • quicoto September 17, 2010 at 5:32 pm #

      Hi Mark,

      Do you mean for all UK / EU / World?

      It’s country based so you could add (UK):

      GB,*,*,0,3.000

      This will apply to all United Kingdom.

      If you want to apply the rest of the world:

      *,*,*,0,3.000

      And I’m afraid there is no fast way to apply all EU. I think you should list every country in EU.

      Let me know if that works.

      Regards.

      • Mark Brown September 17, 2010 at 8:24 pm #

        Hi

        Thanks for the reply, is it best to upload it as a csv from excel as I’ve heard a few people have had problems? I’m a bit new to this kind of thing so not sure the best way to do it?

        Thanks

      • quicoto September 17, 2010 at 9:51 pm #

        You can donload the generated CSV file and edit it with a text editor (notepad, Text Mate, Dreamweaver…) (Sometimes Excel breaks it, be carefull).

  10. joan October 14, 2010 at 6:04 pm #

    Hola,

    Creo que hablas español, te cuento que una persona me esta armando una tienda en magento y tenemos el problema del shipping, ya que mi pais (Peru) no tiene un modulo para este fin.
    El programador me dijo que podemos aplicar tu metodo.
    Pero aun no me queda claro como debo colocar los datos en el archivo de excel csv.
    Haber si me despejas las dudas:
    debe colocar en una columna todas las iniciales de los paises correcto?
    los de los asteriscos no me queda claro, necesito colocar los codigos zip? o solo coloco asteriscos?

    Saludos.

    • quicoto October 14, 2010 at 7:43 pm #

      Hola joan,

      Debes colocar tan solo los paises que necesites.

      Los asteriscos significa “todo”. Es decir *,*,*,0,3.000 significa que aplica a todo el mundo.

      Espero que te sirva,

      Saludos.

  11. joan October 14, 2010 at 7:53 pm #

    Muchas gracias por la respuesta.
    Para redondear la idea, quedaría así:

    US,*,*,0,3.000
    PK,*,*,0,3.000
    etc
    etc

    Una consulta adicional, en mi pais los costos de envio se definen por rangos, es decir:

    Enviar a USA: 101 a 250 gramos – costo: $10
    Enviar a USA: 251 a 500 gramos – costo: $19

    y asi varia dependiendo del continente. Explicado esto para aplicarlo en tu csv quedaría así:

    US,*,*,101-250,$10
    US,*,*,251-500,$19
    etc
    etc

    Estoy en lo correcto?

    Saludos.

    • quicoto October 14, 2010 at 8:25 pm #

      Hola joan,

      No. No debes poner simbolos. Solo números.

      La primera linea del CSV es así (y no debes romper el formato)

      “Country”,”Region/State”,”Zip/Postal Code”,”Weight (and above)”,”Shipping Price”

      Si te fijas, para poner rango de precios deberás usar varias reglas. De 0 a 5, de 5 a 10, etc…

      Un saludo.

  12. joan October 14, 2010 at 9:14 pm #

    Hola Quicoto,

    Ya me mareaste un poco.

    Cuando me dices que no debo pober simbolos te refieres que no debo poner el signo $$ correcto?
    Luego cuando me dices el rango de precios “poner varias reglas” eso no me quedo claro, me puedes explicar un poco ese tema.

    Por el momento estaria quedando asi:

    US,*,*,101-250,10
    US,*,*,251-500,19
    Estoy bien o mal?

    Muchas gracias por tu apoyo.

    Saludos.

    • quicoto October 14, 2010 at 9:18 pm #

      No puedes poner “101-250”

      Tiene que ser:

      Hasta 101 = US,*,*,101,10
      A partir de 250 = US,*,*,250,19

      También puedes ir probando de subir el archivo CSV si está mal te saldrá el aviso 🙂

      Saludos

  13. joan October 14, 2010 at 9:31 pm #

    Ok, ya me esta quedando mas claro el asunto.
    Ahora te comento para que te des una idea, mi tienda va a vender ropa, en la cual me voy a posicionar en la venta de polos o t-shirt.
    Entonces yo voy a pesar cada prenda por ejemplo la prenda de la marca “A” talla S, tiene un peso de 140 gramos.
    Como encajaria este peso dentro de los parametros que ya hemos visto:
    US,*,*,101,10 ??

    Saludos.

    • quicoto October 14, 2010 at 9:40 pm #

      En este caso, si solo tuvieras la linea:

      US,*,*,101,10

      Por el peso de 140 saldría 10.

      El peso es “peso (o superior)” quiere decir que tendría que tener una regla tipo:

      US,*,*,0.1,10

      Que aplicaría a todos los productos entre 0.1 y 101.

      Saludos.

  14. joan October 14, 2010 at 9:46 pm #

    Gracias quicoto, bueno me queda mas que nada comenzar a armar el csv con todos los paises y cada uno con sus rangos de peso, me va a llevar un buen tiempo.

    Saludos y muchas gracias por tu ayuda.

  15. lee October 10, 2011 at 9:26 am #

    hi , i am a magento owner from New Zealand . i want to set up different shipping fees according to different regions , such as Northland , Southland and so on . Could you please tell me how i can do that ? can it be finished by the table rates , or some other magento extensions must be used ? i am appreciate that you can help me . thank you very much .

  16. lee October 10, 2011 at 10:33 am #

    Thank you , Rick . but now another problem occured . It seems to be that only two letters can input in the region . for example , i want to set up the shipping fees for Auckland in New Zealand , i failed because AKL is short for Auckland ,but only two letter can be input in the region in the csv.Could you help me ?

  17. lee October 10, 2011 at 11:09 am #

    Rick , Thank you for your help . i have installed that extension before, but i can’t find the information about how to set up and use this extension .If you know something about that , i will very appreciate for your help. thank you very much !

    • Rick October 11, 2011 at 8:44 am #

      No idea mate. Perhaps you could contact the extension developer or use the documentation (if there’s any).

      Regards

  18. lee October 11, 2011 at 9:07 am #

    Thank you so much . You are so nice to help me .

    • Richard February 26, 2012 at 10:35 pm #

      Hi Lee, did you find any answer to the NZ regions? I am having the same shipping issues with the Region no accepting “Addington” or “SI” or “CAN”. It is really important for this Magento site to work on it. Any help would be appreciated.

      • Richard November 28, 2013 at 9:24 am #

        If you have the NZ region list, can you buzz me a copy to xtr671134@hotmail.com

  19. Tiago October 18, 2011 at 3:52 am #

    Thank you all guys! Just reading through your comments helped me a lot 🙂 This lack of documentation on magento website it’s a real pain in the ass..

    • Rick October 18, 2011 at 8:28 am #

      Glad it helped Tiago 😉

  20. Tim January 18, 2012 at 1:10 am #

    For international shipping –

    Is there a code for ALL countries? Can you just write ‘A?LL’ -or- do you have to list each country individually?

    • Rick January 18, 2012 at 8:35 am #

      I think you can add *

      See, this example:

      US,*,*,0.1,10

      So I guess you could add all countries.

      Regards

  21. Tim January 18, 2012 at 1:32 am #

    Another question:

    What text editor do you use to edit the csv file?

    • Rick January 18, 2012 at 8:36 am #

      You should NOT use any kind of “Microsoft Excel”.

      To avoid problems use a plain editor like textmate (mac) or notepad (windows. Not sure if it works though). Also… dreamweaver can do the trick.

      Regards

  22. Tim January 18, 2012 at 10:51 pm #

    Great thanks!

    So for an international shipment available to ALL countries, I should use this:

    *,*,*,0.1,10

    Is that correct?

    • Rick January 18, 2012 at 10:53 pm #

      Yeah, give it a try and let us know 🙂

  23. Tim January 18, 2012 at 10:56 pm #

    Thanks Rick! I appreciate you answering so promptly!

    I will certainly let you know.

    By the way – Great site! Nicely put together.. This is truly a valuable resource.

  24. Martial February 29, 2012 at 12:51 pm #

    Hi,

    I have a little problem with Magento. I want to offer the same standard shipping rate throughout the UK but anyone with a Channel Islands postcode is charged international shipping rate. How do I go about making sure this doesn’t happen?

    Thanks

    • Kate January 11, 2017 at 5:34 pm #

      Just wondering if you found a solution as I’m needing to do the samething

  25. Paul March 14, 2012 at 5:48 am #

    Hi, i have been reading this site, and think its very informative! great work guys.

    i am new to all this, so please fogive me if i ask stupid things.

    Ok, so i want to know if i can set a price for shipping per gram. 1 gram = $0.23.

    so for example: item1 = 200grams. using my csv file it will automaticly calculate that $0.23 X 200 = $46

    if had item1 (200gram) item2 (900grams) and so on, it would just add it all up…

    OR do i have to set shipping weight for EACH item weight i have listed in my website..

    Obviously hassle for Combined shipping items.

    Thanx for your help, and appologies for any stupiduty on my part!!

    • Rick March 14, 2012 at 8:17 am #

      Hi Paul,

      The only way I know is setting weight ranges.

      “Country”,”Region/State”,”Zip/Postal Code”,”Weight (and above)”,”Shipping Price”

      If you scroll up you can see a couple of examples.

      Let me know if this helps,

      Regards.

  26. Paul March 14, 2012 at 6:02 am #

    ooops forgot…!

    also wanted to have weight ranges, so anything from 1gram up to 500grams, would cost $0.13 per gram.

    and 510grams up to 700grams would cost $0.09 per grams…

    And so on…

    Please help..

  27. Dolendro March 20, 2012 at 7:11 am #

    Hi,

    My csv is working poperly, but when i added region/state i got an error. i want to put some state of my country(India). So, how should i put the name of the region/state of India.

    • Rick March 20, 2012 at 8:41 am #

      ¿Could you paste one row to check if there’s any error?

      Perhaps the region/state is not valid.

  28. Paul March 23, 2012 at 4:11 am #

    so, i have solved all this, and even now have multiple shipping options per weight.. thanx guys.

    But i now have a new, and maybe bigger problem.

    Ok, so i have paypal set up for checkouts., it calculates product price plus shipping and charges to that fact,

    BUT if i use Paypal Express checkout, it only charges the product cost, and does not add shipping…

    Anything to do about this?

  29. kervin ramen April 24, 2012 at 9:26 am #

    I made a per continent country code.

  30. Kunal Arun July 14, 2012 at 4:05 pm #

    Hi,
    I am a new user to magento, Plz Help,
    I want to upload Shipping table rates for different States of India.
    How can I do so?

    Regards

    • Rick July 14, 2012 at 4:08 pm #

      Hi there,

      You need to create a CSV file with the following structure:

      “Country”,”Region/State”,”Zip/Postal Code”,”Weight (and above)”,”Shipping Price”

      You can define the States in the second parameter.

      Example: US,*,*,101,10

      * means everything.

      Let me know if this helps,

      Cheers.

  31. siddeh July 21, 2012 at 9:21 am #

    Can You plz help, how can change the flate for canada as $30 instead of $23.25 for “Priority Mail International $23.25”

  32. Kunal Arun July 24, 2012 at 8:29 am #

    Hi Rick,
    I have tried all these options, once and separately too.
    The system does not recognize India states and Postal Codes.
    Is there any extension which I need to install for India?

    Help!

    Regards

    • Rick July 24, 2012 at 9:55 am #

      Not that I know of, sorry.

      Please let me know if you find the solution.

      Cheers.

  33. siddesh July 24, 2012 at 8:38 am #

    HI RICK,

    I dint get the solution still, i am waiting for replay..!!

    • Rick July 24, 2012 at 9:54 am #

      Hi siddesh,

      I’m afraid you’ll have to figure it out

      Please follow this structure:

      “Country”,”Region/State”,”Zip/Postal Code”,”Weight (and above)”,”Shipping Price”

      Example: US,*,*,101,10

      * means everything

  34. Kunal Arun July 24, 2012 at 10:41 am #

    Hi Rick,
    Thanks for the concern, I will surely update ASA i get any details.

    Regards

  35. Esteban December 21, 2012 at 10:14 am #

    Hola Rick una consulta fácil, puedo poner varios países juntos en una misma línea??

    BGR;CYP;SVK;SVN;EST;HUN;LVA;LTU;MLT;POL;CZE;ROU * * 100 3540
    GIB;LIE;MAR;NOR;SMR;CHE * * 0 23.02
    GIB;LIE;MAR;NOR;SMR;CHE * * 0.5 28.85
    GIB;LIE;MAR;NOR;SMR;CHE * * 1 34.82
    GIB;LIE;MAR;NOR;SMR;CHE * * 1.5 40.79
    GIB;LIE;MAR;NOR;SMR;CHE * * 2 46.76
    GIB;LIE;MAR;NOR;SMR;CHE * * 2.5 51.88
    GIB;LIE;MAR;NOR;SMR;CHE * * 3 57.01
    GIB;LIE;MAR;NOR;SMR;CHE * * 3.5 62.13
    GIB;LIE;MAR;NOR;SMR;CHE * * 4 67.25
    GIB;LIE;MAR;NOR;SMR;CHE * * 4.5 72.37
    GIB;LIE;MAR;NOR;SMR;CHE * * 5 74.66
    GIB;LIE;MAR;NOR;SMR;CHE * * 5.5 76.95
    GIB;LIE;MAR;NOR;SMR;CHE * * 6 79.24
    GIB;LIE;MAR;NOR;SMR;CHE * * 6.5 81.53

    de ser positiva la respuesta
    cual sería el símbolo que separa a los países para que no de error?
    el listado de precios es muy largo como para repetirlo país por país

    Saludos y muchísimas gracias por la colaboración

  36. Caroline January 16, 2013 at 7:44 am #

    Hi Rick,

    I am setting up table rates on a mac and I don’t have textmate. However I do have dreamweaver where I entered the parameters for my shipping. when I upload the html file into magneto i receive the message that its an invalid file format. do i have to do a further conversion of the html file back into a csv, if so how do i go about this as I can’t see this option in DW.

    Thank you

    • Rick January 16, 2013 at 9:15 am #

      Hi Caroline,

      Dreamweaver is fine, you should be able to do it.

      When you go to “File > Save As” you should see a “file type”. Select (if I’m not mistaken) the last one which is something like “All files”.

      Then just type .csv after your desired file name.

      Let me know if this helps.

  37. Caroline January 18, 2013 at 12:00 am #

    Hi Rick,

    Thanks, i managed to create the table rate and am able to save the config in magneto where before i was getting an error messages. However none of my delivery settings are showing in the shopping basket, so I cant say for sure if the system has processed my rates. I will spend some time on this and let you know of the outcome.

    Caroline

  38. leonilyn January 21, 2013 at 4:30 pm #

    hello there,

    My client want to set the shipping and handling charges at 10% of selling price. How will I do that?

  39. Will Halls January 23, 2013 at 12:17 pm #

    Hi Rick,

    I have created my cdv file (firstly in Excel Mac 2011), which allowed me to save as either:
    Comma Seperated Values (.csv)
    Windows Comma Separated (.csv)
    MS-DOS Comma Separated (.csv)

    All of which did not work.

    I then tried saving using programs such as TextEdit, TexWrangler with the following settings:
    Line Breaks:Unix (LF)
    Encoding: Unicode (UTF-8)

    Again none of these worked.
    Also, I am trying for EU shipping only. All EU contries have been added to by csv file.
    I have then tried allowing specified countries (then selected all EU Contries).

    Every time I upload and save config, nothing changes at all. All countries show from dropdown, but only GBP will work as on the previous csv file.. Its as if its not recognising anything i do.

    I have also disabled the ‘Compiler’ to see if this was effecting it, no luck.

    I just have a horrid feeling that Excel has ruined my csv file (i have tried copying and pasting all text into other programs and resaving to try and create new, no luck)

    Or could it be that something within my setup is disabling me to make any changes to the shipping methods?

    I know you have answered hundreds of questions, and i just hope im not to late!! Thanks for all your help with previous posts so far!

    Thanks again,
    Will Halls

    • Will Halls January 23, 2013 at 12:19 pm #

      Ignore the first line mistake, i meant csv but my iMac loves to auto-correct!

      *also, tried multiple browsers, refreshing index, cache etc through Magento and still no luck*

    • Rick January 23, 2013 at 12:24 pm #

      This is a tough one Will.

      If the CSV does not return any error when uploading it means the format is fine. The problem must be in the rules.

      Could you please try to add a single line such as:

      (change the values if needed)

      Then try to checkout a product to see if it works.

      Cheers.

  40. Will Halls January 23, 2013 at 12:43 pm #

    Sorry, I am not the most computer literate when it comes to codes etc.

    So make a csv file with one line as shown in your post? Upload and see if it works..
    My csv starts with this:

    Country,Region/State,Zip/Postal Code,Weight (and above),Shipping Price
    GBR,*,*,1,1.5
    GBR,*,*,2,4.41
    GBR,*,*,4,7.62
    GBR,*,*,6,10.34
    GBR,*,*,8,12.67
    GBR,*,*,15,13.61
    GBR,*,*,20,15.86
    ALB,*,*,1,36.23
    ALB,*,*,2,44.98
    ALB,*,*,4,55.43
    ALB,*,*,6,62.32

    etc etc..

    So I shall make a new csv, just with:

    Country,Region/State,Zip/Postal Code,Weight (and above),Shipping Price
    GBR,*,*,1,1.5

    and see if its works?

    Thanks for the unbelievably fast response!!

    Will

  41. Will Halls January 23, 2013 at 12:49 pm #

    Still no luck after creating a new csv with only the first few lines…

    Its as if magento is completely ignoring anything i change within the shipping area..

    Thanks,
    Will

  42. Will Halls January 23, 2013 at 1:28 pm #

    Once uploaded, no change. I still get ‘Sorry, no quotes are available for this order at this time.’

    Also, I have tried enabling and disabling all of the tick boxes next to every option, which usually are all ticked to ‘use default’. No luck.

    So, we know its not the csv now then at least!

    Any other thoughts?

    Thank you Rick, really appreciate your time!

    • Rick January 23, 2013 at 1:43 pm #

      What about the weight?

      Does your product have weight? I think it’s a mandatory field for the shipping rates to work.

      At this point I’m guessing the problem it’s some configuration.

  43. Will Halls January 23, 2013 at 1:46 pm #

    Yes all products have weights.

    The shipping on the website currently works fine for the UK, as my web designer set up.

    It just seems that anything I do, or changes i try with the shipping options, do not apply. I shall get in touch with my designer again, to see if he can shed any light on it, as he configured it. I know he played with cache management and the Compiler options to speed the website up, so i wonder if that could be something to do with it…

    Thank you for your time, and if there is anything else you can think of then i would be immensely grateful!

    Thanks,
    Will

    • Rick January 23, 2013 at 1:51 pm #

      Oh My …. 🙂

      It has to be the cache. You have to flush it every time you change something like that.

      If not, maybe your designer hardcoded something or installed an extension to override the shipping table (could be posible).

      Cheers,

  44. Will Halls January 23, 2013 at 1:57 pm #

    Configuration, Layouts and Blocks HTML output are all enabled, the rest are disabled.

    Reflushed cache, no luck.

    Whats weird is even though i set ‘specified countries’ and select them, every time i go to select a country in the front end, the entire list comes up, showing that whatever i am saving, it is not applying!

    Im starting to think that can be the only option, that he has hardcoded something into the site, blocking any updates within this area….

    Thanks again Rick.

    Will

  45. Will Halls February 11, 2013 at 2:43 pm #

    Sorted this by simply installing MatrixRates by WebShopApps (http://www.webshopapps.com/uk/matrixrate-shipping-extension.html) for anyone who was interested. Must have been an issue with the standard shipping setup on my site.

    Big thanks to Rick for all your help though buddy!

    • Rick February 11, 2013 at 10:59 pm #

      You’re welcome, thanks for posting it!

  46. imacreste March 7, 2013 at 1:55 pm #

    Hola quicoto

    Tengo un problema con el table rates que no se identificar.

    Lo configuro y me funciona, pero transcurridas unas horas (normalmente por la noche, soy d e España) se me desconfigura y ya no me calcula bien.

    Lo tengo del siguiente modo:
    De 0 a 60 -> 6€
    y a partir de 60 GRATIS.

    Lo subo y me funciona bien: 70 € gratis.

    Pero de repente,…. deja de calcular el gratis, y no se por que… si lo vuelvo a subir me lo hace bien…

  47. Richard September 3, 2013 at 12:29 pm #

    This is a geat help thanks – I would how ever only need the following;
    Ireland;
    United Kingdom;
    Europe
    Rest of world
    what would the codes be for the above?
    Regards
    Richard

  48. Peeyush September 4, 2013 at 2:46 pm #

    Hi,

    I want to use below syntax.

    Country,Region/State,Zip/Postal Code,Weight (and above),Shipping Price
    IND,*,1100*,500,199

    Would it be possible ?

    I have many zips which has starting 110001, 110002 and etc…

    Please help me …

    • Rick September 19, 2013 at 5:26 pm #

      Hi there,

      I don’t think you can use the * on a partial Zip code.

      If you make it work, please let us know 😉

  49. jmm September 20, 2013 at 8:10 am #

    Postcode ranges don’t seem to work in Magento. Is this correct? In tablerates csv I have tested to no avail:

    35*
    01000-06999
    “37999,39000”

    • Rick September 20, 2013 at 6:09 pm #

      Yep, I don’t think they work.

  50. May December 7, 2013 at 9:16 am #

    Hi,

    Is there any method to set different shipping rate for different region of China?

    • Rick December 7, 2013 at 1:19 pm #

      Sure, you just need the region codes (postal codes?) 🙂

      • May December 9, 2013 at 8:06 am #

        Thanks your help.
        I got another problem with shopping cart.
        When “edit” a product in shopping cart, I will be bring back to product page, and after I “update cart”, there is one more product in shopping cart.
        Is there a method to fix it to keep only the updated product in the cart?

      • Rick December 10, 2013 at 1:36 pm #

        As I understand the only way to edit the product quantity is from the cart itself. You shouldn’t have to redirect the user to the detail page. By doing so they will click on “add to cart” that will add a new item to the cart.

        Cheers.

  51. May December 10, 2013 at 6:46 pm #

    Got it, thanks.
    Another problem. After setup Paypal, “Unable to process payment. Please contact the merchant as the shipping address provided by the merchant is invalid, and the merchant has requested that your order must be shipped to that address.” message popup when checkout with China shipping address using Paypal payment, . Please advise how to fix it.

    • Rick December 10, 2013 at 11:24 pm #

      Perhaps you should take a look at the PayPal documentation. I’m sure they have this error registered in some FAQ so you can understand your issue.

  52. Sboudet March 20, 2014 at 4:37 pm #

    Hola Rick,

    De antemano te agradesco toda la ayuda que me puedas brindar.
    El Problema que tengo en estos momentos es que ocupo que cuando una compra sobrepase el maximo (que es de 27 kilos) de peso que enviamos el cliente vea un mensaje, (EJEMPLO: si un cliente compra un refrigerador que obviamente va a pesar mas de 27 kilos le de al cliente este mensaje (Retiro en bodega. Costos de envío no incluídos).

    Gracias

    • Rick March 20, 2014 at 4:40 pm #

      Hola,

      No parece que sea algo que puedas hacer desde el admin, ni tampoco que sea fácil. Dependiendo de en que punto del proceso de compra quieres que salga el mensaje tendrás que editar unos ficheros u otros. Además esos ficheros dependerán exclusivamente de la plantilla que uses.
      Activando los path hints (How to Turn on Magento Path Hints) te va a dar una idea de lo que tienes que tocar. Una vez ahí tendrás que intentar recuperar el peso total de la cesta (o del item) y mostrar o no un mensaje

      Antes de hacer todo esto te recomendaría que buscaras alguna extensión, igual ya existe alguna similar.

      Un saludo!

      • Sboudet March 24, 2014 at 7:51 pm #

        Hola Rick,

        Te cuento que despues de ir y venir varias veces he logrado hacer lo que te dije. Use una extencion que se llama Multiple Table Rates Extension y usando un programa que se llama CSVed que es especial para editar .csv lo haces. Lo mejor de todo es que lo haces todo desde el admin.

        Saludos desde Costa Rica.

  53. Ryan TeGantvoort August 5, 2014 at 11:29 pm #

    Hi Rick,

    Thank you for this and typically I have noticed the Country likes the 3 digit and Region/State likes 2 digit codes.

    Anyways on to my question: I am trying to set up shipping to Hong Kong since we have been shipping a lot of our product to Hong Kong recently via FedEx International Economy. So I tried setting up Hong Kong to only ship via FedEx International Economy but when I do, I get nothing. I tried using the 2 digit and 3 digit code but still nothing. I am not even receiving the error stating “No quotes are available at this time”. It just reloads the page and nothing changes.

    My take on this problem is: I have a feeling it has something to do with the way Magento has Hong Kong set up as Hong Kong SAR China. I am thinking FedEx is not recognizing this as a country and in return has no idea what to do? So I was looking for hopefully a way to change “Hong Kong SAR China” to simply “Hong Kong”? Or will this affect other things?

    Thanks in advance.

  54. harsheen July 26, 2015 at 5:44 pm #

    hi
    i wanted the region codes for countries like greece, spain and italy
    but i am unable to find it please help.

  55. Mary Johnson May 5, 2016 at 7:37 pm #

    Thanks for sharing the info and thanks for replying to everyone’s questions. I am new to Magento and I am trying to set-up my site. I feel it is going to take me a while to set-up my shipping fees for each country.

  56. Steven October 29, 2016 at 12:03 am #

    Thanks for sharing the info and thanks for replying to everyone’s questions. I am new to Magento and I am trying to set-up my site. I feel it is going to take me a while to set-up my shipping fees for each country.

    • Rick October 31, 2016 at 10:03 am #

      You’re welcome Steven!

  57. Steven October 29, 2016 at 12:04 am #

    BUT WORKS PERFECTLY !!! AND ONLY NEED 10 MINUTES !

  58. Anu November 25, 2016 at 7:26 am #

    hi,
    i need to get region/state code for dammam, riyadh and jeddah in saudi arabia.
    pls help, i’am in hurry.

Leave a Reply

Add <code> Some Code </code> by using this tags.