Google Checkout module for ZC 1.3.x (beta)

[gid]

This is what is says in the read me file. But it is incorrect.

https://<url-site-url>/admin/googlecheckout/responsehandler.php
Chances are you do not have the googlecheckout folder under the admin folder, so it will most likely be:
https://<url-site-url>/store/googlecheckout/responsehandler.php
or
https://<url-site-url>/googlecheckout/responsehandler.php


You logon into google checkout. Click settings tab. Then you will see an Integration in the left. Then drop your url into the API callback URL text area.

[gid]

Oh yeah, to your second question. I am debugging the code now. I have to take a break and will not get back to it until later, but once I figure out the issue I will let you know.

[misticjeff]

Hi,

Just did a test order on the production server and still don't get an order showing in admin. Here's the error from Googles Integration area in my merchant account: (removed customer information)
=================================================
We encountered an error trying to access your server at https://www.xxxx.com/googlecheckout/responsehandler.php -- the error we got is: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
-------------------
XML We Received:

xml not received.
-------------------
XML We Sent:

<?xml version="1.0" encoding="UTF-8"?>
<new-order-notification xmlns="http://checkout.google.com/schema/2" serial-number="aa82b284-1ac7-46c6-8ec4-99fb7a2b11c4">
<timestamp>2006-10-13T22:10:41.810Z</timestamp>
<google-order-number>204401224105607</google-order-number>
<shopping-cart>
<merchant-private-data>


<session-data>96b374aa3565f4057d6d37f7a4400c7f;zenid</session-data>


<product-data>;6</product-data>


</merchant-private-data>
<items>
<item>
<item-name>Product Name Here</item-name>
<item-description></item-description>
<unit-price currency="USD">1.0</unit-price>
<quantity>1</quantity>
<tax-table-selector></tax-table-selector>
</item>
</items>
</shopping-cart>
<buyer-shipping-address>
<email>[email protected]</email>
<address1>xxxx xxxx Way</address1>
<address2></address2>
<company-name></company-name>
<contact-name>Customer Name</contact-name>
<phone></phone>
<fax></fax>
<country-code>US</country-code>
<city>Las Vegas</city>
<region>XX</region>
<postal-code>XXXXX</postal-code>
</buyer-shipping-address>
<buyer-billing-address>
<email>[email protected]</email>
<address1>xxx xxxx Way</address1>
<address2></address2>
<company-name></company-name>
<contact-name>Customer Name Here</contact-name>
<phone></phone>
<fax></fax>
<country-code>US</country-code>
<city>Las Vegas</city>
<region>NV</region>
<postal-code>XXXXX</postal-code>
</buyer-billing-address>
<buyer-marketing-preferences>
<email-allowed>true</email-allowed>
</buyer-marketing-preferences>
<order-adjustment>
<merchant-codes />
<shipping>
<flat-rate-shipping-adjustment>
<shipping-name>Standard flat-rate shipping- Table Rate</shipping-name>
<shipping-cost currency="USD">5.05</shipping-cost>
</flat-rate-shipping-adjustment>
</shipping>
<total-tax currency="USD">0.0</total-tax>
<adjustment-total currency="USD">5.05</adjustment-total>
</order-adjustment>
<order-total currency="USD">6.05</order-total>
<fulfillment-order-state>NEW</fulfillment-order-state>
<financial-order-state>REVIEWING</financial-order-state>
<buyer-id>XXXXXXXXXXX8817</buyer-id>
</new-order-notification>

[gid]

misticjeff that means your certificate was not installed correctly. Well, that was the error I was getting for a while. I ended up having to ask google support, and they were able to show me how it was installed incorrectly.

[gid]

I have narrowed the error down to this line

[ $customer_info = $db->Execute("select customers_id from " .$googlepayment->table_name . " where buyer_id = ". makeSqlString($data[$root]['buyer-id']) );]

in responsehandler.php.

The query it is trying to execute is:
select customers_id from google_checkout where buyer_id = 715670627742896

I am able to run this from phpmyadmin and it does return a row. That makes me think it is a db connection issue.

[misticjeff]

misticjeff that means your certificate was not installed correctly. Well, that was the error I was getting for a while. I ended up having to ask google support, and they were able to show me how it was installed incorrectly.

Anyone specific you contacted???

[colosports]

Actually I think he and Google's code staff are obligated to not only answer questions but to also be proactive in getting the MOD to work correctly with ZenCart. Just because the MOD is "free" should not make it a hardship for those that want to use it.

First of all, no one to obligated to do anything. You guys should be thanking Jacob and the Google team for there hard work in providing a base for Zencart users that want to use Google checkout. Out of the box, the code does the job. It sends orders to Google and sends you the funds.
Have you ever try coding anything in Zencart? You can not learn how everything in ZenCart works in one day. Google provided us with the base version. If Zencart users wants to make it more ZenCart friendly, the Zen Cart community will have to contribute. Over time, the module will be updated. If you are unhappy with how it preforms now, don't use it. Wait for a updated version.

[colosports]

I have narrowed the error down to this line

[ $customer_info = $db->Execute("select customers_id from " .$googlepayment->table_name . " where buyer_id = ". makeSqlString($data[$root]['buyer-id']) );]

The code should work fine. It might not be returning anything because google_checkout table is empty.

gid, i would restart over. It seems that you have been changing codes in responsehander.php.
This should only be done by experts. It you have an extra comman of extra semi-colon anywhere in the files. It will cause an error. The error will not appear on the screen or error log files. The error can cause the orders to not appear in admin.
I suggest that you start with a fresh copy of responsehander.php and place a new order again. I have succesfully recieved orders in admin without any modification to the files.

just to clarify to everyone, the call url should be:
https://<url-site-url>/googlecheckout/responsehandler.php
In sandbox, ssl is not required.
In live mod, ssl is required.

[gid]

The code should work fine. It might not be returning anything because google_checkout table is empty.

Thanks colosports. Though, like I said in my last comment the google_checkout table is returning a value when I execute the query.

I have reinstalled the mod from scratch several times. I have even gone as far as deleting all my mods, done a get on the code base and reinstalled.

[gid]

misticjeff,
Go to this URL and fill out the form. They got back to me in less than a day. http://base.google.com/support/bin/request.py