Shopware Shop: Tips for Italian countries

25.09.2017
by Meike Müller
Shopware
Banner

As a certified Shopware agency, we would like to help you take your online store to the next level with useful tips and tricks. If you need help with your Shopware online store or if you have any further questions - feel free to contact us! And now have fun with our list of American states for Shopware:

The "14" in the script below needs to be replaced with the ID of the corresponding country.
You can find the list of countries and IDs in s_core_countries

HERE IS THE INSERT FOR THE ITALIAN STATES IN ENGLISH:

 
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Abruzzo', '65', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Agrigento', 'AG', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Alessandria', 'AL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Ancona', 'AN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Aosta', 'AO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Arezzo', 'AR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Ascoli Piceno', 'AP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Asti', 'AT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Avellino', 'AV', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Bari', 'BA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Barletta-Andria-Trani', 'BT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Basilicata', '77', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Belluno', 'BL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Benevento', 'BN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Bergamo', 'BG', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Biella', 'BI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Bologna', 'BO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Bolzano', 'BZ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Brescia', 'BS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Brindisi', 'BR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Cagliari', 'CA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Calabria', '78', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Caltanissetta', 'CL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Campania', '72', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Campobasso', 'CB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Carbonia-Iglesias', 'CI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Caserta', 'CE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Catania', 'CT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Catanzaro', 'CZ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Chieti', 'CH', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Como', 'CO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Cosenza', 'CS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Cremona', 'CR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Crotone', 'KR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Cuneo', 'CN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Emilia-Romagna', '45', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Enna', 'EN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Fermo', 'FM', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Ferrara', 'FE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Firenze', 'FI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Foggia', 'FG', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Forli-Cesena', 'FC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Friuli-Venezia Giulia', '36', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Frosinone ', 'FR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Genova', 'GE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Gorizia', 'GO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Grosseto', 'GR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Imperia', 'IM', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Isernia', 'IS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'L\'Aquila', 'AQ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'La Spezia', 'SP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Latina', 'LT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Lazio', '62', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Lecce', 'LE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Lecco', 'LC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Liguria', '42', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Livorno', 'LI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Lodi', 'LO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Lombardia', '25', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Lucca', 'LU', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Macerata', 'MC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Mantova', 'MN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Marche', '57', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Massa-Carrara', 'MS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Matera', 'MT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Medio Campidano', 'VS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Messina', 'ME', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Milano', 'MI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Modena', 'MO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Molise', '67', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Monza e Brianza', 'MB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Napoli', 'NA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Novara', 'NO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Nuoro', 'NU', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Ogliastra', 'OG', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Olbia-Tempio', 'OT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Oristano', 'OR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Padova', 'PD', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Palermo', 'PA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Parma', 'PR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Pavia', 'PV', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Perugia', 'PG', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Pesaro e Urbino', 'PU', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Pescara', 'PE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Piacenza', 'PC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Piemonte', '21', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Pisa', 'PI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Pistoia', 'PT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Pordenone', 'PN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Potenza', 'PZ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Prato', 'PO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Puglia', '75', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Ragusa', 'RG', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Ravenna', 'RA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Reggio Calabria', 'RC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Reggio Emilia', 'RE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Rieti', 'RI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Rimini', 'RN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Roma', 'RM', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Rovigo', 'RO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Salerno', 'SA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Sardegna', '88', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Sassari', 'SS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Savona', 'SV', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Sicilia', '82', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Siena', 'SI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Siracusa', 'SR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Sondrio', 'SO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Taranto', 'TA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Teramo', 'TE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Terni', 'TR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Torino', 'TO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Toscana', '52', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Trapani', 'TP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Trentino-Alto Adige', '32', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Trento', 'TN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Treviso', 'TV', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Trieste', 'TS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Udine', 'UD', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Umbria', '55', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Valle d\'Aosta', '23', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Varese', 'VA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Veneto', '34', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Venezia', 'VE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Verbano-Cusio-Ossola', 'VB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Vercelli', 'VC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Verona', 'VR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Vibo Valentia', 'VV', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Vicenza', 'VI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (14, 'Viterbo', 'VT', 0, 1);



Payment methods for orders abroad

Many online stores not only offer shipping within Germany, but also to other countries . If you would also like to offer this in your store, select the availability of payment methods for the individual countries via the country selection. In the checkbox that appears there, select the country to be supplied. If the appropriate country is missing, you can add it in the country settings. You can enter country-specific surcharges in the country surcharge section for the countries you previously specified in the country selection.

If you have any questions about creating an online store with Shopware, please feel free to contact us as always. Take a look at our other tips & tricks on the topic of online stores and e-commerce!

 

Was ist dein Projekt? Wenn du uns darüber erzählen möchtest, rufen wir dich zurück!

 
Meike
Meike
from 25.09.2017

Hello, my name is Meike. I take care of the EXWE back office and am responsible for our social media channels. All of our articles are meant to make your life easier and help you make decisions. Nevertheless, it can happen that something remains unclear, so: If you have questions about this article you can easily reach me at +49 231 93149827.

Du möchtest immer am Zenit der Technik bleiben? Keine News und Blogbeiträge mehr verpassen.
We also have the following interesting posts from our tech blog for you on this topic
Shopware: An SQL query for PayPal relevant states

Use our Shopware tip on the topic: Shopware - All mandatory states for PayPal in one SQL. Use the SQL query in the article.

How to create invoice corrections for Shopware 5 without overwriting!

Our tip for Shopware invoices: Create an invoice correction without overwriting! Optimize processes in your online store quickly and easily.

This has changed in Shopware 6 since the last update!

Find out about the improvements and new features from Shopware 6.0 to Shopware 6.4.1.0 and stay up to date on the topic of online store creation.