Oscommerce : pays en français

OScommerce est un script e-commerce opensource et gratuit. Il est très répandu parmis les solutions e-commerce.
Bien que de nombreuses fonctionnalités sont présentes sur la versions de base, il est necessaire de procéder à quelques retouches pour avoir une version utilisable pour la France.

En effet la liste des pays présente par défaut est en anglais. Voici un moyen de modifier les noms de pays sans avoir à les changer manuellement par l'interface d'administration.

Il faut avoir un acces dans la base de donnée par phpmyadmin ( par exemple ).
Puis
cliquez sur slq et copier le code suivant :*

DROP TABLE IF EXISTS `countries`;

CREATE TABLE `countries` (

`countries_id` int(11) NOT NULL auto_increment,

`countries_name` varchar(64) NOT NULL default '',

`countries_iso_code_2` char(2) NOT NULL default '',

`countries_iso_code_3` char(3) NOT NULL default '',

`address_format_id` int(11) NOT NULL default '0',

PRIMARY KEY (`countries_id`),

KEY `IDX_COUNTRIES_NAME` (`countries_name`)

) TYPE=MyISAM;



INSERT INTO `countries` VALUES (1,'Afghanistan','AF','AFG',1);

INSERT INTO `countries` VALUES (2,'Albanie','AL','ALB',1);

INSERT INTO `countries` VALUES (3,'Algérie','DZ','DZA',1);

INSERT INTO `countries` VALUES (4,'Samoa américaines','AS','ASM',1);

INSERT INTO `countries` VALUES (5,'Andorre','AD','AND',1);

INSERT INTO `countries` VALUES (6,'Angola','AO','AGO',1);

INSERT INTO `countries` VALUES (7,'Anguilla','AI','AIA',1);

INSERT INTO `countries` VALUES (8,'Antarctique','AQ','ATA',1);

INSERT INTO `countries` VALUES (9,'Antigua-et-Barbuda','AG','ATG',1);

INSERT INTO `countries` VALUES (10,'Argentine','AR','ARG',1);

INSERT INTO `countries` VALUES (11,'Arménie','AM','ARM',1);

INSERT INTO `countries` VALUES (12,'Aruba','AW','ABW',1);

INSERT INTO `countries` VALUES (13,'Australie','AU','AUS',1);

INSERT INTO `countries` VALUES (14,'Autriche','AT','AUT',5);

INSERT INTO `countries` VALUES (15,'Azerbaïdjan','AZ','AZE',1);

INSERT INTO `countries` VALUES (16,'Bahamas','BS','BHS',1);

INSERT INTO `countries` VALUES (17,'Bahreïn','BH','BHR',1);

INSERT INTO `countries` VALUES (18,'Bangladesh','BD','BGD',1);

INSERT INTO `countries` VALUES (19,'Barbade','BB','BRB',1);

INSERT INTO `countries` VALUES (20,'Belarus','BY','BLR',1);

INSERT INTO `countries` VALUES (21,'Belgique','BE','BEL',1);

INSERT INTO `countries` VALUES (22,'Belize','BZ','BLZ',1);

INSERT INTO `countries` VALUES (23,'Bénin','BJ','BEN',1);

INSERT INTO `countries` VALUES (24,'Bermudes','BM','BMU',1);

INSERT INTO `countries` VALUES (25,'Bhoutan','BT','BTN',1);

INSERT INTO `countries` VALUES (26,'Bolivie','BO','BOL',1);

INSERT INTO `countries` VALUES (27,'Bosnie-Herzégovine','BA','BIH',1);

INSERT INTO `countries` VALUES (28,'Botswana','BW','BWA',1);

INSERT INTO `countries` VALUES (29,'BouvetIsland','BV','BVT',1);

INSERT INTO `countries` VALUES (30,'Brésil','BR','BRA',1);

INSERT INTO `countries` VALUES (31,'Territoire Britannique D\'Océan Indien','IO','IOT',1);

INSERT INTO `countries` VALUES (32,'Brunei','BN','BRN',1);

INSERT INTO `countries` VALUES (33,'Bulgarie','BG','BGR',1);

INSERT INTO `countries` VALUES (34,'Burkina Faso','BF','BFA',1);

INSERT INTO `countries` VALUES (35,'Burundi','BI','BDI',1);

INSERT INTO `countries` VALUES (36,'Cambodge','KH','KHM',1);

INSERT INTO `countries` VALUES (37,'Cameroun','CM','CMR',1);

INSERT INTO `countries` VALUES (38,'Canada','CA','CAN',1);

INSERT INTO `countries` VALUES (39,'Cap-Vert','CV','CPV',1);

INSERT INTO `countries` VALUES (40,'CaymanIslands','KY','CYM',1);

INSERT INTO `countries` VALUES (41,'République centrafricaine','CF','CAF',1);

INSERT INTO `countries` VALUES (42,'Tchad','TD','TCD',1);

INSERT INTO `countries` VALUES (43,'Chili','CL','CHL',1);

INSERT INTO `countries` VALUES (44,'Chine','CN','CHN',1);

INSERT INTO `countries` VALUES (45,'ChristmasIsland','CX','CXR',1);

INSERT INTO `countries` VALUES (46,'Cocos(Keeling)Islands','CC','CCK',1);

INSERT INTO `countries` VALUES (47,'Colombie','CO','COL',1);

INSERT INTO `countries` VALUES (48,'Comores','KM','COM',1);

INSERT INTO `countries` VALUES (49,'Congo','CG','COG',1);

INSERT INTO `countries` VALUES (50,'Cook (les Îles)','CK','COK',1);

INSERT INTO `countries` VALUES (51,'Costa Rica','CR','CRI',1);

INSERT INTO `countries` VALUES (52,'Cote D\'Ivoire','CI','CIV',1);

INSERT INTO `countries` VALUES (53,'Croatie','HR','HRV',1);

INSERT INTO `countries` VALUES (54,'Cuba','CU','CUB',1);

INSERT INTO `countries` VALUES (55,'Chypre','CY','CYP',1);

INSERT INTO `countries` VALUES (56,'République tchèque','CZ','CZE',1);

INSERT INTO `countries` VALUES (57,'Danemark','DK','DNK',1);

INSERT INTO `countries` VALUES (58,'Djibouti','DJ','DJI',1);

INSERT INTO `countries` VALUES (59,'Dominique','DM','DMA',1);

INSERT INTO `countries` VALUES (60,'République Dominicaine','DO','DOM',1);

INSERT INTO `countries` VALUES (61,'Timor Est','TP','TMP',1);

INSERT INTO `countries` VALUES (62,'Equateur','EC','ECU',1);

INSERT INTO `countries` VALUES (63,'Egypte','EG','EGY',1);

INSERT INTO `countries` VALUES (64,'Salvador','SV','SLV',1);

INSERT INTO `countries` VALUES (65,'Guinée équatoriale','GQ','GNQ',1);

INSERT INTO `countries` VALUES (66,'Erythrée','ER','ERI',1);

INSERT INTO `countries` VALUES (67,'Estonie','EE','EST',1);

INSERT INTO `countries` VALUES (68,'Ethiopie','ET','ETH',1);

INSERT INTO `countries` VALUES (69,'Malouines','FK','FLK',1);

INSERT INTO `countries` VALUES (70,'Îles De Faroe','FO','FRO',1);

INSERT INTO `countries` VALUES (71,'Fidji','FJ','FJI',1);

INSERT INTO `countries` VALUES (72,'Finlande','FI','FIN',1);

INSERT INTO `countries` VALUES (73,'France','FR','FRA',5);

INSERT INTO `countries` VALUES (74,'France Métropolitan','FX','FXX',1);

INSERT INTO `countries` VALUES (75,'Guyane','GF','GUF',1);

INSERT INTO `countries` VALUES (76,'Polynésie','PF','PYF',1);

INSERT INTO `countries` VALUES (77,'Territoires Méridionaux','TF','ATF',1);

INSERT INTO `countries` VALUES (78,'Gabon','GA','GAB',1);

INSERT INTO `countries` VALUES (79,'Gambie','GM','GMB',1);

INSERT INTO `countries` VALUES (80,'Géorgie','GE','GEO',1);

INSERT INTO `countries` VALUES (81,'Allemagne','DE','DEU',5);

INSERT INTO `countries` VALUES (82,'Ghana','GH','GHA',1);

INSERT INTO `countries` VALUES (83,'Gibraltar','GI','GIB',1);

INSERT INTO `countries` VALUES (84,'Grèce','GR','GRC',1);

INSERT INTO `countries` VALUES (85,'Groenland','GL','GRL',1);

INSERT INTO `countries` VALUES (86,'Grenade','GD','GRD',1);

INSERT INTO `countries` VALUES (87,'Guadeloupe','GP','GLP',1);

INSERT INTO `countries` VALUES (88,'Guam','GU','GUM',1);

INSERT INTO `countries` VALUES (89,'Guatemala','GT','GTM',1);

INSERT INTO `countries` VALUES (90,'Guinée','GN','GIN',1);

INSERT INTO `countries` VALUES (91,'Guinée-Bissao','GW','GNB',1);

INSERT INTO `countries` VALUES (92,'Guyana','GY','GUY',1);

INSERT INTO `countries` VALUES (93,'Haïti','HT','HTI',1);

INSERT INTO `countries` VALUES (94,'Îles De Heardand McDonald','HM','HMD',1);

INSERT INTO `countries` VALUES (95,'Honduras','HN','HND',1);

INSERT INTO `countries` VALUES (96,'Hong Kong','HK','HKG',1);

INSERT INTO `countries` VALUES (97,'Hongrie','HU','HUN',1);

INSERT INTO `countries` VALUES (98,'Islande','IS','ISL',1);

INSERT INTO `countries` VALUES (99,'Inde','IN','IND',1);

INSERT INTO `countries` VALUES (100,'Indonésie','ID','IDN',1);

INSERT INTO `countries` VALUES (101,'Iran','IR','IRN',1);

INSERT INTO `countries` VALUES (102,'Iraq','IQ','IRQ',1);

INSERT INTO `countries` VALUES (103,'Irlande','IE','IRL',1);

INSERT INTO `countries` VALUES (104,'Israël','IL','ISR',1);

INSERT INTO `countries` VALUES (105,'Italie','IT','ITA',1);

INSERT INTO `countries` VALUES (106,'Jamaïque','JM','JAM',1);

INSERT INTO `countries` VALUES (107,'Japon','JP','JPN',1);

INSERT INTO `countries` VALUES (108,'Jordanie','JO','JOR',1);

INSERT INTO `countries` VALUES (109,'Kazakhstan','KZ','KAZ',1);

INSERT INTO `countries` VALUES (110,'Kenya','KE','KEN',1);

INSERT INTO `countries` VALUES (111,'Kiribati','KI','KIR',1);

INSERT INTO `countries` VALUES (112,'Corée du Nord','KP','PRK',1);

INSERT INTO `countries` VALUES (113,'Corée du Sud','KR','KOR',1);

INSERT INTO `countries` VALUES (114,'Koweït','KW','KWT',1);

INSERT INTO `countries` VALUES (115,'Kirghizistan','KG','KGZ',1);

INSERT INTO `countries` VALUES (116,'Laos','LA','LAO',1);

INSERT INTO `countries` VALUES (117,'Lettonie','LV','LVA',1);

INSERT INTO `countries` VALUES (118,'Liban','LB','LBN',1);

INSERT INTO `countries` VALUES (119,'Lesotho','LS','LSO',1);

INSERT INTO `countries` VALUES (120,'Libéria','LR','LBR',1);

INSERT INTO `countries` VALUES (121,'Libye','LY','LBY',1);

INSERT INTO `countries` VALUES (122,'Liechtenstein','LI','LIE',1);

INSERT INTO `countries` VALUES (123,'Lituanie','LT','LTU',1);

INSERT INTO `countries` VALUES (124,'Luxembourg','LU','LUX',1);

INSERT INTO `countries` VALUES (125,'Macau','MO','MAC',1);

INSERT INTO `countries` VALUES (126,'Macédoine','MK','MKD',1);

INSERT INTO `countries` VALUES (127,'Madagascar','MG','MDG',1);

INSERT INTO `countries` VALUES (128,'Malawi','MW','MWI',1);

INSERT INTO `countries` VALUES (129,'Malaisie','MY','MYS',1);

INSERT INTO `countries` VALUES (130,'Maldives','MV','MDV',1);

INSERT INTO `countries` VALUES (131,'Mali','ML','MLI',1);

INSERT INTO `countries` VALUES (132,'Malte','MT','MLT',1);

INSERT INTO `countries` VALUES (133,'Îles Marshall','MH','MHL',1);

INSERT INTO `countries` VALUES (134,'Martinique','MQ','MTQ',1);

INSERT INTO `countries` VALUES (135,'Mauritanie','MR','MRT',1);

INSERT INTO `countries` VALUES (136,'Îles Maurice','MU','MUS',1);

INSERT INTO `countries` VALUES (137,'Mayotte','YT','MYT',1);

INSERT INTO `countries` VALUES (138,'Mexique','MX','MEX',1);

INSERT INTO `countries` VALUES (139,'Micronésie','FM','FSM',1);

INSERT INTO `countries` VALUES (140,'Moldavie','MD','MDA',1);

INSERT INTO `countries` VALUES (141,'Monaco','MC','MCO',1);

INSERT INTO `countries` VALUES (142,'Mongolie','MN','MNG',1);

INSERT INTO `countries` VALUES (143,'Montserrat','MS','MSR',1);

INSERT INTO `countries` VALUES (144,'Maroc','MA','MAR',1);

INSERT INTO `countries` VALUES (145,'Mozambique','MZ','MOZ',1);

INSERT INTO `countries` VALUES (146,'Myanmar','MM','MMR',1);

INSERT INTO `countries` VALUES (147,'Namibie','NA','NAM',1);

INSERT INTO `countries` VALUES (148,'Nauru','NR','NRU',1);

INSERT INTO `countries` VALUES (149,'Népal','NP','NPL',1);

INSERT INTO `countries` VALUES (150,'Pays-Bas','NL','NLD',1);

INSERT INTO `countries` VALUES (151,'Hollandes Antilles','AN','ANT',1);

INSERT INTO `countries` VALUES (152,'Nouvelle Calédonie','NC','NCL',1);

INSERT INTO `countries` VALUES (153,'Nouvelle-Zélande','NZ','NZL',1);

INSERT INTO `countries` VALUES (154,'Nicaragua','NI','NIC',1);

INSERT INTO `countries` VALUES (155,'Niger','NE','NER',1);

INSERT INTO `countries` VALUES (156,'Nigéria','NG','NGA',1);

INSERT INTO `countries` VALUES (157,'Niue','NU','NIU',1);

INSERT INTO `countries` VALUES (158,'Île De la Norfolk','NF','NFK',1);

INSERT INTO `countries` VALUES (159,'Île Mariannes du Nord','MP','MNP',1);

INSERT INTO `countries` VALUES (160,'Norvège','NO','NOR',1);

INSERT INTO `countries` VALUES (161,'Oman','OM','OMN',1);

INSERT INTO `countries` VALUES (162,'Pakistan','PK','PAK',1);

INSERT INTO `countries` VALUES (163,'Palau','PW','PLW',1);

INSERT INTO `countries` VALUES (164,'Panama','PA','PAN',1);

INSERT INTO `countries` VALUES (165,'Papouasie Nouvelle-Guinée','PG','PNG',1);

INSERT INTO `countries` VALUES (166,'Paraguay','PY','PRY',1);

INSERT INTO `countries` VALUES (167,'Pérou','PE','PER',1);

INSERT INTO `countries` VALUES (168,'Philippines','PH','PHL',1);

INSERT INTO `countries` VALUES (169,'Pitcairn','PN','PCN',1);

INSERT INTO `countries` VALUES (170,'Pologne','PL','POL',1);

INSERT INTO `countries` VALUES (171,'Portugal','PT','PRT',1);

INSERT INTO `countries` VALUES (172,'Puerto Rico','PR','PRI',1);

INSERT INTO `countries` VALUES (173,'Qatar','QA','QAT',1);

INSERT INTO `countries` VALUES (174,'Réunion','RE','REU',1);

INSERT INTO `countries` VALUES (175,'Roumanie','RO','ROM',1);

INSERT INTO `countries` VALUES (176,'Russie','RU','RUS',1);

INSERT INTO `countries` VALUES (177,'Rwanda','RW','RWA',1);

INSERT INTO `countries` VALUES (178,'Saint-Christophe-et-Niévès','KN','KNA',1);

INSERT INTO `countries` VALUES (179,'Sainte-Lucie','LC','LCA',1);

INSERT INTO `countries` VALUES (180,'Saint-Vincent et les Grenadines','VC','VCT',1);

INSERT INTO `countries` VALUES (181,'Samoa','WS','WSM',1);

INSERT INTO `countries` VALUES (182,'Saint-Marin','SM','SMR',1);

INSERT INTO `countries` VALUES (183,'Sao Tomé-et-Principe','ST','STP',1);

INSERT INTO `countries` VALUES (184,'Arabie Saoudite','SA','SAU',1);

INSERT INTO `countries` VALUES (185,'Sénégal','SN','SEN',1);

INSERT INTO `countries` VALUES (186,'Seychelles','SC','SYC',1);

INSERT INTO `countries` VALUES (187,'Sierra Leone','SL','SLE',1);

INSERT INTO `countries` VALUES (188,'Singapour','SG','SGP',4);

INSERT INTO `countries` VALUES (189,'Slovaquie','SK','SVK',1);

INSERT INTO `countries` VALUES (190,'Slovénie','SI','SVN',1);

INSERT INTO `countries` VALUES (191,'Îles Salomon','SB','SLB',1);

INSERT INTO `countries` VALUES (192,'Somalie','SO','SOM',1);

INSERT INTO `countries` VALUES (193,'Afrique du Sud','ZA','ZAF',1);

INSERT INTO `countries` VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS',1);

INSERT INTO `countries` VALUES (195,'Espagne','ES','ESP',3);

INSERT INTO `countries` VALUES (196,'Sri Lanka','LK','LKA',1);

INSERT INTO `countries` VALUES (197,'Sainte-Helène','SH','SHN',1);

INSERT INTO `countries` VALUES (198,'Saint Pierre et Miquelon','PM','SPM',1);

INSERT INTO `countries` VALUES (199,'Soudan','SD','SDN',1);

INSERT INTO `countries` VALUES (200,'Suriname','SR','SUR',1);

INSERT INTO `countries` VALUES (201,'Îles de Svalbard et de JanMayen','SJ','SJM',1);

INSERT INTO `countries` VALUES (202,'Swaziland','SZ','SWZ',1);

INSERT INTO `countries` VALUES (203,'Suède','SE','SWE',1);

INSERT INTO `countries` VALUES (204,'Suisse','CH','CHE',1);

INSERT INTO `countries` VALUES (205,'Syrie','SY','SYR',1);

INSERT INTO `countries` VALUES (206,'Taïwan','TW','TWN',1);

INSERT INTO `countries` VALUES (207,'Tadjikistan','TJ','TJK',1);

INSERT INTO `countries` VALUES (208,'Tanzanie','TZ','TZA',1);

INSERT INTO `countries` VALUES (209,'Thaïlande','TH','THA',1);

INSERT INTO `countries` VALUES (210,'Togo','TG','TGO',1);

INSERT INTO `countries` VALUES (211,'Tokélao','TK','TKL',1);

INSERT INTO `countries` VALUES (212,'Tonga','TO','TON',1);

INSERT INTO `countries` VALUES (213,'Trinité-et-Tobago','TT','TTO',1);

INSERT INTO `countries` VALUES (214,'Tunisie','TN','TUN',1);

INSERT INTO `countries` VALUES (215,'Turquie','TR','TUR',1);

INSERT INTO `countries` VALUES (216,'Turkménistan','TM','TKM',1);

INSERT INTO `countries` VALUES (217,'Îles Turques et Caïques','TC','TCA',1);

INSERT INTO `countries` VALUES (218,'Tuvalu','TV','TUV',1);

INSERT INTO `countries` VALUES (219,'Ouganda','UG','UGA',1);

INSERT INTO `countries` VALUES (220,'Ukraine','UA','UKR',1);

INSERT INTO `countries` VALUES (221,'Emirats Arabes Unis','AE','ARE',1);

INSERT INTO `countries` VALUES (222,'Royaume-Uni','GB','GBR',1);

INSERT INTO `countries` VALUES (223,'Etats-Unis','US','USA',2);

INSERT INTO `countries` VALUES (224,'Îles Périphériques Mineures Des Etats-Unis','UM','UMI',1);

INSERT INTO `countries` VALUES (225,'Uruguay','UY','URY',1);

INSERT INTO `countries` VALUES (226,'Ouzbékistan','UZ','UZB',1);

INSERT INTO `countries` VALUES (227,'Vanuatu','VU','VUT',1);

INSERT INTO `countries` VALUES (228,'Vatican','VA','VAT',1);

INSERT INTO `countries` VALUES (229,'Venezuela','VE','VEN',1);

INSERT INTO `countries` VALUES (230,'Viêt Nam','VN','VNM',1);

INSERT INTO `countries` VALUES (231,'Îles Vierges britanniques','VG','VGB',1);

INSERT INTO `countries` VALUES (232,'Îles Vierges américaines','VI','VIR',1);

INSERT INTO `countries` VALUES (233,'Îles de Wallis et de Futuna','WF','WLF',1);

INSERT INTO `countries` VALUES (234,'Sahara occidental','EH','ESH',1);

INSERT INTO `countries` VALUES (235,'Yémen','YE','YEM',1);

INSERT INTO `countries` VALUES (236,'Yougoslavie','YU','YUG',1);

INSERT INTO `countries` VALUES (237,'Zaïre','ZR','ZAR',1);

INSERT INTO `countries` VALUES (238,'Zambie','ZM','ZMB',1);

INSERT INTO `countries` VALUES (239,'Zimbabwe','ZW','ZWE',1);

Et lancer le sql. Voila c'est tout
Autrement il y a
http://www.oscommerce.com/community/contributions,3524