US Shipping Only - is there an easy way?

Is there an easy to set it up for single country shipping (US only, in my case).

It will take forever to delete all the other countries.....

Will rarely ship elsewhere, but don't want to eliminate the possibility - only make it a case by case estimate. So, is it possible to do this so that all other countries get the rate of "please call or email for a rate to your country"

I did it without deleted the other countries. I just have to remember how I did it.

I would forever be gratefull if you could...

anybody????

this sure is getting tedious deleting countries....

...i am down to 8 pages of them:cry:

Well, one way you can make that faster is to go into phpadmin and delete them by selecting all except for the US.

Do you know how to use phpadmin? It's in your hosting backend, cpanel, pleask, something like that.

JP

this is what i see in phpmyadmin under zen_countries - i don't see individual countries that can be nuked:

countries_id
countries_name
countries_iso_code_2
countries_iso_code_3
address_format_id

I made this video to show you what I'm talking about.

http://www.youtube.com/watch?v=W4lDUGkfoWc

Let me know if you have questions.

brilliant!
finally a good use for youtube!
that was very helpful and worked like a charm.
thank you.

Cool! Glad you liked it.

Now I'll do some of the tutorials.

Hmmm, The Zen Cart Video Blog. sounds catchy....

I am needing the answer that apparenlty was given in the Video but the link no longer points to a valid video. Is there a new link to this.

I want to limit shipping (and customer registration) to the continental USA but I do not want to remove all the countries in case I want to ship to them later. There has been a lot of discussion on this and I am prepared to remove all the countries in the database but I was hoping for a way to do it without deleting them all.

go into your PHPMyAdmin
Select the database for your zen cart installation
Click on Table: zen_countries
Click on BROWSE
Select ALL (except for United States)
Delete (or Drop) all selected