Locations

[dlsodders]

Hello again community,

 

Does anyone know how to remove all the locations except ones you work in or will ship too?

 

I would really only like to ship within the united states however removing the countries one by one would take a lot of time.

 

Thanks for any help.

 

BYW.. You guys have been great

 

david

[Guest]

open your database and do it via mysql connector, phpmyadmin or the mysql shell

[dlsodders]

Thanks John :) I guess I should have looked there first!

[xuoaddict]

I tried that too. But unless you know a better way it still only allowed me to delete one at a time. So I went back to Admin and deleted them from there.

[nrlatsha]

If I'm not mistaken, you can use phpmyadmin, browse the table, select the check boxes next to each one, and drop all selected tables, that seems pretty easy to me... Heck of alot easier than doing it through admin.

[xuoaddict]

my php must be different than yours as I do not have the boxes next to each country to select. only edit or delete. Still gona have to do it one at a time.

[nrlatsha]

my php must be different than yours as I do not have the boxes next to each country to select. only edit or delete. Still gona have to do it one at a time.

Through the sql phpmyadmin area.

 

In the database, you go to the countries table and hit browse, select the countries you want to kill via the checkboxes and select drop at the bottom of the page.

 

Of course you probably already have it done, but this might help someone else looking for it...

[sheepiedog]

My store only ships within the U.S. If I just delete all the other countries in Admin, then this will mean I cant accept orders from outside the US?

 

This is what I need to find, a way to not allow non-US orders. Can anyone please confirm that this will be what I need?

[nrlatsha]

If you delete all other countries in admin, the only box people can select it US, of course they can put US, but be somewhere else...

 

**edit**

 

But then again, you get into mail drops in the US. They use a US address to drop it to, the dropee ships it to them overseas...

 

You can then do an IP lookup on them to see where they're from too. If you are using credit cards, you can install my maxmind contrib, that'll tell you:

 

Where they're from

City of the credit card billing address

City of IP

Card issuer city and state

 

And a lot of other stuff, you can get it here: http://www.oscommerce.com/community/contributions,2115

 

HTH

Noel