Google Checkout Order History on the AC Dashboard

[DonAshby]

Hi all,

When someone places an order thru Google Checkout, does it show up in the AC Dashboard and Order History... So we dont have to do a feed. Right now we dont see it... looks like we have to do to Google to see the order?

It seems to work for PayPal and PalExpress - orders go into the Dashboard nicely and we can print from here.

Thanks, Don

PS> can you comment on the best way to feed the addresses into an Address Feed such as Endicia or UPS world ship?

[sohaib]

Google Checkout orders will show up in Dashboard and Order History.
The order is created on callback from Google Checkout. If you don't see GoogleCheckout orders in AC make sure you have configured the callback URL at GoogleCheckout correctly.

[DonAshby]

Google Checkout - You told us to "make sure you have configured the callack URL at Google Checkout correctly." But what is that configuration? 5.5 help says to use:

https://www.url.com/ac/calculate.aspx but that does not work.

i assume it must be https? not http?

Google says to use something else.

Has anyone gotten this to work?

Thanks, Don

[Logan Rhodehamel]

For callback url, try:

<yoururl>/Checkout/Google/NotificationListener.ashx

ETA: I haven't used the feature so I don't know if this is something you can configure. Usually services like this let you pass the callback URL to them for each request.

[DonAshby]

Unfortunately, that did not work.

We are using XML not HTML format - a Google choice.

https://www.ourname.com/xxx/checkout/go ... tener.ashx.

we also tried it without the folder xxx

Isnt this something you had working in 5.5

Doesnt JustMetal have it working?

Don

Do Capitals matters?

[Logan Rhodehamel]

Darn... I had hoped that would be the solution. I am not the most qualified to answer this question since I have not worked at all with our Google integration. I will have Sohaib investigate and respond.

[DonAshby]

Thanks - Google has something different - a little wierd. We did not try the HTML version. I understand one of your other customers JustMetal has it working. But we dont know what they did.

Don

[sohaib]

Hello,

Please confirm the following

1. You have added GoogleCheckout gateway to AC7 and you have provided correct Merchant ID and Merchant Key.

2. You should not associate any payment method to GoogleCheckout.

3. In your GoogleCheckout account ->Settings -> Integration section
API callback URL is set to something like
http://www.mystore.com/ac7/Checkout/Goo ... tener.ashx
Callback method is set to XML

4. To make sure that the URL you added in step 3 is correct, try to open it in browser. It should ask you for user name and password in a browser popup window.

5. Check your integration by placing an order. After completing the order, if you do not see a new order in AC7, go to GoogleCheckout Account -> Tools -> Integration Console. See if there are any issues logged by Google. Please post the details so that we can investigate further.


Thanks,
Sohaib

[DonAshby]

Hello,

We tried following your steps carefully and it still does not work. We tried with https://www.oururl.com/ac7/Checkout/Goo ... tener.ashx and https://www.oururl.com/xxx/Checkout/Goo ... tener.ashx. We notice that you left the "s" off the https but we put it in because Google Checkout requires it. We also tried step 4 by logging in and when we did we received a server error in our /xxx application which is pasted below:

Root element is missing.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Xml.XmlException: Root element is missing.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<Page>

or:

2) Add the following section to the configuration file of your application:

<configuration>
<system>
<compilation>
</system>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

[XmlException: Root element is missing.]
System.Xml.XmlTextReaderImpl.Throw(Exception e) +87
System.Xml.XmlTextReaderImpl.ThrowWithoutLineInfo(String res) +109
System.Xml.XmlTextReaderImpl.ParseDocumentContent() +1904085
System.Xml.XmlTextReaderImpl.Read() +38
System.Xml.XmlTextReader.Read() +12
CommerceBuilder.Payments.Providers.GoogleCheckout.Util.EncodeHelper.GetTopElement(String Xml) +150
NotificationListner.ProcessRequest(HttpContext context) +250
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

------------------------------------------------------------------------------
Furthermore, we received another error that may be from Google Checkout itself. It appears to be a handshake issue. See below for further details:

Integration Issue Detail
Related order: 470915392561939
Time of occurrence: Nov 27, 2007 11:20:33 PM PST
Error: We encountered an error trying to access your server at https://www.ourstore.com/xxx/Checkout/G ... tener.ashx -- the error we got is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
Warnings:
XML We Sent:
<xml>
<order>
<timestamp>2007-11-27T22:03:33.000Z</timestamp>
<google>470915392561939</google>
<new>NEW</new>
<new>CHARGEABLE</new>
<previous>NEW</previous>
<previous>REVIEWING</previous>
</order>

Thank you,
Don

[Logan Rhodehamel]

https://www.ourstore.com/xxx/Checkout/G ... tener.ashx -- the error we got is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

This error almost seems like they do not trust your SSL certificate. What company issued your SSL?

(http://checkout.google.com/support/sell ... swer=57856)

[DonAshby]

Hi Logan,
Verisign - but we havent installed it yet. We did not know that it was a requirment for this to work.

Our Verisign Logo is on the old site but not moved to the new one yet. I did not think we had to have the CLICK VERISIGN to VERIFY logo installed to go live. But maybe Google needs to see it. We will install it and see. Thanks for the tip.

Don

Could it be a security setting in W 2003?

[Shopping Cart Admin]

Hello Don,

without the certificate, since the URL is required to be SSL this won't work. Hopefully with the certificate installed, this will be problem solved.

[AbleMods]

Hi Logan,
Verisign - but we havent installed it yet. We did not know that it was a requirment for this to work.

Our Verisign Logo is on the old site but not moved to the new one yet. I did not think we had to have the CLICK VERISIGN to VERIFY logo installed to go live. But maybe Google needs to see it. We will install it and see. Thanks for the tip.

Don

Could it be a security setting in W 2003?

If Google requires the URL is https:, you must have your proper SSL certificate installed on the AC7 site. Not a logo, the actual certificate. If the certificate is keyed to your www. domain, you would have to make your store run as www. in order to test it with that certificate.
I wasn't able to test certain aspects involving SSL because my certificate was bought for http://www.whatever.com and I was running my test site as test.whatever.com.

[DonAshby]

Hi -
Thanks to everyone for all the help on this. Unfortunately, we have done everything and google checkout still doesnt work. The SSL was always there - we just did not have the Verisign Flash Logo - which we do now. But the SSL is to our domain http://www.store.com not http://www.store.com/xxx

Our domain in the dashboard is http://www.store.com which is tied to our key we think. The URL we put into the dashboard is http://www.store.com/xxx

We modeled this after the Able Commerce URL of the beta program
http://www.ablecommerce.com/ac6

Does the domain and the URL need to match up? The SSL is just for the domain but it worked on our old store with the /xxx/default.asp

?

We turned off google checkout and paypal express for now as we wonder if these problems are related. I can try matching up the URL and the Domain but I dont want to break something else.

We did this configuration earlier:
http://www.mystore.com/ac7/Checkout/Goo ... tener.ashx
Callback method is set to XML = this is DONE

Any ideas are appreciated.

Thanks, Don

[AbleMods]

The SSL cert will work for sub-folders of the domain name it was assigned. In other words, http://www.Solunar.com/ can do SSL pages as well as http://www.Solunar.com/Checkout/.
But http://test.Solunar.com/ would generate an SSL warning/failure because the root name is different from that assigned to the SSL cert installed on the server.

Only if the root host name changes will the SSL break. So, as long as the root name doesn't change, any folders under it will accept SSL.

I'm thinking about exploring Google Checkout - I'll see what I can research for you.

[sohaib]

if you open https://www.ourstore.com/xxx/Checkout/G ... tener.ashx
in your browser do you get any warning?

Click cancel on this page when asked for login and then check for the page's security certificate in browser. This might give some more insight.

[DonAshby]

So basically google Check out works as far as the customer knows, the orders just dont come back to the Dashboards order history so i think the API is Callback URL is where the problem exists.

The shipping rate goes to the default rate, and the tax doesnt show

The customer gets a confirmation email, and our mailbox gets an email, basically Ablecommerce doesnt get the notice in the dashboard order history

Our verisign is up and running, so the site is now secure

[nfortune]

Google Checkout works pretty much out of the box for us. In fact, we like the flow much better than Paypal does.

A few things we have done to make it work,

1. There was a typo in our load for the filename "NotificationListener.ashx", we just did a rename on the file
2. I remember we had to tweak the permission/authentication of the google checkout directory. I'm not sure if we did it on the staging server or the production server.

We can receive payment notification from google and AC payment status updates correctly. Google will call one of the fuctions in AC to get shipping/tax rates, if it timeout, this will default to "0". I can also confirm that shipping/tax rate (even coupon) show up correctly in google and AC in this matter.

And I can confirm that Versign certificate works with Google checkout.

Hope this helps.

Matthew.

[DonAshby]

Hi Matthew,

Can you give us any tips on how to tweek the permissions on Google Checkout? We spent another 1/2 day on this Friday and just cant seem to get Google Checkout to communicate with AC 7. We are very cautious about changing permissions and want to do it correctly.

We are going to try again this afternoon Monday to get it to work. We are live on the production server now.

Thanks, Don

" I remember we had to tweak the permission/authentication of the google checkout directory. I'm not sure if we did it on the staging server or the production server. "

[sohaib]

Google will call one of the fuctions in AC to get shipping/tax rates, if it timeout, this will default to "0".

Tip: You can set the default shipping charge value in Google Checkout configuration page.

[DonAshby]

Hi

Thanks for the tip... we got that part already going with a default of $6.95 but they do not give sliding price options and we can't do express and worse - we dont get the orders back to us into our dashboard. To find orders, we have to go to Google. Hopefully, it will be a permissions fix . Also, we want to display the Google Checkout button - but first we have to get it working.

Don