Adding countries

When I set up a new store, I copied my other store's database. That database only has about 5 countries. Now, I need all the countries that came with ZC by default. What's the quickest way to add this? I do have another dB with all the countries - I just don't know how to export and import just the country table via MySQL. TIA!

Figured it out. Thx.

What is the secret to your success? :smile:

I also need to know this!
We were only taking orders from the US, but now that Google Checkout and Paypal are installed, we want to accept orders from outside of the US for those methods....

Which brings on my next question...
I want anyone to be able to checkout using Google or Paypal, but give ONLY the US and possibly Canada the ability to use the default checkout method. If I am correct, I would just select the zones in the payment modules?

You want to double-check this list before pasting it into the SQL update screen. Some characters might need a \ (backslash) in front of it. You probably want to check the database to make sure that the numbers (countries_id) don't conflict either. I am not an SQL expert at all, so use at your own risk!

insert into countries (countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id) values
('240','Aaland Islands','AX','ALA','1')
('1','Afghanistan','AF','AFG','1'),
('2','Albania','AL','ALB','1'),
('3','Algeria','DZ','DZA','1'),
('4','American Samoa','AS','ASM','1'),
('5','Andorra','AD','AND','1'),
('6','Angola','AO','AGO','1'),
('7','Anguilla','AI','AIA','1'),
('8','Antarctica','AQ','ATA','1'),
('9','Antigua and Barbuda','AG','ATG','1'),
('10','Argentina','AR','ARG','1'),
('11','Armenia','AM','ARM','1'),
('12','Aruba','AW','ABW','1'),
('13','Australia','AU','AUS','1'),
('14','Austria','AT','AUT','5'),
('15','Azerbaijan','AZ','AZE','1'),
('16','Bahamas','BS','BHS','1'),
('17','Bahrain','BH','BHR','1'),
('18','Bangladesh','BD','BGD','1'),
('19','Barbados','BB','BRB','1'),
('20','Belarus','BY','BLR','1'),
('21','Belgium','BE','BEL','1'),
('22','Belize','BZ','BLZ','1'),
('23','Benin','BJ','BEN','1'),
('24','Bermuda','BM','BMU','1'),
('25','Bhutan','BT','BTN','1'),
('26','Bolivia','BO','BOL','1'),
('27','Bosnia and Herzegowina','BA','BIH','1'),
('28','Botswana','BW','BWA','1'),
('29','Bouvet Island','BV','BVT','1'),
('30','Brazil','BR','BRA','1'),
('31','British Indian Ocean Territory','IO','IOT','1'),
('32','Brunei Darussalam','BN','BRN','1'),
('33','Bulgaria','BG','BGR','1'),
('34','Burkina Faso','BF','BFA','1'),
('35','Burundi','BI','BDI','1'),
('36','Cambodia','KH','KHM','1'),
('37','Cameroon','CM','CMR','1'),
('38','Canada','CA','CAN','1'),
('39','Cape Verde','CV','CPV','1'),
('40','Cayman Islands','KY','CYM','1'),
('41','Central African Republic','CF','CAF','1'),
('42','Chad','TD','TCD','1'),
('43','Chile','CL','CHL','1'),
('44','China','CN','CHN','1'),
('45','Christmas Island','CX','CXR','1'),
('46','Cocos (Keeling) Islands','CC','CCK','1'),
('47','Colombia','CO','COL','1'),
('48','Comoros','KM','COM','1'),
('49','Congo','CG','COG','1'),
('50','Cook Islands','CK','COK','1'),
('51','Costa Rica','CR','CRI','1'),
('52','Cote D'Ivoire','CI','CIV','1'),
('53','Croatia','HR','HRV','1'),
('54','Cuba','CU','CUB','1'),
('55','Cyprus','CY','CYP','1'),
('56','Czech Republic','CZ','CZE','1'),
('57','Denmark','DK','DNK','1'),
('58','Djibouti','DJ','DJI','1'),
('59','Dominica','DM','DMA','1'),
('60','Dominican Republic','DO','DOM','1'),
('61','East Timor','TP','TMP','1'),
('62','Ecuador','EC','ECU','1'),
('63','Egypt','EG','EGY','1'),
('64','El Salvador','SV','SLV','1'),
('65','Equatorial Guinea','GQ','GNQ','1'),
('66','Eritrea','ER','ERI','1'),
('67','Estonia','EE','EST','1'),
('68','Ethiopia','ET','ETH','1'),
('69','Falkland Islands (Malvinas)','FK','FLK','1'),
('70','Faroe Islands','FO','FRO','1'),
('71','Fiji','FJ','FJI','1'),
('72','Finland','FI','FIN','1'),
('73','France','FR','FRA','1'),
('74','France Metropolitan','FX','FXX','1'),
('75','French Guiana','GF','GUF','1'),
('76','French Polynesia','PF','PYF','1'),
('77','French Southern Territories','TF','ATF','1'),
('78','Gabon','GA','GAB','1'),
('79','Gambia','GM','GMB','1'),
('80','Georgia','GE','GEO','1'),
('81','Germany','DE','DEU','5'),
('82','Ghana','GH','GHA','1'),
('83','Gibraltar','GI','GIB','1'),
('84','Greece','GR','GRC','1'),
('85','Greenland','GL','GRL','1'),
('86','Grenada','GD','GRD','1'),
('87','Guadeloupe','GP','GLP','1'),
('88','Guam','GU','GUM','1'),
('89','Guatemala','GT','GTM','1'),
('90','Guinea','GN','GIN','1'),
('91','Guinea-bissau','GW','GNB','1'),
('92','Guyana','GY','GUY','1'),
('93','Haiti','HT','HTI','1'),
('94','Heard and Mc Donald Islands','HM','HMD','1'),
('95','Honduras','HN','HND','1'),
('96','Hong Kong','HK','HKG','1'),
('97','Hungary','HU','HUN','1'),
('98','Iceland','IS','ISL','1'),
('99','India','IN','IND','1'),
('100','Indonesia','ID','IDN','1'),
('101','Iran (Islamic Republic of)','IR','IRN','1'),
('102','Iraq','IQ','IRQ','1'),
('103','Ireland','IE','IRL','1'),
('104','Israel','IL','ISR','1'),
('105','Italy','IT','ITA','1'),
('106','Jamaica','JM','JAM','1'),
('107','Japan','JP','JPN','1'),
('108','Jordan','JO','JOR','1'),
('109','Kazakhstan','KZ','KAZ','1'),
('110','Kenya','KE','KEN','1'),
('111','Kiribati','KI','KIR','1'),
('112','Korea Democratic People's Republic of','KP','PRK','1'),
('113','Korea Republic of','KR','KOR','1'),
('114','Kuwait','KW','KWT','1'),
('115','Kyrgyzstan','KG','KGZ','1'),
('116','Lao People's Democratic Republic','LA','LAO','1'),
('117','Latvia','LV','LVA','1'),
('118','Lebanon','LB','LBN','1'),
('119','Lesotho','LS','LSO','1'),
('120','Liberia','LR','LBR','1'),
('121','Libyan Arab Jamahiriya','LY','LBY','1'),
('122','Liechtenstein','LI','LIE','1'),
('123','Lithuania','LT','LTU','1'),
('124','Luxembourg','LU','LUX','1'),
('125','Macau','MO','MAC','1'),
('126','Macedonia The Former Yugoslav Republic of','MK','MKD','1'),
('127','Madagascar','MG','MDG','1'),
('128','Malawi','MW','MWI','1'),
('129','Malaysia','MY','MYS','1'), 
('130','Maldives','MV','MDV','1'),
('131','Mali','ML','MLI','1'),
('132','Malta','MT','MLT','1'), 
('133','Marshall Islands','MH','MHL','1'),
('134','Martinique','MQ','MTQ','1'),
('135','Mauritania','MR','MRT','1'),
('136','Mauritius','MU','MUS','1'),
('137','Mayotte','YT','MYT','1'),
('138','Mexico','MX','MEX','1'),
('139','Micronesia Federated States of','FM','FSM','1'),
('140','Moldova Republic of','MD','MDA','1'),
('141','Monaco','MC','MCO','1'),),
('142','Mongolia','MN','MNG','1'),
('143','Montserrat','MS','MSR','1'),
('144','Morocco','MA','MAR','1'),
('145','Mozambique','MZ','MOZ','1'),
('146','Myanmar','MM','MMR','1'),
('147','Namibia','NA','NAM','1'),
('148','Nauru','NR','NRU','1'),
('149','Nepal','NP','NPL','1'),
('150','Netherlands','NL','NLD','1'),
('151','Netherlands Antilles','AN','ANT','1'),
('152','New Caledonia','NC','NCL','1'),
('153','New Zealand','NZ','NZL','1'),
('154','Nicaragua','NI','NIC','1'),
('155','Niger','NE','NER','1'),
('156','Nigeria','NG','NGA','1'),
('157','Niue','NU','NIU','1'),
('158','Norfolk Island','NF','NFK','1'),
('159','Northern Mariana Islands','MP','MNP','1'),
('160','Norway','NO','NOR','1'),
('161','Oman','OM','OMN','1'),
('162','Pakistan','PK','PAK','1'),
('163','Palau','PW','PLW','1'),
('164','Panama','PA','PAN','1'),
('165','Papua New Guinea','PG','PNG','1'),
('166','Paraguay','PY','PRY','1'),
('167','Peru','PE','PER','1'),
('168','Philippines','PH','PHL','1'),
('169','Pitcairn','PN','PCN','1'),
('170','Poland','PL','POL','1'),
('171','Portugal','PT','PRT','1'),
('172','Puerto Rico','PR','PRI','1'),
('173','Qatar','QA','QAT','1'),
('174','Reunion','RE','REU','1'),
('175','Romania','RO','ROM','1'),
('176','Russian Federation','RU','RUS','1'),
('177','Rwanda','RW','RWA','1'),
('178','Saint Kitts and Nevis','KN','KNA','1'),
('179','Saint Lucia','LC','LCA','1'),
('180','Saint Vincent and the Grenadines','VC','VCT','1'),
('181','Samoa','WS','WSM','1'),
('182','San Marino','SM','SMR','1'),
('183','Sao Tome and Principe','ST','STP','1'),
('184','Saudi Arabia','SA','SAU','1'),
('185','Senegal','SN','SEN','1'),
('186','Seychelles','SC','SYC','1'),
('187','Sierra Leone','SL','SLE','1'),
('188','Singapore','SG','SGP','4'),
('189','Slovakia (Slovak Republic)','SK','SVK','1'),
('190','Slovenia','SI','SVN','1'),
('191','Solomon Islands','SB','SLB','1'),
('192','Somalia','SO','SOM','1'),
('193','South Africa','ZA','ZAF','1'),
('194','South Georgia and the South Sandwich Islands','GS','SGS','1'),
('195','Spain','ES','ESP','3'),
('196','Sri Lanka','LK','LKA','1'),
('197','St. Helena','SH','SHN','1'),
('198','St. Pierre and Miquelon','PM','SPM','1'),
('199','Sudan','SD','SDN','1'),
('200','Suriname','SR','SUR','1'),
('201','Svalbard and Jan Mayen Islands','SJ','SJM','1'),
('202','Swaziland','SZ','SWZ','1'),
('203','Sweden','SE','SWE','1'),
('204','Switzerland','CH','CHE','1'),
('205','Syrian Arab Republic','SY','SYR','1'),
('206','Taiwan','TW','TWN','1'),
('207','Tajikistan','TJ','TJK','1'),
('208','Tanzania United Republic of','TZ','TZA','1'),
('209','Thailand','TH','THA','1'),
('210','Togo','TG','TGO','1'),
('211','Tokelau','TK','TKL','1'),
('212','Tonga','TO','TON','1'),
('213','Trinidad and Tobago','TT','TTO','1'),
('214','Tunisia','TN','TUN','1'),
('215','Turkey','TR','TUR','1'),
('216','Turkmenistan','TM','TKM','1'),
('217','Turks and Caicos Islands','TC','TCA','1'),
('218','Tuvalu','TV','TUV','1'),
('219','Uganda','UG','UGA','1'),
('220','Ukraine','UA','UKR','1'),
('221','United Arab Emirates','AE','ARE','1'),
('222','United Kingdom','GB','GBR','6'),
('223','United States','US','USA','2'),
('224','United States Minor Outlying Islands','UM','UMI','1'),
('225','Uruguay','UY','URY','1'),
('226','Uzbekistan','UZ','UZB','1'),
('227','Vanuatu','VU','VUT','1'),
('228','Vatican City State (Holy See)','VA','VAT','1'),
('229','Venezuela','VE','VEN','1'),
('230','Viet Nam','VN','VNM','1'),
('231','Virgin Islands (British)','VG','VGB','1'),
('232','Virgin Islands (U.S.)','VI','VIR','1'),
('233','Wallis and Futuna Islands','WF','WLF','1'),
('234','Western Sahara','EH','ESH','1'),
('235','Yemen','YE','YEM','1'),
('236','Yugoslavia','YU','YUG','1'),
('237','Zaire','ZR','ZAR','1'),
('238','Zambia','ZM','ZMB','1'),
('239','Zimbabwe','ZW','ZWE','1');

I accept Paypal donations... Just kidding. I wish...

well i know nothing about php or mysql so you beat me there...

This is the error I get when trying that....

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('1','Afghanistan','AF','AFG','1'), ('2','Albania','AL','ALB','1'), ('3','Algeri' at line 1

Sorry, I can't really help you.

If this wasn't the entire error message, I would try copying/pasting the first 2 lines to see if it takes. If not, then you should google what the syntax is for your SQL version.

If just the first 2 lines take, then it's just a matter of finding an offending line. I think descriptions with a ' needs to be preceeded by a . So for example, 52 would become

('52','Cote D'Ivoire','CI','CIV','1'),

For the ones that gave me a hard time, I just manually did it through the Admin area.

You can also manually enter them in MySQL, which is a little easier than the Admin area. Make sure to back up first!

Hmmn, I really don't know what I am doing when it comes to this. I guess I'm stuck with just the US being able to order. Entering everything one by one seems way too tedious, and I already have too much on my plate...

There is a missing comma on the INSERT for the row starting with 240

Ok so, I added the comma, escaped the ' (apostraphe) in despcriptions with a \ (there were a few of them) and found an extra ), in there before the line with Mongolia

BUT then I get this error

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1)' at line 1

when this gets figured out please post the correct SQL statement

khopek:

Ok so, I added the comma, escaped the ' (apostraphe) in despcriptions with a \ (there were a few of them) and found an extra ), in there before the line with Mongolia

BUT then I get this error

Do you more or less just want to have the original countries and zones tables put back into your database that you would have with a clean install?

I cleaned up the SQL statement but it still has this error and I don't know how to take care of it, anyone?

"1062 Duplicate entry '240' for key 1"

here is the statement

insert into countries (countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id) values
('240','Aaland Islands','AX','ALA','1'),
('1','Afghanistan','AF','AFG','1'),
('2','Albania','AL','ALB','1'),
('3','Algeria','DZ','DZA','1'),
('4','American Samoa','AS','ASM','1'),
('5','Andorra','AD','AND','1'),
('6','Angola','AO','AGO','1'),
('7','Anguilla','AI','AIA','1'),
('8','Antarctica','AQ','ATA','1'),
('9','Antigua and Barbuda','AG','ATG','1'),
('10','Argentina','AR','ARG','1'),
('11','Armenia','AM','ARM','1'),
('12','Aruba','AW','ABW','1'),
('13','Australia','AU','AUS','1'),
('14','Austria','AT','AUT','5'),
('15','Azerbaijan','AZ','AZE','1'),
('16','Bahamas','BS','BHS','1'),
('17','Bahrain','BH','BHR','1'),
('18','Bangladesh','BD','BGD','1'),
('19','Barbados','BB','BRB','1'),
('20','Belarus','BY','BLR','1'),
('21','Belgium','BE','BEL','1'),
('22','Belize','BZ','BLZ','1'),
('23','Benin','BJ','BEN','1'),
('24','Bermuda','BM','BMU','1'),
('25','Bhutan','BT','BTN','1'),
('26','Bolivia','BO','BOL','1'),
('27','Bosnia and Herzegowina','BA','BIH','1'),
('28','Botswana','BW','BWA','1'),
('29','Bouvet Island','BV','BVT','1'),
('30','Brazil','BR','BRA','1'),
('31','British Indian Ocean Territory','IO','IOT','1'),
('32','Brunei Darussalam','BN','BRN','1'),
('33','Bulgaria','BG','BGR','1'),
('34','Burkina Faso','BF','BFA','1'),
('35','Burundi','BI','BDI','1'),
('36','Cambodia','KH','KHM','1'),
('37','Cameroon','CM','CMR','1'),
('38','Canada','CA','CAN','1'),
('39','Cape Verde','CV','CPV','1'),
('40','Cayman Islands','KY','CYM','1'),
('41','Central African Republic','CF','CAF','1'),
('42','Chad','TD','TCD','1'),
('43','Chile','CL','CHL','1'),
('44','China','CN','CHN','1'),
('45','Christmas Island','CX','CXR','1'),
('46','Cocos (Keeling) Islands','CC','CCK','1'),
('47','Colombia','CO','COL','1'),
('48','Comoros','KM','COM','1'),
('49','Congo','CG','COG','1'),
('50','Cook Islands','CK','COK','1'),
('51','Costa Rica','CR','CRI','1'),
('52','Cote DIvoire','CI','CIV','1'),
('53','Croatia','HR','HRV','1'),
('54','Cuba','CU','CUB','1'),
('55','Cyprus','CY','CYP','1'),
('56','Czech Republic','CZ','CZE','1'),
('57','Denmark','DK','DNK','1'),
('58','Djibouti','DJ','DJI','1'),
('59','Dominica','DM','DMA','1'),
('60','Dominican Republic','DO','DOM','1'),
('61','East Timor','TP','TMP','1'),
('62','Ecuador','EC','ECU','1'),
('63','Egypt','EG','EGY','1'),
('64','El Salvador','SV','SLV','1'),
('65','Equatorial Guinea','GQ','GNQ','1'),
('66','Eritrea','ER','ERI','1'),
('67','Estonia','EE','EST','1'),
('68','Ethiopia','ET','ETH','1'),
('69','Falkland Islands (Malvinas)','FK','FLK','1'),
('70','Faroe Islands','FO','FRO','1'),
('71','Fiji','FJ','FJI','1'),
('72','Finland','FI','FIN','1'),
('73','France','FR','FRA','1'),
('74','France Metropolitan','FX','FXX','1'),
('75','French Guiana','GF','GUF','1'),
('76','French Polynesia','PF','PYF','1'),
('77','French Southern Territories','TF','ATF','1'),
('78','Gabon','GA','GAB','1'),
('79','Gambia','GM','GMB','1'),
('80','Georgia','GE','GEO','1'),
('81','Germany','DE','DEU','5'),
('82','Ghana','GH','GHA','1'),
('83','Gibraltar','GI','GIB','1'),
('84','Greece','GR','GRC','1'),
('85','Greenland','GL','GRL','1'),
('86','Grenada','GD','GRD','1'),
('87','Guadeloupe','GP','GLP','1'),
('88','Guam','GU','GUM','1'),
('89','Guatemala','GT','GTM','1'),
('90','Guinea','GN','GIN','1'),
('91','Guinea-bissau','GW','GNB','1'),
('92','Guyana','GY','GUY','1'),
('93','Haiti','HT','HTI','1'),
('94','Heard and Mc Donald Islands','HM','HMD','1'),
('95','Honduras','HN','HND','1'),
('96','Hong Kong','HK','HKG','1'),
('97','Hungary','HU','HUN','1'),
('98','Iceland','IS','ISL','1'),
('99','India','IN','IND','1'),
('100','Indonesia','ID','IDN','1'),
('101','Iran (Islamic Republic of)','IR','IRN','1'),
('102','Iraq','IQ','IRQ','1'),
('103','Ireland','IE','IRL','1'),
('104','Israel','IL','ISR','1'),
('105','Italy','IT','ITA','1'),
('106','Jamaica','JM','JAM','1'),
('107','Japan','JP','JPN','1'),
('108','Jordan','JO','JOR','1'),
('109','Kazakhstan','KZ','KAZ','1'),
('110','Kenya','KE','KEN','1'),
('111','Kiribati','KI','KIR','1'),
('112','Korea Democratic Peoples Republic of','KP','PRK','1'),
('113','Korea Republic of','KR','KOR','1'),
('114','Kuwait','KW','KWT','1'),
('115','Kyrgyzstan','KG','KGZ','1'),
('116','Lao Peoples Democratic Republic','LA','LAO','1'),
('117','Latvia','LV','LVA','1'),
('118','Lebanon','LB','LBN','1'),
('119','Lesotho','LS','LSO','1'),
('120','Liberia','LR','LBR','1'),
('121','Libyan Arab Jamahiriya','LY','LBY','1'),
('122','Liechtenstein','LI','LIE','1'),
('123','Lithuania','LT','LTU','1'),
('124','Luxembourg','LU','LUX','1'),
('125','Macau','MO','MAC','1'),
('126','Macedonia The Former Yugoslav Republic of','MK','MKD','1'),
('127','Madagascar','MG','MDG','1'),
('128','Malawi','MW','MWI','1'),
('129','Malaysia','MY','MYS','1'),
('130','Maldives','MV','MDV','1'),
('131','Mali','ML','MLI','1'),
('132','Malta','MT','MLT','1'),
('133','Marshall Islands','MH','MHL','1'),
('134','Martinique','MQ','MTQ','1'),
('135','Mauritania','MR','MRT','1'),
('136','Mauritius','MU','MUS','1'),
('137','Mayotte','YT','MYT','1'),
('138','Mexico','MX','MEX','1'),
('139','Micronesia Federated States of','FM','FSM','1'),
('140','Moldova Republic of','MD','MDA','1'),
('141','Monaco','MC','MCO','1'),
('142','Mongolia','MN','MNG','1'),
('143','Montserrat','MS','MSR','1'),
('144','Morocco','MA','MAR','1'),
('145','Mozambique','MZ','MOZ','1'),
('146','Myanmar','MM','MMR','1'),
('147','Namibia','NA','NAM','1'),
('148','Nauru','NR','NRU','1'),
('149','Nepal','NP','NPL','1'),
('150','Netherlands','NL','NLD','1'),
('151','Netherlands Antilles','AN','ANT','1'),
('152','New Caledonia','NC','NCL','1'),
('153','New Zealand','NZ','NZL','1'),
('154','Nicaragua','NI','NIC','1'),
('155','Niger','NE','NER','1'),
('156','Nigeria','NG','NGA','1'),
('157','Niue','NU','NIU','1'),
('158','Norfolk Island','NF','NFK','1'),
('159','Northern Mariana Islands','MP','MNP','1'),
('160','Norway','NO','NOR','1'),
('161','Oman','OM','OMN','1'),
('162','Pakistan','PK','PAK','1'),
('163','Palau','PW','PLW','1'),
('164','Panama','PA','PAN','1'),
('165','Papua New Guinea','PG','PNG','1'),
('166','Paraguay','PY','PRY','1'),
('167','Peru','PE','PER','1'),
('168','Philippines','PH','PHL','1'),
('169','Pitcairn','PN','PCN','1'),
('170','Poland','PL','POL','1'),
('171','Portugal','PT','PRT','1'),
('172','Puerto Rico','PR','PRI','1'),
('173','Qatar','QA','QAT','1'),
('174','Reunion','RE','REU','1'),
('175','Romania','RO','ROM','1'),
('176','Russian Federation','RU','RUS','1'),
('177','Rwanda','RW','RWA','1'),
('178','Saint Kitts and Nevis','KN','KNA','1'),
('179','Saint Lucia','LC','LCA','1'),
('180','Saint Vincent and the Grenadines','VC','VCT','1'),
('181','Samoa','WS','WSM','1'),
('182','San Marino','SM','SMR','1'),
('183','Sao Tome and Principe','ST','STP','1'),
('184','Saudi Arabia','SA','SAU','1'),
('185','Senegal','SN','SEN','1'),
('186','Seychelles','SC','SYC','1'),
('187','Sierra Leone','SL','SLE','1'),
('188','Singapore','SG','SGP','4'),
('189','Slovakia (Slovak Republic)','SK','SVK','1'),
('190','Slovenia','SI','SVN','1'),
('191','Solomon Islands','SB','SLB','1'),
('192','Somalia','SO','SOM','1'),
('193','South Africa','ZA','ZAF','1'),
('194','South Georgia and the South Sandwich Islands','GS','SGS','1'),
('195','Spain','ES','ESP','3'),
('196','Sri Lanka','LK','LKA','1'),
('197','St. Helena','SH','SHN','1'),
('198','St. Pierre and Miquelon','PM','SPM','1'),
('199','Sudan','SD','SDN','1'),
('200','Suriname','SR','SUR','1'),
('201','Svalbard and Jan Mayen Islands','SJ','SJM','1'),
('202','Swaziland','SZ','SWZ','1'),
('203','Sweden','SE','SWE','1'),
('204','Switzerland','CH','CHE','1'),
('205','Syrian Arab Republic','SY','SYR','1'),
('206','Taiwan','TW','TWN','1'),
('207','Tajikistan','TJ','TJK','1'),
('208','Tanzania United Republic of','TZ','TZA','1'),
('209','Thailand','TH','THA','1'),
('210','Togo','TG','TGO','1'),
('211','Tokelau','TK','TKL','1'),
('212','Tonga','TO','TON','1'),
('213','Trinidad and Tobago','TT','TTO','1'),
('214','Tunisia','TN','TUN','1'),
('215','Turkey','TR','TUR','1'),
('216','Turkmenistan','TM','TKM','1'),
('217','Turks and Caicos Islands','TC','TCA','1'),
('218','Tuvalu','TV','TUV','1'),
('219','Uganda','UG','UGA','1'),
('220','Ukraine','UA','UKR','1'),
('221','United Arab Emirates','AE','ARE','1'),
('222','United Kingdom','GB','GBR','6'),
('223','United States','US','USA','2'),
('224','United States Minor Outlying Islands','UM','UMI','1'),
('225','Uruguay','UY','URY','1'),
('226','Uzbekistan','UZ','UZB','1'),
('227','Vanuatu','VU','VUT','1'),
('228','Vatican City State (Holy See)','VA','VAT','1'),
('229','Venezuela','VE','VEN','1'),
('230','Viet Nam','VN','VNM','1'),
('231','Virgin Islands (British)','VG','VGB','1'),
('232','Virgin Islands (U.S.)','VI','VIR','1'),
('233','Wallis and Futuna Islands','WF','WLF','1'),
('234','Western Sahara','EH','ESH','1'),
('235','Yemen','YE','YEM','1'),
('236','Yugoslavia','YU','YUG','1'),
('237','Zaire','ZR','ZAR','1'),
('238','Zambia','ZM','ZMB','1'),
('239','Zimbabwe','ZW','ZWE','1');

If you want to re-add all original countries to the countries table you need to empty the table first to truncate the table so that you can start over ...

Then add all the countries back in ...

The original SQL code from Zen Cart Install is:

INSERT INTO countries VALUES (240,'Aaland Islands','AX','ALA','1');
INSERT INTO countries VALUES (1,'Afghanistan','AF','AFG','1');
INSERT INTO countries VALUES (2,'Albania','AL','ALB','1');
INSERT INTO countries VALUES (3,'Algeria','DZ','DZA','1');
INSERT INTO countries VALUES (4,'American Samoa','AS','ASM','1');
INSERT INTO countries VALUES (5,'Andorra','AD','AND','1');
INSERT INTO countries VALUES (6,'Angola','AO','AGO','1');
INSERT INTO countries VALUES (7,'Anguilla','AI','AIA','1');
INSERT INTO countries VALUES (8,'Antarctica','AQ','ATA','1');
INSERT INTO countries VALUES (9,'Antigua and Barbuda','AG','ATG','1');
INSERT INTO countries VALUES (10,'Argentina','AR','ARG','1');
INSERT INTO countries VALUES (11,'Armenia','AM','ARM','1');
INSERT INTO countries VALUES (12,'Aruba','AW','ABW','1');
INSERT INTO countries VALUES (13,'Australia','AU','AUS','1');
INSERT INTO countries VALUES (14,'Austria','AT','AUT','5');
INSERT INTO countries VALUES (15,'Azerbaijan','AZ','AZE','1');
INSERT INTO countries VALUES (16,'Bahamas','BS','BHS','1');
INSERT INTO countries VALUES (17,'Bahrain','BH','BHR','1');
INSERT INTO countries VALUES (18,'Bangladesh','BD','BGD','1');
INSERT INTO countries VALUES (19,'Barbados','BB','BRB','1');
INSERT INTO countries VALUES (20,'Belarus','BY','BLR','1');
INSERT INTO countries VALUES (21,'Belgium','BE','BEL','1');
INSERT INTO countries VALUES (22,'Belize','BZ','BLZ','1');
INSERT INTO countries VALUES (23,'Benin','BJ','BEN','1');
INSERT INTO countries VALUES (24,'Bermuda','BM','BMU','1');
INSERT INTO countries VALUES (25,'Bhutan','BT','BTN','1');
INSERT INTO countries VALUES (26,'Bolivia','BO','BOL','1');
INSERT INTO countries VALUES (27,'Bosnia and Herzegowina','BA','BIH','1');
INSERT INTO countries VALUES (28,'Botswana','BW','BWA','1');
INSERT INTO countries VALUES (29,'Bouvet Island','BV','BVT','1');
INSERT INTO countries VALUES (30,'Brazil','BR','BRA','1');
INSERT INTO countries VALUES (31,'British Indian Ocean Territory','IO','IOT','1');
INSERT INTO countries VALUES (32,'Brunei Darussalam','BN','BRN','1');
INSERT INTO countries VALUES (33,'Bulgaria','BG','BGR','1');
INSERT INTO countries VALUES (34,'Burkina Faso','BF','BFA','1');
INSERT INTO countries VALUES (35,'Burundi','BI','BDI','1');
INSERT INTO countries VALUES (36,'Cambodia','KH','KHM','1');
INSERT INTO countries VALUES (37,'Cameroon','CM','CMR','1');
INSERT INTO countries VALUES (38,'Canada','CA','CAN','2');
INSERT INTO countries VALUES (39,'Cape Verde','CV','CPV','1');
INSERT INTO countries VALUES (40,'Cayman Islands','KY','CYM','1');
INSERT INTO countries VALUES (41,'Central African Republic','CF','CAF','1');
INSERT INTO countries VALUES (42,'Chad','TD','TCD','1');
INSERT INTO countries VALUES (43,'Chile','CL','CHL','1');
INSERT INTO countries VALUES (44,'China','CN','CHN','1');
INSERT INTO countries VALUES (45,'Christmas Island','CX','CXR','1');
INSERT INTO countries VALUES (46,'Cocos (Keeling) Islands','CC','CCK','1');
INSERT INTO countries VALUES (47,'Colombia','CO','COL','1');
INSERT INTO countries VALUES (48,'Comoros','KM','COM','1');
INSERT INTO countries VALUES (49,'Congo','CG','COG','1');
INSERT INTO countries VALUES (50,'Cook Islands','CK','COK','1');
INSERT INTO countries VALUES (51,'Costa Rica','CR','CRI','1');
INSERT INTO countries VALUES (52,'Cote D\'Ivoire','CI','CIV','1');
INSERT INTO countries VALUES (53,'Croatia','HR','HRV','1');
INSERT INTO countries VALUES (54,'Cuba','CU','CUB','1');
INSERT INTO countries VALUES (55,'Cyprus','CY','CYP','1');
INSERT INTO countries VALUES (56,'Czech Republic','CZ','CZE','1');
INSERT INTO countries VALUES (57,'Denmark','DK','DNK','1');
INSERT INTO countries VALUES (58,'Djibouti','DJ','DJI','1');
INSERT INTO countries VALUES (59,'Dominica','DM','DMA','1');
INSERT INTO countries VALUES (60,'Dominican Republic','DO','DOM','1');
INSERT INTO countries VALUES (61,'East Timor','TP','TMP','1');
INSERT INTO countries VALUES (62,'Ecuador','EC','ECU','1');
INSERT INTO countries VALUES (63,'Egypt','EG','EGY','1');
INSERT INTO countries VALUES (64,'El Salvador','SV','SLV','1');
INSERT INTO countries VALUES (65,'Equatorial Guinea','GQ','GNQ','1');
INSERT INTO countries VALUES (66,'Eritrea','ER','ERI','1');
INSERT INTO countries VALUES (67,'Estonia','EE','EST','1');
INSERT INTO countries VALUES (68,'Ethiopia','ET','ETH','1');
INSERT INTO countries VALUES (69,'Falkland Islands (Malvinas)','FK','FLK','1');
INSERT INTO countries VALUES (70,'Faroe Islands','FO','FRO','1');
INSERT INTO countries VALUES (71,'Fiji','FJ','FJI','1');
INSERT INTO countries VALUES (72,'Finland','FI','FIN','1');
INSERT INTO countries VALUES (73,'France','FR','FRA','1');
INSERT INTO countries VALUES (74,'France, Metropolitan','FX','FXX','1');
INSERT INTO countries VALUES (75,'French Guiana','GF','GUF','1');
INSERT INTO countries VALUES (76,'French Polynesia','PF','PYF','1');
INSERT INTO countries VALUES (77,'French Southern Territories','TF','ATF','1');
INSERT INTO countries VALUES (78,'Gabon','GA','GAB','1');
INSERT INTO countries VALUES (79,'Gambia','GM','GMB','1');
INSERT INTO countries VALUES (80,'Georgia','GE','GEO','1');
INSERT INTO countries VALUES (81,'Germany','DE','DEU','5');
INSERT INTO countries VALUES (82,'Ghana','GH','GHA','1');
INSERT INTO countries VALUES (83,'Gibraltar','GI','GIB','1');
INSERT INTO countries VALUES (84,'Greece','GR','GRC','1');
INSERT INTO countries VALUES (85,'Greenland','GL','GRL','1');
INSERT INTO countries VALUES (86,'Grenada','GD','GRD','1');
INSERT INTO countries VALUES (87,'Guadeloupe','GP','GLP','1');
INSERT INTO countries VALUES (88,'Guam','GU','GUM','1');
INSERT INTO countries VALUES (89,'Guatemala','GT','GTM','1');
INSERT INTO countries VALUES (90,'Guinea','GN','GIN','1');
INSERT INTO countries VALUES (91,'Guinea-bissau','GW','GNB','1');
INSERT INTO countries VALUES (92,'Guyana','GY','GUY','1');
INSERT INTO countries VALUES (93,'Haiti','HT','HTI','1');
INSERT INTO countries VALUES (94,'Heard and Mc Donald Islands','HM','HMD','1');
INSERT INTO countries VALUES (95,'Honduras','HN','HND','1');
INSERT INTO countries VALUES (96,'Hong Kong','HK','HKG','1');
INSERT INTO countries VALUES (97,'Hungary','HU','HUN','1');
INSERT INTO countries VALUES (98,'Iceland','IS','ISL','1');
INSERT INTO countries VALUES (99,'India','IN','IND','1');
INSERT INTO countries VALUES (100,'Indonesia','ID','IDN','1');
INSERT INTO countries VALUES (101,'Iran (Islamic Republic of)','IR','IRN','1');
INSERT INTO countries VALUES (102,'Iraq','IQ','IRQ','1');
INSERT INTO countries VALUES (103,'Ireland','IE','IRL','1');
INSERT INTO countries VALUES (104,'Israel','IL','ISR','1');
INSERT INTO countries VALUES (105,'Italy','IT','ITA','1');
INSERT INTO countries VALUES (106,'Jamaica','JM','JAM','1');
INSERT INTO countries VALUES (107,'Japan','JP','JPN','1');
INSERT INTO countries VALUES (108,'Jordan','JO','JOR','1');
INSERT INTO countries VALUES (109,'Kazakhstan','KZ','KAZ','1');
INSERT INTO countries VALUES (110,'Kenya','KE','KEN','1');
INSERT INTO countries VALUES (111,'Kiribati','KI','KIR','1');
INSERT INTO countries VALUES (112,'Korea, Democratic People\'s Republic of','KP','PRK','1');
INSERT INTO countries VALUES (113,'Korea, Republic of','KR','KOR','1');
INSERT INTO countries VALUES (114,'Kuwait','KW','KWT','1');
INSERT INTO countries VALUES (115,'Kyrgyzstan','KG','KGZ','1');
INSERT INTO countries VALUES (116,'Lao People\'s Democratic Republic','LA','LAO','1');
INSERT INTO countries VALUES (117,'Latvia','LV','LVA','1');
INSERT INTO countries VALUES (118,'Lebanon','LB','LBN','1');
INSERT INTO countries VALUES (119,'Lesotho','LS','LSO','1');
INSERT INTO countries VALUES (120,'Liberia','LR','LBR','1');
INSERT INTO countries VALUES (121,'Libyan Arab Jamahiriya','LY','LBY','1');
INSERT INTO countries VALUES (122,'Liechtenstein','LI','LIE','1');
INSERT INTO countries VALUES (123,'Lithuania','LT','LTU','1');
INSERT INTO countries VALUES (124,'Luxembourg','LU','LUX','1');
INSERT INTO countries VALUES (125,'Macau','MO','MAC','1');
INSERT INTO countries VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD','1');
INSERT INTO countries VALUES (127,'Madagascar','MG','MDG','1');
INSERT INTO countries VALUES (128,'Malawi','MW','MWI','1');
INSERT INTO countries VALUES (129,'Malaysia','MY','MYS','1');
INSERT INTO countries VALUES (130,'Maldives','MV','MDV','1');
INSERT INTO countries VALUES (131,'Mali','ML','MLI','1');
INSERT INTO countries VALUES (132,'Malta','MT','MLT','1');
INSERT INTO countries VALUES (133,'Marshall Islands','MH','MHL','1');
INSERT INTO countries VALUES (134,'Martinique','MQ','MTQ','1');
INSERT INTO countries VALUES (135,'Mauritania','MR','MRT','1');
INSERT INTO countries VALUES (136,'Mauritius','MU','MUS','1');
INSERT INTO countries VALUES (137,'Mayotte','YT','MYT','1');
INSERT INTO countries VALUES (138,'Mexico','MX','MEX','1');
INSERT INTO countries VALUES (139,'Micronesia, Federated States of','FM','FSM','1');
INSERT INTO countries VALUES (140,'Moldova, Republic of','MD','MDA','1');
INSERT INTO countries VALUES (141,'Monaco','MC','MCO','1');
INSERT INTO countries VALUES (142,'Mongolia','MN','MNG','1');
INSERT INTO countries VALUES (143,'Montserrat','MS','MSR','1');
INSERT INTO countries VALUES (144,'Morocco','MA','MAR','1');
INSERT INTO countries VALUES (145,'Mozambique','MZ','MOZ','1');
INSERT INTO countries VALUES (146,'Myanmar','MM','MMR','1');
INSERT INTO countries VALUES (147,'Namibia','NA','NAM','1');
INSERT INTO countries VALUES (148,'Nauru','NR','NRU','1');
INSERT INTO countries VALUES (149,'Nepal','NP','NPL','1');
INSERT INTO countries VALUES (150,'Netherlands','NL','NLD','1');
INSERT INTO countries VALUES (151,'Netherlands Antilles','AN','ANT','1');
INSERT INTO countries VALUES (152,'New Caledonia','NC','NCL','1');
INSERT INTO countries VALUES (153,'New Zealand','NZ','NZL','1');
INSERT INTO countries VALUES (154,'Nicaragua','NI','NIC','1');
INSERT INTO countries VALUES (155,'Niger','NE','NER','1');
INSERT INTO countries VALUES (156,'Nigeria','NG','NGA','1');
INSERT INTO countries VALUES (157,'Niue','NU','NIU','1');
INSERT INTO countries VALUES (158,'Norfolk Island','NF','NFK','1');
INSERT INTO countries VALUES (159,'Northern Mariana Islands','MP','MNP','1');
INSERT INTO countries VALUES (160,'Norway','NO','NOR','1');
INSERT INTO countries VALUES (161,'Oman','OM','OMN','1');
INSERT INTO countries VALUES (162,'Pakistan','PK','PAK','1');
INSERT INTO countries VALUES (163,'Palau','PW','PLW','1');
INSERT INTO countries VALUES (164,'Panama','PA','PAN','1');
INSERT INTO countries VALUES (165,'Papua New Guinea','PG','PNG','1');
INSERT INTO countries VALUES (166,'Paraguay','PY','PRY','1');
INSERT INTO countries VALUES (167,'Peru','PE','PER','1');
INSERT INTO countries VALUES (168,'Philippines','PH','PHL','1');
INSERT INTO countries VALUES (169,'Pitcairn','PN','PCN','1');
INSERT INTO countries VALUES (170,'Poland','PL','POL','1');
INSERT INTO countries VALUES (171,'Portugal','PT','PRT','1');
INSERT INTO countries VALUES (172,'Puerto Rico','PR','PRI','1');
INSERT INTO countries VALUES (173,'Qatar','QA','QAT','1');
INSERT INTO countries VALUES (174,'Reunion','RE','REU','1');
INSERT INTO countries VALUES (175,'Romania','RO','ROM','1');
INSERT INTO countries VALUES (176,'Russian Federation','RU','RUS','1');
INSERT INTO countries VALUES (177,'Rwanda','RW','RWA','1');
INSERT INTO countries VALUES (178,'Saint Kitts and Nevis','KN','KNA','1');
INSERT INTO countries VALUES (179,'Saint Lucia','LC','LCA','1');
INSERT INTO countries VALUES (180,'Saint Vincent and the Grenadines','VC','VCT','1');
INSERT INTO countries VALUES (181,'Samoa','WS','WSM','1');
INSERT INTO countries VALUES (182,'San Marino','SM','SMR','1');
INSERT INTO countries VALUES (183,'Sao Tome and Principe','ST','STP','1');
INSERT INTO countries VALUES (184,'Saudi Arabia','SA','SAU','1');
INSERT INTO countries VALUES (185,'Senegal','SN','SEN','1');
INSERT INTO countries VALUES (186,'Seychelles','SC','SYC','1');
INSERT INTO countries VALUES (187,'Sierra Leone','SL','SLE','1');
INSERT INTO countries VALUES (188,'Singapore','SG','SGP', '4');
INSERT INTO countries VALUES (189,'Slovakia (Slovak Republic)','SK','SVK','1');
INSERT INTO countries VALUES (190,'Slovenia','SI','SVN','1');
INSERT INTO countries VALUES (191,'Solomon Islands','SB','SLB','1');
INSERT INTO countries VALUES (192,'Somalia','SO','SOM','1');
INSERT INTO countries VALUES (193,'South Africa','ZA','ZAF','1');
INSERT INTO countries VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS','1');
INSERT INTO countries VALUES (195,'Spain','ES','ESP','3');
INSERT INTO countries VALUES (196,'Sri Lanka','LK','LKA','1');
INSERT INTO countries VALUES (197,'St. Helena','SH','SHN','1');
INSERT INTO countries VALUES (198,'St. Pierre and Miquelon','PM','SPM','1');
INSERT INTO countries VALUES (199,'Sudan','SD','SDN','1');
INSERT INTO countries VALUES (200,'Suriname','SR','SUR','1');
INSERT INTO countries VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM','1');
INSERT INTO countries VALUES (202,'Swaziland','SZ','SWZ','1');
INSERT INTO countries VALUES (203,'Sweden','SE','SWE','1');
INSERT INTO countries VALUES (204,'Switzerland','CH','CHE','1');
INSERT INTO countries VALUES (205,'Syrian Arab Republic','SY','SYR','1');
INSERT INTO countries VALUES (206,'Taiwan','TW','TWN','1');
INSERT INTO countries VALUES (207,'Tajikistan','TJ','TJK','1');
INSERT INTO countries VALUES (208,'Tanzania, United Republic of','TZ','TZA','1');
INSERT INTO countries VALUES (209,'Thailand','TH','THA','1');
INSERT INTO countries VALUES (210,'Togo','TG','TGO','1');
INSERT INTO countries VALUES (211,'Tokelau','TK','TKL','1');
INSERT INTO countries VALUES (212,'Tonga','TO','TON','1');
INSERT INTO countries VALUES (213,'Trinidad and Tobago','TT','TTO','1');
INSERT INTO countries VALUES (214,'Tunisia','TN','TUN','1');
INSERT INTO countries VALUES (215,'Turkey','TR','TUR','1');
INSERT INTO countries VALUES (216,'Turkmenistan','TM','TKM','1');
INSERT INTO countries VALUES (217,'Turks and Caicos Islands','TC','TCA','1');
INSERT INTO countries VALUES (218,'Tuvalu','TV','TUV','1');
INSERT INTO countries VALUES (219,'Uganda','UG','UGA','1');
INSERT INTO countries VALUES (220,'Ukraine','UA','UKR','1');
INSERT INTO countries VALUES (221,'United Arab Emirates','AE','ARE','1');
INSERT INTO countries VALUES (222,'United Kingdom','GB','GBR','6');
INSERT INTO countries VALUES (223,'United States','US','USA', '2');
INSERT INTO countries VALUES (224,'United States Minor Outlying Islands','UM','UMI','1');
INSERT INTO countries VALUES (225,'Uruguay','UY','URY','1');
INSERT INTO countries VALUES (226,'Uzbekistan','UZ','UZB','1');
INSERT INTO countries VALUES (227,'Vanuatu','VU','VUT','1');
INSERT INTO countries VALUES (228,'Vatican City State (Holy See)','VA','VAT','1');
INSERT INTO countries VALUES (229,'Venezuela','VE','VEN','1');
INSERT INTO countries VALUES (230,'Viet Nam','VN','VNM','1');
INSERT INTO countries VALUES (231,'Virgin Islands (British)','VG','VGB','1');
INSERT INTO countries VALUES (232,'Virgin Islands (U.S.)','VI','VIR','1');
INSERT INTO countries VALUES (233,'Wallis and Futuna Islands','WF','WLF','1');
INSERT INTO countries VALUES (234,'Western Sahara','EH','ESH','1');
INSERT INTO countries VALUES (235,'Yemen','YE','YEM','1');
INSERT INTO countries VALUES (236,'Yugoslavia','YU','YUG','1');
INSERT INTO countries VALUES (237,'Zaire','ZR','ZAR','1');
INSERT INTO countries VALUES (238,'Zambia','ZM','ZMB','1');
INSERT INTO countries VALUES (239,'Zimbabwe','ZW','ZWE','1');

NOTE: if you have also lost the original Zones defined in the zones table for these countries ... empty or truncate the zones table and you can reset those with:

# USA
INSERT INTO zones VALUES (1,223,'AL','Alabama');
INSERT INTO zones VALUES (2,223,'AK','Alaska');
INSERT INTO zones VALUES (3,223,'AS','American Samoa');
INSERT INTO zones VALUES (4,223,'AZ','Arizona');
INSERT INTO zones VALUES (5,223,'AR','Arkansas');
INSERT INTO zones VALUES (6,223,'AF','Armed Forces Africa');
INSERT INTO zones VALUES (7,223,'AA','Armed Forces Americas');
INSERT INTO zones VALUES (8,223,'AC','Armed Forces Canada');
INSERT INTO zones VALUES (9,223,'AE','Armed Forces Europe');
INSERT INTO zones VALUES (10,223,'AM','Armed Forces Middle East');
INSERT INTO zones VALUES (11,223,'AP','Armed Forces Pacific');
INSERT INTO zones VALUES (12,223,'CA','California');
INSERT INTO zones VALUES (13,223,'CO','Colorado');
INSERT INTO zones VALUES (14,223,'CT','Connecticut');
INSERT INTO zones VALUES (15,223,'DE','Delaware');
INSERT INTO zones VALUES (16,223,'DC','District of Columbia');
INSERT INTO zones VALUES (17,223,'FM','Federated States Of Micronesia');
INSERT INTO zones VALUES (18,223,'FL','Florida');
INSERT INTO zones VALUES (19,223,'GA','Georgia');
INSERT INTO zones VALUES (20,223,'GU','Guam');
INSERT INTO zones VALUES (21,223,'HI','Hawaii');
INSERT INTO zones VALUES (22,223,'ID','Idaho');
INSERT INTO zones VALUES (23,223,'IL','Illinois');
INSERT INTO zones VALUES (24,223,'IN','Indiana');
INSERT INTO zones VALUES (25,223,'IA','Iowa');
INSERT INTO zones VALUES (26,223,'KS','Kansas');
INSERT INTO zones VALUES (27,223,'KY','Kentucky');
INSERT INTO zones VALUES (28,223,'LA','Louisiana');
INSERT INTO zones VALUES (29,223,'ME','Maine');
INSERT INTO zones VALUES (30,223,'MH','Marshall Islands');
INSERT INTO zones VALUES (31,223,'MD','Maryland');
INSERT INTO zones VALUES (32,223,'MA','Massachusetts');
INSERT INTO zones VALUES (33,223,'MI','Michigan');
INSERT INTO zones VALUES (34,223,'MN','Minnesota');
INSERT INTO zones VALUES (35,223,'MS','Mississippi');
INSERT INTO zones VALUES (36,223,'MO','Missouri');
INSERT INTO zones VALUES (37,223,'MT','Montana');
INSERT INTO zones VALUES (38,223,'NE','Nebraska');
INSERT INTO zones VALUES (39,223,'NV','Nevada');
INSERT INTO zones VALUES (40,223,'NH','New Hampshire');
INSERT INTO zones VALUES (41,223,'NJ','New Jersey');
INSERT INTO zones VALUES (42,223,'NM','New Mexico');
INSERT INTO zones VALUES (43,223,'NY','New York');
INSERT INTO zones VALUES (44,223,'NC','North Carolina');
INSERT INTO zones VALUES (45,223,'ND','North Dakota');
INSERT INTO zones VALUES (46,223,'MP','Northern Mariana Islands');
INSERT INTO zones VALUES (47,223,'OH','Ohio');
INSERT INTO zones VALUES (48,223,'OK','Oklahoma');
INSERT INTO zones VALUES (49,223,'OR','Oregon');
INSERT INTO zones VALUES (50,163,'PW','Palau');
INSERT INTO zones VALUES (51,223,'PA','Pennsylvania');
INSERT INTO zones VALUES (52,223,'PR','Puerto Rico');
INSERT INTO zones VALUES (53,223,'RI','Rhode Island');
INSERT INTO zones VALUES (54,223,'SC','South Carolina');
INSERT INTO zones VALUES (55,223,'SD','South Dakota');
INSERT INTO zones VALUES (56,223,'TN','Tennessee');
INSERT INTO zones VALUES (57,223,'TX','Texas');
INSERT INTO zones VALUES (58,223,'UT','Utah');
INSERT INTO zones VALUES (59,223,'VT','Vermont');
INSERT INTO zones VALUES (60,223,'VI','Virgin Islands');
INSERT INTO zones VALUES (61,223,'VA','Virginia');
INSERT INTO zones VALUES (62,223,'WA','Washington');
INSERT INTO zones VALUES (63,223,'WV','West Virginia');
INSERT INTO zones VALUES (64,223,'WI','Wisconsin');
INSERT INTO zones VALUES (65,223,'WY','Wyoming');

# Canada
INSERT INTO zones VALUES (66,38,'AB','Alberta');
INSERT INTO zones VALUES (67,38,'BC','British Columbia');
INSERT INTO zones VALUES (68,38,'MB','Manitoba');
INSERT INTO zones VALUES (69,38,'NL','Newfoundland');
INSERT INTO zones VALUES (70,38,'NB','New Brunswick');
INSERT INTO zones VALUES (71,38,'NS','Nova Scotia');
INSERT INTO zones VALUES (72,38,'NT','Northwest Territories');
INSERT INTO zones VALUES (73,38,'NU','Nunavut');
INSERT INTO zones VALUES (74,38,'ON','Ontario');
INSERT INTO zones VALUES (75,38,'PE','Prince Edward Island');
INSERT INTO zones VALUES (76,38,'QC','Quebec');
INSERT INTO zones VALUES (77,38,'SK','Saskatchewan');
INSERT INTO zones VALUES (78,38,'YT','Yukon Territory');

# Germany
INSERT INTO zones VALUES (79,81,'NDS','Niedersachsen');
INSERT INTO zones VALUES (80,81,'BAW','Baden Würtemberg');
INSERT INTO zones VALUES (81,81,'BAY','Bayern');
INSERT INTO zones VALUES (82,81,'BER','Berlin');
INSERT INTO zones VALUES (83,81,'BRG','Brandenburg');
INSERT INTO zones VALUES (84,81,'BRE','Bremen');
INSERT INTO zones VALUES (85,81,'HAM','Hamburg');
INSERT INTO zones VALUES (86,81,'HES','Hessen');
INSERT INTO zones VALUES (87,81,'MEC','Mecklenburg-Vorpommern');
INSERT INTO zones VALUES (88,81,'NRW','Nordrhein-Westfalen');
INSERT INTO zones VALUES (89,81,'RHE','Rheinland-Pfalz');
INSERT INTO zones VALUES (90,81,'SAR','Saarland');
INSERT INTO zones VALUES (91,81,'SAS','Sachsen');
INSERT INTO zones VALUES (92,81,'SAC','Sachsen-Anhalt');
INSERT INTO zones VALUES (93,81,'SCN','Schleswig-Holstein');
INSERT INTO zones VALUES (94,81,'THE','Thringen');

# Austria
INSERT INTO zones VALUES (95,14,'WI','Wien');
INSERT INTO zones VALUES (96,14,'NO','Niedersterreich');
INSERT INTO zones VALUES (97,14,'OO','Obersterreich');
INSERT INTO zones VALUES (98,14,'SB','Salzburg');
INSERT INTO zones VALUES (99,14,'KN','Kärnten');
INSERT INTO zones VALUES (100,14,'ST','Steiermark');
INSERT INTO zones VALUES (101,14,'TI','Tirol');
INSERT INTO zones VALUES (102,14,'BL','Burgenland');
INSERT INTO zones VALUES (103,14,'VB','Voralberg');

# Swizterland
INSERT INTO zones VALUES (104,204,'AG','Aargau');
INSERT INTO zones VALUES (105,204,'AI','Appenzell Innerrhoden');
INSERT INTO zones VALUES (106,204,'AR','Appenzell Ausserrhoden');
INSERT INTO zones VALUES (107,204,'BE','Bern');
INSERT INTO zones VALUES (108,204,'BL','Basel-Landschaft');
INSERT INTO zones VALUES (109,204,'BS','Basel-Stadt');
INSERT INTO zones VALUES (110,204,'FR','Freiburg');
INSERT INTO zones VALUES (111,204,'GE','Genf');
INSERT INTO zones VALUES (112,204,'GL','Glarus');
INSERT INTO zones VALUES (113,204,'JU','Graubnden');
INSERT INTO zones VALUES (114,204,'JU','Jura');
INSERT INTO zones VALUES (115,204,'LU','Luzern');
INSERT INTO zones VALUES (116,204,'NE','Neuenburg');
INSERT INTO zones VALUES (117,204,'NW','Nidwalden');
INSERT INTO zones VALUES (118,204,'OW','Obwalden');
INSERT INTO zones VALUES (119,204,'SG','St. Gallen');
INSERT INTO zones VALUES (120,204,'SH','Schaffhausen');
INSERT INTO zones VALUES (121,204,'SO','Solothurn');
INSERT INTO zones VALUES (122,204,'SZ','Schwyz');
INSERT INTO zones VALUES (123,204,'TG','Thurgau');
INSERT INTO zones VALUES (124,204,'TI','Tessin');
INSERT INTO zones VALUES (125,204,'UR','Uri');
INSERT INTO zones VALUES (126,204,'VD','Waadt');
INSERT INTO zones VALUES (127,204,'VS','Wallis');
INSERT INTO zones VALUES (128,204,'ZG','Zug');
INSERT INTO zones VALUES (129,204,'ZH','Zrich');

# Spain
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'A Corua','A Corua');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Alava','Alava');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Albacete','Albacete');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Alicante','Alicante');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Almeria','Almeria');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Asturias','Asturias');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Avila','Avila');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Badajoz','Badajoz');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Baleares','Baleares');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Barcelona','Barcelona');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Burgos','Burgos');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Caceres','Caceres');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cadiz','Cadiz');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cantabria','Cantabria');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Castellon','Castellon');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ceuta','Ceuta');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ciudad Real','Ciudad Real');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cordoba','Cordoba');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Cuenca','Cuenca');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Girona','Girona');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Granada','Granada');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Guadalajara','Guadalajara');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Guipuzcoa','Guipuzcoa');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Huelva','Huelva');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Huesca','Huesca');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Jaen','Jaen');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'La Rioja','La Rioja');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Las Palmas','Las Palmas');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Leon','Leon');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Lleida','Lleida');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Lugo','Lugo');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Madrid','Madrid');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Malaga','Malaga');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Melilla','Melilla');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Murcia','Murcia');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Navarra','Navarra');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Ourense','Ourense');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Palencia','Palencia');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Pontevedra','Pontevedra');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Salamanca','Salamanca');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Santa Cruz de Tenerife','Santa Cruz de Tenerife');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Segovia','Segovia');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Sevilla','Sevilla');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Soria','Soria');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Tarragona','Tarragona');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Teruel','Teruel');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Toledo','Toledo');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Valencia','Valencia');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Valladolid','Valladolid');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Vizcaya','Vizcaya');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Zamora','Zamora');
INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (195,'Zaragoza','Zaragoza');

#australian zones
INSERT INTO zones VALUES (NULL, 13, 'ACT', 'Australian Capital Territory');
INSERT INTO zones VALUES (NULL, 13, 'NSW', 'New South Wales');
INSERT INTO zones VALUES (NULL, 13, 'NT', 'Northern Territory');
INSERT INTO zones VALUES (NULL, 13, 'QLD', 'Queensland');
INSERT INTO zones VALUES (NULL, 13, 'SA', 'South Australia');
INSERT INTO zones VALUES (NULL, 13, 'TAS', 'Tasmania');
INSERT INTO zones VALUES (NULL, 13, 'VIC', 'Victoria');
INSERT INTO zones VALUES (NULL, 13, 'WA', 'Western Australia');

Yes, I was wanting to add all countries back that I would have with a clean install.:yes:

Worked Perfect! Seriously thanks for helping!

thank you Ajeh, I am getting the duplicate entry error because it's all ready there, I have been using a US only zone, I thought I was missing something, so if I select no zone then the cart goes worldwide correct? I am going worldwide next month that why i'm looking into this!

If you already have all of the countries and all of the zones for those countries then just removing the Zone you created to filter you modules should do it for you ...

This would have saved a few hours of work for me back then. Would've appreciated help sooner. I have so many posts that never went answered that are sure easy answers for coders, which I am not. Sorry to go off-topic, but I needed to vent.:censored: