OpenCart

For the US:

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