1

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.

closed as unclear what you're asking by 7ochem, Murtuza Zabuawala, Khoa TruongDinh, Marius Nov 26 '16 at 21:31

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 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? – Teja Bhagavan Kollepara 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
3

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

  • 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 – Nitin Pawar 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. – Nitin Pawar Nov 25 '16 at 9:28

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