Prestashop, el mundo del café y las cápsulas de café.

Después de mucho tiempo sin escribir nada en mi blog. Me he planteado empezar a escribir de dos cosas de las que creo que tengo bastante experiencia.

Una es el café y las capsulas de café, llevo desde 1990 dedicado al vending, al café y unos años después al mundo de las cápsulas de café.

El otro tema del que puedo ayudar o del que considero que a base de prueba y error he aprendido bastante es de Prestashop, por lo que creo que son dos temas de los que puedo hablar.

No se si tendré tiempo pues llevo muchas, pero voy a hacer un esfuerzo e intentarlo.

Añadir provincias de Grecia a Prestashop 1.6

Viendo que Google me estaba enviando a gente de Grecia a visitar mi web de venta de cápsulas de café CAPSULARIUM  . Dicen que es de bien nacido ser agradecido y yo he pensado que no es lógico que si los griegos vienen a visitar mi tienda y quieren comprar unas cápsulas de café o unas infusiones o unas chocolatinas típicas de España, que no lo puedan hacer. Mi sorpresa ha sido que prestashop por defecto no lleva las provincias de Grecia. Tirando de Wikipedia, he creado la siguiente consulta SQL, para añadir las provincias a nuestro prestashop. Es el mismo sistema que en el post anterior http://davidmogort.com/anadir-provincias-espana-francia-portugal-alemania-o-reino-unido-a-prestashop-1-6/

La consulta SQL para añadir las provincias de Grecia es la siguiente:

Grecia:

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

(1021, 9, 19, ‘Anatoliki Makedonia kai Thraki’, ‘GR-A’, 0, 1),
(1022, 9, 19, ‘Attiki’, ‘GR-I’, 0, 1),
(1023, 9, 19, ‘Dytiki Ellada’, ‘GR-G’, 0, 1),
(1024, 9, 19, ‘Dytiki Makedonia’, ‘GR-C’, 0, 1),
(1025, 9, 19, ‘Ionia Nisia’, ‘GR-F’, 0, 1),
(1026, 9, 19, ‘Ipeiros’, ‘GR-D’, 0, 1),
(1027, 9, 19, ‘Kentriki Makedonia’, ‘GR-B’, 0, 1),
(1028, 9, 19, ‘Kriti’, ‘GR-M’, 0, 1),
(1029, 9, 19, ‘Notio Aigaio’, ‘GR-L’, 0, 1),
(1030, 9, 19, ‘Peloponnisos’, ‘GR-J’, 0, 1),
(1031, 9, 19, ‘Sterea Ellada’, ‘GR-H’, 0, 1),
(1032, 9, 19, ‘Thessalia’, ‘GR-E’, 0, 1),
(1033, 9, 19, ‘Voreio Aigaio’, ‘GR-K’, 0, 1);

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.

Saludo

David Mogort