Deleting all countries?

10 Aug 2007, 8:52 AM

#1

blueparukia

New Zenner

Join Date:: Aug 2007
Posts:: 18
Plugin Contributions:: 0

Deleting all countries?

I want my business to be Australian only, so I need to delete all 239 other countries. Can I do this quickly?

Thanks,

BP

10 Aug 2007, 8:56 AM

#2

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: Deleting all countries?

I want my business to be Australian only, so I need to delete all 239 other countries. Can I do this quickly?Do not need to delete any Just configure the shop to be only for the AU with zones

Countries only seen on the admin side

10 Aug 2007, 9:44 AM

#3

blueparukia

New Zenner

Join Date:: Aug 2007
Posts:: 18
Plugin Contributions:: 0

Re: Deleting all countries?

How do I do that exactly?

Thanks,

BP

10 Aug 2007, 12:03 PM

#4

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: Deleting all countries?

Here are 2 that I responded to and I know that there are many more in addition to the FAQ's and the wiki

One thread and another thread

10 Aug 2007, 11:19 PM

#5

blueparukia

New Zenner

Join Date:: Aug 2007
Posts:: 18
Plugin Contributions:: 0

Re: Deleting all countries?

I don't actually want to know shipping costs, I just want to remove all countries bar Australia from the dropdown list that appears on the registration page.

BP

10 Aug 2007, 11:22 PM

#6

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: Deleting all countries?

The quickest way is to grab that table from your DB and eliminate the records that you do not want and re-insert the edited table back to your DB.

Or the slow way is to delete them one by one via the admin

11 Aug 2007, 1:44 AM

#7

blueparukia

New Zenner

Join Date:: Aug 2007
Posts:: 18
Plugin Contributions:: 0

Re: Deleting all countries?

What's the table name?

11 Aug 2007, 4:57 AM

#8

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: Deleting all countries?

Deleting all countries? - What's the table name?

Uh?? Countries

11 Aug 2007, 7:35 AM

#9

blueparukia

New Zenner

Join Date:: Aug 2007
Posts:: 18
Plugin Contributions:: 0

Re: Deleting all countries?

Sorry, I had a blank/dumb/normal moment

11 Aug 2007, 5:15 PM

#10

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: Deleting all countries?

Sorry, I had a blank/dumb/normal moment
Don't we all!!??