{"id":1317,"date":"2020-10-25T11:08:08","date_gmt":"2020-10-25T11:08:08","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/2020\/10\/25\/import-italian-states-in-magento\/"},"modified":"2025-07-17T10:25:27","modified_gmt":"2025-07-17T04:55:27","slug":"import-italian-states-in-magento","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/import-italian-states-in-magento\/","title":{"rendered":"How to Import Italian States in Magento"},"content":{"rendered":"\n<p class=\"has-text-align-center wp-block-paragraph\"><em>Ciao. Come stai?<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Italy-based Magento 1 and\u00a0Magento 2\u00a0store owners do not get the default dropdown option that contains all the states of Italy.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In online stores when forms are used, asking customers to type the name of their respective state contributes to poor user experience.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On the other hand, if the developers have to write code for each registration form and include dropdown list, it is a time-consuming and tedious task.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To give better user experience and easing the developer\u2019s task, importing states to display in dropdown option is the best thing to implement.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I have prepared an SQL script to&nbsp;<strong>import Italian states in Magento<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Script to the Import Italian States in Magento<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" 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, 'IT', 'AG', 'Sicilia'),\n   (NULL, 'IT', 'AL', 'Piemonte'),\n   (NULL, 'IT', 'AN', 'Marche'),\n   (NULL, 'IT', 'AO', 'Valle d Aosta'),\n   (NULL, 'IT', 'AQ', 'Abruzzo'),\n   (NULL, 'IT', 'AR', 'Toscana'),\n   (NULL, 'IT', 'AP', 'Marche'),\n   (NULL, 'IT', 'AT', 'Piemonte'),\n   (NULL, 'IT', 'AV', 'Campania'),\n   (NULL, 'IT', 'BA', 'Puglia'),\n   (NULL, 'IT', 'BT', 'Punglia'),\n   (NULL, 'IT', 'BL', 'Veneto'),\n   (NULL, 'IT', 'PM', 'Piedmont'),\n   (NULL, 'IT', 'SD', 'Sardinia'),\n   (NULL, 'IT', 'SC', 'Sicily'),\n   (NULL, 'IT', 'TT', 'Trentino-Alto Adige'),\n   (NULL, 'IT', 'TC', 'Tuscany'),\n   (NULL, 'IT', 'UM', 'Umbria'),\n   (NULL, 'IT', 'VC', 'Valle d'Aosta'),\n   (NULL, 'IT', 'VN', 'Veneto');\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 = 'IT'<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">That\u2019s it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Feel free to use the above script to import Italian states in Magento 1 or Magento 2 development.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Share this programmatic solution with the Italian store owners via social media.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Buona Giornata.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank you.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Related post:&nbsp;<a href=\"https:\/\/meetanshi.com\/blog\/import-australian-states-in-magento\/\">How to Import Australian States in Magento<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ciao. Come stai? Italy-based Magento 1 and\u00a0Magento 2\u00a0store owners do not get the default dropdown option that contains all the states of Italy. In online&#8230;<\/p>\n","protected":false},"author":13,"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-1317","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1317","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\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=1317"}],"version-history":[{"count":1,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1317\/revisions"}],"predecessor-version":[{"id":4663,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1317\/revisions\/4663"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=1317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=1317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=1317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}