News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Chilean states

Started by razor7, September 01, 2016, 00:54:48 AM

Previous topic - Next topic

razor7

Hi, I have created this list of countries for Chile, please include it in future releases of VM. Code 2 is ISO ISO_3166-2:CL

Thanks!

INSERT INTO `#_virtuemart_states` (`virtuemart_state_id`, `virtuemart_country_id`, `virtuemart_worldzone_id`, `state_name`, `state_3_code`, `state_2_code`, `published`) VALUES
(730,43,0,'Aysén del General Carlos Ibáñez del Campo','AII','AI',1),
(731,43,0,'Antofagasta','ANN','AN',1),
(732,43,0,'Arica y Parinacota','APP','AP',1),
(733,43,0,'Araucanía','ARR','AR',1),
(734,43,0,'Atacama','ATT','AT',1),
(735,43,0,'Biobío','BII','BI',1),
(736,43,0,'Coquimbo','COO','CO',1),
(737,43,0,'Libertador General Bernardo O\'Higgins','LII','LI',1),
(738,43,0,'Los Lagos','LLL','LL',1),
(739,43,0,'Los Ríos','LRR','LR',1),
(740,43,0,'Magallanes y la Antártica Chilena','MAA','MA',1),
(741,43,0,'Maule','MLL','ML',1),
(742,43,0,'Metropolitana de Santiago','RMM','RM',1),
(743,43,0,'Tarapacá','TAA','TA',1),
(744,43,0,'Valparaíso','VSS','VS',1);
MGS Creativa - VirtueMart Payment Plugin Experts
http://www.mgscreativa.com

Take a look at our downloads section for VirtueMart payment plugins and mouch more!
http://www.mgscreativa.com/en/online-store

razor7

Hi! according to this two sites, I have modified the Chile states SQL query and attached to this thread, I think it's quite comprehensive for the ISO 2 and 3 states code. Hope it helps

http://www.editorialox.com/provinciasdechile.htm
http://www.statoids.com/ycl.html

PS: remember to change #__ with your joomla! table prefix!
MGS Creativa - VirtueMart Payment Plugin Experts
http://www.mgscreativa.com

Take a look at our downloads section for VirtueMart payment plugins and mouch more!
http://www.mgscreativa.com/en/online-store