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

Actualizar PRESTASHOP a 1.6

Aun que estamos en plena semana fallera en Valencia, os presento el nuevo cambio a PRESTASHOP 1,6 RC 4. Es una tienda que está en producción pero poca de momento.  Después de hablar en el e-show Barcelona 2014 con uno de los técnicos de PRESTASHOP, Hace mucho tiempo que no chapurreaba nada de francés. Me comento el técnico que no había ningún problema en que me bajara la última versión de github y que el día 17 cuando llegara la versión oficial que volviera a actualizar y que no pasaba nada.  Al final después de varias pruebas y no terminándome de convencer el resultado, decidí empezar de cero, ya que tenía solo una docena de artículos en esta web. Bueno no me enrollo más, os envío el link por si le queréis dar un vistazo antes de animaros a actualizar una tienda en producción real.  Saludos y felicidades anticipadas a todos los pepes, joses, pepas, Josefas.

OBSOLESCÈNCIA PROGRAMADA

 

Tot  va vindre a arrel d’un documental que vaig veure a TVE L’any passat. Encara que és molt interessant crec que no el voldreu veure ara complet, dura 52 minuts .

En els temps actuals en que estem vivint, Crisi, ja fa 4 anys d’allò de  Lehman Brothers , veies el telediari (eixe que els de Tavernes  i els de Benifairó diuen que a Simat el fan un hora abans)  a un tall d’executius  amb les caixes de cartró amb tots els seus objectes personals eixir de les oficines de Lehman Brothers, i algun que eixos dies fruit de la desesperació i d’alguna aposta molt arriscada a la borsa de New York, eixia mes lleuger però per la finestra dels edificis. Després de les retallades que estem patint, el funcionaris, el pensionistes amb la pèrdua de poder adquisitiu, les empreses amb la minva de guanys i en molts casos en pèrdues fins i tot haver que tancar. La pèrdua de 560.000 autònoms i xicotets empresaris durant  els 4 últims anys. La crisi de la rajola , la de la banca, etc.  etc.
Bé  torne  al Documental, doncs això que es un xic que té una impressora i que de sobte deixa de funcionar, ell la revisa i veu que està tot correcte. La porta a reparar a diverses tendes d’informàtica  i tots li diuen que no té solució o que val més d’arreglar del que val una nova.  Buscant pel Google veu que la impressora té un comptador intern que està programada per a que una certa quantitat de còpies, l’aparell deixe de funcionar. O siga que tu compres la impressora i si no es trenca per  l’ús, te la trenquen ells.  Això més o menys dit en poques paraules és la OBSOLESCÈNCIA PROGRAMADA.  Este xic va tindre sort i va baixar un programa d’internet que va  fer un reset i el comptador es va posar a zero i la impressora va tornar a funcionar. El primer cas de obsolescència programada va ser el dels fabricants de perilles , no pot ser que en 1900 i pico una bombeta de la llum segons els anuncis de l’època tingueren una durada de 2.500 hores i hui després de 100 anys sols duren 1.000 hores.  En 1924 una agrupació de fabricants de bombetes elèctriques es posaren d’acord i varen limitar la vida útil de les bombetes a  1.000 hores (que llests). Encara que açò mai va passar dit per ells, el documental diu que el grup es deia PHOEBUS.
A part del tema MEDIAMBIENTAL, estè també el tema ECONòMIC. Els  consumidors, no deuríem consentir que ens prenguen el pèl i els diners d’eixa manera.
Gràcies per el teu temps.
David