Thread: Mods for UK site: VAT and counties

Is there a definitive list of things you need to do to set up VAT for UK and also to set up counties rather than US states?

I see there are various sites that have done this without source code modes (eg 3M), so I know it should be easy to do, but it is a question of where to start.

This could then be included as a sticky post or as a PDF doc for download..

To turn on VAT, set the appconfig VAT.Enabled to true

If you want customers to be able to choose how prices are displayed (i.e. rices shown VAT inclusive or prices shown VAT exclusive), set the appconfig VAT.AllowCustomerToChooseSetting to true

If want the VAT tax to be shown as a line item when the subtotal displays on the checkout pages, the appconfig VAT.HideTaxInOrderSummary must be true

The other VAT related appconfigs (there are only 4 more...and they can all be found by selecting VAT from the Config Groups dropdown box in Misc -> AppConfig Parameters), are pretty self explanatory. One is for the ID of the country the VAT tax is based off of (United Kingdom is 80), one is for which price display method is the default (inclusive or exclusive), one is for configuring the storefront to know that you have entered the original prices with VAT already included in which case the tax amount is removed from the price you have entered in when the selected price display method is exclusive, and the last one is configuring the storefront to round the VAT included price before or after multiplying the price by the quantity of the product ordered.

SQL for inserting UK counties is as simple as grabbing one of the state insert statements from the original database installation scripts and substituting the name, abbreviation, and country id for your UK counties...something like

Code:

INSERT [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Avon','AVN',1)

for each county in the UK. If you find that you need more than 5 characters for the county abbreviation...you'll need to modify the Abbreviation column in the State table in the database to accept more than 5 characters.

Many thanks for the reply. This explains everything... although the county of Avon dissappeared in 1996!! Once I get a list together, I will post the SQL script for UK counties.

Hi,

Hope this helps some one, here is the sql for the uk counties:

Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Alderney','ALD',1)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Antrim','ATM',2)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Armagh','ARM',3)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Avon','AVN',4)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Bedfordshire','BFD',5)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Berkshire','BRK',6)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Borders','BDS',7)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Buckinghamshire','BUX',8)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Cambridgeshire','CBE',9)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Central','CTR',10)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Cheshire','CHS',11)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Cleveland','CVE',12)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Clwyd','CLD',13)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Cornwall','CNL',14)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Cumbria','CBA',15)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Derbyshire','DYS',16)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Devon','DVN',17)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Dorse','DOR',18)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Down','DWN',19)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Dumfries and Galloway','DGL',20)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Durham','DHM',21)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Dyfed','DFD',22)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Essex','ESX',23)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Fermanagh','FMH',24)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Fife','FFE',25)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Mid Glamorgan','GNM',26)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'South Glamorgan','GNS',27)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'West Glamorgan','GNW',28)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Gloucester','GLR',29)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Grampian','GRN',30)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Guernsey','GUR',31)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Gwent','GWT',32)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Gwynedd','GDD',33)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Hampshire','HPH',34)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Hereford and Worcester','HWR',35)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Hertfordshire','HFD',36)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Highlands','HLD',37)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Humberside','HBS',38)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Isle of Man','IOM',39)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Isle of Wight','IOW',40)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Jersey','JER',41)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Kent','KNT',42)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Lancashire','LNH',43)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Leicestershire','LEC',44)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Lincolnshire','LCN',45)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Greater London','LDN',46)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Londonderry ','LDR',47)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Lothian','LTH',48)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Greater Manchester','MCH',49)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Merseyside','MSY',50)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Norfolk','NOR',51)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Northamptonshire','NHM',52)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Northumberland','NLD',53)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Nottinghamshire','NOT',54)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Orkney','ORK',55)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Oxfordshire','OFE',56)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Powys','PWS',57)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Shropshire','SPE',58)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Sark','SRK',59)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Shetland','SLD',60)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Somerset','SOM',61)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Staffordshire','SFD',62)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Strathclyde','SCD',63)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Suffolk','SFK',64)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Surrey','SRY',65)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'East Sussex','SXE',66)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'West Sussex','SXW',67)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Tayside','TYS',68)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Tyne and Wear','TWR',69)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Tyrone','TYR',70)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Warwickshire','WKS',71)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Western Isles','WIL',72)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'West Midlands','WMD',73)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Wiltshire','WLT',74)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'North Yorkshire','YSN',75)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'South Yorkshire','YSS',76)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'West Yorkshire','YSW',77)

That is quite nice. thanks for posting.

Originally Posted by ASPDNSF Staff - George

The other VAT related appconfigs ........ one is for configuring the storefront to know that you have entered the original prices with VAT already included in which case the tax amount is removed from the price you have entered in when the selected price display method is exclusive.......

Hi George,

Does that one actually work? or even exist? (sure I saw it a while ago, but cannot find it now - 7.0.2.3 ).


TTFN

BFG

The ability to enter VAT-inclusive prices is not in the product. All pricing is entered as VAT-exclusive, then tax is added as needed based on the tax class and ship-to country.

The existing PricesEnteredWithVAT AppConfig is not currently used.

I've asked dev to remove the appconfig until it's implemented to avoid any further confusion. thx.

All prices I have in my database (the one I received from my supplier; I've not yet imported to admin) are inclusive of VAT. From the last post I gather that AppConfig.PricesEnteredWithVAT isn't actually functional? Is this correct?

Does this mean I cannot simply upload my supplier DB prices, and get ASPDNSF to automatically calculate and display how much of each price is VAT?

To show the VAT on the order total during checkout process, must I remove 17.5% off my supplier DB prices before actually importing for the storefront?

If I do this, and set VAT.DefaultSetting = 1, VAT.Enabled=true, and VAT.HideTaxInOrderSummary = false, will ASPDNSF automatically (using existing functionality) add the corect amount of VAT to each product price when displayed on the site, and then show the actual amount of VAT for the basket total during the checkout process?

...... OR .... a possible alternative solution that doesn't require altering original DB?......

We definately want to be able to accept orders from those who can claim the VAT on their purchases back. (Question: If the VAT amount is not explicitly shown in the customers basket and sales receipt, is it possible for customers to legally claim back VAT??).

Could I not just add some code to shoppingcart.aspx.cs, that calculates the VAT amount from the final basket total (remember that includes VAT), and displays this in the shopping basket and the sales receipt too)??

Infact, would adding this code within an if statement that checked if AppConfig.PricesEnteredWithVAT=true work?

The calculation would be ( 100 / ( 100 + [17.5%] ) * [Final Basket Total] = [Pre-VAT Price] ....

Could I use a flat 17.5%? Or is there a better way of doing this?

Any advice appreciated....

Added the UK counties list but on creating a new account, the page doesnt refresh after selecting 'UK'....thus the whole list of counties is displayed in the County/State dropdown.....

suppose the Country drop down should first not last in the list also if more than one country has applicable states/counties as they are all listed in the state/county drop down before a country is selected....could run into hundreds eventually.

Originally Posted by supergriff

--snip--

Any advice appreciated....

The store handles VAT perfectly.
Just import your products with the inclusive price / 1.175
The VAT element IS shown on reciepts.


TTFN

BFG

Originally Posted by mikemurphy

Added the UK counties list but on creating a new account, the page doesnt refresh after selecting 'UK'....thus the whole list of counties is displayed in the County/State dropdown.....

suppose the Country drop down should first not last in the list also if more than one country has applicable states/counties as they are all listed in the state/county drop down before a country is selected....could run into hundreds eventually.

just wanted this NOT to be missed...several threads in this topic

Originally Posted by akshah1

Hi,

Hope this helps some one, here is the sql for the uk counties:

Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Alderney','ALD',1)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Antrim','ATM',2)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Armagh','ARM',3)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Avon','AVN',4)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Bedfordshire','BFD',5)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Berkshire','BRK',6)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Borders','BDS',7)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Buckinghamshire','BUX',8)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Cambridgeshire','CBE',9)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Central','CTR',10)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Cheshire','CHS',11)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Cleveland','CVE',12)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Clwyd','CLD',13)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Cornwall','CNL',14)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Cumbria','CBA',15)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Derbyshire','DYS',16)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Devon','DVN',17)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Dorse','DOR',18)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Down','DWN',19)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Dumfries and Galloway','DGL',20)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Durham','DHM',21)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Dyfed','DFD',22)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Essex','ESX',23)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Fermanagh','FMH',24)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Fife','FFE',25)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Mid Glamorgan','GNM',26)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'South Glamorgan','GNS',27)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'West Glamorgan','GNW',28)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Gloucester','GLR',29)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Grampian','GRN',30)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Guernsey','GUR',31)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Gwent','GWT',32)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Gwynedd','GDD',33)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Hampshire','HPH',34)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Hereford and Worcester','HWR',35)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Hertfordshire','HFD',36)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Highlands','HLD',37)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Humberside','HBS',38)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Isle of Man','IOM',39)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Isle of Wight','IOW',40)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Jersey','JER',41)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Kent','KNT',42)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Lancashire','LNH',43)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Leicestershire','LEC',44)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Lincolnshire','LCN',45)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Greater London','LDN',46)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Londonderry ','LDR',47)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Lothian','LTH',48)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Greater Manchester','MCH',49)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Merseyside','MSY',50)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Norfolk','NOR',51)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Northamptonshire','NHM',52)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Northumberland','NLD',53)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Nottinghamshire','NOT',54)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Orkney','ORK',55)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Oxfordshire','OFE',56)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Powys','PWS',57)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Shropshire','SPE',58)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Sark','SRK',59)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Shetland','SLD',60)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Somerset','SOM',61)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Staffordshire','SFD',62)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Strathclyde','SCD',63)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Suffolk','SFK',64)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Surrey','SRY',65)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'East Sussex','SXE',66)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'West Sussex','SXW',67)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Tayside','TYS',68)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Tyne and Wear','TWR',69)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'County Tyrone','TYR',70)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Warwickshire','WKS',71)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Western Isles','WIL',72)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'West Midlands','WMD',73)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'Wiltshire','WLT',74)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'North Yorkshire','YSN',75)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'South Yorkshire','YSS',76)
Insert [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values (80,'West Yorkshire','YSW',77)

Im really inexsperienced with asp (and web site customization for that matter) where would i paste this to make it work?

this needs to be executed as an sql query.....you may need someone to do it for you if you're not experienced.....and back up first !

This is the SQL I used, created from the list on the site http://www.logisticsworld.com/ukcounties.asp.

Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'ABD','Aberdeenshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'ALD','Alderney',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'AGY','Anglesey',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'ANS','Angus',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'ARL','Argyllshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'AYR','Ayrshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'BAN','Banffshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'BDF','Bedfordshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'BRK','Berkshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'BEW','Berwickshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'BOR','Borders',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'BRE','Breconshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'BKM','Buckinghamshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'BUT','Bute',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CAE','Caernarvonshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CAI','Caithness',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CAM','Cambridgeshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CGN','Cardiganshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CMN','Carmarthenshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CEN','Central',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CHS','Cheshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CLK','Clackmannanshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CLV','Cleveland',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CWD','Clwyd',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'ANT','Co. Antrim',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'ARM','Co. Armagh',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'DOW','Co. Down',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'DUR','Co. Durham',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'FER','Co. Fermanagh',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'LDY','Co. Londonderry',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'TYR','Co. Tyrone',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CON','Cornwall',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CUL','Cumberland',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'CMA','Cumbria',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'DEN','Denbighshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'DBY','Derbyshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'DEV','Devon',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'DOR','Dorset',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'DGY','Dumfries and Galloway',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'DFS','Dumfries-shire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'DNB','Dunbartonshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'DFD','Dyfed',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'ELN','East Lothian',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'ERY','East Riding of Yorkshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SXE','East Sussex',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'ESS','Essex',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'FIF','Fife',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'FLN','Flintshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'GLA','Glamorgan',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'GLS','Gloucestershire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'GMP','Grampian',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'GTM','Greater Manchester',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'GSY','Guernsey',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'GNT','Gwent',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'GWN','Gwynedd',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'HAM','Hampshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'HWR','Hereford and Worcester',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'HEF','Herefordshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'HRT','Hertfordshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'HLD','Highland',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'HUM','Humberside',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'HUN','Huntingdonshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'INV','Inverness-shire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'IOW','Isle of Wight',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'JSY','Jersey',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'KEN','Kent',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'KCD','Kincardineshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'KRS','Kinross-shire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'KKD','Kirkcudbrightshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'LKS','Lanarkshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'LAN','Lancashire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'LEI','Leicestershire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'LIN','Lincolnshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'LTN','Lothian',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'MER','Merionethshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'MSY','Merseyside',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'MGM','Mid Glamorgan',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'MLN','Midlothian',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'MON','Monmouthshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'MGY','Montgomeryshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'MOR','Morayshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'NAI','Nairn',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'NFK','Norfolk',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'NRY','North Riding of Yorkshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'NYK','North Yorkshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'NTH','Northamptonshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'NBL','Northumberland',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'NTT','Nottinghamshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'OKI','Orkney',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'OXF','Oxfordshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'PEE','Peebles-shire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'PEM','Pembrokeshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'PER','Perth',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'POW','Powys',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'RAD','Radnorshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'RFW','Renfrewshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'ROC','Ross and Cromarty',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'ROX','Roxburghshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'RUT','Rutland',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SRK','Sark',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SEL','Selkirkshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SHI','Shetland',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SAL','Shropshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SOM','Somerset',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SGM','South Glamorgan',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SYK','South Yorkshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'STS','Staffordshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'STI','Stirlingshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'STD','Strathclyde',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SFK','Suffolk',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SRY','Surrey',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SSX','Sussex',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SUT','Sutherland',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'TAY','Tayside',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'TWR','Tyne and Wear',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'WAR','Warwickshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'WGM','West Glamorgan',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'WLN','West Lothian',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'WMD','West Midlands',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'WRY','West Riding of Yorkshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'SXW','West Sussex',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'WYK','West Yorkshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'WIS','Western Isles',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'WES','Westmorland',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'WIG','Wigtownshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'WIL','Wiltshire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'WOR','Worcestershire',1)
Insert [dbo].State(CountryID,Abbreviation,Name,DisplayOrder) values (80,'YKS','Yorkshire',1)

Checklist : The cart only allow 3 digit abreviation. Few know or use them. Our devs had to customise 'abreviation' filed to 50 chars.

Also don't forget to set the appconfig to accept Solo and Maestro cards