Unable to delete country

Hello,

I had my site originally set up to ship only within the U.S. but somehow, Canada showed up, not sure how. I wasn't aware until I received an order tonight from a Canadian customer.

I refunded the money and sent an email advising that I wasn't able to ship to their location. Afterwards, I logged into my admin, went to delete Canada from my country list but it wouldn't let me due to being linked to a customer. I went back and cancelled the original order and deleted it, then went and deleted the customer then logged off and back on to try but it still wouldn't let me delete it again saying it was linked to a customer.

How can I get it deleted?

Thanks

Jim

You would need to check the table:
address_book

and see who else is using Canada for the field:
entry_country_id

is set to 38 (the default of Canada) ...

Ajeh:

You would need to check the table:
address_book

and see who else is using Canada for the field:
entry_country_id

is set to 38 (the default of Canada) ...

Thanks, if you have a sec could you tell me where to go to check that table?

Thanks again,

Jim

You would need to go to your phpMyAdmin to review that table in your database and locate which customer(s) are using Canada ...

RiverCity:

Thanks, if you have a sec could you tell me where to go to check that table?

Thanks again,

Jim

That worked, got it deleted, had one other one in there I didn't know about.

Thanks again,