country pulldown change

[fairestcape]

Are you nuts? DB is the fastest way.

Took me literally 30 seconds to delete all countries except for north america.

DELETE from countries WHERE countries_iso_code_3 NOT IN('USA', 'CAN') 

No, we're not nuts old boy... Just like to play it safe with people who are not likely to have a Masters Degree in MySQL.

[Rebelwax]

I deleted a whole bunch of countries a while back because I wasn't shipping to them and now I want to start shipping to a few that were deleted. Is there a list of country ISO codes that I can reference to add them back in? Also what does the Address Format do?

[Vladimir7]

No, we're not nuts old boy... Just like to play it safe with people who are not likely to have a Masters Degree in MySQL.

Well, it is not a hard query by any stretch of the imagination, anyone with a slight knowledge of SQL would know how to do it... but ya I guess if you don't want to take a risk (although could just backup a table)

[Shana]

Dear @rashawn13,

I also am interested in the login box.
Where can I get that from?

Thank you,
Shana

[nuftjedi]

I deleted a whole bunch of countries a while back because I wasn't shipping to them and now I want to start shipping to a few that were deleted. Is there a list of country ISO codes that I can reference to add them back in? Also what does the Address Format do?

I would like to know how to add countries back in as well... any help would be great. thanks!

[elastic]

hi folks i posted one solution here:

http://www.zen-cart.com/forum/showth...ighlight=viola

[jamesdavid]

I want to remove all countries except for the UK. Presumably I need to type in the following;

DELETE from countries WHERE countries_iso_code_3 NOT IN('UK')

Where to i type in this command?

[Steven300]

I want to remove all countries except for the UK. Presumably I need to type in the following;

DELETE from countries WHERE countries_iso_code_3 NOT IN('UK')

Try this instead:

DELETE from countries WHERE countries_iso_code_3 NOT IN('GBR')

Where to i type in this command?

Admin > Tools > Install SQL Patches

Backup your db first

[thatglenn]

Try this instead:

DELETE from countries WHERE countries_iso_code_3 NOT IN('GBR')



Admin > Tools > Install SQL Patches

Backup your db first

I tried this and it did not work.
Neither did
DELETE from countries WHERE countries_iso_code_3 NOT IN('UK')

Solution?
Backup DB first.
DELETE from countries WHERE countries_iso_code_3 NOT IN('GBR');

(copy & paste into Admin/Tools/Install SQL Queries panel and send)

Make sure you do not miss out the ; and it works fine.
This is a standard DB query string and should work across all versions of ZC, but I have only tested this on v1.3.8.

[Steven300]

Yes naturally a semicolon should be added at the end.

Thanks for making that clear.