Jump to content
PatriciaDU

Chile, configuración de LOCALIZACION para luego configurar transportes

Recommended Posts

No tengo la verdad absoluta, solamente aporto mis ideas, si alguien sabe cómo hacerlo mejor, bienvenida/o.
 
Cómo configurar la LOCALIZACION que luego usaremos para el precio del transporte:
 
Como nuestra web vende solamente en Chile, la configuramos de la siguiente manera:
 
Eliminamos todos los países, dejando solamente a Chile.
 
Eliminamos todas las regiones.
 
Eliminamos todas las zonas geográficas dejando solamente South America.
 
Ingresamos a las zonas geográficas cada una de las 14 regiones de Chile, más la Metropolitana, escribiendo
Nombre: I Región de Tarapacá, y la activamos. Hasta llegar a la XIV Región de Arica y parinacota para luego la Región Metropolitana.
 
Luego ingresamos en Estados, las Regiones de Chile nuevamente
Nombre: I Región de Tarapacá
Código ISO: CL-TA
País: Chile
Zona: I Región de Tarapacá
Activar: SI
Les dejo el código ISO de cada Región
I Región Tarapacá CL-TA
II Región de Antofagasta CL-AN
III Región Atacama CL-AT
IV Región Coquimbo CL-CO
V Región Valparaíso CL-VS
VI Región Libertador B. O'Higgins CL-LI
VII Región Maule CL-ML
VIII Región Biobío CL-BI
IX Región Araucanía CL-AR
X Región Los Lagos CL-LL
XI Región Aysén del Gral. C. Ibañez CL-AI
XII Región Magallanes y Antártica CL-MA
XIII Región Los Ríos CL-LR
XIV Región Arica y Parinacota CL-AP
Metropolitana de Santiago CL-RM
 
------------------------------
 
Ahora Configuraremos TRANSPORTE:
 
En el caso de nuestra web se paga el transporte y se paga lo que cobra la empresa nada más, ya que en el precio del producto hemos recargado el valor del sobre en que se enviará. Vendemos joyas que van en caja, así que solamente se pone la cajita dentro de un sobre y listo.
 
Por lo tanto configuramos de esta forma:
 
Gastos de mantenimiento . $0 (después exlicaré dónde se configura para que el signo pesos vaya antes del número.
 
Envío gratuito a partir de $50.000 o el valor que ustedes deseen, nosotras con ese valor en ventas lo enviamos gratis.
 
Envío gratuto a partir de 0Kg, esta línea nos pide en kilos, pero nosotros lo hacemos gratis según el monto de la compra.
 
Opciones del transportista
 
Aquí se configura la forma que se presentan en el formulario de cómo los veremos nosotros y en el formulario del front office cuando el cliente va a escoger un transportista, Nosotras lo hicimos de tal forma que el transportista 
que cobra menos aparezca primero.
 
Transportista por defecto: Mejor precio
Orden por defecto para los transportistas: Precio
Orden por defecto para los transportistas: Ascendente (así aparecen en el Frontis)

----

Ahora ya podemos cargar los transportista que usaremos.

 

Nosotras escogimos Chilexpress, Correos de Chile y Tur Bus Cargo

 

Ingresamos a los sitios webs de cada una de estas empresas y vimos los precios para la Capital regional solamente y ese aplicamos.

 

Vimos el tiempo de demora para cada una de esas ciudades y ese aplicamos.

 

Pusimos en las webs de los transportistas. Ciudad de Origen La Serena, Ciudad de destino: fuimos poniendo todas las capitales regionales y además ingresamos con el doble de la medida de nuestra caja (que generalmente nos compran dos) y el doble del peso, que una caja pesa 0.3 kg. Y al poner el peso nos dimos cuenta que hasta 5Kg es el mismo valor, ellos también tienen rangos.

 

Ingresamos a TRANSPORTISTAS, añadir nuevo

 

Nombre del transportista: Chilexpress

 

Tiempo de tránsito: ¡Entrega día siguiente! III, IV, V, VI y RM. Demás regiones día subsiguiente (desde La Serena, ojo)

 

Grado de velocidad : 9 (son los más rápidos)

 

Logo: de la misma web de Chilexpress descargamos la imagen y la achicamos 
http://www.arrakasta.cl/img/chilexpresschico.jpg
de aquí la descargan

 

URL de seguimiento: http://www.chilexpress.cl/courier.asp

 

SIGUIENTE, ya tenemos la primera parte del formulario listo

 

Gastos de envío y preparación: NO ya expliqué que no cobramos el sobre ni los pasajes para llevarlo al transportista

 

Aplicar los gastos de envío: SI

 

Facturación: De acuerdo al peso total 

 

Impuestos: Ninguna tasa ya que usamos todo con IVA incluído

 

Fuera de la gama de comportamiento: Aplicar el coste más alto de la gama definida
Cuando seleccionamos de acuerdo al peso se despliegan los casilleros que hay que llenar con cuidado para que no terminemos pagando nosotras el envío.

 

Será aplicado cuando el peso sea (mayor o igual > =) 0.0 kg

 

Será aplicado cuando el peso sea (menor que < = 5.0 kg les expliqué que el valor no cambia en los transportistas 

 

All (Todos) queda en blanco ya que cada Región tiene su valor especial

 

y aparecen nuestras Zonas
I región de Tarapacá= SI (tickear) 3.850
II                                                     3.570

South America                                2.340

 

Estos valores son DESDE LA SERENA a las otras capitales, ustedes no están aquí así que deben ingresar a la web de Chilexpress y ver sus valores.

 

En South America pusimos el valor que corresponde a la Región de Coquimbo, no lo dejen en blanco porque tendrán problemas después cuando el cliente llena el formulario ya que Chile está dentro de esta zona y aparecerá un mensaje de error diciendo que no hay transportista para esa ciudad.

 

Suponiendo que ya llenaron todas las regiones

 

SIGUIENTE

 

Altura máxima del paquete 100 OJO está en centímetros y 1 metro es el máximo que acepta como encomienda

 

Anchura y Profundidad igual 100 cm

 

Peso máximo del paquete 5kg ya que no mandaremos nada más pesado que eso y ahí habría que agregar en el paso anterior otro rango entre 5.1 a 10.1 o algo así

 

Acceso del grupo, seleccionamos a todos.

 

SIGUIENTE, aparece un resumen, verlo tranquilamente, si está todo bien le damos a TERMINAR
Y así agregaremos Tur Bus Cargo con su logo 

http://www.arrakasta.cl/img/turbus-cargo1chico.jpg
y la dirección de seguimiento
 
https://www.turbus.cl/wtbus/indexCargoSeguimiento.jsf

y la de Correos de Chile
http://www.arrakasta.cl/img/logo_correosmaschico.jpg
y la dirección de seguimiento
http://www.correos.cl/SitePages/empresa/productos/encomiendas/nacional.aspx

  • Like 5

Share this post


Link to post
Share on other sites

Tema movido a la sección de:

Módulos gratis, sobrecargas y otras astucias que cambian la vida.

Share this post


Link to post
Share on other sites

Nadie: ¿Me traslado al de Módulos etc?

 

El tema fue movido a la sección de Aportes gratuitos.

 

La sección de aportes gratuitos, son tanto guías, como módulos, como plantillas, etc..

  • Like 1

Share this post


Link to post
Share on other sites

Te he fusionado también el otro mensaje que has escrito en este mismo tema en el primer mensaje, ponlo en el primer mensaje lo que es la guía completa de transportes y localización, no en distintos mensajes.

 

PD: Gracias por su colaboración con la Comunidad de Prestashop.

Share this post


Link to post
Share on other sites

Nadie, pensé que se van a marear, confundir, por eso fuí paso a paso, pero tú sabes mejor como son los foreros. 

No supe como subir la imagen de los transportistas por eso di el link para que los descargaran de mi web, pero no es la idea, si puedes arreglar eso, regio.

Share this post


Link to post
Share on other sites

Nadie, pensé que se van a marear, confundir, por eso fuí paso a paso, pero tú sabes mejor como son los foreros.

Te he fusionado otra vez el mensaje.

 

Todo en un mismo mensaje, y por favor mete intros a los párrafos la próxima vez, he tenido que meterte yo los intros de forma rápida en el mensaje porque tenias todos los párrafos juntos y pegados.

 

Si puedes mete también negritas, para distinguir partes del texto.

 

También tienes la opción de preparar un documento en tu ordenador, y subir ese documento como guía, asi sera mas cómodo.

 

PD: Gracias por su colaboración con la Comunidad de Prestashop.

Share this post


Link to post
Share on other sites

Me funciona, para mi tienda en Chile, 

aun lo estoy probando.

 

Mi consulta es la siguiente como logra que el cliente pueda seleccionar la region:

 

Escoja Región de DESTINO DEL PAQUETE para ver precios, más adelante lo seleccionará

 

A mi me entrega el valor de forma automática (según la dirección que el cliente tenga registrada)

 

Saludos gracias por el aporte

Share this post


Link to post
Share on other sites

Muchas gracias! Me sirvió.

 

Una duda. ¿Hay alguna forma de configurar un transportista que envíe "por pagar"? ("a portes debidos")

 

Gracias.

Share this post


Link to post
Share on other sites
Posted (edited)

Hola tengo una consulta compré  Modulo Chilexpress y no reconoce las ciudades chilenas cuando un usuario las registra  sin la primera letra mayúscula , simplemente no las reconoce y en la opción transportista no te da elegir Chilexpress . Me gustaría que alguien me ayudara Por ahora solo voy a escribir un texto que diga lo que hacer junto a la palabra ciudades , pero si alguien sabe si se puede crear un selector de ciudades , o picar el código javascript para que la primera letra de la ciudad  se transforme en mayúscula automática,, o picar la base de datos. o simplemente configurar algo. Agradecería alguna respuesta

Edited by Nanito (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites

Estimado mi colaboracion a la causa, Para gente de Chile les dejo mi compocicion.

Si alguien tiene la de transporte se lo agradeceria.

Item 1 - Pais

INSERT INTO `ps_country` (`id_country`, `id_zone`, `id_currency`, `iso_code`, `call_prefix`, `active`, `contains_states`, `need_identification_number`, `need_zip_code`, `zip_code_format`, `display_tax_label`) VALUES
(1, 13, 0, 'CL', 56, 1, 0, 0, 1, 'NNNNNNN', 1);

Item 2 -- Regiones

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(1, 'I Tarapacá', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(2, 'II Antofagasta', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(3, 'III Atacama', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(4, 'IV Coquimbo', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(5, 'V Valparaíso', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(6, 'VI Libertador General Bernardo O''Higgins', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(7, 'VII Maule', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(8, 'VIII Bío - Bío', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(9, 'IX Araucanía', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(10, 'X Los Lagos', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(11, 'XI Aysén del General Carlos Ibáñez del Campo', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(12, 'XII Magallanes y de la Antártica Chilena', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(13, 'RM - Región Metropolitana', 1);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(14, 'XIV Los Ríos', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(15, 'XV Arica y Parinacota', 0);
INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(16, 'XVI Nuble', 0);

Item 3 - Regiones y Ciudades

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(1, 'I Tarapacá', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Iquique", "01101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Alto Hospicio", "01107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Pozo Almonte", "01401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Camiña", "01402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Colchane", "01403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Huara", "01404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 1, "Pica", "01405", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(2, 'II Antofagasta', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Antofagasta", "02101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Mejillones", "02102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Sierra Gorda", "02103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Taltal", "02104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Calama", "02201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Ollagüe", "02202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "San Pedro de Atacama", "02203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "Tocopilla", "02301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 2, "María Elena", "02302", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(3, 'III Atacama', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Copiapó", "03101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Caldera", "03102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Tierra Amarilla", "03103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Chañaral", "03201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Diego de Almagro", "03202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Vallenar", "03301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Alto del Carmen", "03302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Freirina", "03303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 3, "Huasco", "03304", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(4, 'IV Coquimbo', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "La Serena", "04101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Coquimbo", "04102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Andacollo", "04103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "La Higuera", "04104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Paiguano", "04105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Vicuña", "04106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Illapel", "04201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Canela", "04202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Los Vilos", "04203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Salamanca", "04204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Ovalle", "04301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Combarbalá", "04302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Monte Patria", "04303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Punitaqui", "04304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 4, "Río Hurtado", "04305", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(5, 'V Valparaíso', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Valparaíso", "05101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Casablanca", "05102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Concón", "05103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Juan Fernández", "05104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Puchuncaví", "05105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Quintero", "05107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Viña del Mar", "05109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Isla de Pascua", "05201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Los Andes", "05301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Calle Larga", "05302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Rinconada", "05303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "San Esteban", "05304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "La Ligua", "05401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Cabildo", "05402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Papudo", "05403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Petorca", "05404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Zapallar", "05405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Quillota", "05501", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Calera", "05502", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Hijuelas", "05503", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "La Cruz", "05504", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Nogales", "05506", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "San Antonio", "05601", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Algarrobo", "05602", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Cartagena", "05603", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "El Quisco", "05604", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "El Tabo", "05605", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Santo Domingo", "05606", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "San Felipe", "05701", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Catemu", "05702", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Llaillay", "05703", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Panquehue", "05704", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Putaendo", "05705", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Santa María", "05706", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Quilpué", "05801", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Limache", "05802", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Olmué", "05803", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 5, "Villa Alemana", "05804", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(6, 'VI Libertador General Bernardo O''Higgins', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Rancagua", "06101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Codegua", "06102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Coinco", "06103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Coltauco", "06104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Doñihue", "06105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Graneros", "06106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Las Cabras", "06107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Machalí", "06108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Malloa", "06109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Mostazal", "06110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Olivar", "06111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Peumo", "06112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Pichidegua", "06113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Quinta de Tilcoco", "06114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Rengo", "06115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Requínoa", "06116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "San Vicente", "06117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Pichilemu", "06201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "La Estrella", "06202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Litueche", "06203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Marchihue", "06204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Navidad", "06205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Paredones", "06206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "San Fernando", "06301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Chépica", "06302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Chimbarongo", "06303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Lolol", "06304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Nancagua", "06305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Palmilla", "06306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Peralillo", "06307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Placilla", "06308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Pumanque", "06309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 6, "Santa Cruz", "06310", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(7, 'VII Maule', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Talca", "07101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Constitución", "07102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Curepto", "07103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Empedrado", "07104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Maule", "07105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Pelarco", "07106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Pencahue", "07107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Río Claro", "07108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "San Clemente", "07109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "San Rafael", "07110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Cauquenes", "07201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Chanco", "07202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Pelluhue", "07203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Curicó", "07301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Hualañé", "07302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Licantén", "07303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Molina", "07304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Rauco", "07305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Romeral", "07306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Sagrada Familia", "07307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Teno", "07308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Vichuquén", "07309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Linares", "07401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Colbún", "07402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Longaví", "07403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Parral", "07404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Retiro", "07405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "San Javier", "07406", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Villa Alegre", "07407", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 7, "Yerbas Buenas", "07408", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(8, 'VIII Bío - Bío', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Concepción", "08101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Coronel", "08102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Chiguayante", "08103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Florida", "08104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Hualqui", "08105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Lota", "08106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Penco", "08107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Pedro de la Paz", "08108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Santa Juana", "08109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Talcahuano", "08110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Tomé", "08111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Hualpén", "08112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Lebu", "08201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Arauco", "08202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Cañete", "08203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Contulmo", "08204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Curanilahue", "08205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Los Álamos", "08206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Tirúa", "08207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Los Ángeles", "08301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Antuco", "08302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Cabrero", "08303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Laja", "08304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Mulchén", "08305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Nacimiento", "08306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Negrete", "08307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Quilaco", "08308", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Quilleco", "08309", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Rosendo", "08310", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Santa Bárbara", "08311", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Tucapel", "08312", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Yumbel", "08313", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Alto Biobío", "08314", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Chillán", "08401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Bulnes", "08402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Cobquecura", "08403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Coelemu", "08404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Coihueco", "08405", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Chillán Viejo", "08406", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "El Carmen", "08407", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Ninhue", "08408", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Ñiquén", "08409", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Pemuco", "08410", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Pinto", "08411", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Portezuelo", "08412", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Quillón", "08413", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Quirihue", "08414", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Ránquil", "08415", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Carlos", "08416", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Fabián", "08417", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Ignacio", "08418", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "San Nicolás", "08419", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Treguaco", "08420", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 8, "Yungay", "08421", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(9, 'IX Araucanía', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Temuco", "09101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Carahue", "09102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Cunco", "09103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Curarrehue", "09104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Freire", "09105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Galvarino", "09106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Gorbea", "09107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Lautaro", "09108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Loncoche", "09109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Melipeuco", "09110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Nueva Imperial", "09111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Padre Las Casas", "09112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Perquenco", "09113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Pitrufquén", "09114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Pucón", "09115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Saavedra", "09116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Teodoro Schmidt", "09117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Toltén", "09118", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Vilcún", "09119", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Villarrica", "09120", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Cholchol", "09121", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Angol", "09201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Collipulli", "09202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Curacautín", "09203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Ercilla", "09204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Lonquimay", "09205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Los Sauces", "09206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Lumaco", "09207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Purén", "09208", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Renaico", "09209", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Traiguén", "09210", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 9, "Victoria", "09211", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(10, 'X Los Lagos', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Puerto Montt", "10101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Calbuco", "10102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Cochamó", "10103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Fresia", "10104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Frutillar", "10105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Los Muermos", "10106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Llanquihue", "10107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Maullín", "10108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Puerto Varas", "10109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Castro", "10201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Ancud", "10202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Chonchi", "10203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Curaco de Vélez", "10204", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Dalcahue", "10205", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Puqueldón", "10206", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Queilén", "10207", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Quellón", "10208", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Quemchi", "10209", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Quinchao", "10210", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Osorno", "10301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Puerto Octay", "10302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Purranque", "10303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Puyehue", "10304", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Río Negro", "10305", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "San Juan de la Costa", "10306", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "San Pablo", "10307", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Chaitén", "10401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Futaleufú", "10402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Hualaihué", "10403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 10, "Palena", "10404", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(11, 'XI Aysén del General Carlos Ibáñez del Campo', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Coyhaique", "11101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Lago Verde", "11102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Aysén", "11201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Cisnes", "11202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Guaitecas", "11203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Cochrane", "11301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "O’Higgins", "11302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Tortel", "11303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Chile Chico", "11401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 11, "Río Ibáñez", "11402", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(12, 'XII Magallanes y de la Antártica Chilena', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Punta Arenas", "12101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Laguna Blanca", "12102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Río Verde", "12103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "San Gregorio", "12104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Cabo de Hornos", "12201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Antártica", "12202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Porvenir", "12301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Primavera", "12302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Timaukel", "12303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Natales", "12401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 12, "Torres del Paine", "12402", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(13, 'RM - Región Metropolitana', 1);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Santiago", "13101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Cerrillos", "13102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Cerro Navia", "13103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Conchalí", "13104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "El Bosque", "13105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Estación Central", "13106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Huechuraba", "13107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Independencia", "13108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "La Cisterna", "13109", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "La Florida", "13110", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "La Granja", "13111", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "La Pintana", "13112", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "La Reina", "13113", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Las Condes", "13114", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Lo Barnechea", "13115", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Lo Espejo", "13116", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Lo Prado", "13117", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Macul", "13118", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Maipú", "13119", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Ñuñoa", "13120", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Pedro Aguirre Cerda", "13121", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Peñalolén", "13122", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Providencia", "13123", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Pudahuel", "13124", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Quilicura", "13125", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Quinta Normal", "13126", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Recoleta", "13127", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Renca", "13128", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San Joaquín", "13129", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San Miguel", "13130", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San Ramón", "13131", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Vitacura", "13132", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Puente Alto", "13201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Pirque", "13202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San José de Maipo", "13203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Colina", "13301", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Lampa ", "13302", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Tiltil", "13303", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San Bernardo", "13401", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Buin", "13402", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Calera de Tango", "13403", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Paine", "13404", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Melipilla", "13501", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Alhué", "13502", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Curacaví", "13503", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "María Pinto", "13504", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "San Pedro", "13505", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Talagante", "13601", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "El Monte", "13602", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Isla de Maipo", "13603", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Padre Hurtado", "13604", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 13, "Peñaflor", "13605", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(14, 'XIV Los Ríos', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Valdivia", "14101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Corral", "14102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Lanco", "14103", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Los Lagos", "14104", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Máfil", "14105", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Mariquina", "14106", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Paillaco", "14107", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Panguipulli", "14108", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "La Unión", "14201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Futrono", "14202", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Lago Ranco", "14203", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 14, "Río Bueno", "14204", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(15, 'XV Arica y Parinacota', 0);


INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 15, "Arica", "15101", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 15, "Camarones", "15102", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 15, "Putre", "15201", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 15, "General Lagos", "15202", 0, 1);

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`) VALUES(16, 'XVI Nuble', 0);

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 16, "Diguillín", "16100", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 16, "Itata", "16200", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (1, 16, "Punilla", "16300", 0, 1);

  • Thanks 3

Share this post


Link to post
Share on other sites

Gracias , Excelente aporte estimado.. pero acá tu das otra forma ...  la persona que inicio el post sugiere poner las regiones nuevamente en  ps state

Tu estas mostrando que hay que poner las comunas en ps state , bien osea ahora no sale las regiones salen las comunas aun asi ,

en la parte donde poner la ciudad todavia no me acepta , osea las graba pero el modulo de prestashop no las toma si no van con letra mayuscula

la primera letra. 

Share this post


Link to post
Share on other sites
On 5/30/2019 at 2:06 PM, @Balthazar said:

Te pasaste, me ahorraste ene pega.

Cómo te lo pago wn.!!!

Wooow!

 

 

Share this post


Link to post
Share on other sites
40 minutes ago, WroKeN said:

Qué bueno que te sirvió, soy wna. Me lo pagarás haciendo la diferencia cuando hables de femenino, por ejemplo: ellos y ellas (el elles es un chiste que inventaron los hombres para desprestigiar el ellas), las y los niños, las mamás y los papás, etc. Tu hija te lo agradecerá a ti y así hacemos una cadena de agradecimientos for ever.

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More