How to Remove all open cart Countries Except Your Country

 June 28, 2015   OpenCart

For the US:

delete from country where country_id <> 223;
delete from zone where country_id <> 223;