Magento

I was told by Google this should not be a problem, as Sandbox does not require SSL.

Still can not get Magento to properly pass on shipping charges to Google Checkout…
Lisa

Hello Lisa,

have you checked google integration console? what do you see there?

Best regards,
Serge

Hi Serge!

Finally a member of the team—many thanks!

Well, it usually says:

“Your server returned no data in its reply; Checkout requires data of type merchant-calculation-results in reply to merchant-calculation-callback”

Sometimes it also says

“We timed out waiting for your server at http://www.MYSITE.com/magento/googlecheckout/api/; the error we got is: Read timed out Your server must respond faster to merchant calculation callback requests.

If you could help fix this, that would be much appreciated!
Thank you!
Lisa

Etho, Lisa

UK could be a factor!

as far as I can see in the google doc:

http://code.google.com/apis/checkout/developer/Google_Checkout_XML_API_Carrier_Calculated_Shipping.html

in the overview they have a note:

Note: This feature is only supported for shipments sent to and from U.S. postal addresses. In addition, any costs associated with carrier-calculated shipping methods must be specified in U.S. dollars (USD).

so I think it might be a problem that you are not sending from and to U.S. postal addresses.
please, double check it with google.

Best regards,
Serge

Lisa,

also it could be good if you contact your hosting provider, because it is abnormal to get such errors, especially sometimes with timeouts, so they will check that google responses come in correctly.

it will be helpful to get more info from integration console. what request has google sent you? they normally publish it in the console.

Best regards,
Serge

Hi Serge,

I usually just get “Your server returned no data in its reply”. Only ocassionally do I get the time-outs.

I have also read this on Google groups: “I can let you know that Google Checkout sends an name/value pair HTML
callback over an HTTPS callback URL, and require a similar response
back from your system. “

Just to confirm - the callback URL should be:

http://www.SITE.com/magento/index.php/googlecheckout/api
Callback method XML, Provide the first name, Return the buyer’s ship-to phone number, Return the buyer’s billing phone number checked in GC integration settings. Correct?

This is the last one I got:

Your server returned no data in its reply; Checkout requires data of type merchant-calculation-results in reply to merchant-calculation-callback

<?xml version="1.0" encoding="UTF-8"?>
<merchant-calculation-callback xmlns="http://checkout.google.com/schema/2" serial-number="b8592985-92a5-444f-b165-c2cdc2379fbc">
<shopping-cart>
<items>
<item>
<item-weight value="60.0" unit="LB" />
<tax-table-selector>2</tax-table-selector>
<item-name>TEST</item-name>
<item-description></item-description>
<quantity>2</quantity>
<unit-price currency="GBP">9.0</unit-price>
<merchant-item-id>frmyrrh</merchant-item-id>
<merchant-private-item-data>


<quote-item-id>40</quote-item-id>


</merchant-private-item-data>
</item>
</items>
<merchant-private-data>


<quote-id>37</quote-id>


</merchant-private-data>
</shopping-cart>
<buyer-id>949842525499086</buyer-id>
<calculate>
<addresses>
<anonymous-address id="261286200525582">
<country-code>GB</country-code>
<postal-code>SE8 4DS</postal-code>
<city>London</city>
<region>LONDON</region>
</anonymous-address>
<anonymous-address id="502926368539481">
<country-code>GB</country-code>
<postal-code>SE8 5DD</postal-code>
<city>London</city>
<region>LONDON</region>
</anonymous-address>
</addresses>
<shipping>
<method name="Royal Mail - Shipping” />
</shipping>
<tax>true</tax>
<merchant-code-strings />
</calculate>
<buyer-language>en_US</buyer-language>
</merchant-calculation-callback>

Lisa,

setting seems to be correct, but Royal Mail is not supported shipping carrier at the moment, so we are unable to estimate shipping rates for this carrier. how do you want to make it working? I didn’t quite get everything behind the scene

Best regards,
Serge

Hi Serge,

I have just named the shipping “royal mail” - it is still merchant calculated. If you want to PM me, I’ll send you my admin log-in to my test site if that helps, and grant access to my GC sandbox account.
Many thanks!
Lisa

Hello Lisa,

I still cannot understand what you did.
can you publish here step by step “manual” of steps I need to follow to reproduce the problem and get blank responses on google requests asking to estimate “royal mail” ?..

probably that there is any problem or misunderstanding on any step performed…

Best regards,
Serge

Hi Serge,

I am NOT using carrier calculated shipping.

With Google Checkout, it tries to contact Magento using API to get merchant calculated shipping.

If that for any reason fails, GC will default to the value set in System>>config>>sales>>Google API>>Google Checkout Shipping (merchant calculated).

“Royal Mail” is only a title that I have assigned to my Table rates under System>>config>>sales>>shipping methods>>Table Rate>>Title.

It is not a separate module, if that’s what you were wondering.

Do let me know if this makes it any clearer
Many thanks for your help so far!

Lisa

well, I understood that you are not using carrier calculations, but merchant calculations.

it is also clear about table rates now. that I was aware about how you did “Royal Mail"…

so the next step I need you to do is to turn on debug mode for google api (Magento admin config option), make a few tests, make dump of googlecheckout_api_debug table and attach it here, so I will be able to check how responses and google request comes inside Magento system. it will help us to investigate the problem, find possible reasons and solutions.

Best regards,
Serge

Hi Serge,

I have attached the database dump as requested. I hope that gives some insight into what the problem is.

I have had to change a couple of entries for privacy reasons (database name etc), as I could not PM you - it bounced. This should not affect anything, but do let me know if you want me to email you the original.

Many thanks for looking into this, you’re a star!
Lisa

googlecheckout_api_debug.sql  (File Size: 21KB - Downloads: 8)

Thank you, Lisa!

we are re-checking it all.
only one small questions at the moment: what version of Magento do you have? 1.0.19870.1?

Best regards,
Serge

Hello Serge,

Many thanks for that.

I am using 1.0.19870 (which is the same as the 1.0.19870.1 apart from the 2 URL bug fixes AFAIK)

Thank you Serge!
Lisa

also one thing that will be good to check:

open .htaccess file, look for similar lines:

add the next lines to your .htaccess:

actually it seems that you have errors output turned off and merchant callback script fails in any reason, but we see no result in the integration console.

so after you do required changes and enable error reporting and displaying errors run your test with google checkout one-two times more and check google integration console. let me know what you will see there. ty!

Best regards,
Serge