News anzeigen (16)   News-Kategorien anzeigen



Shopware USA bzw. amerikanische Staaten


Die "28" im nachfolgenden Skript muss durch die ID des entsprechenden Landes ausgetauscht werden.
Die Liste mit den Ländern und den ID's findet Ihr in s_core_countries
Hier der Insert für die USA bzw. amerikanischen Bundesstaaten auf Englisch:

INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Alabama','AL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Alaska','AK',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Arizona','AZ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Arkansas','AR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Colorado','CO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Connecticut','CT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Delaware','DE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'District of Columbia','DC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Florida','FL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Georgia','GA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Hawaii','HI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Idaho','ID',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Illinois','IL',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Indiana','IN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Iowa','IA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Kalifornien','CA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Kansas','KS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Kentucky','KY',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Louisiana','LA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Maine','ME',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Maryland','MD',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Massachusetts','MA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Michigan','MI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Minnesota','MN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Mississippi','MS',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Missouri','MO',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Montana','MT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Nebraska','NE',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Nevada','NV',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'New Hampshire','NH',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'New Jersey','NJ',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'New Mexico','NM',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'New York','NY',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'North Carolina','NC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'North Dakota','ND',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Ohio','OH',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Oklahoma','OK',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Oregon','OR',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Pennsylvania','PA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Rhode Island','RI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'South Carolina','SC',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'South Dakota','SD',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Tennessee','TN',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Texas','TX',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Utah','UT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Vermont','VT',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Virginia','VA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Washington','WA',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'West Virginia','WV',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Wisconsin','WI',0,1);
INSERTINTO`s_core_countries_states`(`countryID`,`name`,`shortcode`,`position`,`active`)VALUES(28,'Wyoming','WY',0,1);

vom 29.11.17 um 12:33




"
Schreibe EXWE auf WhatsApp