{"id":199,"date":"2018-10-03T12:30:49","date_gmt":"2018-10-03T12:30:49","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/2018\/10\/03\/import-australian-states-in-magento\/"},"modified":"2025-05-22T17:18:19","modified_gmt":"2025-05-22T11:48:19","slug":"import-australian-states-in-magento","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/import-australian-states-in-magento\/","title":{"rendered":"How to Import Australian States in Magento"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">From the design standpoint, drop-down is an excellent feature which helps creating cleaner layout and automatically validates the input. While working with Magento 1 or Magento 2, the best example is country and state drop down lists.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Talking about Australia, majority of the older Magento 1 and Magento 2 versions don\u2019t include states drop down list for it. Magento developers need to deal with creating a list of states while adding forms or in the backend configuration. So here, I\u2019ve come up with the SQL script to<i><strong>&nbsp;import Australian states in Magento<\/strong><\/i>&nbsp;here!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You may use the SQL script while creating shipping rules,&nbsp;setting a default state for a country, allowing customers to select shipping state in Australia while placing orders, etc. Anything related to Australian states in Magento development and the script is ready for you ?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Script to<i><strong>&nbsp;<\/strong><\/i>I<i><\/i>mport Australian States in Magento:<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">INSERT INTO `directory_country_region` (`region_id`, `country_id`, `code`, `default_name`) VALUES\n   (NULL, 'AU', 'NSW', 'New South Wales'),\n   (NULL, 'AU', 'QLD', 'Queensland'),\n   (NULL, 'AU', 'VIC', 'Victoria'),\n   (NULL, 'AU', 'WA', 'Western Australia'),\n   (NULL, 'AU', 'TAS', 'Tasmania'),\n   (NULL, 'AU', 'SA', 'South Australia'),\n   (NULL, 'AU', 'NT', 'Northern Territory'),\n   (NULL, 'AU', 'ACT', 'Australian Capital Territory')\n    ;\n \n \nINSERT INTO directory_country_region_name( locale, region_id, name )\nSELECT 'en_US' AS \"language\", region_id, default_name\nFROM `directory_country_region`\nWHERE country_id = 'AU'<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You may use the above SQL script anywhere to import Australian states in Magento 1 or Magento 2 store development ?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank you <\/p>\n","protected":false},"excerpt":{"rendered":"<p>From the design standpoint, drop-down is an excellent feature which helps creating cleaner layout and automatically validates the input. While working with Magento 1 or&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-199","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=199"}],"version-history":[{"count":2,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/199\/revisions"}],"predecessor-version":[{"id":15588,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/199\/revisions\/15588"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}