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 18 of 18

Thread: Adding UK States

  1. #1
    theinternetmostwanted is offline Junior Member
    Join Date
    Feb 2006
    Location
    NY
    Posts
    2

    Default Adding UK States

    Hello, we sell to the USA, Canada and also the UK, how can I add UK States in the drop options? do you recommend this or is there another way? please help, thank you.

    JG

  2. #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    You can add those by going to Configuration -> Taxes -> States/Provinces menu in the admin. See this manual

  3. #3
    Dimmer is offline Member
    Join Date
    May 2008
    Location
    London
    Posts
    40

    Default

    Hi

    There is little point in adding UK states (counties) as they can be manually added by the customer in the last address line. They are not needed to effect a delivery to the UK. Remember its a little place and the Postal Code is sufficient to get the goods delivered.

    Al

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

    Default Function required: Adding States /counties/ provinces regions

    We need States /counties/ provinces regions without the need fora breavations in the cart for the world. Anyone selling out side the US needs this.

    ASPDTSF is great, but, outside of the US we have problms for thsi cart. In a right thinking world just adding the state to teh address field would be OK, you should not need a States field. nay leave it out, for even the US. But if you deal witha s many customers as we do, and you don't ask for the complete address, you can bet 10% of the time, you won't get it. And tehn spend a morning sorting out the mess, chasing couriers, postal sevices and the like. So, no state? Not wise. We need States /counties/ provinces regions in the cart for the world. At the moment they are not there and when you put them in, the cart wants a 5 character limit abrevaition for the region. Only if the US is the world does that work. Meantime, even if you populate state field with States /counties/ provinces regions the abbrevation usaully does not exist for that countreis region/state

    i belive the 5 char limit is there for RTShipping, but...

    I know that many countries don't have abbreviations for the regions. Yet, for example, the cart insists that the UK does, and that they are 3 digit. Its nonsense. In real common use, as far as I can work out, abbbrevs are used in 2 digit form only in the US and not too much any where else. I confirmd thsi with our UK based couriers.

    I think the 5 char filed needs to be used for RTShipping and a written State field abbrev. for the confimation be added. Thus giving 5 char limit for RTShipping as needed without messign up the worlds regions. Please I beg, would love this. Martin

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

    Default

    I just glanced at the main database script, and UK counties are added to the States table, starting on line 12617. (I'm looking at a v8.0.1 script):
    Code:
        INSERT [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values(@countryid,'Alderney','ALD',1)
        INSERT [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values(@countryid,'County Antrim','ATM',2)
        INSERT [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values(@countryid,'County Armagh','ARM',3)
        INSERT [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values(@countryid,'Avon','AVN',4)
    
       <etc ...>
    You don't have that script?
    Jon Wolthuis

  6. #6
    weblingo is offline Member
    Join Date
    Feb 2008
    Location
    Bristol, UK
    Posts
    63

    Default

    There have been other posts on this subject. We don't have states in the UK and forcing counties/administrative areas into the constrained drop down in ASPDNSF is not a good fit

    The script contains counties which were abolished 13 years ago (e.g. Avon) and I understand three more "counties" were created this month (in Cheshire?)

    I live in "the county of" North Somerset (created in 1996), but Royal Mail excludes it from my address and uses Bristol instead which is my nearest postal town

    We have taken the route of removing/hiding the states drop down from all pages (there are many to be changed) and letting the customer enter their own address

    What would be great would be an AppConfig to show/hide States in the standard product....

  7. #7
    DotNetDevelopments is offline Senior Member
    Join Date
    Jul 2008
    Location
    Harlow / Essex / UK
    Posts
    619

    Default

    Quote Originally Posted by weblingo View Post
    There have been other posts on this subject. We don't have states in the UK and forcing counties/administrative areas into the constrained drop down in ASPDNSF is not a good fit

    The script contains counties which were abolished 13 years ago (e.g. Avon) and I understand three more "counties" were created this month (in Cheshire?)

    I live in "the county of" North Somerset (created in 1996), but Royal Mail excludes it from my address and uses Bristol instead which is my nearest postal town

    We have taken the route of removing/hiding the states drop down from all pages (there are many to be changed) and letting the customer enter their own address

    What would be great would be an AppConfig to show/hide States in the standard product....
    I really have to second this, as fantastic as ASPDotNetStoreFront is, it really does let itself down when it comes to shipping options/configuration for anywhere outside the US

    In the UK counties are of no interest to the couriers, it is only the first part of the postcode they are interested in, it would be great if technical could get a grip of this and create a fix once and for all in future releases...
    =====
    Version (Code/DB): AspDotNetStorefront MSx 9.1.0.1/9.1.0.0
    Execution Mode: 64 Bit
    Dot Net Developments - E-commerce By Experience

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

    Default

    The next version has an Address User Control that provides a bit more intelligence for enterning addresses, not just for UK address, but worldwide.

    I wasn't aware that Counties weren't required by the couriers. Is this also the case in Ireland (Republic of)?
    Jon Wolthuis

  9. #9
    Dimmer is offline Member
    Join Date
    May 2008
    Location
    London
    Posts
    40

    Default ROI Counties

    Jon

    Unfotunately in Ireland they do not use Postal Codes, so the County is extremely important.

    Al
    Alan
    Version (Code/DB): AspDotNetStorefront ML 7.1.0.0/7.1.1.0 - with modifications
    www.stuff-uk.net

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

    Default

    Nice

    Thanks for the information.
    Jon Wolthuis

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

    Default UK counties can't be abbreviated to 5 chars

    Biggest prob is htat many UK counties don't shrink down to 5 chars as the cart we have us do. Cart outputs them in a form no one in the UK would understand. I agree with last psot that oftern provided the postcode is there couriers don't give a flyin' for the county, but if we can get a cust. to supply it, county can still be an indicator nonetheless. We ahve for example I think, 5 x St.Ives in the UK. If the postcode is wrong, which one did the cust mean without a county?

    I LOVE this cart, but it is still very US-centric, with language kits not being addressed and non-US counties, states & Provinces not existing without mamoth typing jobs. Try selling worldwide with this cart in differetn langs & currencis as it promises and you soon come badly unstuck. UK postcode lookup would be great too. For those that don't know. Ask a cust for their postcode and then the street number and you can nail an address to a few yards. (we use 'em in SatNav here for that reason) very usefula and why UK couriers don't worry about counties so much. Whereas I understand US zips don't narrow it down to much less than half a city.

  12. #12
    tacklediscounts is offline Junior Member
    Join Date
    Apr 2009
    Location
    London, England
    Posts
    12

    Default

    Quote Originally Posted by omaxuk View Post
    Whereas I understand US zips don't narrow it down to much less than half a city.
    The first 5 digits of the zip code does only narrow it down only to a city, or part there of. however, US zip codes in 1983 began using 4 additional digits (XXXXX-XXXX) and then the building/house is more exactly determined. Few people use or know their Zip+4, as it's commonly called, however.
    Last edited by tacklediscounts; 08-20-2009 at 06:18 AM.

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

    Default

    Jon you wrote on:

    INSERT [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values(@countryid,'Alderney','ALD',1)
    INSERT [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values(@countryid,'County Antrim','ATM',2)
    INSERT [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values(@countryid,'County Armagh','ARM',3)
    INSERT [dbo].State(CountryID,Name,Abbreviation,DisplayOrder) values(@countryid,'Avon','AVN',4)

    <etc ...>

    The trouble is the abbr as much as anything. Use of counties is still best to ahve if you can. Agreed our Post office/Royal Mail don't use counties as they used to, but the 3 char . abbrevaion is not undertsood eg: 'County Armagh' cannot be abbrev. to ARM. Ask anyone living there where ARM is and you'll get a 'blank'. Our devs did a mod for thsi, but sorry don't ask me what it was? Equally when i last looked, any state or province outsied the US didn't exist. We ahd to go round the world with atlas in hand, and type these in.

    Interseting you point about US zips. Here is a UK postcode, usually six chars. HU9 3NH (mine) it'll narrow you down to a few houses. If ZIPS don't really locate the address (as used) and the +4 isn't (used), how do you use them? As I unserstand it, half of say LA is on 2 or 3 zips? We use your ZIPs now, because, we ahve the field in the cart, but in selling to the US, are they really needed?
    Last edited by omaxuk; 09-10-2009 at 10:36 AM. Reason: Typos

  14. #14
    DanV's Avatar
    DanV is offline Ursus arctos horribilis
    Join Date
    Apr 2006
    Posts
    1,568

    Default

    The problem is that there are 195 countries in the world (give or take a few at any given time it seems these days), each with different rules, requirements, postal systems, constantly changing local subdivisions, etc. etc. etc. We can supply these out of the box, but I would suspect it would be "up to date" for about a week before someone added/deleted something, and then we catch flak for not paying attention

    In any case, if anyone has a good resource for UK counties, abbreviations, shipping rules, etc. I wouldn't mind taking a look at it.

  15. #15
    Froggitt is offline Junior Member
    Join Date
    Apr 2009
    Posts
    10

    Default

    Quote Originally Posted by omaxuk View Post
    UK postcode lookup would be great too. For those that don't know. Ask a cust for their postcode and then the street number and you can nail an address to a few yards. (we use 'em in SatNav here for that reason) very usefula and why UK couriers don't worry about counties so much.
    Its relatively easy to integrate a postcode lookup service into aspdnsf - they all get their data from the Royal Mail. All you need is entry fields for the house number and the postcode (eg 27 B1 2JP), and the software returns the full postal address, including whatever county the RM thinks the address is in.

    Downside......for a small business is probably cost prohibitive.......£1500-£2000 p.a.

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

    Default Adding Royal Mail Postcode Look Up

    195 countries . I'm still adding counties around th world to stop the NonUS default. I've been on htis for days. Not good. Should be in the cart, even if liste a littel out of date.

    I understadn there are comapnies tha you can subscribe to. Thus, get thsi data on a blow-by-blow click basis. We're palnning to do thsi soon. 2-300 a year. Small company though. to own it is too rich for us. Anyone already done this one?

    Annoys me though, our postcode data si something we should all have access to as part of 'UK plc' intellectual property. It saves fortunes in msidirected mail. satnav, couriers etc etc. It should not be owned. Just like the BBC its ours to use for all that pay UK taxes and subsidises (as we do, or did) the Royal Mail. Rant over.
    Last edited by omaxuk; 09-21-2009 at 06:03 AM. Reason: Added a rant

  17. #17
    TRP is offline Junior Member
    Join Date
    Jul 2007
    Posts
    8

    Question Shipping to Japan

    We are trying to collect addresses to ship to Japan. Using the existing fields is fine; however, aspdnsf tries to force you to select a state. Any thoughts?

  18. #18
    StevenCashman is offline Junior Member
    Join Date
    Dec 2009
    Posts
    1

    Default

    Jon

    Unfotunately in Ireland they do not use Postal Codes, so the County is extremely important.

    Al
    yep, I also was wondered when we had realized that. In that project we had to add additional class because of that