Script para incluir las provincias de España en Prestashop.
Después de ejecutar el script, hay que activar dentro del país que admite "Estados" que es la traducción que tiene Prestashop para referirse a las provincias.
Este script se ha probado con MySQL 5 y es válido para las siguientes zonas con estos ID:
9 Península
10 Islas Canarias
11 Baleares
12 Ceuta y Melilla
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Álava", "ALA", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Albacete", "ALB", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Alicante", "ALC", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Almería", "ALM", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Asturias", "AST", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Ávila", "AVL", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Badajoz", "BDJ", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 11, "Islas Baleares", "BLS", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Barcelona", "BCN", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Burgos", "BUG", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Cáceres", "CCR", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Cádiz", "CAD", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Cantabria", "CNT", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Castellón", "CST", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 12, "Ceuta", "CET", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Ciudad Real", "CRE", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Córdoba", "COR", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Cuenca", "CUE", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Gerona", "GIR", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Granada", "GRA", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Guadalajara", "GUA", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Guipúzcoa", "GIZ", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Huelva", "HUV", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Huesca", "HUS", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Jaén", "JAN", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "La Coruña", "COR", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "La Rioja", "LRJ", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Las Palmas", "LPS", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "León", "LEO", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Lérida", "LER", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Lugo", "LUG", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Madrid", "MAD", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Málaga", "MAG", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 12, "Melilla", "MEL", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Murcia", "MUR", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Navarra", "NAV", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Orense", "ORE", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Palencia", "ESP", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Pontevedra", "PNT", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Salamanca", "SAL", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 10, "Santa Cruz de Tenerife", "STF", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Segovia", "SGV", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Sevilla", "SEV", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Soria", "SOR", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Tarragona", "TAR", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Teruel", "TER", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Toledo", "TOL", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Valencia", "VLN", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Valladolid", "VAL", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Vizcaya", "VIZ", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Zamora", "ZAM", 0, 1); INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (6, 9, "Zaragoza", "ZAG", 0, 1);
Muy buena tu aportación Javier.
Aún asi necesito una explicación para dummies. Donde se ejecuta el script? Donde hay que instalarlo? Donde debe quedar guardada toda esa información?
Y en el caso de tu aportación, ya que no es un instalador... Donde se edita para poder ponerlo?
Muchas gracias
Tienes que ejecutarlo sobre la base de datos, desde PHPMyAdmin o MySQL Query Browser… hay muchos. Desde el que elijas podrás editarlo.
Las provincias te saldrán dentro de la pestaña Transporte en “Estados”.
Saludos.