Allow only customers for US

[arashb]

How can I limit customer's to only be from the US? I want to ship only to the US, and in the new customer section, I want the country to only be US.
Thanks

[barco57]

Admin>location/taxes>countries delete all of those countries you don't want.

[alicia1234]

Is there an easy way to delete all countries except US, other than manually deleting one by one?

[fairestcape]

Unless you're a dab hand at MySQL, or know your way around phpMyAdmin, most reliable way is to delete them manually in your Admin Panel. Yes, it takes about 15 to 20 minutes - but will prevent errors!

[alicia1234]

I do know my away around MySQL and phpAdmin. Thanks for that tip!

Here's what I did:

DELETE FROM `zen_countries` WHERE countries_name <> "United States"

Nice and quick!

[Soul39]

that was slick! I was looking for a way to do that for the uk.
Now i can. Thanks to you.



soul39

[asimms1]

The syntax in this statement did not work on my version of Zen. I made some changes. Try this if the above doesn't work for you.

DELETE FROM `countries` WHERE countries_name <> "United States";

Adam

[alicia1234]

asimms1: it has to do with how you set up zen cart. I chose to have the names of all my table start with "zen_". That's the difference. Thanks for pointing that out.

[gilby]

How can I limit customer's to only be from the US? I want to ship only to the US, and in the new customer section, I want the country to only be US.
Thanks

You don't want orders from outside the US for delivery to the US???

[susb8383]

I just did the same thing (deleted my non-US countries) and I just wanted to mention: don't forget about zones (states).

In my case my dropshipper will only ship to the continental US. The default zones table has lots of US 'states' such as Guam, Puerto Rico, Armed Services Africa, etc.

I just went in and deleted the non-continental ones.

Also if you have any zone definitions set up in ZenCart for a country or zone you're about to delete, remove these manually first so you don't end up with orphans.

I guess if you wanted to keep everything clean, you should delete all the entries in the zone table that aren't for the US, but I just left them since they'll never show up in a dropdown list because the visitor can only select the US.

Technically I supposed I should allow a foreign billing country to ship to the US, but I haven't gotten any orders like this yet so it probably doesn't justify the added complexity to arrange it.