Kryptronic Software Support Forum

mixer25 · 02-06-2007 05:19:10

Is there an easy way of deleteing 5 pages of countries when u only want to do UK?

Thanks

Litemaster · 02-06-2007 05:54:18

Go to Kryptronic Hybrid X Core: Raw Database Admin
Then choose the 'SQL Statement: Submit a Raw SQL Statement'
Then enter: DELETE FROM ccp0_country WHERE id<>'United Kingdom'

This will delete every entry except the United Kingdom

Mike Simpson
Litemaster Systems
wwwdjshopper.net

Lisaweb · 02-07-2007 13:50:03

What would be the SQL statement to delete individual ones that you don't want?

Thanks!
Lisa

Dave · 02-07-2007 14:04:26

Code:

DELETE FROM ccp0_country WHERE id = 'country to remove'

Lisaweb · 02-08-2007 10:58:20

Thanks Dave!

wyattea · 02-08-2007 16:26:39

I assume this is for deleting countries that refer to the billing address? What if you only ship within a specific country (e.g. canada) and you don't want them to put a shipping address out of canada? Is it a sql statement or is it built into the admin panel?

James...

webmaster · 02-09-2007 10:59:56

That's built into the management interface. Go to:

ClickCartPro > Locations: States, Provinces and Countries > Manage Countries

Choose to update whatever country you want. The two fields:

Display in Contact Forms
Display in Delivery Forms

Handle whether the country is shown in billing and shipping forms respectively.

rickmase · 08-10-2007 12:49:42

Is there an easy way to set "Display in Contact Forms" and "Display in Delivery Forms" all to "No" so I can go back and just turn on the US?

webmaster · 08-18-2007 11:42:42

Yes. Access:

Home > Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin

And choose to execute a Raw SQL Statement. Execute these statements one at a time:

UPDATE ccp0_country SET usedel=0, usecon=0

UPDATE ccp0_stateprov SET usedel=0, usecon=0

wyattea · 03-22-2008 19:06:33

UPDATE ccp0_country SET usedel=0, usecon=0

- just to confirm, will this only apply to delivery? the question from rickmase referred to BOTH contact forms and delivery forms. I just want to change countries for DELIVERY all to NO.

Regards,

James...

wyattea · 03-22-2008 20:32:00

nevermind, i just exported the csv and changed all to 0 except Canada and imported it back in

James...

Kryptronic Software Support Forum

#1 02-06-2007 05:19:10

deleting countries you don't want to deal with

#2 02-06-2007 05:54:18

Re: deleting countries you don't want to deal with

#3 02-07-2007 13:50:03

Re: deleting countries you don't want to deal with

#4 02-07-2007 14:04:26

Re: deleting countries you don't want to deal with

Code:

#5 02-08-2007 10:58:20

Re: deleting countries you don't want to deal with

#6 02-08-2007 16:26:39

Re: deleting countries you don't want to deal with

#7 02-09-2007 10:59:56

Re: deleting countries you don't want to deal with

#8 08-10-2007 12:49:42

Re: deleting countries you don't want to deal with

#9 08-18-2007 11:42:42

Re: deleting countries you don't want to deal with

#10 03-22-2008 19:06:33

Re: deleting countries you don't want to deal with

#11 03-22-2008 20:32:00

Re: deleting countries you don't want to deal with

Board footer