QUICK EDIT FOR COUNTRIES I WOULD SHIP TOO

Hi,

I only want to ship to USA. Is there an easier way to delete all countries in 1 easy step vs:

http://www.whatismydogtype.com/Administration/Countries.aspx where I have to click on each country and click edit for EACH country?

Thanks

1. Connect to your database and execute the following query:

update Nop_Country
set allowsshipping=0
where countryid <> 1
//countryid = 1 is USA by default"

2. Reset your cache

Thanks, will do right now :)

Just in case someone needs it.  Here is the SQL statement for v2.65

/*Allow only US to have products shipped (ID =1)*/
UPDATE Country
SET AllowsShipping=0
WHERE Id <> 1