2

i need to get the region/state code for Riyadh, Dammam, Jeddah. or get me the zip/postal code range for the same cities. pls help me. Thanks.

2
  • Hi, welcome to magento. what do you want to know? tell clearly. for ex: if you want to code for delhi, add 110002 like this. you mean this right? Nov 25 '16 at 8:38
  • i need the region/state code for these cities in saudi arabia. my purpose is to fill the tablerate.csv file in magento2. i searched in the net, bt never got the answer. can u help me? thank you
    – Anu
    Nov 25 '16 at 8:41
4

You can get the state/region code from directory_country_region table in database.

11
  • i need the region/state code to enter into the tablerate.csv file.when i enter JED,RUH,DMM in these fields it shows error. actually i need to set different prices for these cities in the country saudi arabia.
    – Anu
    Nov 25 '16 at 8:25
  • in my database i checked for these cities, bt never got an answer.i'm new to magento ,so plz forgive me if i'm asking silly questions. thank you
    – Anu
    Nov 25 '16 at 9:10
  • Anu you need to add the states in the database first, here is the query you can run on your database to add indian states reference: magento.stackexchange.com/questions/34259/how-add-indian-state Nov 25 '16 at 9:15
  • 1
    thankz nitin. i have one doubt, from where i get the state codes for saudi arabia. is there is any standard codes for those cities. or can i insert into db according to my wish?
    – Anu
    Nov 25 '16 at 9:26
  • 1
    You can add it according to you. Nov 25 '16 at 9:28

Not the answer you're looking for? Browse other questions tagged or ask your own question.