Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Locations


dlsodders

Recommended Posts

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

Link to comment
Share on other sites

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.

9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard)

 

Replace that and you're fine...

Link to comment
Share on other sites

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...

9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard)

 

Replace that and you're fine...

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard)

 

Replace that and you're fine...

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...