Shopware Tips and Tricks - All states that are mandatory for PayPal in one SQL
SHOPWARE THROWS ERRORS FOR THE FOLLOWING COUNTRIES AS SOON AS NO INFORMATION ABOUT THE STATE OR STATE MADE.
USA, Japan, Argentina, Brazil, Canada, India, Italy, Mexico, Thailand
We have this SQL Querry for you, which contains all relevant states that are mandatory for PayPal. Important: You still have to adapt the countryID to your own IDs from the s_core_countries. Depending on how you inserted them at the time, they can vary.
With us, for example, the USA has the 28th Germany has the 2:
id;countryname
2;Deutschland
14;Italien
16;Kanada
28;USA
36;Brasilien
51;Argentinien
112;Indien
159;Mexiko
228;Thailand
PLEASE ALSO NOTE THAT YOU ALSO ACTIVATED THE STATES FOR THE STATE AND MARKED IT AS A MANDATORY FIELD..
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Baden-Württemberg', 'BW', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Bayern', 'BY', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Berlin', 'BE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Brandenburg', 'BB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Bremen', 'HB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Hamburg', 'HH', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Hessen', 'HE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Mecklenburg-Vorpommern', 'MV', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Niedersachsen', 'NI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Nordrhein-Westfalen', 'NW', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Rheinland-Pfalz', 'RP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Saarland', 'SL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Sachsen', 'SN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Sachsen-Anhalt', 'ST', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Schleswig-Holstein', 'SH', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (2, 'Thüringen', 'TH', 0, 1);
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);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Aichi', '23', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Akita', '05', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Aomori', '02', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Chiba', '12', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Ehime', '38', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Fukui', '18', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Fukuoka', '40', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Fukushima', '07', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Gifu', '21', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Gunma', '10', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Hiroshima', '34', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Hokkaido', '01', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Hyogo', '28', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Ibaraki', '08', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Ishikawa', '17', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Iwate', '03', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Kagawa', '37', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Kagoshima', '46', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Kanagawa', '14', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Kochi', '39', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Kumamoto', '43', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Kyoto', '26', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Mie', '24', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Miyagi', '04', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Miyazaki', '45', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Nagano', '20', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Nagasaki', '42', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Nara', '29', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Niigata', '15', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Oita', '44', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Okayama', '33', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Okinawa', '47', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Osaka', '27', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Saga', '41', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Saitama', '11', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Shiga', '25', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Shimane', '32', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Shizuoka', '22', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Tochigi', '09', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Tokushima', '36', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Tokyo', '13', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Tottori', '31', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Toyama', '16', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Wakayama', '30', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Yamagata', '06', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Yamaguchi', '35', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (15, 'Yamanashi', '19', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'Alberta', 'AB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'British Columbia', 'BC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'Manitoba', 'MB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'New Brunswick', 'NB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'Newfoundland and Labrador', 'NL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'Northwest Territories', 'NT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'Nova Scotia', 'NS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'Nunavut', 'NU', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'Ontario', 'ON', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'Prince Edward Island', 'PE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'Quebec', 'QC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'Saskatchewan', 'SK', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (16, 'Yukon Territory', 'YT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Alabama', 'AL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Alaska', 'AK', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Arizona', 'AZ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Arkansas', 'AR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Colorado', 'CO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Connecticut', 'CT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Delaware', 'DE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'District of Columbia', 'DC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Florida', 'FL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Georgia', 'GA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Hawaii', 'HI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Idaho', 'ID', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Illinois', 'IL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Indiana', 'IN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Iowa', 'IA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Kalifornien', 'CA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Kansas', 'KS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Kentucky', 'KY', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Louisiana', 'LA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Maine', 'ME', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Maryland', 'MD', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Massachusetts', 'MA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Michigan', 'MI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Minnesota', 'MN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Mississippi', 'MS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Missouri', 'MO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Montana', 'MT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Nebraska', 'NE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Nevada', 'NV', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'New Hampshire', 'NH', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'New Jersey', 'NJ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'New Mexico', 'NM', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'New York', 'NY', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'North Carolina', 'NC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'North Dakota', 'ND', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Ohio', 'OH', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Oklahoma', 'OK', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Oregon', 'OR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Pennsylvania', 'PA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Rhode Island', 'RI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'South Carolina', 'SC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'South Dakota', 'SD', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Tennessee', 'TN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Texas', 'TX', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Utah', 'UT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Vermont', 'VT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Virginia', 'VA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Washington', 'WA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'West Virginia', 'WV', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Wisconsin', 'WI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (28, 'Wyoming', 'WY', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Acre', 'AC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Alagoas', 'AL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Amapá', 'AP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Amazonas', 'AM', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Bahia', 'BA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Ceará', 'CE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Distrito Federal', 'DF', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Espírito Santo', 'ES', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Goiás', 'GO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Maranhão', 'MA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Mato Grosso', 'MT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Mato Grosso do Sul', 'MS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Minas Gerais', 'MG', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Pará', 'PA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Paraíba', 'PB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Paraná', 'PR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Pernambuco', 'PE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Piauí', 'PI', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Rio de Janeiro', 'RJ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Rio Grande do Norte', 'RN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Rio Grande do Sul', 'RS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Rondônia', 'RO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Roraima', 'RR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Santa Catarina', 'SC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'São Paulo', 'SP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Sergipe', 'SE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (36, 'Tocantins', 'TO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Catamarca', 'K', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Chaco', 'H', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Chubut', 'U', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Ciudad Autónoma de Buenos Aires', 'C', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Córdoba', 'X', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Corrientes', 'W', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Entre Ríos', 'E', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Formosa', 'P', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Jujuy', 'Y', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'La Pampa', 'L', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'La Rioja', 'F', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Mendoza', 'M', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Misiones', 'N', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Neuquén', 'Q', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Río Negro', 'R', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Salta', 'A', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'San Juan', 'J', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'San Luis', 'D', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Santa Cruz', 'Z', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Santa Fe', 'S', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Santiago del Estero', 'G', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Tierra del Fuego', 'V', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (51, 'Tucumán', 'T', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Andaman and Nicobar Islands', 'AN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Andhra Pradesh', 'AP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Arunachal Pradesh', 'AR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Assam', 'AS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Bihar', 'BR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Chandigarh', 'CH', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Chhattisgarh', 'CT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Dadra and Nagar Haveli', 'DN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Daman and Diu', 'DD', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Delhi', 'DL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Goa', 'GA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Gujarat', 'GJ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Haryana', 'HR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Himachal Pradesh', 'HP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Jammu and Kashmir', 'JK', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Jharkhand', 'JH', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Karnataka', 'KA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Kerala', 'KL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Lakshadweep', 'LD', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Madhya Pradesh', 'MP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Maharashtra', 'MH', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Manipur', 'MN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Meghalaya', 'ML', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Mizoram', 'MZ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Nagaland', 'NL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Orissa', 'OR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Pondicherry', 'PY', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Punjab', 'PB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Rajasthan', 'RJ', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Sikkim', 'SK', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Tamil Nadu', 'TN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Tripura', 'TR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Uttar Pradesh', 'UP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'Uttaranchal', 'UT', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (112, 'West Bengal', 'WB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Aguascalientes', 'AGU', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Baja California', 'BCN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Baja California Sur', 'BCS', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Campeche', 'CAM', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Chiapas', 'CHP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Chihuahua', 'CHH', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Coahuila', 'COA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Colima', 'COL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Distrito Federal', 'DIF', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Durango', 'DUR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Guanajuato', 'GUA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Guerrero', 'GRO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Hidalgo', 'HID', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Jalisco', 'JAL', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'México', 'MEX', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Michoacán', 'MIC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Morelos', 'MOR', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Nayarit', 'NAY', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Nuevo León', 'NLE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Oaxaca', 'OAX', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Puebla', 'PUE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Querétaro', 'QUE', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Quintana Roo', 'ROO', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'San Luis Potosí', 'SLP', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Sinaloa', 'SIN', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Sonora', 'SON', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Tabasco', 'TAB', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Tamaulipas', 'TAM', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Tlaxcala', 'TLA', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Veracruz', 'VER', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Yucatán', 'YUC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (159, 'Zacatecas', 'ZAC', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Amnat Charoen', '37', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Ang Thong', '15', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Buri Ram', '31', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Chachoengsao', '24', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Chai Nat', '18', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Chaiyaphum', '36', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Chanthaburi', '22', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Chiang Mai', '50', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Chiang Rai', '57', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Chon Buri', '20', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Chumphon', '86', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Kalasin', '46', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Kamphaeng Phet', '62', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Kanchanaburi', '71', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Khon Kaen', '40', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Krabi', '81', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Krung Thep Maha Nakhon [Bangkok]', '10', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Lampang', '52', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Lamphun', '51', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Loei', '42', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Lop Buri', '16', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Mae Hong Son', '58', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Maha Sarakham', '44', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Mukdahan', '49', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Nakhon Nayok', '26', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Nakhon Pathom', '73', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Nakhon Phanom', '48', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Nakhon Ratchasima', '30', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Nakhon Sawan', '60', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Nakhon Si Thammarat', '80', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Nan', '55', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Narathiwat', '96', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Nong Bua Lam Phu', '39', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Nong Khai', '43', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Nonthaburi', '12', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Pathum Thani', '13', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Pattani', '94', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Phangnga', '82', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Phatthalung', '93', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Phatthaya', 'S', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Phayao', '56', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Phetchabun', '67', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Phetchaburi', '76', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Phichit', '66', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Phitsanulok', '65', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Phra Nakhon Si Ayutthaya', '14', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Phrae', '54', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Phuket', '83', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Prachin Buri', '25', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Prachuap Khiri Khan', '77', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Ranong', '85', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Ratchaburi', '70', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Rayong', '21', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Roi Et', '45', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Sa Kaeo', '27', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Sakon Nakhon', '47', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Samut Prakan', '11', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Samut Sakhon', '74', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Samut Songkhram', '75', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Saraburi', '19', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Satun', '91', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Si Sa Ket', '33', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Sing Buri', '17', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Songkhla', '90', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Sukhothai', '64', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Suphan Buri', '72', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Surat Thani', '84', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Surin', '32', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Tak', '63', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Trang', '92', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Trat', '23', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Ubon Ratchathani', '34', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Udon Thani', '41', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Uthai Thani', '61', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Uttaradit', '53', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Yala', '95', 0, 1);
INSERT INTO `s_core_countries_states` (`countryID`, `name`, `shortcode`, `position`, `active`) VALUES (228, 'Yasothon', '35', 0, 1);
The PayPal plugin
Shopware offers a plugin to offer your customers the PayPal payment method. In addition to direct online payment (express checkout), PayPal offers installment payment or purchase on account (payment after 14 days). As usual with Shopware, the installation takes place via the plugin manager in the backend of your online shop As always, if you have any questions, please contact info@exwe.de.
Meike
from 29.11.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.
We also have the following interesting posts from our tech blog for you on this topic
The Shopware 6 Interfaces Guide
Shopware Interfaces: The perfect link to your online store Meta Description: What are Shopware 6 interfaces and what can they be used for? In this article you will get all the information about Shopware interfaces.
New Shopware Flow Builder for automated business processes
With the new Shopware release comes a new feature: the Flow Builder. We'll show you what it's for and how you can use it in your online store.
Correct currency & tax rates: Shopware Japanese States
The Shopware insert for the Japanese States - Use our tips and tricks about Shopware and optimize your online store now!
