Jump to content

Leaderboard


Popular Content

Showing content with the highest reputation since 08/15/2019 in all areas

  1. 1 point
    Este mensaje fue actualizado el día 14 de Septiembre del 2013. MODULO LISTO: PARA PRESTASHOP 1.4.6.2 Que hace: Actualiza stock Actualiza precios Descarga de clientes registrados Descarga de pedidos Aviso de registro en la tienda Que no hace: Crear referencias en ninguno de los 2 sentidos. Lo pongo de descarga desde el foro ya que recibi un mp diciendo de ponerlo sin link externo, así que ya esta puesto en el foro xD 1 Saludo a tod@s. Script 403: Requisitos: Factusol (Da igual versión) siempre que exporte tarifas. Prestashop (Da igual versión). Microsoft excel o Open Office. Datos BD. Acceso FTP. FACTUSOL: -Tenemos que ir a INFORMES/ARTICULOS -Una vez seleccionado la salida del archivo y como queréis tener ordenado el listado, lo generamos. -Abrir el archivo generado y localizar las columnas donde se almacena la información que queremos exportar a prestashop,(Precio de compra(costo), Precio PVP sin IVA, stock, referencia de producto y borrar la cabecera de la tabla. IMPORTANTE: LA REFERENCIA DEBE SER IGUAL EN LOS 2 SISTEMAS. -Cuando ya sabemos a qué columna pertenece la información le daremos a guardar como y seleccionaremos como nombre update y como extensión CSV(separado por comas) quedando así: update.csv. -Ahora cogemos el archivo 403.rar y lo descomprimimos, dentro se encuentra el archivo 403.php, lo abrimos con cualquier procesador de textos (note ++) y modificamos las siguientes líneas. -Añadimos los datos de nuestra base de datos, para la conexión del script con Prestashop. mysql_connect("localhost", "Nombre Usuario BD", "Contraseña") mysql_select_db("Nombre de la BD") -Asegurarnos que en las líneas 32, 41, 49 y 58 está asociada la columna a la que pertenecen nuestros datos de update.csv //Precio PVP if ($c == 5) -Una vez concluidos estos pasos, introducimos en la carpeta 403 los archivos 403.php(modificado) y update.csv (generado de Factusol). Procedemos a subir por FTP la carpeta 403 donde este nuestra tienda. -Ahora viene lo mejor……… -Accedemos por el navegador a la ruta donde hemos puesto la carpeta y archivo 403, http://www.tudominio.com/403/403.php -Automáticamente el script entra en funcionamiento y coteja en primera instancia que coincida la referencia del CSV con la de Prestashop y posteriormente actualiza precios y stock masivamente, dando el ok al final. -Si faltara alguna referencia en la web que está en Factusol, te genera un archivo falta.txt en la carpeta del ftp. Y con esto y un bizcocho hasta mañana a las ocho xD. Descarga directa aquí , ya que no veo la posibilidad de subir un nuevo archivo. PrestaFactu.zip
  2. 1 point
    Witam Poszukujemy doświadczonego programisty prestashop na dłuższa współprace z naszą firmą Zajmujemy się sprzedarzą mebli online posiadamy dwa sklepy w systemie Prestashop 1.6 Zakres prac - optymalizacja, tj. przyśpieszenie działania sklepu - reakcja w przypadku awarii - modyfikowanie szablonu - instalacji i dostosowaniu wizualnym modułow - tworzenie modułow dedykowanych Wymagania - Poszukujemy doświadczonego programistce oferta nie jest aktualna dla osób początkujących- - Osoba odpowiedzialna terminowa Oferujemy: Dobre wynagrodzenie finansowe Pozdrawiam
  3. 1 point
    Hi there, am working on Prestashop backend for a client, now they need to expand the system so it will be great if I get a few clarifications and experience from you. 1.Is that Prestashop is a good option if we have too much customization needed 2.we need more accounting visibility like sales by product and HR management,and ERP so is there any plugin to do this. 3.We need more statics and reports so is that possible to pull data from db to presta admin panel please let me know your valuable suggestions Thanks
  4. 1 point
  5. 1 point
    Ürünlerinizi N11 e kolayca aktabilir ve N11 üzerinden satış yapabilirsiniz. Prestashop N11 entegrasyonu hızlı ve güvenle ürün aktarımı sağlamaktadır. Özellikleri Tek tıklama ile tüm ürünlerinizi N11 aktarma Kategori bazlı veya Tüm kategorileri seçme N11 kategori eşleşme Ürün fiyatını N11 e aktarırken komisyon oranını belirleme VIDEO IZLE SATIN AL
  6. 1 point
    Concernant le module payant (Addon) il fonctionne, mais celui dévellopé par e-transaction toujours pas, malgré mes relances et malgré l'aide offerte par ttoine... On me répond on attend des nouvelles du dévellopeur qui a fait le module qui ne fonctionne pas avec les nouvelles directives de Prestashop.
  7. 1 point
    This small module will let you edit your products or categories directly from your front office. This is ideal tool to quickly adjust content that is being displayed on your store without the need to switch to your back office and search for the correct entity. You can test the functionality live on my demo server And you can purchase it here. The module is compatible with both ps16 and ps17 At the moment, module allows you to edit products and categories. You can change texts like name or description, seo fields, and more (enable or disable product, disable purchase button, etc. ). In the future, I plan to add support for other pages as well - CMS pages, blog posts, manufacturers, suppliers, etc. I will also implement modification of other fields (features, quantities, images,...). If you purchase module now, you will be able to upgrade to *all* future versions for free.
  8. 1 point
  9. 1 point
    Cdiscount : "Commander", il s'embarrassent pas de détails eux.. honnêtement, je pense que tout le monde se masturbe le cerveau pour pas grand chose..
  10. 1 point
    lol, yeah sure get me here in nowhereland. Legal consequences. Take that umbrella off your ass.
  11. 1 point
    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);
  12. 1 point
    I find it here : https://github.com/PrestaShop/psgdpr/releases I click on link psgdpr.zip
  13. 1 point
    Wyszła nowa aktualizacja, w której uwzględniono tą funkcjonalność 😀
  14. 1 point
    Halo, kali ini saya mau share module untuk cek ongkir menggunakan API dari raja ongkir. Module ini include JNE, TIKI dan POS. Untuk detailnya cek aja di mari : https://immanueljl.blogspot.co.id/2017/08/module-hitung-ongkir-jne-tiki-pos.html Dukung pengembangan module ini dengan like & share
  15. 1 point
    La verdad es que recomendar Woocomerce que en algunos ámbitos está mucho mas limitado que Magento, Prestashop, etc que sí son CMS puros de tiendas en vez de un blog de mierda maqueado, dice mucho de ellos..
  16. 1 point
    Sur la page produit si tu utilises : $_SERVER['HTTP_REFERER'] Tu sais d'ou vient ton client. Il existe même un variable smarty qui se nomme $come_from https://www.team-ever.com/les-variables-smarty-de-prestashop/
  17. 1 point
    How to get delivery address state id variable in pdf/ invoice.tpl file, I have tried State::getNameById({$addresses.invoice->id_state}) but it is not working ... I want to check the customer's delivery state I am using PrestaShop version: 1.6.0.5 -------------------------------------------------------------------------------------------- Solution:- delivery & billing address is same you need to assign this $invoice_address->id_state; in HTMLTemplateInvoice.php delivery & billing address differ you need to assign $delivery_address->id_state; in HTMLTemplateInvoice.php . and catch the variable in invoice.tpl
  18. 1 point
    from your shops admin international-->locations-->countries for each country remove the zip format https://www.screencast.com/t/rmq6RbRS
  19. 1 point
    Finally got it working!! Pascal gave me the idea with the password thing, in fact there was the error. I was saving the password unencrypted, thus the code to accomplish the task as follows: <?php require(dirname(__FILE__).'/config/config.inc.php'); $context=Context::getContext(); $_POST['lastname']='Chavez'; $_POST['firstname']='Hugo'; $_POST['customer_lastname']=$_POST['lastname']; $_POST['customer_firstname']=$_POST['firstname']; $_POST['phone']='5411123456780'; $_POST['email']='hchavez3@gmail.com'; // Checked the user address in case he changed his email address if (Validate::isEmail($email = Tools::getValue('email')) && !empty($email)) if (Customer::customerExists($email)) die('An account using this email address has already been registered.'); // Preparing customer $customer = new Customer(); $lastnameAddress = Tools::getValue('lastname'); $firstnameAddress = Tools::getValue('firstname'); $_POST['lastname'] = Tools::getValue('customer_lastname'); $_POST['firstname'] = Tools::getValue('customer_firstname'); $error_phone = false; $customer->lastname=$lastnameAddress; $customer->firstname =$firstnameAddress; $pwd='wsxedc'; $customer->passwd=md5(pSQL(_COOKIE_KEY_.$pwd)); $customer->email=$_POST['email']; if (Configuration::get('PS_ONE_PHONE_AT_LEAST')) { if (Tools::isSubmit('submitGuestAccount') || !Tools::getValue('is_new_customer')) { if (!Tools::getValue('phone') && !Tools::getValue('phone_mobile')) $error_phone = true; } elseif (((Configuration::get('PS_REGISTRATION_PROCESS_TYPE') && Configuration::get('PS_ORDER_PROCESS_TYPE')) || (Configuration::get('PS_ORDER_PROCESS_TYPE') && !Tools::getValue('email_create'))) && (!Tools::getValue('phone') && !Tools::getValue('phone_mobile'))) $error_phone = true; elseif (((Configuration::get('PS_REGISTRATION_PROCESS_TYPE') && Configuration::get('PS_ORDER_PROCESS_TYPE') && Tools::getValue('email_create'))) && (!Tools::getValue('phone') && !Tools::getValue('phone_mobile'))) $error_phone = true; } if ($error_phone) die('You must register at least one phone number.'); if (!Configuration::get('PS_REGISTRATION_PROCESS_TYPE') && !Tools::isSubmit('submitGuestAccount')) { $customer->firstname = Tools::ucwords($customer->firstname); $customer->birthday = (empty($_POST['years']) ? '' : (int)$_POST['years'].'-'.(int)$_POST['months'].'-'.(int)$_POST['days']); if (!Validate::isBirthDate($customer->birthday)) die('Invalid date of birth.'); // New Guest customer $customer->is_guest = (Tools::isSubmit('is_new_customer') ? !Tools::getValue('is_new_customer', 1) : 0); $customer->active = 1; if ($customer->add()) { updateContext($customer); //$context->cart->update(); /* Hook::exec('actionCustomerAccountAdd', array( '_POST' => $_POST, 'newCustomer' => $customer ));*/ die("listo?"); } else die('An error occurred while creating your account.'); } function updateContext(Customer $customer) { global $context; $context->customer = $customer; $context->smarty->assign('confirmation', 1); $context->cookie->id_customer = (int)$customer->id; $context->cookie->customer_lastname = $customer->lastname; $context->cookie->customer_firstname = $customer->firstname; $context->cookie->passwd = $customer->passwd; $context->cookie->logged = 1; // if register process is in two steps, we display a message to confirm account creation if (!Configuration::get('PS_REGISTRATION_PROCESS_TYPE')) $context->cookie->account_created = 1; $customer->logged = 1; $context->cookie->email = $customer->email; $context->cookie->is_guest = !Tools::getValue('is_new_customer', 1); // Update cart address $context->cart->secure_key = $customer->secure_key; } Thank you very much guys!
  20. 1 point
    _PS_ROOT_DIR_."/testadmin" This will give you full path to the admin directory. The _PS_ROOT_DIR_ is used to get the PS complete path to directory where it is installed.
  21. 1 point
    you've got this message only when you're unlogged? i checked your website and I can browse the categories problem solved?
  22. 1 point
    I had the same problem, after some searching I found out that the search-index is not complete, just rebuild it: Go into your back office, select Preferences->Search. You should see a section called Indexation (sp) click Re-build entire index. That should fix your problems, just for all the people who got the same problem.
  23. 1 point
    You shouldn't modify ProductController.php, use the override folder to create a file ProductController.php in controllers folders with this class : class ProductController extends ProductControllerCore { } and add in this class the method you want to modify from the original ProductController.php file, and apply midiman fix then. So when you will upgrade your PrestaShop to next version, you won't loose your modifications.
  24. 1 point
    The root directory of PrestaShop. If you have installed PrestaShop in your public_html directory, it should be here. If you installed PrestaShop in its own prestashop directory, it should be in that prestashop directory.
  25. 1 point
    I realize I'm a bit late posting and hopefully you've already figured it out, but if not... The problem is most default server installations have don't allow FollowSymLinks To fix it just add the line: Options FollowSymLinks somewhere at the top of your htaccess file. I put mine just below the RewriteEngine on line. # URL rewriting module activation RewriteEngine on Options FollowSymLinks # URL rewriting rules ...
×

Important Information

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