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