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

Thread: Google Checkout

  1. 07-16-2007, 02:12 PM #1
    jon-langley is offline Member
    Join Date
    Jun 2007
    Location
    UK
    Posts
    69

    Default Google Checkout

    Hi All,

    I think I must be really stupid as I cannot figure this out,

    I go to my site, I buy something, I click Google Checkout and it says

    "XYZ does not ship to this address".

    I have checked through Google and I hae checked various configs and I am darned if I can find the problem area...

    Does anyone have a pointer? I am happy to keep looking, but a slight nudge would be great.
  2. 07-16-2007, 02:26 PM #2
    Rob is offline Senior Member
    Join Date
    Aug 2004
    Posts
    3,037

    Default

    what storefront version are you running?
  3. 07-16-2007, 04:01 PM #3
    jon-langley is offline Member
    Join Date
    Jun 2007
    Location
    UK
    Posts
    69

    Default

    Sorry, I forgot to add that bit.

    AspDotNetStorefront ML 7.0.1.3/7.0.1.1
    DB Version: 7.0.1.1
  4. 07-17-2007, 06:35 AM #4
    jon-langley is offline Member
    Join Date
    Jun 2007
    Location
    UK
    Posts
    69

    Default

    I sussed out the problem.

    Some of it was my end (although not really a problem), some of it is the way Google works.

    FTR.

    I have Shipping by weight Methods, and I have "States/Counties" set up as well for each method as certain areas get different rates.

    When the buyer goes to GC, they are presented with a Text field to enter the County.
    eg, Hampshire.

    This text "Hampshire" is sent back to ASPDN and queries the Abbrv field for counties/states.

    As the counties/states in ASPDN has a 5 chr limit, Hampshire cannot and will not be found.

    It would be "good" if the return from GC did a double check on the Name as well as the abbrv for UK...

    We can then enter
    Name=Hampshire and Abbrv=Hants. to cater for both options.

    I know not fullproof as W. Midlands and W Midlands and West Midlands are all the same place and would depend on what the buyer entered.


    Does anyone else have any ideas/thoughts on the best way to implement this? ATM, it is either do not offer GC Checkout and ship to everyone, or offer GC checkout and not ship to areas that would get different rates.
  5. 07-17-2007, 12:26 PM #5
    ASPDNSF Staff - Buddy is offline Banned
    Join Date
    Jul 2005
    Posts
    378

    Default

    Aren't your counties entered as states? If so then all you would have to do is lengthen the state abbreviation feild to allow full county name then counties would be selecteable in the "state" dropdown list and you wouldn't have to worry about people hand entering (i.e. mistyping) the county.
  6. 07-18-2007, 12:40 AM #6
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    Hi Buddy,

    At Googles checkout site, the State (county) field is a free text field.
    We have to try to match this to our State-Abbreviation field - there's no way of forcing customers to spell things correctly when google gives them a free text field.


    TTFN

    BFG
  7. 07-18-2007, 07:26 AM #7
    jon-langley is offline Member
    Join Date
    Jun 2007
    Location
    UK
    Posts
    69

    Default

    BFG is correct.

    The issue is the Match of the Free Text Field versus the abbrv.

    This is the area that Google is causing problems... I have already gone onto them and mentioned this and they said that everyone else does it by Zip Code. Alas, the Zip code function within ASPDN doesn't work too well with UK Post Codes.

    FTR. I have already increased the sice of my abbrv field and populated it with the full name so at the moment I am happy.

    But I could still have the problem of
    "Hampshire" being entered as "Hants"
    or
    "West Midlands" entered as "W. Midlands". (Also consider W Midlands and W. Mids etc. etc.).

    Of course, the other benefit of this to me is that now all my addresses are populated with the full county name (Here in the UK we don't abbreviate them) which is how the Post Office wants it.
  8. 07-18-2007, 09:37 AM #8
    ASPDNSF Staff - Buddy is offline Banned
    Join Date
    Jul 2005
    Posts
    378

    Default

    Yes, I forgot about GC-UK allowing users to type in the county. What enhancement would be needed to work better with UK postal codes? We are adding support for configurable length matching on postal cose in shipping calculations so instead of just three digits/characters you can set it to what ever you need. This will be in the next maintenance release.
  9. 07-18-2007, 10:06 AM #9
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    That would pretty much solve the issue Buddy.
    i.e. if Zones can be modified to allow alphanumeric ranges upto 5 characters e.g. :-

    GU1 - GU35, NW11A - NW14E, etc. etc.

    Then we could use Zones instead of Counties (States).


    Whilst we're at it, how about an appconfig to convert 'State' from required to optional & another to convert it from a drop down select to a free text field?
    I can see that this would mean that the 'Set allowed States' for the shipping method would become inoperative, but..... I think that's a small price to pay.

    Any thoughts here Jon?



    TTFN

    BFG
  10. 07-18-2007, 04:38 PM #10
    jon-langley is offline Member
    Join Date
    Jun 2007
    Location
    UK
    Posts
    69

    Default

    BFG/Buddy,

    re the zones, I should imagine that the program is already there to allow alphanumeric... After all. it only checks the prefix... But it is only based on the first 3 characters...

    I agree to allow the best functionality between US and UK, then 5 characters is a MUST... Carriers over here, state that certain "Prefixes" are differet rates. eg, IV54... Techincally, 4 characters is enough, BUT, someone may want to allow a "Pickup" in a specific Postcode in their area... eg, If I was in NW14E, then I may want to allow others in that area a pickup rate... So yes, 5 characters is Perfect for the UK.

    Re the AppConfig for State to be allowed or Optional... Hmm... I think I may disagree on that one.. Unless you know better... (You may have more info on that than I do bearing in mind who I think you work for).

    BUT... What would be nice... is...

    If that country has a selection of "States", then create a drop down...
    If NOT, then create custom text field....
    (This could be enhanced to allow "Other" to be selected as an option, then select a custom text field.


    Just as an adendum on the Postal Code Situation. Please remember that is isn't always 2 letters then 1 or 2 numbers.
    You "could" have 1 letter and 1 number. ie, N1.

    Also, As I am not into Zip codes... A "Catchall" Zone would certainly benefit..
    So I could create a Zone 1, = HP0-HP9, HP10-HP14,HP16-HP19 (Note HP15 is missing.
    Zone 2 could be another batch etc. etc.
    Zone ALL would then be a catchall..
    That may already be in place but I haven't looked as it is US based. but if it isn't then I think that would be a right PITA to implement.
  11. 11-19-2007, 06:49 AM #11
    supergriff is offline Senior Member
    Join Date
    Sep 2007
    Posts
    102

    Default

    To those of you who have setup UK counties in your admin after extending the abbreviation field - did you manually have to insert every one, or is there a way of importing them all in bulk? Where did you get your full list of Counties?
  12. 12-07-2007, 11:03 PM #12
    dircums is offline Junior Member
    Join Date
    Dec 2007
    Posts
    15

    Default

    Quote Originally Posted by supergriff View Post
    To those of you who have setup UK counties in your admin after extending the abbreviation field - did you manually have to insert every one, or is there a way of importing them all in bulk? Where did you get your full list of Counties?
    Maybe someone could provide a SQL script to load these directly into the database..
  13. 02-15-2008, 04:41 AM #13
    jondicks is offline Junior Member
    Join Date
    Feb 2008
    Posts
    13

    Default

    hi there.

    I too have the same problem with GC not allowing me to ship to addresses - however I believe my problem is much simpler (hopefully).

    we offer a FREE postage and packaging service on all of our products, and so there is no particular varying rate dependant on which county you are in (yes - I am a UK site).

    I have attempted to setup at least ONE county (states/province) with its name as the full name and the abbrv as "Herts", just to perform a simple test.

    when going through to GC and entering an address using Herts as the county - GC still refuses and simply gives me the XYZ does not ship to this address

    I have also added a delivery zone - and attempted with another county "Worcs" with the post code range of B00 - B99 (as I know a valid postcode is B97 ...)

    can someone shed somelight as to what I may be doing wrong - or even better, the way to get around this problem!!

    (using ML 7.0.1.2)
  14. 02-15-2008, 05:21 AM #14
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    I seem to remember that this is something to do with appconfig 'RTShipping.OriginCountry' - might be worth setting it to UK.......


    TTFN

    BFG
  15. 02-15-2008, 06:01 AM #15
    jondicks is offline Junior Member
    Join Date
    Feb 2008
    Posts
    13

    Default

    BFG

    thanks for your help on this - I have now changed the appconfig (didnt realise it was set to US) - but still no difference im afriad, regardless of what address I attempt to enter.

    could you just confirm where AND what I should have as the county list - postcode format etc (not that I really want to check it against postcode - just thought I would try it)

    all I want is to be able to put an order through, like i said, we offer free P&P anyway!

    thanks again
  16. 02-15-2008, 06:39 AM #16
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    Hi Jon,

    I've just checked my setup & we don't have any of the 'States' selected.
    I've just selected the Country 'UK' for shipping method 'UK' & selected all of the european countries for the shipping method 'Rest of Europe'.

    I'm fairly sure that what you want to do in your case is to deselect all of the checkboxes under 'set allowed states' & 'set allowed zones'.



    TTFN

    BFG
  17. 02-15-2008, 06:54 AM #17
    jondicks is offline Junior Member
    Join Date
    Feb 2008
    Posts
    13

    Default

    BFG

    ok - having just gone through my settings, I can confirm that in:

    TAXES > EDIT STATE/PROVINCES - I have one record - "default"

    DELIVERY > DELIVERY ZONES - I have one record (ireland - this is due to customer having to pay a small amount if shipping to ireland)

    DELIVERY > DELIVERY METHODS - I have 2 records - one is our UK FREE DELIVERY, and one is Ireland (£9.99) - obvioulsy this option is displayed dependant on what country they are shipping to when using the standard aspdnsf checkout.

    within the Set allowed states box - I have the following ticked for each option:

    FREE UK DELIVERY: DEFAULT
    IRELAND : (nothing - default is not ticked)

    within the Set allowed countries box - I have the following ticked for each option:

    FREE UK DELIVERY: United Kingdom
    IRELAND : Ireland

    within the Set allowed zones box - I have the following ticked for each option:

    FREE UK DELIVERY: nothing
    IRELAND : nothing



    I have removed all my references to counties - to take us back to the beginning. does this all look right to you????

    once again - thank you for your help on this - its good to know that someone has it working and is will to share their advice.

    J
  18. 02-15-2008, 07:07 AM #18
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    That looks correct to me.....
    Can you turn on logging?
    Set 'GoogleCheckout.LogMessages' to true & 'GoogleCheckout.LogFileName' to 'googlecheckout.txt'.
    Then when you try to go through to googlecheckout, it will generate a log file in your root - this will probably have some pointers as to what's going wrong.


    TTFN

    BFG
  19. 02-15-2008, 07:08 AM #19
    jondicks is offline Junior Member
    Join Date
    Feb 2008
    Posts
    13

    Default

    will do - will let you know what gives.
  20. 02-15-2008, 07:19 AM #20
    jondicks is offline Junior Member
    Join Date
    Feb 2008
    Posts
    13

    Default

    BFG

    ok - I have the log file and there are a few things I would question, which may - or may not be causing the problem.

    within my shipping methods I have:

    <merchant-calculated-shipping name="FREE UK Delivery">
    <price currency="GBP">0.000</price>
    <shipping-restrictions>
    <allowed-areas>
    <us-zip-area>
    <zip-pattern>00000</zip-pattern>
    </us-zip-area>
    </allowed-areas>
    <excluded-areas>
    <us-country-area country-area="ALL" />
    </excluded-areas>
    </shipping-restrictions>
    </merchant-calculated-shipping>

    Is this correct?

    (so on and so forth for the other shipping methods (ireland etc))



    <buyer-language>en_US</buyer-language>

    should this be UK?
    and finally - telling me something I already know:

    <merchant-calculation-results xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://checkout.google.com/schema/2">
    <results>
    <result address-id="824397627917598" shipping-name="FREE UK Delivery">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="&lt;b&gt;£9.99&lt;/b&gt; - Republic of Ireland">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="International Zone 1">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="International Zone 2">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="International Zone 3">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="International Zone 4">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="International Zone 5">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    </results>
    </merchant-calculation-results>


    yep - shippable is all FALSE.

    this is my first shot a integrating GC, and this is the only thread which came up with anything to do with my probs.

    sorry to be a pain.
  21. 02-15-2008, 07:27 AM #21
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    I'm at the wrong PC at the moment to be able to compare that with a known good one - I'll take a look tonight & let you know.


    TTFN

    BFG
  22. 02-15-2008, 07:30 AM #22
    jondicks is offline Junior Member
    Join Date
    Feb 2008
    Posts
    13

    Default

    great thanks.
  23. 02-15-2008, 10:15 AM #23
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    Quote Originally Posted by jondicks View Post
    <merchant-calculated-shipping name="FREE UK Delivery">
    <price currency="GBP">0.000</price>
    <shipping-restrictions>
    <allowed-areas>
    <us-zip-area>
    <zip-pattern>00000</zip-pattern>
    </us-zip-area>
    </allowed-areas>
    <excluded-areas>
    <us-country-area country-area="ALL" />
    </excluded-areas>
    </shipping-restrictions>
    </merchant-calculated-shipping>

    Is this correct?

    Hmm...
    The equivalent part of mine looks like this :-
    C#/VB.NET Code:
          <shipping-methods>
            <    merchant-calculated-shipping name="UK Mainland">
              <    address-filters>
                <    allowed-areas>
                  <    world-area />
                </    allowed-areas>
              </    address-filters>
              <    price currency="GBP">1.6900</price>
            </    merchant-calculated-shipping>
            <    merchant-calculated-shipping name="Rest of Europe">
              <    price currency="GBP">0.00</price>
            </    merchant-calculated-shipping>
            <    merchant-calculated-shipping name="Free Shipping">
              <    price currency="GBP">0.00</price>
            </    merchant-calculated-shipping>
          </    shipping-methods> 
    I'm not seeing the zipcodes at all - I have no zones at all defined though.....
    Quote Originally Posted by jondicks View Post
    <buyer-language>en_US</buyer-language>

    should this be UK?
    Yup - that's the same as Mine.
    Quote Originally Posted by jondicks View Post

    <merchant-calculation-results xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://checkout.google.com/schema/2">
    <results>
    <result address-id="824397627917598" shipping-name="FREE UK Delivery">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="&lt;b&gt;£9.99&lt;/b&gt; - Republic of Ireland">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="International Zone 1">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="International Zone 2">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="International Zone 3">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="International Zone 4">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    <result address-id="824397627917598" shipping-name="International Zone 5">
    <shippable>false</shippable>
    <shipping-rate currency="GBP">0</shipping-rate>
    </result>
    </results>
    </merchant-calculation-results>
    & mine then (although it's no help to you....) produces this :-
    C#/VB.NET Code:
    <merchant-calculation-results xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://checkout.google.com/schema/2">
      <    results>
        <    result shipping-name="UK Mainland" address-id="554732622173064">
          <    shippable>true</shippable>
          <    shipping-rate currency="GBP">1.99</shipping-rate>
        </    result>
        <    result shipping-name="Rest of Europe" address-id="554732622173064">
          <    shippable>false</shippable>
          <    shipping-rate currency="GBP">0</shipping-rate>
        </    result>
        <    result shipping-name="Free Shipping" address-id="554732622173064">
          <    shippable>false</shippable>
          <    shipping-rate currency="GBP">0</shipping-rate>
        </    result>
      </    results>
    </    merchant-calculation-results> 

    I'd try deleting your zones.....


    TTFN

    BFG
  24. 02-15-2008, 10:39 AM #24
    msprague is offline Member
    Join Date
    Nov 2005
    Posts
    37

    Default

    @jondicks,
    Shipping outside your country of origin with Google Checkout was not supported until v7.0.2.5 of the storefront. I'm afraid your version won't work for shipping to non-UK addresses.
    / michael sprague /
  25. 02-15-2008, 10:56 AM #25
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    I've been shipping outside of the UK with Google checkout since last April......


    TTFN

    BFG
  26. 02-17-2008, 11:06 AM #26
    jondicks is offline Junior Member
    Join Date
    Feb 2008
    Posts
    13

    Default

    this is slowly driving me nuts now.
    I dont strictly want to ship outside of the UK at the moment with GC - I just simply want to be able to ship with google checkout as an option.

    I have removed all zones now, and still I get the same result.

    I simply cant figure it out. can anyone, or you BFG offer any further recommendations as to what is going on.
  27. 02-17-2008, 11:54 AM #27
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    Do you want to drop me a url & a login?
    I can take a look when the kids have gone to bed.....


    TTFN

    BFG
  28. 02-18-2008, 01:20 AM #28
    jondicks is offline Junior Member
    Join Date
    Feb 2008
    Posts
    13

    Default

    BFG - did you receive my PM?
  29. 02-18-2008, 01:44 AM #29
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    Yup - & replied via PM - couldn't email you - it bounced 'Mailbox Full' :-)


    TTFN

    BFG
  30. 02-19-2008, 02:52 PM #30
    ASPDNSF Staff - Buddy is offline Banned
    Join Date
    Jul 2005
    Posts
    378

    Default

    In your GC log there is both a cart request and merchant calcs request. Check to see if there is any difference between the shipping method names between those to requests. There was an issue with GC stripping some characters or possibly a case sensitivity issue that caused the shipping methods to not be understood by GC.