Prestashop – desactivar todos los países

[cc] UPDATE ps_country SET active=0 WHERE iso_code NOT LIKE ‘GB’
[/cc]

Valor ID de la zona península es: 9

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);

One thought on “Prestashop – desactivar todos los países

Leave a Reply

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