Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 16 of 16

Thread: Mods for UK site: VAT and counties

  1. #1
    dircums is offline Junior Member
    Join Date
    Dec 2007
    Posts
    15

    Default 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..

  2. #2
    George the Great is offline Senior Member
    Join Date
    Nov 2006
    Location
    Cleveland, OH
    Posts
    1,792

    Default

    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.
    <a href="http://www.aspdotnetstorefront.com">Shopping Cart Software</a>

  3. #3
    dircums is offline Junior Member
    Join Date
    Dec 2007
    Posts
    15

    Default

    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.
    Last edited by dircums; 01-17-2008 at 05:40 AM.

  4. #4
    akshah1 is offline Junior Member
    Join Date
    Nov 2007
    Posts
    12

    Default 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)

  5. #5
    Rob is offline Senior Member
    Join Date
    Aug 2004
    Posts
    3,037

    Default

    That is quite nice. thanks for posting.
    AspDotNetStorefront
    Shopping Cart

  6. #6
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    Quote Originally Posted by ASPDNSF Staff - George View Post
    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

  7. #7
    ASPDNSF Staff - Jon's Avatar
    ASPDNSF Staff - Jon is offline Senior Member
    Join Date
    Sep 2004
    Posts
    11,419

    Default

    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.
    Jon Wolthuis

  8. #8
    Rob is offline Senior Member
    Join Date
    Aug 2004
    Posts
    3,037

    Default

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

  9. #9
    supergriff is offline Senior Member
    Join Date
    Sep 2007
    Posts
    102

    Default

    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....
    Last edited by supergriff; 02-09-2008 at 08:37 PM.

  10. #10
    mikemurphy is offline Senior Member
    Join Date
    Mar 2006
    Location
    United Kingdom
    Posts
    207

    Default

    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.
    8.0.1.4 W2008R2 64-bit MSSQL2005

  11. #11
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    Quote Originally Posted by supergriff View Post
    --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

  12. #12
    mikemurphy is offline Senior Member
    Join Date
    Mar 2006
    Location
    United Kingdom
    Posts
    207

    Default

    Quote Originally Posted by mikemurphy View Post
    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
    8.0.1.4 W2008R2 64-bit MSSQL2005

  13. #13
    STERSIMPSON is offline Junior Member
    Join Date
    Mar 2008
    Location
    SOUTHPORT UK
    Posts
    4

    Talking im totally new !!

    Quote Originally Posted by akshah1 View Post
    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?

  14. #14
    mikemurphy is offline Senior Member
    Join Date
    Mar 2006
    Location
    United Kingdom
    Posts
    207

    Default

    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 !
    8.0.1.4 W2008R2 64-bit MSSQL2005

  15. #15
    kentrob is offline Member
    Join Date
    Apr 2008
    Posts
    41

    Default UK County List

    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)

  16. #16
    omaxuk is offline Member
    Join Date
    Apr 2009
    Location
    We're Brits
    Posts
    73

    Default Checklis UK Counties States

    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
    Last edited by omaxuk; 10-09-2009 at 06:19 AM.