How to remove all countries and only allow US

Adisan wrote:Moggin is right; if the countries do not show in the dropdown menu

( even after you did run this code:

UPDATE country SET status = 0 WHERE country_id <> 223;
UPDATE zone SET status = 0 WHERE country_id <> 223;)
,
just delete all the files in the system/cache folder except the index.html, that should solve it; in my case did.
And thanks for the help guys, I appreciate it!

Thanks Adisan, seems like what you found out is the right choice. I decided to add all the countries I had deleted before (with status = 0) so they are now disabled, and after cleaning the cache in /system/cache/ all is working fine in the drop-down arrow for countries only shows the one I selected with status =1

We opted to perform the delete instead of change status. It worked as expected BUT now when completing purchase at checkout the shipping address is not saved. Shipping address whether entered different than payment address or not specified as different; both result in no shipping address attached to the transaction and blank in the confirmation email.

The timing may have been a coincidence but what should I look for to resolve this.

thanks

kbtech wrote:We opted to perform the delete instead of change status. It worked as expected BUT now when completing purchase at checkout the shipping address is not saved. Shipping address whether entered different than payment address or not specified as different; both result in no shipping address attached to the transaction and blank in the confirmation email.

The timing may have been a coincidence but what should I look for to resolve this.

thanks

If you saved the country table (in phpmyadmin or the free cvs module) just before deleting, can you incorporated it back and see if that fix your problem ?

Thanks for the quick response, I tried that and no luck. I guess it's unrelated to disabling the other countries but I'm still stuck. Upon further testing I realized that if I use an existing user account and login during checkout everything works fine. This occurs at Guest Checkout only. At least I have some additional data to search the forum with. thanks again

My issue turned out to be the result of my inexperience with OC and not the removing of countries. The lack of shipping address was due to a product setting not requiring shipping. This was simply to allow free shipping on that particular item. Instead I've implemented a free shipping work around provided at another post....http://forum.opencart.com/viewtopic.php ... 5&p=146386

Works perfectly, thank you for saving me HOURS of manual deleting!!

hi all

anyone know the id to disable all countries and allow only australia?
i am using v1.5.1


cheers!

ppourri wrote:hi all

anyone know the id to disable all countries and allow only australia?
i am using v1.5.1


cheers!

Australia is ID 13 in my 1.5.1 database. If you go to PhpMyAdmin > your shop database > & browse to the 'country' table, you should see it there

Moggin wrote:

ppourri wrote:hi all

anyone know the id to disable all countries and allow only australia?
i am using v1.5.1


cheers!

Australia is ID 13 in my 1.5.1 database. If you go to PhpMyAdmin > your shop database > & browse to the 'country' table, you should see it there

Thanks for that!

Does anyone know if this works for version 1.5.1?

grgolf wrote:Does anyone know if this works for version 1.5.1?

Yes it does. I've tried it. works perfect

How do I keep just 4 countries?

For all versions 1.4.8 through 1.5.x
1. Goto Admin System->Settings
2. On the options tab set "Default Items Per Page (Admin):" to 300
3. Save
4. Goto Admin->System->Localisation->Countries
5. Let all 240ish countries load up
6. Click the master checkbox
7. Scroll down to the countries you don't want to add and uncheck them
8. Click the "Delete" Button at the top of the page.
9. Go back to the system- settings and change the Default items per page back to something lower

Thanks Q, I tried that before as I thought that would work but I get "Warning: This country cannot be deleted as it is currently assigned to 4 zones!" when I try to delete them all except the 4 I wish to keep.

Ozfarmer wrote:Thanks Q, I tried that before as I thought that would work but I get "Warning: This country cannot be deleted as it is currently assigned to 4 zones!" when I try to delete them all except the 4 I wish to keep.

Well then delete the geozones first

Thanks Q, That worked well.

Adisan wrote:Moggin is right; if the countries do not show in the dropdown menu

( even after you did run this code:

UPDATE country SET status = 0 WHERE country_id <> 223;
UPDATE zone SET status = 0 WHERE country_id <> 223;)
,
just delete all the files in the system/cache folder except the index.html, that should solve it; in my case did.
And thanks for the help guys, I appreciate it!

this did it for me in 1.5.1.3 , thankyou

Is this still the only way to remove all countries but USA ? I am using version 1.5.1.3

I used the delete version last year.

But now i am expanding outside the UK is there a way of installing all countries and all zones within the countries again?

Big thanks to everyone who inputted on this thread, below worked perfectly for me for the UK after clearing the cache folder too (opencart version 1.5.2.1)

UPDATE country SET status = 0 WHERE country_id <> 222;
UPDATE zone SET status = 0 WHERE country_id <> 222;