Prestashop – cargar provincias de España via SQL

Hay que tener creadas las zonas previamente (id_zone)

[cc]
INSERT INTO `ps_state` (`id_state`,`id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES
(313, 6, 9, ‘La Coruña’, ‘C’, 0, 1),
(314, 6, 9, ‘Álava’, ‘VI’, 0, 1),
(315, 6, 9, ‘Albacete’ ,’AB’, 0, 1),
(316, 6, 9, ‘Alicante’, ‘A’, 0, 1),
(317, 6, 9, ‘Almería’, ‘AL’, 0, 1),
(318, 6, 9, ‘Asturias’, ‘O’, 0, 1),
(319, 6, 9, ‘Ávila’, ‘AV’, 0, 1),
(320, 6, 9, ‘Badajoz’, ‘BA’, 0, 1),
(321, 6, 11, ‘Islas Baleares’, ‘PM’, 0, 1),
(322, 6, 9, ‘Barcelona’, ‘B’, 0, 1),
(323, 6, 9, ‘Burgos’, ‘BU’, 0, 1),
(324, 6, 9, ‘Cáceres’, ‘CC’, 0, 1),
(325, 6, 9, ‘Cádiz’, ‘CA’, 0, 1),
(326, 6, 9, ‘Cantabria’, ‘S’, 0, 1),
(327, 6, 9, ‘Castellón’, ‘CS’, 0, 1),
(328, 6, 12, ‘Ceuta’, ‘CE’, 0, 1),
(329, 6, 9, ‘Ciudad Real’, ‘CR’, 0, 1),
(330, 6, 9, ‘Córdoba’, ‘CO’, 0, 1),
(331, 6, 9, ‘Cuenca’, ‘CU’, 0, 1),
(332, 6, 9, ‘Gerona’, ‘GI’, 0, 1),
(333, 6, 9, ‘Granada’, ‘GR’, 0, 1),
(343, 6, 9, ‘Guadalajara’, ‘GU’, 0, 1),
(345, 6, 9, ‘Guipuzcoa’, ‘SS’, 0, 1),
(346, 6, 9, ‘Huelva’, ‘H’, 0, 1),
(347, 6, 9, ‘Huesca’, ‘HU’, 0, 1),
(348, 6, 9, ‘Jaén’, ‘J’, 0, 1),
(349, 6, 9, ‘La Rioja’, ‘LO’, 0, 1),
(350, 6, 10, ‘Las Palmas’, ‘GC’, 0, 1),
(351, 6, 9, ‘León’, ‘LE’, 0, 1),
(352, 6, 9, ‘Lérida’, ‘L’, 0, 1),
(353, 6, 9, ‘Lugo’, ‘LU’, 0, 1),
(354, 6, 9, ‘Madrid’, ‘M’, 0, 1),
(355, 6, 9, ‘Málaga’, ‘MA’, 0, 1),
(356, 6, 12, ‘Melilla’, ‘ML’, 0, 1),
(357, 6, 9, ‘Murcia’, ‘MU’, 0, 1),
(358, 6, 9, ‘Navarra’, ‘NA’, 0, 1),
(359, 6, 9, ‘Orense’, ‘OR’, 0, 1),
(360, 6, 9, ‘Palencia’, ‘P’, 0, 1),
(361, 6, 9, ‘Pontevedra’, ‘PO’, 0, 1),
(362, 6, 9, ‘Salamanca’, ‘SA’, 0, 1),
(363, 6, 10, ‘Santa Cruz de Tenerife’, ‘TF’, 0, 1),
(364, 6, 9, ‘Segovia’, ‘SG’, 0, 1),
(365, 6, 9, ‘Sevilla’, ‘SE’, 0, 1),
(366, 6, 9, ‘Soria’, ‘SO’, 0, 1),
(367, 6, 9, ‘Tarragona’, ‘T’, 0, 1),
(368, 6, 9, ‘Teruel’, ‘TE’, 0, 1),
(369, 6, 9, ‘Toledo’, ‘TO’, 0, 1),
(370, 6, 9, ‘Valencia’, ‘V’, 0, 1),
(371, 6, 9, ‘Valladolid’, ‘VA’, 0, 1),
(372, 6, 9, ‘Vizcaya’, ‘BI’, 0, 1),
(373, 6, 9, ‘Zamora’, ‘ZA’, 0, 1),
(374, 6, 9, ‘Zaragoza’, ‘Z’, 0, 1);
[/cc]

Leave a Reply

Your email address will not be published. Required fields are marked *