🔥 Just Launched! Werra Premium Template for HyväSee it in Action

How to Import Italian States in Magento

By Jignesh ParmarUpdated on Mar 17, 2025 2 min read

Ciao. Come stai?

Italy-based Magento 1 and Magento 2 store owners do not get the default dropdown option that contains all the states of Italy.

In online stores when forms are used, asking customers to type the name of their respective state contributes to poor user experience.

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.

To give better user experience and easing the developer’s task, importing states to display in dropdown option is the best thing to implement.

I have prepared an SQL script to import Italian states in Magento.

SQL Script to the Import Italian States in Magento

INSERT INTO `directory_country_region` (`region_id`, `country_id`, `code`, `default_name`) VALUES
   (NULL, 'IT', 'AG', 'Sicilia'),
   (NULL, 'IT', 'AL', 'Piemonte'),
   (NULL, 'IT', 'AN', 'Marche'),
   (NULL, 'IT', 'AO', 'Valle d Aosta'),
   (NULL, 'IT', 'AQ', 'Abruzzo'),
   (NULL, 'IT', 'AR', 'Toscana'),
   (NULL, 'IT', 'AP', 'Marche'),
   (NULL, 'IT', 'AT', 'Piemonte'),
   (NULL, 'IT', 'AV', 'Campania'),
   (NULL, 'IT', 'BA', 'Puglia'),
   (NULL, 'IT', 'BT', 'Punglia'),
   (NULL, 'IT', 'BL', 'Veneto'),
   (NULL, 'IT', 'PM', 'Piedmont'),
   (NULL, 'IT', 'SD', 'Sardinia'),
   (NULL, 'IT', 'SC', 'Sicily'),
   (NULL, 'IT', 'TT', 'Trentino-Alto Adige'),
   (NULL, 'IT', 'TC', 'Tuscany'),
   (NULL, 'IT', 'UM', 'Umbria'),
   (NULL, 'IT', 'VC', 'Valle d'Aosta'),
   (NULL, 'IT', 'VN', 'Veneto');
 
INSERT INTO directory_country_region_name( locale, region_id, name )
SELECT 'en_US' AS "language", region_id, default_name
FROM `directory_country_region`
WHERE country_id = 'IT'

That’s it.

Feel free to use the above script to import Italian states in Magento 1 or Magento 2 development.

Share this programmatic solution with the Italian store owners via social media.

Buona Giornata.

Thank you.

Related post: How to Import Australian States in Magento

Jignesh Parmar Full Image
Article byJignesh Parmar

An expert in his field, Jignesh is the team leader at Meetanshi and a certified Magento developer. His passion for Magento has inspired others in the team too. Apart from work, he is a cricket lover.