News anzeigen (17)   News-Kategorien anzeigen



Shopware Japanische Staaten


Die "15" 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 Japanischen Bundesstaaten auf Englisch:

INSERT INTO `s_core_countries_states` VALUES
(NULL, 15, "Hokkaido","01",0,1),
(NULL, 15, "Aomori","02",0,1),
(NULL, 15, "Iwate","03",0,1),
(NULL, 15, "Miyagi","04",0,1),
(NULL, 15, "Akita","05",0,1),
(NULL, 15, "Yamagata","06",0,1),
(NULL, 15, "Fukushima","07",0,1),
(NULL, 15, "Ibaraki","08",0,1),
(NULL, 15, "Tochigi","09",0,1),
(NULL, 15, "Gunma","10",0,1),
(NULL, 15, "Saitama","11",0,1),
(NULL, 15, "Chiba","12",0,1),
(NULL, 15, "Tokyo","13",0,1),
(NULL, 15, "Kanagawa","14",0,1),
(NULL, 15, "Niigata","15",0,1),
(NULL, 15, "Toyama","16",0,1),
(NULL, 15, "Ishikawa","17",0,1),
(NULL, 15, "Fukui","18",0,1),
(NULL, 15, "Yamanashi","19",0,1),
(NULL, 15, "Nagano","20",0,1),
(NULL, 15, "Gifu","21",0,1),
(NULL, 15, "Shizuoka","22",0,1),
(NULL, 15, "Aichi","23",0,1),
(NULL, 15, "Mie","24",0,1),
(NULL, 15, "Shiga","25",0,1),
(NULL, 15, "Kyoto","26",0,1),
(NULL, 15, "Osaka","27",0,1),
(NULL, 15, "Hyogo","28",0,1),
(NULL, 15, "Nara","29",0,1),
(NULL, 15, "Wakayama","30",0,1),
(NULL, 15, "Tottori","31",0,1),
(NULL, 15, "Shimane","32",0,1),
(NULL, 15, "Okayama","33",0,1),
(NULL, 15, "Hiroshima","34",0,1),
(NULL, 15, "Yamaguchi","35",0,1),
(NULL, 15, "Tokushima","36",0,1),
(NULL, 15, "Kagawa","37",0,1),
(NULL, 15, "Ehime","38",0,1),
(NULL, 15, "Kochi","39",0,1),
(NULL, 15, "Fukuoka","40",0,1),
(NULL, 15, "Saga","41",0,1),
(NULL, 15, "Nagasaki","42",0,1),
(NULL, 15, "Kumamoto","43",0,1),
(NULL, 15, "Oita","44",0,1),
(NULL, 15, "Miyazaki","45",0,1),
(NULL, 15, "Kagoshima","46",0,1),
(NULL, 15, "Okinawa","47",0,1);

vom 29.11.17 um 12:33




Schreibe EXWE auf WhatsApp