[bigmaggot]

I've seen a couple of posts on Northern Ireland, Channel Islands (Guernsey Jersey), Isle of Wight, Isle of Man and I've spent hours trying to sort how to sort adding countries and shipping prices to these countries so here we are.

I've investigated the ISO number, codes and they are fully compatible. This means that the below countries will not be overwritten etc by new country codes. Of course it will be up to you whether you have Jersey etc as I country.

If you wish you can investigate the ISO codes and change them to your preference but I don't see any point!

Go to Patch and Upgrade and run this:

INSERT INTO xcart_countries VALUES ('IM','IMN',833,'EU','iso-8859-1','Y','D','Y');
INSERT INTO xcart_languages VALUES ('US','Isle of Man','country_IM','Isle of Man','Countries');
INSERT INTO xcart_languages VALUES ('US','Language of Isle of Man','language_IM','English','Languages');

INSERT INTO xcart_countries VALUES ('JE','JEY',832,'EU','iso-8859-1','Y','D','Y');
INSERT INTO xcart_languages VALUES ('US','Jersey','country_JE','Jersey','Countries');
INSERT INTO xcart_languages VALUES ('US','Language of Jersey','language_JE','English','Languages');

INSERT INTO xcart_countries VALUES ('GG','GGY',831,'EU','iso-8859-1','Y','D','Y');
INSERT INTO xcart_languages VALUES ('US','Guernsey','country_GG','Guernsey','Countrie s');
INSERT INTO xcart_languages VALUES ('US','Language of Guernsey','language_GG','English','Languages');

INSERT INTO xcart_countries VALUES ('ZZ','ZZZ',999,'EU','iso-8859-1','Y','D','Y');
INSERT INTO xcart_languages VALUES ('US','Northern Ireland','country_ZZ','Northern Ireland','Countries');
INSERT INTO xcart_languages VALUES ('US','Language of Northern Ireland','language_ZZ','English','Languages');

INSERT INTO xcart_countries VALUES ('XY','XXY',998,'EU','iso-8859-1','Y','D','Y');
INSERT INTO xcart_languages VALUES ('US','Isle of Wight','country_XY','Isle of Wight','Countries');
INSERT INTO xcart_languages VALUES ('US','Language of Isle of Wight','language_XY','English','Languages');

INSERT INTO xcart_countries VALUES ('XX','XXX',997,'EU','iso-8859-1','Y','D','Y');
INSERT INTO xcart_languages VALUES ('US','UK Offshore','country_XX','UK Offshore','Countries');
INSERT INTO xcart_languages VALUES ('US','Language of UK Offshore','language_XX','English','Languages');

INSERT INTO xcart_countries VALUES ('XV','XXV',996,'EU','iso-8859-1','Y','D','Y');
INSERT INTO xcart_languages VALUES ('US','UK BFPO','country_XV','UK BFPO','Countries');
INSERT INTO xcart_languages VALUES ('US','Language of UK BFPO','language_XV','English','Languages');

This will work on 4.0.17 and 4.0.18 and possibly previous versions but can't list as I haven't used these versions.

Here is the official example info that I got from xcart support which I don't think is a great example:

---
INSERT INTO xcart_countries VALUES ('US','USA',840,'NA','iso-8859-1','Y','','Y');
INSERT INTO xcart_country_currencies VALUES ('USD','US');
INSERT INTO xcart_currencies VALUES ('USD',840,'US Dollar','$');
INSERT INTO xcart_languages VALUES ('US','United States','country_US','United States','Countries');
INSERT INTO xcart_languages VALUES ('US','Language of United States','language_US','English','Languages');
---

Any questions or thanks please let me know.

Thanks,

Andy