Añadir provincias de España,Francia, Portugal, Alemania, Reino Unido y Bélgica a Prestashop 1.6.

logo prestashop

Pues eso, como indica el título del post, supongo que tito Google te ha traído aquí porque estas intentando añadir provincias de España, Francia, Portugal, Alemania o Reino Unido (Escocia, Gales, Inglaterra e Irlanda del Norte), Bélgica a prestashop 1,6.  La cosa es muy simple si tienes acceso al PHPMYADMIN de tu base de datos. Como siempre supongo que no hace falta que os diga que antes de hacer ninguna modificación en tu base de datos, hagas una copia de seguridad de todas las tablas. La verdad es que una vez le coges el truco es muy fácil añadir cualquier país del mundo.

Selecciona el país a añadir y copia el código tal cual.

 

España:

INSERT INTO ps_state (id_country, id_zone, name, iso_code, active) VALUES (6, 9, ‘La Coruña’, ‘ES-C’, 1), (6, 9, ‘Álava’, ‘ES-VI’, 1), (6, 9, ‘Albacete’ ,’ES-AB’, 1), (6, 9, ‘Alicante’, ‘ES-A’, 1), (6, 9, ‘Almería’, ‘ES-AL’, 1), (6, 9, ‘Asturias’, ‘ES-O’, 1), (6, 9, ‘Ávila’, ‘ES-AV’, 1), (6, 9, ‘Badajoz’, ‘ES-BA’, 1), (6, 11, ‘Islas Baleares’, ‘ES-PM’, 1), (6, 9, ‘Barcelona’, ‘ES-B’, 1), (6, 9, ‘Burgos’, ‘ES-BU’, 1), (6, 9, ‘Cáceres’, ‘ES-CC’, 1), (6, 9, ‘Cádiz’, ‘ES-CA’, 1), (6, 9, ‘Cantabria’, ‘ES-S’, 1), (6, 9, ‘Castellón’, ‘ES-CS’, 1), (6, 12, ‘Ceuta’, ‘ES-CE’, 1), (6, 9, ‘Ciudad Real’, ‘ES-CR’, 1), (6, 9, ‘Córdoba’, ‘ES-CO’, 1), (6, 9, ‘Cuenca’, ‘ES-CU’, 1), (6, 9, ‘Gerona’, ‘ES-GI’, 1), (6, 9, ‘Granada’, ‘ES-GR’, 1), (6, 9, ‘Guadalajara’, ‘ES-GU’, 1), (6, 9, ‘Guipuzcoa’, ‘ES-SS’, 1), (6, 9, ‘Huelva’, ‘ES-H’, 1), (6, 9, ‘Huesca’, ‘ES-HU’, 1), (6, 9, ‘Jaén’, ‘ES-J’, 1), (6, 9, ‘La Rioja’, ‘ES-LO’, 1), (6, 10, ‘Las Palmas’, ‘ES-GC’, 1), (6, 9, ‘León’, ‘ES-LE’, 1), (6, 9, ‘Lérida’, ‘ES-L’, 1), (6, 9, ‘Lugo’, ‘ES-LU’, 1), (6, 9, ‘Madrid’, ‘ES-M’, 1), (6, 9, ‘Málaga’, ‘ES-MA’, 1), (6, 12, ‘Melilla’, ‘ES-ML’, 1), (6, 9, ‘Murcia’, ‘ES-MU’, 1), (6, 9, ‘Navarra’, ‘ES-NA’, 1), (6, 9, ‘Orense’, ‘ES-OR’, 1), (6, 9, ‘Palencia’, ‘ES-P’, 1), (6, 9, ‘Pontevedra’, ‘ES-PO’, 1), (6, 9, ‘Salamanca’, ‘ES-SA’, 1), (6, 10, ‘Santa Cruz de Tenerife’, ‘ES-TF’, 1), (6, 9, ‘Segovia’, ‘ES-SG’, 1), (6, 9, ‘Sevilla’, ‘ES-SE’, 1), (6, 9, ‘Soria’, ‘ES-SO’, 1), (6, 9, ‘Tarragona’, ‘ES-T’, 1), (6, 9, ‘Teruel’, ‘ES-TE’, 1), (6, 9, ‘Toledo’, ‘ES-TO’, 1), (6, 9, ‘Valencia’, ‘ES-V’, 1), (6, 9, ‘Valladolid’, ‘ES-VA’, 1), (6, 9, ‘Vizcaya’, ‘ES-BI’, 1), (6, 9, ‘Zamora’, ‘ES-ZA’, 1), (6, 9, ‘Zaragoza’, ‘ES-Z’, 1);

Alemania:

INSERT INTO `ps_state` (`id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES

(1, 1,’Baden-Württemberg’,’DE-BW’,’0′,’1′),
(1, 1,’Bayern’,’DE-BY’,’0′,’1′),
(1, 1,’Berlin’,’DE-BE’,’0′,’1′),
(1, 1,’Brandenburg’,’DE-BB’,’0′,’1′),
(1, 1,’Bremen’,’DE-HB’,’0′,’1′),
(1, 1,’Hamburg’,’DE-HH’,’0′,’1′),
(1, 1,’Hessen’,’DE-HE’,’0′,’1′),
(1, 1,’Mecklenburg-Vorpommern ‘,’DE-MV’,’0′,’1′),
(1, 1,’Niedersachsen’,’DE-NI’,’0′,’1′),
(1, 1,’Nordrhein-Westfalen’,’DE-NW’,’0′,’1′),
(1, 1,’Rheinland-Pfalz ‘,’DE-RP’,’0′,’1′),
(1, 1,’Saarland ‘,’DE-SL’,’0′,’1′),
(1, 1,’Sachsen’,’DE-SN’,’0′,’1′),
(1, 1,’Sachsen-Anhalt’,’DE-ST’,’0′,’1′),
(1, 1,’Schleswig-Holstein’,’DE-SH’,’0′,’1′),
(1, 1,’Thüringen’,’DE-TH’,’0′,’1′),
(1, 1,’Bundesrepublik Deutschland ‘,’DE-DE’,’0′,’1′);

Francia:

 INSERT INTO ps_state (id_country, id_zone, name, iso_code, active) VALUES
(8, 1, “Lot-et-Garonne”, “FR-47”, 1),
(8, 1, “Corse-du-Sud”, “FR-2A”, 1),
(8, 1, “Tarn”, “FR-81”, 1),
(8, 1, “Orne”, “FR-61”, 1),
(8, 1, “Somme”, “FR-80”, 1),
(8, 1, “Maine-et-Loire”, “FR-49”, 1),
(8, 1, “Charente”, “FR-16”, 1),
(8, 1, “Haute-Savoie”, “FR-74”, 1),
(8, 1, “Pas-de-Calais”, “FR-62”, 1),
(8, 1, “Gers”, “FR-32”, 1),
(8, 1, “Cantal”, “FR-15”, 1),
(8, 1, “Yonne”, “FR-89”, 1),
(8, 1, “Vaucluse”, “FR-84”, 1),
(8, 1, “Meuse”, “FR-55”, 1),
(8, 1, “Haute-Corse”, “FR-2B”, 1),
(8, 1, “Oise”, “FR-60”, 1),
(8, 1, “Territoire de Belfort”, “FR-90”, 1),
(8, 1, “Doubs”, “FR-25”, 1),
(8, 1, “Loir-et-Cher”, “FR-41”, 1),
(8, 1, “Seine-Saint-Denis”, “FR-93”, 1),
(8, 1, “Ain”, “FR-1”, 1),
(8, 1, “Cher”, “FR-18”, 1),
(8, 1, “Gironde”, “FR-33”, 1),
(8, 1, “Calvados”, “FR-14”, 1),
(8, 1, “Lot”, “FR-46”, 1),
(8, 1, “Aude”, “FR-11”, 1),
(8, 1, “Puy-de-Dôme”, “FR-63”, 1),
(8, 1, “Haut-Rhin”, “FR-68”, 1),
(8, 1, “Val-de-Marne”, “FR-94”, 1),
(8, 1, “Marne”, “FR-51”, 1),
(8, 1, “Savoie”, “FR-73”, 1),
(8, 1, “Ardennes”, “FR-8”, 1),
(8, 1, “Eure-et-Loir”, “FR-28”, 1),
(8, 1, “Indre”, “FR-36”, 1),
(8, 1, “Haute-Marne”, “FR-52”, 1),
(8, 1, “Alpes-de-Haute-Provence”, “FR-4”, 1),
(8, 1, “Côte-dOr”, “FR-21”, 1),
(8, 1, “Vosges”, “FR-88”, 1),
(8, 1, “Bas-Rhin”, “FR-67”, 1),
(8, 1, “Eure”, “FR-27”, 1),
(8, 1, “Essonne”, “FR-91”, 1),
(8, 1, “Ariège”, “FR-9”, 1),
(8, 1, “Hautes-Alpes”, “FR-5”, 1),
(8, 1, “Isère”, “FR-38”, 1),
(8, 1, “Creuse”, “FR-23”, 1),
(8, 1, “Charente-Maritime”, “FR-17”, 1),
(8, 1, “Vendée”, “FR-85”, 1),
(8, 1, “Aisne”, “FR-2”, 1),
(8, 1, “Mayenne”, “FR-53”, 1),
(8, 1, “Sarthe”, “FR-72”, 1),
(8, 1, “Haute-Loire”, “FR-43”, 1),
(8, 1, “Nord”, “FR-59”, 1),
(8, 1, “Haute-Vienne”, “FR-87”, 1),
(8, 1, “Jura”, “FR-39”, 1),
(8, 1, “Rhône”, “FR-69”, 1),
(8, 1, “Saone-et-Loire”, “FR-71”, 1),
(8, 1, “Bouches-du-Rhône”, “FR-13”, 1),
(8, 1, “Seine-et-Marne”, “FR-77”, 1),
(8, 1, “Lozère”, “FR-48”, 1),
(8, 1, “Moselle”, “FR-57”, 1),
(8, 1, “Tarn-et-Garonne”, “FR-82”, 1),
(8, 1, “Landes”, “FR-40”, 1),
(8, 1, “Hérault”, “FR-34”, 1),
(8, 1, “Allier”, “FR-3”, 1),
(8, 1, “Meurthe-et-Moselle”, “FR-54”, 1),
(8, 1, “Hauts-de-Seine”, “FR-92”, 1),
(8, 1, “Loire-Atlantique”, “FR-44”, 1),
(8, 1, “Nièvre”, “FR-58”, 1),
(8, 1, “Gard”, “FR-30”, 1),
(8, 1, “Deux-Sèvres”, “FR-79”, 1),
(8, 1, “Alpes-Maritimes”, “FR-6”, 1),
(8, 1, “Loiret”, “FR-45”, 1),
(8, 1, “Paris”, “FR-75”, 1),
(8, 1, “Pyrénées-Atlantiques”, “FR-64”, 1),
(8, 1, “Dordogne”, “FR-24”, 1),
(8, 1, “Pyrénées-Orientales”, “FR-66”, 1),
(8, 1, “Vienne”, “FR-86”, 1),
(8, 1, “Val-d”Oise”, “FR-95”, 1),
(8, 1, “Ardèche”, “FR-7”, 1),
(8, 1, “Finistère”, “FR-29”, 1),
(8, 1, “Ille-et-Vilaine”, “FR-35”, 1),
(8, 1, “Aveyron”, “FR-12”, 1),
(8, 1, “Seine-Maritime”, “FR-76”, 1),
(8, 1, “Côtes-dArmor”, “FR-22”, 1),
(8, 1, “Loire”, “FR-42”, 1),
(8, 1, “Manche”, “FR-50”, 1),
(8, 1, “Hautes-Pyrénées”, “FR-65”, 1),
(8, 1, “Var”, “FR-83”, 1),
(8, 1, “Haute-Garonne”, “FR-31”, 1),
(8, 1, “Indre-et-Loire”, “FR-37”, 1),
(8, 1, “Aube”, “FR-10”, 1),
(8, 1, “Corrèze”, “FR-19”, 1),
(8, 1, “Drôme”, “FR-26”, 1),
(8, 1, “Morbihan”, “FR-56”, 1),
(8, 1, “Yvelines”, “FR-78”, 1),
(8, 1, “Haute-Saone”, “FR-70”, 1);

Reino Unido:

INSERT INTO `ps_state` (`id_country`, `id_zone`, `iso_code`, `name`,`tax_behavior`, `active`) VALUES(17, 1,’GB-ABE’,’Aberdeen City’,’0′,’1′),
(17, 1,’GB-ABD’,’Aberdeenshire’,’0′,’1′),
(17, 1,’GB-ANS’,’Angus’,’0′,’1′),
(17, 1,’GB-ANT’,’Antrim’,’0′,’1′),
(17, 1,’GB-ARD’,’Ards’,’0′,’1′),
(17, 1,’GB-AGB’,’Argyll and Bute’,’0′,’1′),
(17, 1,’GB-ARM’,’Armagh’,’0′,’1′),
(17, 1,’GB-BLA’,’Ballymena’,’0′,’1′),
(17, 1,’GB-BLY’,’Ballymoney’,’0′,’1′),
(17, 1,’GB-BNB’,’Banbridge’,’0′,’1′),
(17, 1,’GB-BDG’,’Barking and Dagenham’,’0′,’1′),
(17, 1,’GB-BNE’,’Barnet’,’0′,’1′),
(17, 1,’GB-BNS’,’Barnsley’,’0′,’1′),
(17, 1,’GB-BAS’,’Bath and North East Somerset’,’0′,’1′),
(17, 1,’GB-BDF’,’Bedford’,’0′,’1′),
(17, 1,’GB-BFS’,’Belfast City’,’0′,’1′),
(17, 1,’GB-BEX’,’Bexley’,’0′,’1′),
(17, 1,’GB-BIR’,’Birmingham’,’0′,’1′),
(17, 1,’GB-BBD’,’Blackburn with Darwen’,’0′,’1′),
(17, 1,’GB-BPL’,’Blackpool’,’0′,’1′),
(17, 1,’GB-BGW’,’Blaenau Gwent’,’0′,’1′),
(17, 1,’GB-BOL’,’Bolton’,’0′,’1′),
(17, 1,’GB-BMH’,’Bournemouth’,’0′,’1′),
(17, 1,’GB-BRC’,’Bracknell Forest’,’0′,’1′),
(17, 1,’GB-BRD’,’Bradford’,’0′,’1′),
(17, 1,’GB-BEN’,’Brent’,’0′,’1′),
(17, 1,’GB-BGE’,’Bridgend’,’0′,’1′),
(17, 1,’GB-BRY’,’Bromley’,’0′,’1′),
(17, 1,’GB-BKM’,’Buckinghamshire’,’0′,’1′),
(17, 1,’GB-BUR’,’Bury’,’0′,’1′),
(17, 1,’GB-CAY’,’Caerphilly’,’0′,’1′),
(17, 1,’GB-CLD’,’Calderdale’,’0′,’1′),
(17, 1,’GB-CAM’,’Cambridgeshire’,’0′,’1′),
(17, 1,’GB-CMD’,’Camden’,’0′,’1′),
(17, 1,’GB-CRF’,’Cardiff’,’0′,’1′),
(17, 1,’GB-CMN’,’Carmarthenshire’,’0′,’1′),
(17, 1,’GB-CKF’,’Carrickfergus’,’0′,’1′),
(17, 1,’GB-CSR’,’Castlereagh’,’0′,’1′),
(17, 1,’GB-CBF’,’Central Bedfordshire’,’0′,’1′),
(17, 1,’GB-CGN’,’Ceredigion’,’0′,’1′),
(17, 1,’GB-CHE’,’Cheshire East’,’0′,’1′),
(17, 1,’GB-CHW’,’Cheshire West and Chester’,’0′,’1′),
(17, 1,’GB-BST’,’City of Bristol’,’0′,’1′),
(17, 1,’GB-DER’,’City of Derby’,’0′,’1′),
(17, 1,’GB-EDH’,’City of Edinburgh’,’0′,’1′),
(17, 1,’GB-LCE’,’City of Leicester’,’0′,’1′),
(17, 1,’GB-LND’,’City of London’,’0′,’1′),
(17, 1,’GB-MAN’,’City of Manchester’,’0′,’1′),
(17, 1,’GB-NGM’,’City of Nottingham’,’0′,’1′),
(17, 1,’GB-PTE’,’City of Peterborough’,’0′,’1′),
(17, 1,’GB-PLY’,’City of Plymouth’,’0′,’1′),
(17, 1,’GB-POR’,’City of Portsmouth’,’0′,’1′),
(17, 1,’GB-SLF’,’City of Salford’,’0′,’1′),
(17, 1,’GB-STH’,’City of Southampton’,’0′,’1′),
(17, 1,’GB-STE’,’City of Stoke-on-Trent’,’0′,’1′),
(17, 1,’GB-WSM’,’City of Westminster’,’0′,’1′),
(17, 1,’GB-WLV’,’City of Wolverhampton’,’0′,’1′),
(17, 1,’GB-CLK’,’Clackmannanshire’,’0′,’1′),
(17, 1,’GB-CLR’,’Coleraine’,’0′,’1′),
(17, 1,’GB-CWY’,’Conwy’,’0′,’1′),
(17, 1,’GB-CKT’,’Cookstown’,’0′,’1′),
(17, 1,’GB-CON’,’Cornwall’,’0′,’1′),
(17, 1,’GB-COV’,’Coventry’,’0′,’1′),
(17, 1,’GB-CGV’,’Craigavon’,’0′,’1′),
(17, 1,’GB-CRY’,’Croydon’,’0′,’1′),
(17, 1,’GB-CMA’,’Cumbria’,’0′,’1′),
(17, 1,’GB-DAL’,’Darlington’,’0′,’1′),
(17, 1,’GB-DEN’,’Denbighshire’,’0′,’1′),
(17, 1,’GB-DBY’,’Derbyshire’,’0′,’1′),
(17, 1,’GB-DRY’,’Derry City’,’0′,’1′),
(17, 1,’GB-DEV’,’Devon’,’0′,’1′),
(17, 1,’GB-DNC’,’Doncaster’,’0′,’1′),
(17, 1,’GB-DOR’,’Dorset’,’0′,’1′),
(17, 1,’GB-DOW’,’Down’,’0′,’1′),
(17, 1,’GB-DUD’,’Dudley’,’0′,’1′),
(17, 1,’GB-DGY’,’Dumfries and Galloway’,’0′,’1′),
(17, 1,’GB-DND’,’Dundee City’,’0′,’1′),
(17, 1,’GB-DGN’,’Dungannon and South Tyrone’,’0′,’1′),
(17, 1,’GB-DUR’,’Durham’,’0′,’1′),
(17, 1,’GB-EAL’,’Ealing’,’0′,’1′),
(17, 1,’GB-EAY’,’East Ayrshire’,’0′,’1′),
(17, 1,’GB-EDU’,’East Dunbartonshire’,’0′,’1′),
(17, 1,’GB-ELN’,’East Lothian’,’0′,’1′),
(17, 1,’GB-ERW’,’East Renfrewshire’,’0′,’1′),
(17, 1,’GB-ERY’,’East Riding of Yorkshire’,’0′,’1′),
(17, 1,’GB-ESX’,’East Sussex’,’0′,’1′),
(17, 1,’GB-ENF’,’Enfield’,’0′,’1′),
(17, 1,’GB-ESS’,’Essex’,’0′,’1′),
(17, 1,’GB-FAL’,’Falkirk’,’0′,’1′),
(17, 1,’GB-FER’,’Fermanagh’,’0′,’1′),
(17, 1,’GB-FIF’,’Fife’,’0′,’1′),
(17, 1,’GB-FLN’,’Flintshire’,’0′,’1′),
(17, 1,’GB-GAT’,’Gateshead’,’0′,’1′),
(17, 1,’GB-GLG’,’Glasgow City’,’0′,’1′),
(17, 1,’GB-GLS’,’Gloucestershire’,’0′,’1′),
(17, 1,’GB-GRE’,’Greenwich’,’0′,’1′),
(17, 1,’GB-GWN’,’Gwynedd’,’0′,’1′),
(17, 1,’GB-HCK’,’Hackney’,’0′,’1′),
(17, 1,’GB-HAL’,’Halton’,’0′,’1′),
(17, 1,’GB-HMF’,’Hammersmith and Fulham’,’0′,’1′),
(17, 1,’GB-HAM’,’Hampshire’,’0′,’1′),
(17, 1,’GB-HRY’,’Haringey’,’0′,’1′),
(17, 1,’GB-HRW’,’Harrow’,’0′,’1′),
(17, 1,’GB-HPL’,’Hartlepool’,’0′,’1′),
(17, 1,’GB-HAV’,’Havering’,’0′,’1′),
(17, 1,’GB-HEF’,’Herefordshire’,’0′,’1′),
(17, 1,’GB-HRT’,’Hertfordshire’,’0′,’1′),
(17, 1,’GB-HLD’,’Highland’,’0′,’1′),
(17, 1,’GB-HIL’,’Hillingdon’,’0′,’1′),
(17, 1,’GB-HNS’,’Hounslow’,’0′,’1′),
(17, 1,’GB-IVC’,’Inverclyde’,’0′,’1′),
(17, 1,’GB-AGY’,’Isle of Anglesey’,’0′,’1′),
(17, 1,’GB-IOW’,’Isle of Wight’,’0′,’1′),
(17, 1,’GB-ISL’,’Islington’,’0′,’1′),
(17, 1,’GB-KEC’,’Kensington and Chelsea’,’0′,’1′),
(17, 1,’GB-KEN’,’Kent’,’0′,’1′),
(17, 1,’GB-KHL’,’Kingston upon Hull’,’0′,’1′),
(17, 1,’GB-KTT’,’Kingston upon Thames’,’0′,’1′),
(17, 1,’GB-KIR’,’Kirklees’,’0′,’1′),
(17, 1,’GB-KWL’,’Knowsley’,’0′,’1′),
(17, 1,’GB-LBH’,’Lambeth’,’0′,’1′),
(17, 1,’GB-LAN’,’Lancashire’,’0′,’1′),
(17, 1,’GB-LRN’,’Larne’,’0′,’1′),
(17, 1,’GB-LDS’,’Leeds’,’0′,’1′),
(17, 1,’GB-LEC’,’Leicestershire’,’0′,’1′),
(17, 1,’GB-LEW’,’Lewisham’,’0′,’1′),
(17, 1,’GB-LMV’,’Limavady’,’0′,’1′),
(17, 1,’GB-LIN’,’Lincolnshire’,’0′,’1′),
(17, 1,’GB-LSB’,’Lisburn’,’0′,’1′),
(17, 1,’GB-LIV’,’Liverpool’,’0′,’1′),
(17, 1,’GB-LUT’,’Luton’,’0′,’1′),
(17, 1,’GB-MFT’,’Magherafelt’,’0′,’1′),
(17, 1,’GB-MDW’,’Medway’,’0′,’1′),
(17, 1,’GB-MTY’,’Merthyr Tydfil’,’0′,’1′),
(17, 1,’GB-MRT’,’Merton’,’0′,’1′),
(17, 1,’GB-MDB’,’Middlesbrough’,’0′,’1′),
(17, 1,’GB-MLN’,’Midlothian’,’0′,’1′),
(17, 1,’GB-MIK’,’Milton Keynes’,’0′,’1′),
(17, 1,’GB-MON’,’Monmouthshire’,’0′,’1′),
(17, 1,’GB-MRY’,’Moray’,’0′,’1′),
(17, 1,’GB-MYL’,’Moyle’,’0′,’1′),
(17, 1,’GB-NTL’,’Neath Port Talbot’,’0′,’1′),
(17, 1,’GB-NET’,’Newcastle upon Tyne’,’0′,’1′),
(17, 1,’GB-NWM’,’Newham’,’0′,’1′),
(17, 1,’GB-NWP’,’Newport’,’0′,’1′),
(17, 1,’GB-NYM’,’Newry and Mourne’,’0′,’1′),
(17, 1,’GB-NTA’,’Newtownabbey’,’0′,’1′),
(17, 1,’GB-NFK’,’Norfolk’,’0′,’1′),
(17, 1,’GB-NAY’,’North Ayrshire’,’0′,’1′),
(17, 1,’GB-NDN’,’North Down’,’0′,’1′),
(17, 1,’GB-NEL’,’North East Lincolnshire’,’0′,’1′),
(17, 1,’GB-NLK’,’North Lanarkshire’,’0′,’1′),
(17, 1,’GB-NLN’,’North Lincolnshire’,’0′,’1′),
(17, 1,’GB-NSM’,’North Somerset’,’0′,’1′),
(17, 1,’GB-NTY’,’North Tyneside’,’0′,’1′),
(17, 1,’GB-NYK’,’North Yorkshire’,’0′,’1′),
(17, 1,’GB-NTH’,’Northamptonshire’,’0′,’1′),
(17, 1,’GB-NBL’,’Northumberland’,’0′,’1′),
(17, 1,’GB-NTT’,’Nottinghamshire’,’0′,’1′),
(17, 1,’GB-OLD’,’Oldham’,’0′,’1′),
(17, 1,’GB-OMH’,’Omagh’,’0′,’1′),
(17, 1,’GB-ORK’,’Orkney Islands’,’0′,’1′),
(17, 1,’GB-ELS’,’Outer Hebrides’,’0′,’1′),
(17, 1,’GB-OXF’,’Oxfordshire’,’0′,’1′),
(17, 1,’GB-PEM’,’Pembrokeshire’,’0′,’1′),
(17, 1,’GB-PKN’,’Perth and Kinross’,’0′,’1′),
(17, 1,’GB-POL’,’Poole’,’0′,’1′),
(17, 1,’GB-POW’,’Powys’,’0′,’1′),
(17, 1,’GB-RDG’,’Reading’,’0′,’1′),
(17, 1,’GB-RDB’,’Redbridge’,’0′,’1′),
(17, 1,’GB-RCC’,’Redcar and Cleveland’,’0′,’1′),
(17, 1,’GB-RFW’,’Renfrewshire’,’0′,’1′),
(17, 1,’GB-RCT’,’Rhondda Cynon Taf’,’0′,’1′),
(17, 1,’GB-RIC’,’Richmond upon Thames’,’0′,’1′),
(17, 1,’GB-RCH’,’Rochdale’,’0′,’1′),
(17, 1,’GB-ROT’,’Rotherham’,’0′,’1′),
(17, 1,’GB-RUT’,’Rutland’,’0′,’1′),
(17, 1,’GB-SAW’,’Sandwell’,’0′,’1′),
(17, 1,’GB-SCB’,’Scottish Borders’,’0′,’1′),
(17, 1,’GB-SFT’,’Sefton’,’0′,’1′),
(17, 1,’GB-SHF’,’Sheffield’,’0′,’1′),
(17, 1,’GB-ZET’,’Shetland Islands’,’0′,’1′),
(17, 1,’GB-SHR’,’Shropshire’,’0′,’1′),
(17, 1,’GB-SLG’,’Slough’,’0′,’1′),
(17, 1,’GB-SOL’,’Solihull’,’0′,’1′),
(17, 1,’GB-SOM’,’Somerset’,’0′,’1′),
(17, 1,’GB-SAY’,’South Ayrshire’,’0′,’1′),
(17, 1,’GB-SGC’,’South Gloucestershire’,’0′,’1′),
(17, 1,’GB-SLK’,’South Lanarkshire’,’0′,’1′),
(17, 1,’GB-STY’,’South Tyneside’,’0′,’1′),
(17, 1,’GB-SOS’,’Southend-on-Sea’,’0′,’1′),
(17, 1,’GB-SWK’,’Southwark’,’0′,’1′),
(17, 1,’GB-SHN’,’St. Helens’,’0′,’1′),
(17, 1,’GB-STS’,’Staffordshire’,’0′,’1′),
(17, 1,’GB-STG’,’Stirling’,’0′,’1′),
(17, 1,’GB-SKP’,’Stockport’,’0′,’1′),
(17, 1,’GB-STT’,’Stockton-on-Tees’,’0′,’1′),
(17, 1,’GB-STB’,’Strabane’,’0′,’1′),
(17, 1,’GB-SFK’,’Suffolk’,’0′,’1′),
(17, 1,’GB-SND’,’Sunderland’,’0′,’1′),
(17, 1,’GB-SRY’,’Surrey’,’0′,’1′),
(17, 1,’GB-STN’,’Sutton’,’0′,’1′),
(17, 1,’GB-SWA’,’Swansea’,’0′,’1′),
(17, 1,’GB-SWD’,’Swindon’,’0′,’1′),
(17, 1,’GB-TAM’,’Tameside’,’0′,’1′),
(17, 1,’GB-TFW’,’Telford and Wrekin’,’0′,’1′),
(17, 1,’GB-BNH’,’The City of Brighton and Hove’,’0′,’1′),
(17, 1,’GB-THR’,’Thurrock’,’0′,’1′),
(17, 1,’GB-TOB’,’Torbay’,’0′,’1′),
(17, 1,’GB-TOF’,’Torfaen’,’0′,’1′),
(17, 1,’GB-TWH’,’Tower Hamlets’,’0′,’1′),
(17, 1,’GB-TRF’,’Trafford’,’0′,’1′),
(17, 1,’GB-VGL’,’Vale of Glamorgan’,’0′,’1′),
(17, 1,’GB-WKF’,’Wakefield’,’0′,’1′),
(17, 1,’GB-WLL’,’Walsall’,’0′,’1′),
(17, 1,’GB-WFT’,’Waltham Forest’,’0′,’1′),
(17, 1,’GB-WND’,’Wandsworth’,’0′,’1′),
(17, 1,’GB-WRT’,’Warrington’,’0′,’1′),
(17, 1,’GB-WAR’,’Warwickshire’,’0′,’1′),
(17, 1,’GB-WBK’,’West Berkshire’,’0′,’1′),
(17, 1,’GB-WDU’,’West Dunbartonshire’,’0′,’1′),
(17, 1,’GB-WLN’,’West Lothian’,’0′,’1′),
(17, 1,’GB-WSX’,’West Sussex’,’0′,’1′),
(17, 1,’GB-WGN’,’Wigan’,’0′,’1′),
(17, 1,’GB-WIL’,’Wiltshire’,’0′,’1′),
(17, 1,’GB-WNM’,’Windsor and Maidenhead’,’0′,’1′),
(17, 1,’GB-WRL’,’Wirral’,’0′,’1′),
(17, 1,’GB-WOK’,’Wokingham’,’0′,’1′),
(17, 1,’GB-WOR’,’Worcestershire’,’0′,’1′),
(17, 1,’GB-WRX’,’Wrexham’,’0′,’1′),
(17, 1,’GB-YOR’,’York’,’0′,’1′);

Portugal:

INSERT INTO `ps_state` (`id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES(15, 1,’Açores’,’PT-AC’,’0′,’1′),
(15, 1,’Aveiro’,’PT-AV’,’0′,’1′),
(15, 1,’Beja’,’PT-BE’,’0′,’1′),
(15, 1,’Braga’,’PT-BR’,’0′,’1′),
(15, 1,’Bragança’,’PT-BA’,’0′,’1′),
(15, 1,’Castelo Branco’,’PT-CB’,’0′,’1′),
(15, 1,’Coimbra’,’PT-CO’,’0′,’1′),
(15, 1,’Évora’,’PT-EV’,’0′,’1′),
(15, 1,’Faro’,’PT-FA’,’0′,’1′),
(15, 1,’Guarda’,’PT-GU’,’0′,’1′),
(15, 1,’Leiria’,’PT-LE’,’0′,’1′),
(15, 1,’Lisboa’,’PT-LI’,’0′,’1′),
(15, 1,’Madeira’,’PT-MA’,’0′,’1′),
(15, 1,’Portalegre’,’PT-PA’,’0′,’1′),
(15, 1,’Porto’,’PT-PO’,’0′,’1′),
(15, 1,’Santarém’,’PT-SA’,’0′,’1′),
(15, 1,’Setúbal’,’PT-SE’,’0′,’1′),
(15, 1,’Viana do Castelo’,’PT-VC’,’0′,’1′),
(15, 1,’Vila Real’,’PT-VR’,’0′,’1′),
(15, 1,’Viseu’,’PT-VI’,’0′,’1′);

Bélgica:

INSERT INTO `ps_state` (`id_state`, `id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES
(1036, 3, 24, ‘Amberes’, ‘BE-VAN’, 0, 1),
(1037, 3, 24, ‘Limburgo’, ‘BE-VLI’, 0, 1),
(1038, 3, 24, ‘Brabante Flamenco’, ‘BE-VBR’, 0, 1),
(1039, 3, 24, ‘Flandes Oriental’, ‘BE-VOV’, 0, 1),
(1040, 3, 24, ‘Flandes Occidental’, ‘BE-VWV’, 0, 1),
(1041, 3, 24, ‘Henao’, ‘BE-WHT’, 0, 1),
(1042, 3, 24, ‘Brabante Valon’, ‘BE-WBR’, 0, 1),
(1043, 3, 24, ‘Lieja’, ‘BE-WLG’, 0, 1),
(1044, 3, 24, ‘Luxemburgo’, ‘BE-WLX’, 0, 1),
(1045, 3, 24, ‘Bruselas Capital’, ‘BE-BRU’, 0, 1);

entra en tu phpMyadmin y ve a la pestaña SQL

1

Pega el codigo SQL aqui:

2

Dale a la tecla continuar y ya tienes todas las provincias del pais en una sola consulta en su sitio.

Si os ha gustado este post y os ha servido de ayuda agradecería que lo compartáis en vuestras redes sociales favoritas y a ser posible que le deis G+ en la parte de debajo de este post.

Después de varios meses de este post, hoy lo vuelvo a editar, simplemente para comentar que con el prestashop 1.6.0.9 acabo de instalar una web nueva y he tenido que echar mano de este post otra vez, para un nuevo proyecto cápsulas de café para mayoristas mediante dropshipping http://capsulasdropshipping.com/

 

Saludos

David Mogort

The following two tabs change content below.

17 comentaris a “Añadir provincias de España,Francia, Portugal, Alemania, Reino Unido y Bélgica a Prestashop 1.6.

  1. Hola David,

    Mil gracias por tu post y por tu información. Solo una pregunta…. cuando pego los datos en la SQL me da una opción de delimitador. Por defecto aparece el punto y coma (;) sería ese o la coma (,)?

    Un saludo,
    Lucía

    • en principio a mi me funciona con cpanel así, pero hazte una copia de seguridad y prueba. Si no te funcionara, restaura y prueba de la otra manera. Lo normal es que te funcione bien. Saludos

  2. Hola, Gracias por el post, pero tengo un problema.

    Cuando doy continuar me sale el siguiente error:
    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Rochela’, ‘FR-17′, 1),
    (8, 1,’La Roche-sur-Yon’, ‘FR-85′, 1),
    (8’ at line 46

    A que se debe?

    Gracias.

    • Gracias a ti por venir a visitar una de mis humildes moradas. Pues yo soy de francés y era lo que peor llevaba en la escuela. Pero parece que tu versión de SQL no entiende la orden que le das en la consulta. Prueba la misma consulta sin los acentos y signos raros del texto y si puedo ayudarte en algo me avisas

  3. A mi me pasa lo mismo al importar las provincias de Francia, lo he solucionado
    con esta consulta:

    INSERT INTO ps_state (id_country, id_zone, name, iso_code, active) VALUES
    (‘8’, ‘1’, ‘Agen’, ‘FR-47’, ‘1’),
    (‘8’, ‘1’, ‘Ajaccio’, ‘FR-2A’, ‘1’),
    (‘8’, ‘1’, ‘Albi’, ‘FR-81’, ‘1’),
    (‘8’, ‘1’, ‘Alençon’, ‘FR-61’, ‘1’),
    (‘8’, ‘1’, ‘Amiens’, ‘FR-80’, ‘1’),
    (‘8’, ‘1’, ‘Angers’, ‘FR-49’, ‘1’),
    (‘8’, ‘1’, ‘Angulema’, ‘FR-16’, ‘1’),
    (‘8’, ‘1’, ‘Annecy’, ‘FR-74’, ‘1’),
    (‘8’, ‘1’, ‘Arras’, ‘FR-62’, ‘1’),
    (‘8’, ‘1’, ‘Auch’, ‘FR-32’, ‘1’),
    (‘8’, ‘1’, ‘Aurillac’, ‘FR-15’, ‘1’),
    (‘8’, ‘1’, ‘Auxerre’, ‘FR-89’, ‘1’),
    (‘8’, ‘1’, ‘Aviñón’, ‘FR-84’, ‘1’),
    (‘8’, ‘1’, ‘Bar-le-Duc’, ‘FR-55’, ‘1’),
    (‘8’, ‘1’, ‘Bastia’, ‘FR-2B’, ‘1’),
    (‘8’, ‘1’, ‘Beauvais’, ‘FR-60’, ‘1’),
    (‘8’, ‘1’, ‘Belfort’, ‘FR-90’, ‘1’),
    (‘8’, ‘1’, ‘Besançon’, ‘FR-25’, ‘1’),
    (‘8’, ‘1’, ‘Blois’, ‘FR-41’, ‘1’),
    (‘8’, ‘1’, ‘Bobigny’, ‘FR-93’, ‘1’),
    (‘8’, ‘1’, ‘Bourg-en-Bresse’, ‘FR-1’, ‘1’),
    (‘8’, ‘1’, ‘Bourges’, ‘FR-18’, ‘1’),
    (‘8’, ‘1’, ‘Burdeos’, ‘FR-33’, ‘1’),
    (‘8’, ‘1’, ‘Caen’, ‘FR-14’, ‘1’),
    (‘8’, ‘1’, ‘Cahors’, ‘FR-46’, ‘1’),
    (‘8’, ‘1’, ‘Carcasona’, ‘FR-11’, ‘1’),
    (‘8’, ‘1’, ‘Clermont-Ferrand’, ‘FR-63’, ‘1’),
    (‘8’, ‘1’, ‘Colmar’, ‘FR-68’, ‘1’),
    (‘8’, ‘1’, ‘Créteil’, ‘FR-94’, ‘1’),
    (‘8’, ‘1’, ‘Châlons-en-Champagne’, ‘FR-51’, ‘1’),
    (‘8’, ‘1’, ‘Chambéry’, ‘FR-73’, ‘1’),
    (‘8’, ‘1’, ‘Charleville-Mézières’, ‘FR-8’, ‘1’),
    (‘8’, ‘1’, ‘Chartres’, ‘FR-28’, ‘1’),
    (‘8’, ‘1’, ‘Châteauroux’, ‘FR-36’, ‘1’),
    (‘8’, ‘1’, ‘Chaumont’, ‘FR-52’, ‘1’),
    (‘8’, ‘1’, ‘Digne-les-Bains’, ‘FR-4’, ‘1’),
    (‘8’, ‘1’, ‘Dijon’, ‘FR-21’, ‘1’),
    (‘8’, ‘1’, ‘Épinal’, ‘FR-88’, ‘1’),
    (‘8’, ‘1’, ‘Estrasburgo’, ‘FR-67’, ‘1’),
    (‘8’, ‘1’, ‘Évreux’, ‘FR-27’, ‘1’),
    (‘8’, ‘1’, ‘Évry’, ‘FR-91’, ‘1’),
    (‘8’, ‘1’, ‘Foix’, ‘FR-9’, ‘1’),
    (‘8’, ‘1’, ‘Gap’, ‘FR-5’, ‘1’),
    (‘8’, ‘1’, ‘Grenoble’, ‘FR-38’, ‘1’),
    (‘8’, ‘1’, ‘Guéret’, ‘FR-23’, ‘1’),
    (‘8’, ‘1’, ‘La Rochela’, ‘FR-17’, ‘1’),
    (‘8’, ‘1’, ‘La Roche-sur-Yon’, ‘FR-85’, ‘1’),
    (‘8’, ‘1’, ‘Laon’, ‘FR-2’, ‘1’),
    (‘8’, ‘1’, ‘Laval’, ‘FR-53’, ‘1’),
    (‘8’, ‘1’, ‘Le Mans’, ‘FR-72’, ‘1’),
    (‘8’, ‘1’, ‘Le Puy-en-Velay’, ‘FR-43’, ‘1’),
    (‘8’, ‘1’, ‘Lille’, ‘FR-59’, ‘1’),
    (‘8’, ‘1’, ‘Limoges’, ‘FR-87’, ‘1’),
    (‘8’, ‘1’, ‘Lons-le-Saunier’, ‘FR-39’, ‘1’),
    (‘8’, ‘1’, ‘Lyon’, ‘FR-69’, ‘1’),
    (‘8’, ‘1’, ‘Mâcon’, ‘FR-71’, ‘1’),
    (‘8’, ‘1’, ‘Marsella’, ‘FR-13’, ‘1’),
    (‘8’, ‘1’, ‘Melun’, ‘FR-77’, ‘1’),
    (‘8’, ‘1’, ‘Mende’, ‘FR-48’, ‘1’),
    (‘8’, ‘1’, ‘Metz’, ‘FR-57’, ‘1’),
    (‘8’, ‘1’, ‘Montauban’, ‘FR-82’, ‘1’),
    (‘8’, ‘1’, ‘Mont-de-Marsan’, ‘FR-40’, ‘1’),
    (‘8’, ‘1’, ‘Montpellier’, ‘FR-34’, ‘1’),
    (‘8’, ‘1’, ‘Moulins (Allier)’, ‘FR-3’, ‘1’),
    (‘8’, ‘1’, ‘Nancy’, ‘FR-54’, ‘1’),
    (‘8’, ‘1’, ‘Nanterre’, ‘FR-92’, ‘1’),
    (‘8’, ‘1’, ‘Nantes’, ‘FR-44’, ‘1’),
    (‘8’, ‘1’, ‘Nevers’, ‘FR-58’, ‘1’),
    (‘8’, ‘1’, ‘Nimes’, ‘FR-30’, ‘1’),
    (‘8’, ‘1’, ‘Niort’, ‘FR-79’, ‘1’),
    (‘8’, ‘1’, ‘Niza’, ‘FR-6’, ‘1’),
    (‘8’, ‘1’, ‘Orleans’, ‘FR-45’, ‘1’),
    (‘8’, ‘1’, ‘París’, ‘FR-75’, ‘1’),
    (‘8’, ‘1’, ‘Pau’, ‘FR-64’, ‘1’),
    (‘8’, ‘1’, ‘Périgueux’, ‘FR-24’, ‘1’),
    (‘8’, ‘1’, ‘Perpiñán’, ‘FR-66’, ‘1’),
    (‘8’, ‘1’, ‘Poitiers’, ‘FR-86’, ‘1’),
    (‘8’, ‘1’, ‘Pontoise’, ‘FR-95’, ‘1’),
    (‘8’, ‘1’, ‘Privas’, ‘FR-7’, ‘1’),
    (‘8’, ‘1’, ‘Quimper’, ‘FR-29’, ‘1’),
    (‘8’, ‘1’, ‘Rennes’, ‘FR-35’, ‘1’),
    (‘8’, ‘1’, ‘Rodez’, ‘FR-12’, ‘1’),
    (‘8’, ‘1’, ‘Ruan’, ‘FR-76’, ‘1’),
    (‘8’, ‘1’, ‘Saint-Brieuc’, ‘FR-22’, ‘1’),
    (‘8’, ‘1’, ‘Saint-Étienne’, ‘FR-42’, ‘1’),
    (‘8’, ‘1’, ‘Saint-Lô’, ‘FR-50’, ‘1’),
    (‘8’, ‘1’, ‘Tarbes’, ‘FR-65’, ‘1’),
    (‘8’, ‘1’, ‘Toulon’, ‘FR-83’, ‘1’),
    (‘8’, ‘1’, ‘Toulouse’, ‘FR-31’, ‘1’),
    (‘8’, ‘1’, ‘Tours’, ‘FR-37’, ‘1’),
    (‘8’, ‘1’, ‘Troyes’, ‘FR-10’, ‘1’),
    (‘8’, ‘1’, ‘Tulle’, ‘FR-19’, ‘1’),
    (‘8’, ‘1’, ‘Valence’, ‘FR-26’, ‘1’),
    (‘8’, ‘1’, ‘Vannes’, ‘FR-56’, ‘1’),
    (‘8’, ‘1’, ‘Versalles’, ‘FR-78’, ‘1’),
    (‘8’, ‘1’, ‘Vesoul’, ‘FR-70’, ‘1’);

    • Hola muy buenas tardes,

      Una pequeña anotación…. han colocado los nombres de capitales de provincia y tendría que ser el nombre de la provincia ya que puede surgir dudas a los clientes.

      Ejemplo:
      Nombre provincia: 94 Val-de-Marne
      Nombre capital de provincia: Créteil

      Un cordial saludo

      • Siguiendo el hilo de esta respuesto lo he modificado de la siguiente forma para que aparezcan los nombres de provincia (y no el de las capitales):

        INSERT INTO ps_state (id_country, id_zone, name, iso_code, active) VALUES
        (8, 1, “Lot-et-Garonne”, “FR-47”, 1),
        (8, 1, “Corse-du-Sud”, “FR-2A”, 1),
        (8, 1, “Tarn”, “FR-81”, 1),
        (8, 1, “Orne”, “FR-61”, 1),
        (8, 1, “Somme”, “FR-80”, 1),
        (8, 1, “Maine-et-Loire”, “FR-49”, 1),
        (8, 1, “Charente”, “FR-16”, 1),
        (8, 1, “Haute-Savoie”, “FR-74”, 1),
        (8, 1, “Pas-de-Calais”, “FR-62”, 1),
        (8, 1, “Gers”, “FR-32”, 1),
        (8, 1, “Cantal”, “FR-15”, 1),
        (8, 1, “Yonne”, “FR-89”, 1),
        (8, 1, “Vaucluse”, “FR-84”, 1),
        (8, 1, “Meuse”, “FR-55”, 1),
        (8, 1, “Haute-Corse”, “FR-2B”, 1),
        (8, 1, “Oise”, “FR-60”, 1),
        (8, 1, “Territoire de Belfort”, “FR-90”, 1),
        (8, 1, “Doubs”, “FR-25”, 1),
        (8, 1, “Loir-et-Cher”, “FR-41”, 1),
        (8, 1, “Seine-Saint-Denis”, “FR-93”, 1),
        (8, 1, “Ain”, “FR-1”, 1),
        (8, 1, “Cher”, “FR-18”, 1),
        (8, 1, “Gironde”, “FR-33”, 1),
        (8, 1, “Calvados”, “FR-14”, 1),
        (8, 1, “Lot”, “FR-46”, 1),
        (8, 1, “Aude”, “FR-11”, 1),
        (8, 1, “Puy-de-Dôme”, “FR-63”, 1),
        (8, 1, “Haut-Rhin”, “FR-68”, 1),
        (8, 1, “Val-de-Marne”, “FR-94”, 1),
        (8, 1, “Marne”, “FR-51”, 1),
        (8, 1, “Savoie”, “FR-73”, 1),
        (8, 1, “Ardennes”, “FR-8”, 1),
        (8, 1, “Eure-et-Loir”, “FR-28”, 1),
        (8, 1, “Indre”, “FR-36”, 1),
        (8, 1, “Haute-Marne”, “FR-52”, 1),
        (8, 1, “Alpes-de-Haute-Provence”, “FR-4”, 1),
        (8, 1, “Côte-dOr”, “FR-21”, 1),
        (8, 1, “Vosges”, “FR-88”, 1),
        (8, 1, “Bas-Rhin”, “FR-67”, 1),
        (8, 1, “Eure”, “FR-27”, 1),
        (8, 1, “Essonne”, “FR-91”, 1),
        (8, 1, “Ariège”, “FR-9”, 1),
        (8, 1, “Hautes-Alpes”, “FR-5”, 1),
        (8, 1, “Isère”, “FR-38”, 1),
        (8, 1, “Creuse”, “FR-23”, 1),
        (8, 1, “Charente-Maritime”, “FR-17”, 1),
        (8, 1, “Vendée”, “FR-85”, 1),
        (8, 1, “Aisne”, “FR-2”, 1),
        (8, 1, “Mayenne”, “FR-53”, 1),
        (8, 1, “Sarthe”, “FR-72”, 1),
        (8, 1, “Haute-Loire”, “FR-43”, 1),
        (8, 1, “Nord”, “FR-59”, 1),
        (8, 1, “Haute-Vienne”, “FR-87”, 1),
        (8, 1, “Jura”, “FR-39”, 1),
        (8, 1, “Rhône”, “FR-69”, 1),
        (8, 1, “Saone-et-Loire”, “FR-71”, 1),
        (8, 1, “Bouches-du-Rhône”, “FR-13”, 1),
        (8, 1, “Seine-et-Marne”, “FR-77”, 1),
        (8, 1, “Lozère”, “FR-48”, 1),
        (8, 1, “Moselle”, “FR-57”, 1),
        (8, 1, “Tarn-et-Garonne”, “FR-82”, 1),
        (8, 1, “Landes”, “FR-40”, 1),
        (8, 1, “Hérault”, “FR-34”, 1),
        (8, 1, “Allier”, “FR-3”, 1),
        (8, 1, “Meurthe-et-Moselle”, “FR-54”, 1),
        (8, 1, “Hauts-de-Seine”, “FR-92”, 1),
        (8, 1, “Loire-Atlantique”, “FR-44”, 1),
        (8, 1, “Nièvre”, “FR-58”, 1),
        (8, 1, “Gard”, “FR-30”, 1),
        (8, 1, “Deux-Sèvres”, “FR-79”, 1),
        (8, 1, “Alpes-Maritimes”, “FR-6”, 1),
        (8, 1, “Loiret”, “FR-45”, 1),
        (8, 1, “Paris”, “FR-75”, 1),
        (8, 1, “Pyrénées-Atlantiques”, “FR-64”, 1),
        (8, 1, “Dordogne”, “FR-24”, 1),
        (8, 1, “Pyrénées-Orientales”, “FR-66”, 1),
        (8, 1, “Vienne”, “FR-86”, 1),
        (8, 1, “Val-d”Oise”, “FR-95”, 1),
        (8, 1, “Ardèche”, “FR-7”, 1),
        (8, 1, “Finistère”, “FR-29”, 1),
        (8, 1, “Ille-et-Vilaine”, “FR-35”, 1),
        (8, 1, “Aveyron”, “FR-12”, 1),
        (8, 1, “Seine-Maritime”, “FR-76”, 1),
        (8, 1, “Côtes-dArmor”, “FR-22”, 1),
        (8, 1, “Loire”, “FR-42”, 1),
        (8, 1, “Manche”, “FR-50”, 1),
        (8, 1, “Hautes-Pyrénées”, “FR-65”, 1),
        (8, 1, “Var”, “FR-83”, 1),
        (8, 1, “Haute-Garonne”, “FR-31”, 1),
        (8, 1, “Indre-et-Loire”, “FR-37”, 1),
        (8, 1, “Aube”, “FR-10”, 1),
        (8, 1, “Corrèze”, “FR-19”, 1),
        (8, 1, “Drôme”, “FR-26”, 1),
        (8, 1, “Morbihan”, “FR-56”, 1),
        (8, 1, “Yvelines”, “FR-78”, 1),
        (8, 1, “Haute-Saone”, “FR-70”, 1);

  4. Para Portugal:
    INSERT INTO `ps_state` (`id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES
    (15, 1,’Açores’,’PT-AC’,’0′,’1′),
    (15, 1,’Aveiro’,’PT-AV’,’0′,’1′),
    (15, 1,’Beja’,’PT-BE’,’0′,’1′),
    (15, 1,’Braga’,’PT-BR’,’0′,’1′),
    (15, 1,’Bragança’,’PT-BA’,’0′,’1′),
    (15, 1,’Castelo Branco’,’PT-CB’,’0′,’1′),
    (15, 1,’Coimbra’,’PT-CO’,’0′,’1′),
    (15, 1,’Évora’,’PT-EV’,’0′,’1′),
    (15, 1,’Faro’,’PT-FA’,’0′,’1′),
    (15, 1,’Guarda’,’PT-GU’,’0′,’1′),
    (15, 1,’Leiria’,’PT-LE’,’0′,’1′),
    (15, 1,’Lisboa’,’PT-LI’,’0′,’1′),
    (15, 1,’Madeira’,’PT-MA’,’0′,’1′),
    (15, 1,’Portalegre’,’PT-PA’,’0′,’1′),
    (15, 1,’Porto’,’PT-PO’,’0′,’1′),
    (15, 1,’Santarém’,’PT-SA’,’0′,’1′),
    (15, 1,’Setúbal’,’PT-SE’,’0′,’1′),
    (15, 1,’Viana do Castelo’,’PT-VC’,’0′,’1′),
    (15, 1,’Vila Real’,’PT-VR’,’0′,’1′),
    (15, 1,’Viseu’,’PT-VI’,’0′,’1′);

  5. hola
    e puesto tu script en mi tienda de prestashop, pero tengo problemas por que aunque se han creado bien las privincias de España, a la hora de cobrar gastos de envió cobra a todas por igual, tanto melilla como canarias, como madrid

    y era por ver si me puedes ayudar

    gracias

    • Tienes que crear una zona específica , te pongo un ejemplo:

      Entrar en (Localización) + (Zona) + en la parte superior clicar la opción (Añadir nueva zona) y añades un nombre tipo “España y Portugal península”.

      El siguiente paso que tienes que hacer sería ir al apartado (Localización) + (seleccionar país) y te aparecerán todas las provincias. Selecciona todas las provincias menos las islas… una vez tengas todas las provincias, en la parte inferior de la pantalla podrás ver una opción que pone “Habilitar selección” pincha sobre el botón e indica la opción “Afecta a una nueva zona” , con este cambio podrás limitar el precio de los gastos de envío por provincias.

      Espero que te sirva, un cordial saludo.

  6. He realizado eso y me da el siguiente error….

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Coruña’, ‘ES-C’, 1), (6, 9, ‘Ã

    • Para solucionar el problema, pegué el código en el bloc de notas. Eliminé todos los saltos de línea generados por el código HTML de la web. Después dejé los nombres de los campos y la tabla sin esas comillas simples, y los valores alfanuméricos entre dobles comillas dobles. Así funcionó a la primera. publico el resultado.
      INSERT INTO ps_state (id_country, id_zone, name, iso_code, active) VALUES (6, 9, “La Coruña”, “ES-C”, 1), (6, 9, “Álava”, “ES-VI”, 1), (6, 9, “Albacete” ,”ES-AB”, 1), (6, 9, “Alicante”, “ES-A”, 1), (6, 9, “Almería”, “ES-AL”, 1), (6, 9, “Asturias”, “ES-O”, 1), (6, 9, “Ávila”, “ES-AV”, 1), (6, 9, “Badajoz”, “ES-BA”, 1), (6, 11, “Islas Baleares”, “ES-PM”, 1), (6, 9, “Barcelona”, “ES-B”, 1), (6, 9, “Burgos”, “ES-BU”, 1), (6, 9, “Cáceres”, “ES-CC”, 1), (6, 9, “Cádiz”, “ES-CA”, 1), (6, 9, “Cantabria”, “ES-S”, 1), (6, 9, “Castellón”, “ES-CS”, 1), (6, 12, “Ceuta”, “ES-CE”, 1), (6, 9, “Ciudad Real”, “ES-CR”, 1), (6, 9, “Córdoba”, “ES-CO”, 1), (6, 9, “Cuenca”, “ES-CU”, 1), (6, 9, “Gerona”, “ES-GI”, 1), (6, 9, “Granada”, “ES-GR”, 1), (6, 9, “Guadalajara”, “ES-GU”, 1), (6, 9, “Guipuzcoa”, “ES-SS”, 1), (6, 9, “Huelva”, “ES-H”, 1), (6, 9, “Huesca”, “ES-HU”, 1), (6, 9, “Jaén”, “ES-J”, 1), (6, 9, “La Rioja”, “ES-LO”, 1), (6, 10, “Las Palmas”, “ES-GC”, 1), (6, 9, “León”, “ES-LE”, 1), (6, 9, “Lérida”, “ES-L”, 1), (6, 9, “Lugo”, “ES-LU”, 1), (6, 9, “Madrid”, “ES-M”, 1), (6, 9, “Málaga”, “ES-MA”, 1), (6, 12, “Melilla”, “ES-ML”, 1), (6, 9, “Murcia”, “ES-MU”, 1), (6, 9, “Navarra”, “ES-NA”, 1), (6, 9, “Orense”, “ES-OR”, 1), (6, 9, “Palencia”, “ES-P”, 1), (6, 9, “Pontevedra”, “ES-PO”, 1), (6, 9, “Salamanca”, “ES-SA”, 1), (6, 10, “Santa Cruz de Tenerife”, “ES-TF”, 1), (6, 9, “Segovia”, “ES-SG”, 1), (6, 9, “Sevilla”, “ES-SE”, 1), (6, 9, “Soria”, “ES-SO”, 1), (6, 9, “Tarragona”, “ES-T”, 1), (6, 9, “Teruel”, “ES-TE”, 1), (6, 9, “Toledo”, “ES-TO”, 1), (6, 9, “Valencia”, “ES-V”, 1), (6, 9, “Valladolid”, “ES-VA”, 1), (6, 9, “Vizcaya”, “ES-BI”, 1), (6, 9, “Zamora”, “ES-ZA”, 1), (6, 9, “Zaragoza”, “ES-Z”, 1);

  7. Hola muy buenos dias a tod@s!

    Llevo poco tiempo utilizando Prestashop ya que he decidido recientemente cambiar toda la tienda virtual.

    Sobre el tema de las provincias, no hace falta meterse en phpMyadmin ni crear bases SQL ya que almenos en la versión Prestashop 1.6.0 hay la siguiente opción:

    Meterse en el apartado “Localización” + “Provincias”, elegimos un pais entre todos los que tengamos dado de alta, por ejemplo Portugal. Una vez metidos en el apartado Portugal, nos fijamos en la parte superior de la pantalla y clicamos en “Añadir nuevo estado”

    Una vez estemos dentro del apartado “Añadir nuevo estado” tendremos que rellenar los siguientes datos: “Nombre de la provincia” + “Código ISO” + “País” (en nuestro caso Portugal) + “Zona” (en mi caso he creado España y Portugal península ibérica, así podré diferenciar los gastos de envío para las islas) , en el apartado “Estado” lo dejamos en SÍ y guardamos.

    Con estos sencillos pasos podremos crear de forma muy rápida todas las provincias que deseemos, espero que os sirva de ayuda 🙂

    Un cordial saludo!

  8. Hola, enhorabuena por el post. He salido de varias dudas, pero tengo algunas por si puedes ayudar.

    He metido solo reino unido, a mano ya que no tengo acceso a mi phpadmin.
    Me gustaria saber como localizar las zonas de Reino Unido, tengo metidas todas las provincias pero todas en la zona de Reino Unido, no se si es necesaria que cree cada zona, o simplemente con la provincia ya elegida me serviría.

    No consigo localizar un listado de Reino Unido, clasificándome las provincias de las zona, Inglaterra, Gales, Escocia…tienen todos el mismo código de país y de zona.

    Un saludo, y gracias de nuevo

  9. Por si a alguien le da error enganchando desde phpmyadmin, he hecho ajuste en las comillas y ya me lo ha aceptado. Gracias por el aporte David.

    INSERT INTO ps_state (id_country, id_zone, name, iso_code, active) VALUES (6, 9, ‘La Coruña’, ‘ES-C’, 1), (6, 9, ‘Álava’, ‘ES-VI’, 1), (6, 9, ‘Albacete’ ,’ES-AB’, 1), (6, 9, ‘Alicante’, ‘ES-A’, 1), (6, 9, ‘Almería’, ‘ES-AL’, 1), (6, 9, ‘Asturias’, ‘ES-O’, 1), (6, 9, ‘Ávila’, ‘ES-AV’, 1), (6, 9, ‘Badajoz’, ‘ES-BA’, 1), (6, 11, ‘Islas Baleares’, ‘ES-PM’, 1), (6, 9, ‘Barcelona’, ‘ES-B’, 1), (6, 9, ‘Burgos’, ‘ES-BU’, 1), (6, 9, ‘Cáceres’, ‘ES-CC’, 1), (6, 9, ‘Cádiz’, ‘ES-CA’, 1), (6, 9, ‘Cantabria’, ‘ES-S’, 1), (6, 9, ‘Castellón’, ‘ES-CS’, 1), (6, 12, ‘Ceuta’, ‘ES-CE’, 1), (6, 9, ‘Ciudad Real’, ‘ES-CR’, 1), (6, 9, ‘Córdoba’, ‘ES-CO’, 1), (6, 9, ‘Cuenca’, ‘ES-CU’, 1), (6, 9, ‘Gerona’, ‘ES-GI’, 1), (6, 9, ‘Granada’, ‘ES-GR’, 1), (6, 9, ‘Guadalajara’, ‘ES-GU’, 1), (6, 9, ‘Guipuzcoa’, ‘ES-SS’, 1), (6, 9, ‘Huelva’, ‘ES-H’, 1), (6, 9, ‘Huesca’, ‘ES-HU’, 1), (6, 9, ‘Jaén’, ‘ES-J’, 1), (6, 9, ‘La Rioja’, ‘ES-LO’, 1), (6, 10, ‘Las Palmas’, ‘ES-GC’, 1), (6, 9, ‘León’, ‘ES-LE’, 1), (6, 9, ‘Lérida’, ‘ES-L’, 1), (6, 9, ‘Lugo’, ‘ES-LU’, 1), (6, 9, ‘Madrid’, ‘ES-M’, 1), (6, 9, ‘Málaga’, ‘ES-MA’, 1), (6, 12, ‘Melilla’, ‘ES-ML’, 1), (6, 9, ‘Murcia’, ‘ES-MU’, 1), (6, 9, ‘Navarra’, ‘ES-NA’, 1), (6, 9, ‘Orense’, ‘ES-OR’, 1), (6, 9, ‘Palencia’, ‘ES-P’, 1), (6, 9, ‘Pontevedra’, ‘ES-PO’, 1), (6, 9, ‘Salamanca’, ‘ES-SA’, 1), (6, 10, ‘Santa Cruz de Tenerife’, ‘ES-TF’, 1), (6, 9, ‘Segovia’, ‘ES-SG’, 1), (6, 9, ‘Sevilla’, ‘ES-SE’, 1), (6, 9, ‘Soria’, ‘ES-SO’, 1), (6, 9, ‘Tarragona’, ‘ES-T’, 1), (6, 9, ‘Teruel’, ‘ES-TE’, 1), (6, 9, ‘Toledo’, ‘ES-TO’, 1), (6, 9, ‘Valencia’, ‘ES-V’, 1), (6, 9, ‘Valladolid’, ‘ES-VA’, 1), (6, 9, ‘Vizcaya’, ‘ES-BI’, 1), (6, 9, ‘Zamora’, ‘ES-ZA’, 1), (6, 9, ‘Zaragoza’, ‘ES-Z’, 1);

Deixa un comentari

L'adreça electrònica no es publicarà. Els camps necessaris estan marcats amb *