struggling with countries

[keat]

I've upgraded a test site from V3 to V6, which didn't really go in to much depth with countries, as we had a custom shipping and tax mod.

So now i'm trying to get a working V6 to how we'd like it and am really struggling with countries.

So I added GB and Jersey as two test countries.

When I come to create a new account, I have no counties listed, so I have to type my county manually.

This is fine for GB, but as far as I'm aware, the small ilsand of Jersey doesn't have counties and won't allow me to proceed without typing something.

Am I missing something ???

 

[bsmither]

Let's take a step back and have a look at what you are wanting to do.

First, where are you at configuring CubeCart where countries are important?

CC6 already has a country named 'Jersey' (ISO abbreviation 'JE' and ISO-3 of 832), and a country named 'United Kingdom' (ISO abbreviation 'GB' and ISO-3 of 826).

In most places, if CubeCart sees that the country you have selected has states/counties/provinces, then the pertinent form element presented to you to fill out these addresses is suppose to be converted to a drop-down. Otherwise, it stays as a text-entry box (in some cases, that form element disappears completely) and, importantly, the "Required" condition of that text entry box is supposed to be removed.

 

[keat]

I'm in the UK, I was initially trying to setup taxes, but couldn't find any countries configured.

When I enter in to the countries section, I see no countries configured. Last night I added the ISO for the UK etc.

 

I'l start over with the upgrade, and see what's there before I start making changes. It's only an hours work.

[keat]

So I reloaded the V3 and upgraded to V6 and now I see countrys again.

But could these country's and county/zones be imported from V3 and be out of date.

Also, when i choose Jersey as the country, it's still prompting me for a county, yet Jersey is listed as a county in GB.

I'm really confused. Is there any point to having an Iso code for Jersey, iif it's listed under GB.

Also, there appears to be additional entries in the list which are quite clearly not counties.

EG, Wakefield is a city.

[bsmither]

"Could these country's and county/zones be imported from V3 and be out of date?"

The table is renamed, but otherwise the contents carry over from CC3. During the upgrade process, more countries are added.

"Jersey is listed as a county in GB."

There seems to be a vast disparity between what CC3's country/county list gets upgraded to and what a fresh install of CC6 has. (I'll mention this to the developers.) For example, these 'counties' are not found in a fresh install of CC6: Aberdeen, Anglesey, Ards, Ballymena, Ballymoney, Banbridge, Barking and Dagenham, Barnet, Barnsley, Bath, Bedfordshire, and many more.

I do not know if the programmers can/will improve the upgrade process to deal with this.

I'll have more later.

 

[keat]

Some of those you mentioned are towns and cities, Anglesey is neither it's an Island.

so that i'm starting with a semi clean slate, is there any way to identify whats what in the database and clear out any v3 entries or drop the data and re-issue from fresh ?

[keat]

I copied the table 'cubecart_geo_zone' and removed all entries ascociated with 225 (UK) then added these (without abreviations) back in.

I'll copy the tables over this evening when ive a bit more time.

('182', '225', '', 'Avon'),
('183', '225', '', 'Bedfordshire'),
('184', '225', '', 'Berkshire'),
('185', '225', '', 'Borders'),
('186', '225', '', 'Buckinghamshire'),
('187', '225', '', 'Cambridgeshire'),
('188', '225', '', 'Central'),
('189', '225', '', 'Cheshire'),
('190', '225', '', 'Cleveland'),
('191', '225', '', 'Clwyd'),
('192', '225', '', 'Cornwall'),
('193', '225', '', 'County Antrim'),
('194', '225', '', 'County Armagh'),
('195', '225', '', 'County Down'),
('196', '225', '', 'County Fermanagh'),
('197', '225', '', 'County Londonderry'),
('198', '225', '', 'County Tyrone'),
('199', '225', '', 'Cumbria'),
('200', '225', '', 'Derbyshire'),
('201', '225', '', 'Devon'),
('202', '225', '', 'Dorset'),
('203', '225', '', 'Dumfries and Galloway'),
('204', '225', '', 'Durham'),
('205', '225', '', 'Dyfed'),
('206', '225', '', 'East Sussex'),
('207', '225', '', 'Essex'),
('208', '225', '', 'Fife'),
('209', '225', '', 'Gloucestershire'),
('210', '225', '', 'Grampian'),
('211', '225', '', 'Greater Manchester'),
('212', '225', '', 'Gwent'),
('213', '225', '', 'Gwynedd County'),
('214', '225', '', 'Hampshire'),
('215', '225', '', 'Herefordshire'),
('216', '225', '', 'Hertfordshire'),
('217', '225', '', 'Highlands and Islands'),
('218', '225', '', 'Humberside'),
('219', '225', '', 'Isle of Wight'),
('220', '225', '', 'Kent'),
('221', '225', '', 'Lancashire'),
('222', '225', '', 'Leicestershire'),
('223', '225', '', 'Lincolnshire'),
('224', '225', '', 'Lothian'),
('225', '225', '', 'Merseyside'),
('226', '225', '', 'Mid Glamorgan'),
('227', '225', '', 'Norfolk'),
('228', '225', '', 'North Yorkshire'),
('229', '225', '', 'Northamptonshire'),
('230', '225', '', 'Northumberland'),
('231', '225', '', 'Nottinghamshire'),
('232', '225', '', 'Oxfordshire'),
('233', '225', '', 'Powys'),
('234', '225', '', 'Rutland'),
('235', '225', '', 'Shropshire'),
('236', '225', '', 'Somerset'),
('237', '225', '', 'South Glamorgan'),
('238', '225', '', 'South Yorkshire'),
('239', '225', '', 'Staffordshire'),
('240', '225', '', 'Strathclyde'),
('241', '225', '', 'Suffolk'),
('242', '225', '', 'Surrey'),
('243', '225', '', 'Tayside'),
('244', '225', '', 'Tyne and Wear'),
('245', '225', '', 'Warwickshire'),
('246', '225', '', 'West Glamorgan'),
('247', '225', '', 'West Midlands'),
('248', '225', '', 'West Sussex'),
('249', '225', '', 'West Yorkshire'),
('250', '225', '', 'Wiltshire'),
('251', '225', '', 'Worcestershire'),
 

[bsmither]

That should work.

Any existing Order Summary records carried up from CC3 will still have the free-text entry of the County/State name. Any new orders saved in the Order Summary table will have the 'id' value. (The 'id' value is useful to maintain the correct spelling of the County/State, and to manage shipping zones and tax zones. When I was running a CC3 store, I had incredible variety of State names. For example: NOLA for New Orleans, Louisiana, which was acceptable by our USPS.)

[keat]

I uncovered another issue. We have the Islands of Scotland, ot which there are numerous, but still part of the UK.

A customer may enter UK as his country (rightly so), but in the list I created, there's no drop down for Orkney, and as the list is populated, these no ability for free text either, so in the end, i ditched all counties and left the box as free text.

Maybe the UK is trickier than the rest of the world.

[havenswift-hosting]

If you are worried about shipping charges for the "Highlands and Islands" then this can easily be taken care of using the All in One shipping module and defining zones based on postcodes

Ian