(Solucionado) Importar provincias y códigos postales

[LuisValencia]

Buenos días a todos,

Antes de hacer la consulta he estado buscado en el Foro y hay tantísima información sobre este tema que no me he aclarado y me da miedo tocar la Base de Datos.

Estoy utilizando la V. 1.4.8.2 y lo que necesito es ver como importar o dar de alta las provincias, poblaciones y códigos postales de España. Sólo voy a vender en España.

Si alguien conoce algún modulo específico, agradecería tambien la información del mismo.

Gracias.

Edited October 31, 2012 by LuisValencia (see edit history)

[soyseke]

Prueba con esto:

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, 9, “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, 9, “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 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, 9, “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, “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, 9, “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);

 

[nadie]

SET NAMES 'utf8';

--
-- Agregamos las zonas de España
--

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES
(9, 'Peninsula', 1),
(10, 'Canarias', 1),
(11, 'Baleares', 1),
(12, 'Ceuta y Melilla', 1);

--
-- Preparamos el campo ISO_CODE para aceptar 5 caracteres
--

ALTER TABLE `ps_state` MODIFY `iso_code` char(5) NOT NULL;

--
-- Agregamos las provincias y asignamos su zona
--

INSERT INTO `ps_state` (`id_state`,`id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES
(123, 6, 9, 'La Coruña', 'C', 0, 1),
(124, 6, 9, 'Álava', 'VI', 0, 1),
(125, 6, 9, 'Albacete' ,'AB', 0, 1),
(126, 6, 9, 'Alicante', 'A', 0, 1),
(127, 6, 9, 'Almería', 'AL', 0, 1),
(128, 6, 9, 'Asturias', 'O', 0, 1),
(129, 6, 9, 'Ávila', 'AV', 0, 1),
(130, 6, 9, 'Badajoz', 'BA', 0, 1),
(131, 6, 11, 'Islas Baleares', 'PM', 0, 1),
(132, 6, 9, 'Barcelona', 'B', 0, 1),
(133, 6, 9, 'Burgos', 'BU', 0, 1),
(134, 6, 9, 'Cáceres', 'CC', 0, 1),
(135, 6, 9, 'Cádiz', 'CA', 0, 1),
(136, 6, 9, 'Cantabria', 'S', 0, 1),
(137, 6, 9, 'Castellón', 'CS', 0, 1),
(138, 6, 12, 'Ceuta', 'CE', 0, 1),
(139, 6, 9, 'Ciudad Real', 'CR', 0, 1),
(140, 6, 9, 'Córdoba', 'CO', 0, 1),
(141, 6, 9, 'Cuenca', 'CU', 0, 1),
(142, 6, 9, 'Gerona', 'GI', 0, 1),
(143, 6, 9, 'Granada', 'GR', 0, 1),
(144, 6, 9, 'Guadalajara', 'GU', 0, 1),
(145, 6, 9, 'Guipuzcoa', 'SS', 0, 1),
(146, 6, 9, 'Huelva', 'H', 0, 1),
(147, 6, 9, 'Huesca', 'HU', 0, 1),
(148, 6, 9, 'Jaén', 'J', 0, 1),
(149, 6, 9, 'La Rioja', 'LO', 0, 1),
(150, 6, 10, 'Las Palmas', 'GC', 0, 1),
(151, 6, 9, 'León', 'LE', 0, 1),
(152, 6, 9, 'Lérida', 'L', 0, 1),
(153, 6, 9, 'Lugo', 'LU', 0, 1),
(154, 6, 9, 'Madrid', 'M', 0, 1),
(155, 6, 9, 'Málaga', 'MA', 0, 1),
(156, 6, 12, 'Melilla', 'ML', 0, 1),
(157, 6, 9, 'Murcia', 'MU', 0, 1),
(158, 6, 9, 'Navarra', 'NA', 0, 1),
(159, 6, 9, 'Orense', 'OR', 0, 1),
(160, 6, 9, 'Palencia', 'P', 0, 1),
(161, 6, 9, 'Pontevedra', 'PO', 0, 1),
(162, 6, 9, 'Salamanca', 'SA', 0, 1),
(163, 6, 10, 'Santa Cruz de Tenerife', 'TF', 0, 1),
(164, 6, 9, 'Segovia', 'SG', 0, 1),
(165, 6, 9, 'Sevilla', 'SE', 0, 1),
(166, 6, 9, 'Soria', 'SO', 0, 1),
(167, 6, 9, 'Tarragona', 'T', 0, 1),
(168, 6, 9, 'Teruel', 'TE', 0, 1),
(169, 6, 9, 'Toledo', 'TO', 0, 1),
(170, 6, 9, 'Valencia', 'V', 0, 1),
(171, 6, 9, 'Valladolid', 'VA', 0, 1),
(172, 6, 9, 'Vizcaya', 'BI', 0, 1),
(173, 6, 9, 'Zamora', 'ZA', 0, 1),
(174, 6, 9, 'Zaragoza', 'Z', 0, 1);

--
-- Activamos los estados en España
--

UPDATE `ps_country` SET `contains_states` = 1 WHERE `id_country` = 6;

 

Fuente: http://www.fjaguero.com/blog/provincias-en-prestashop-1-4/

[LuisValencia]

Gracias a los dos. El problema que tengo ahora es que como me urgía me he puesto a "trastear" en el backoffice e insertado manualmente laz zonas y las provincias y ahora resulta que al ir a dar de alta una cuenta el campo país aparece bloqueado no deja insertarlo y no permite el registro. Me he quedado totalmente paralizado, ahora no se como salir de esto.

Había puesto otro post con este problema.

http://www.prestashop.com/forums/topic/199036-problema-con-formulario-crear-cuenta/

[LuisValencia]

Gracias de nuevo.

Menos mal que había hecho copia de seguridad, lo he recuperado todo y he podido importar las provincias sin problemas.

[nadie]

Gracias de nuevo.

Menos mal que había hecho copia de seguridad, lo he recuperado todo y he podido importar las provincias sin problemas.

 

Me alegro, de que al final hayas podido realizar la inserción con éxito.

 

Para cualquier otra duda, recuerda que estaremos por el foro, para guiarte por este mundo oscuro y tenebroso.

[mirni]

nadie, necesito ayuda. He ejecutado lo que pusiste, tal cual y me da este error:

Error

 

consulta SQL:

--

-- Agregamos las zonas de España

--

INSERT INTO `ps_zone` ( `id_zone` , `name` , `active` )

VALUES ( 9, 'Peninsula', 1 ) , ( 10, 'Canarias', 1 ) , ( 11, 'Baleares', 1 ) , ( 12, 'Ceuta y Melilla', 1 ) ;

 

MySQL ha dicho:

#1062 - Duplicate entry '9' for key 'PRIMARY'

[mirni]

Lo curioso es que hay una opción en localizaciones donde supuestamente se pueden importar los estados de "Spain"

Lo hago y no importa nada.

[varekay]

nadie, necesito ayuda. He ejecutado lo que pusiste, tal cual y me da este error:

Error

 

consulta SQL:

--

-- Agregamos las zonas de España

--

INSERT INTO `ps_zone` ( `id_zone` , `name` , `active` )

VALUES ( 9, 'Peninsula', 1 ) , ( 10, 'Canarias', 1 ) , ( 11, 'Baleares', 1 ) , ( 12, 'Ceuta y Melilla', 1 ) ;

 

MySQL ha dicho:

#1062 - Duplicate entry '9' for key 'PRIMARY'

 

Ese error es porque ya tienes una zona con el id 9, y te dice que ya existe. Pon otro codigo y deberia dejarte insertarla

[mirni]

gracias, ya lo he solucionado, me salté esa parte, total, yo ya tenía bien delimitadas las zonas, solo me interesa insertas las provincias.