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.

#1 08-15-2011 00:50:26

121NetDesign
Member
From: Surrey, UK
Registered: 05-10-2007
Posts: 427

UK - Isle of Wight in Europacart

Am I missing something?

'UK - Isle of Wight' appears not to be in the countries list.

Last edited by 121NetDesign (08-15-2011 03:04:49)


Tommy Lee

Offline

 

#2 08-15-2011 03:30:08

ZipSkins
Member
From: United Kingdom
Registered: 01-15-2006
Posts: 822
Website

Re: UK - Isle of Wight in Europacart

The Isle of Wight isn't a country, even if some of the residents would like it to be!

The postcode area is Portsmouth.


| Professional Quality Customisable Skins for your ClickCartPro Powered Site


-----------------------------
Certified Support Partner

Offline

 

#3 08-15-2011 03:59:50

121NetDesign
Member
From: Surrey, UK
Registered: 05-10-2007
Posts: 427

Re: UK - Isle of Wight in Europacart

OK, now confused.

We had an order come through this morning with the following Billing and Delivery Address.

Name
xxx road name
newport, Isle of Wight poxx xxx
UK - Isle of Wight

How did they type 'UK - Isle of Wight' when it isn't in the 'Country' list? I can see it in the State/Province' list as 'Isle of Wight'.

How did they do this? AND more important, why was it liable for VAT Refund?

Thanks in Advance

Tommy


Tommy Lee

Offline

 

#4 08-15-2011 09:34:14

zanart
Member
From: bedford
Registered: 04-02-2008
Posts: 1681

Re: UK - Isle of Wight in Europacart

Have you just upgraded to ccp7??

The customer was probably an account holder  from the old CCP6 database where UK - Isle of wight was available.

You need to edit the user accounts so they all read United Kingdom, not UK - Northern Ireland, UK - Channel Islands, etc, etc.


- Euorpacart 8

Offline

 

#5 08-15-2011 10:05:44

121NetDesign
Member
From: Surrey, UK
Registered: 05-10-2007
Posts: 427

Re: UK - Isle of Wight in Europacart

Yeah, went for the upgrade around 2 months ago. Suspected that was the cause.


zanart wrote:

You need to edit the user accounts so they all read United Kingdom, not UK - Northern Ireland, UK - Channel Islands, etc, etc.

OMG! We have 2,700+ user accounts. Surely, there must be an easier way than to manually go through them all 1 by 1.

Tommy

Last edited by 121NetDesign (08-15-2011 10:06:10)


Tommy Lee

Offline

 

#6 08-16-2011 04:31:14

ZipSkins
Member
From: United Kingdom
Registered: 01-15-2006
Posts: 822
Website

Re: UK - Isle of Wight in Europacart

121NetDesign wrote:

Surely, there must be an easier way than to manually go through them all 1 by 1.

Tommy

An SQL update.


| Professional Quality Customisable Skins for your ClickCartPro Powered Site


-----------------------------
Certified Support Partner

Offline

 

#7 08-16-2011 09:25:49

zanart
Member
From: bedford
Registered: 04-02-2008
Posts: 1681

Re: UK - Isle of Wight in Europacart

or download the table and edit in Excel.
Should only take a few minutes.


- Euorpacart 8

Offline

 

Board footer