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.
Was ist dein Projekt? Wenn du uns darüber erzählen möchtest, rufen wir dich zurück!
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.
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
Set up Google target for Shopware
How you can set up target plans for your online store with Google Analytics and how you can connect Google Analytics with Shopware, you can find out here.
The best Shopware 5 and 6 plugins for your online store!
Optimize your Shopware online store - Use the five best webshop plugins 2021 for inventory management systems, customer service or personalized products.
Shopware Download / Attachment Fix after Update
Linked downloads are no longer displayed? Here you will find the problem solving attachment fix that will make your downloads visible again.
