Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Pages: 1
- Index
- » ClickCartPro and EuropaCart 8
- » How to delete unrequired countries & states in Europacart 8 quickly
#1 03-04-2014 18:57:48
- mixer25
- Member
- From: Ireland
- Registered: 04-02-2006
- Posts: 601
How to delete unrequired countries & states in Europacart 8 quickly
Go to System/Database/Raw Database Admin
Find core_country and core_stateprov export both and save.
Run
DELETE FROM core_country
then
DELETE FROM core_stateprov
Delete carefully all the countries/counties unrequired and save as a csv file in Excel
Go back to Go to System/Database/Raw Database Admin
Find core_country and core_stateprov import both again and import...
Worth saving a backup of the two files, in case things change!
Last edited by mixer25 (03-04-2014 19:00:58)
Offline
#2 03-05-2014 12:56:23
Re: How to delete unrequired countries & states in Europacart 8 quickly
Good tip. Thanks. Another way to do it, if you only want to save a few, would be like:
DELETE FROM core_country WHERE id<>'United States' AND id<>'Mexico' AND id<>'Canada'
Nick Hendler
Offline
#3 03-05-2014 19:40:32
- mixer25
- Member
- From: Ireland
- Registered: 04-02-2006
- Posts: 601
Re: How to delete unrequired countries & states in Europacart 8 quickly
webmaster wrote:
Good tip. Thanks. Another way to do it, if you only want to save a few, would be like:
DELETE FROM core_country WHERE id<>'United States' AND id<>'Mexico' AND id<>'Canada'
So just by using this code it keeps the ones you WHERE id<> ?
Offline
#5 03-15-2014 01:04:10
Re: How to delete unrequired countries & states in Europacart 8 quickly
webmaster wrote:
Right.
Thanks Nick,
That made my day. I so love this part. I did a full back up just in case.
Offline
#6 04-22-2014 10:44:38
- Chaz 7788
- Member
- Registered: 04-12-2014
- Posts: 4
Re: How to delete unrequired countries & states in Europacart 8 quickly
I'm using version 8 and I only want to offer services to clients in the united states I try editing with core_country with no results any thoughts.
DELETE FROM core_country WHERE id<>'United States'
Offline
#8 04-22-2014 15:53:35
Re: How to delete unrequired countries & states in Europacart 8 quickly
I know it worked like a champ for me Chaz.
Offline
Pages: 1
- Index
- » ClickCartPro and EuropaCart 8
- » How to delete unrequired countries & states in Europacart 8 quickly