Forums / Addon Payment Modules / Google Checkout module for ZC 1.3.x (beta)

Google Checkout module for ZC 1.3.x (beta)

Locked

Started by jacob13moon on 26 Sep 2006, 8:09 PM · Views: 1,101,466

Results 101 to 120 of 3,921
This thread is locked. New replies are disabled.
13 Oct 2006, 9:54 PM
#101
gid avatar

gid

New Zenner

Join Date:
Oct 2005
Location:
Chattanooga
Posts:
62
Plugin Contributions:
0

Google Checkout module for ZC 1.3.x (beta)

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.

13 Oct 2006, 9:56 PM
#102
gid avatar

gid

New Zenner

Join Date:
Oct 2005
Location:
Chattanooga
Posts:
62
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

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.

13 Oct 2006, 10:22 PM
#103
misticjeff avatar

misticjeff

New Zenner

Join Date:
Dec 2004
Posts:
42
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

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>
13 Oct 2006, 11:04 PM
#104
gid avatar

gid

New Zenner

Join Date:
Oct 2005
Location:
Chattanooga
Posts:
62
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

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.

13 Oct 2006, 11:08 PM
#105
gid avatar

gid

New Zenner

Join Date:
Oct 2005
Location:
Chattanooga
Posts:
62
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

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.

13 Oct 2006, 11:35 PM
#106
misticjeff avatar

misticjeff

New Zenner

Join Date:
Dec 2004
Posts:
42
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

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.

Anyone specific you contacted???

14 Oct 2006, 12:15 AM
#107
colosports avatar

colosports

Zen Follower

Join Date:
May 2005
Location:
Tampa, FL
Posts:
194
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

GlobalVillage:

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.

The Lord gave and the Lord has taken away; may the name of the Lord be praised (Job 1:21 NIV)

14 Oct 2006, 12:18 AM
#108
colosports avatar

colosports

Zen Follower

Join Date:
May 2005
Location:
Tampa, FL
Posts:
194
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

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']) );]
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.

The Lord gave and the Lord has taken away; may the name of the Lord be praised (Job 1:21 NIV)

14 Oct 2006, 12:43 AM
#109
gid avatar

gid

New Zenner

Join Date:
Oct 2005
Location:
Chattanooga
Posts:
62
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

colosports:

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.

14 Oct 2006, 4:44 AM
#111
gid avatar

gid

New Zenner

Join Date:
Oct 2005
Location:
Chattanooga
Posts:
62
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

So, I'm in responsehandler.php doing a little debugging, and this is what I have found.

I am writitng all the values that are returned to the error log like this:
error_func($cust_id);
error_func($data[$root]['buyer-shipping-address']['company-name']);
error_func($data[$root]['buyer-shipping-address']['contact-name']);
error_func($data[$root]['buyer-shipping-address']['address1']);
error_func($data[$root]['buyer-shipping-address']['address2']);
error_func($data[$root]['buyer-shipping-address']['postal-code']);
error_func($data[$root]['buyer-shipping-address']['city']);
error_func($data[$root]['buyer-shipping-address']['region']);
error_func("\n Zone zone id \n" . $zone_answer['zone_id']);

This is what I get back in my error log:
Sat Oct 14 0:39:07 EDT 2006:- 94
Sat Oct 14 0:39:07 EDT 2006:-
Sat Oct 14 0:39:07 EDT 2006:- John Doe
Sat Oct 14 0:39:07 EDT 2006:- 64 My street address
Sat Oct 14 0:39:07 EDT 2006:-
Sat Oct 14 0:39:07 EDT 2006:- 37343
Sat Oct 14 0:39:07 EDT 2006:- Chattavegas
Sat Oct 14 0:39:07 EDT 2006:- TN

It just completely dies when I get to the zone information. I am using the Table Rate on shipping. Is anyone else using table rate?

16 Oct 2006, 10:10 PM
#112
jacob13moon avatar

jacob13moon

New Zenner

Join Date:
Sep 2006
Posts:
8
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

GlobalVillage:

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.

As I've already mentioned this greatly benefits Google for every ZenCart shop that sets up Google Checkout.

How about it Jacob, some support and bug fixes and a better interface for shipping?

Everyone,

My apologies for not promptly addressing the bugs reported. I've been quite busy but I'll try my best to fix the reported bugs as soon as possible, so please continue to report any bugs or requests here.

I'll keep you posted as I update the module with the bug fixes and requests in place.

Thanks,
Jacob

17 Oct 2006, 1:40 AM
#113
colosports avatar

colosports

Zen Follower

Join Date:
May 2005
Location:
Tampa, FL
Posts:
194
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

I have uploaded a new version. It should appear by tomorrow.
The fixes are as follows:
Version : 1.0.2

Description :

  • Fixed languages_id bug.
  • Added return links from Google Checkout Cart.
  • Added customers ip-address & phone number.
  • Added getallheaders() funtion.
  • Fixed zone id bug.
  • Fix address book bug.
  • Added Google link and Order No: to Admin page.
  • Fixed quantity bug.
  • Fixed product attribute bug.
  • Added product attribute in Google Checkout cart.
  • Updated README file.

The Lord gave and the Lord has taken away; may the name of the Lord be praised (Job 1:21 NIV)

17 Oct 2006, 3:00 AM
#115
misticjeff avatar

misticjeff

New Zenner

Join Date:
Dec 2004
Posts:
42
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

Very Nice!!!

Is there anyway to get the order info to pass back to admin without using the Google API SSL URL????

17 Oct 2006, 4:53 AM
#116
colosports avatar

colosports

Zen Follower

Join Date:
May 2005
Location:
Tampa, FL
Posts:
194
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

misticjeff:

Very Nice!!!

Is there anyway to get the order info to pass back to admin without using the Google API SSL URL????

No, SSL is one of the requirements.

The Lord gave and the Lord has taken away; may the name of the Lord be praised (Job 1:21 NIV)

17 Oct 2006, 8:12 AM
#117
misticjeff avatar

misticjeff

New Zenner

Join Date:
Dec 2004
Posts:
42
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

Well if SSL is required for the passback of information into the Zen Cart admin then users should know that Google only accepts SSL Certificates from certain Roots.

Google Checkout currently accepts an SSL certificate whose Root
Certificate is from any of the Certificate Authorities listed below:

* AAA Certificate Services
* AddTrust Class 1 CA Root
* AddTrust External CA Root
* AddTrust Qualified CA Root
* Baltimore CyberTrust Code Signing Root
* Baltimore CyberTrust Root
* Class 1 Public Primary Certification Authority
* Class 1 Public Primary Certification Authority - G2
* Class 2 Public Primary Certification Authority
* Class 2 Public Primary Certification Authority - G2
* Class 3 Public Primary Certification Authority
* Class 3 Public Primary Certification Authority - G2
* Entrust.net Certification Authority (2048)
* Entrust.net Client Certification Authority
* Entrust.net Secure Server Certification Authority
* Equifax Secure Certificate Authority
* Equifax Secure eBusiness CA-1
* Equifax Secure eBusiness CA-2
* Equifax Secure Global eBusiness CA-1
* GeoTrust Global CA
* Go Daddy Class 2 Certification Authority
* GTE CyberTrust Global Root
* GTE CyberTrust Root
* GTE CyberTrust Root 5
* Secure Certificate Services
* Secure Server Certification Authority
* Starfield Class 2 Certification Authority
* Thawte Personal Basic CA
* Thawte Personal Freemail CA
* Thawte Personal Premium CA
* Thawte Premium Server CA
* Thawte Server CA
* Trusted Certificate Services
* UTN - DATACorp SGC
* UTN-USERFirst-Client Authentication and Email
* UTN-USERFirst-Hardware
* UTN-USERFirst-Object
* ValiCert Class 2 Policy Validation Authority
* VeriSign Class 1 Public Primary Certification Authority - G3
* VeriSign Class 2 Public Primary Certification Authority - G3
* VeriSign Class 3 Public Primary Certification Authority - G3

Unfortunatley, my SSL Certificate does not come from one of these Root Providers so I can not use the passback info for Zen Cart.

17 Oct 2006, 2:36 PM
#118
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

misticjeff:

Well if SSL is required for the passback of information into the Zen Cart admin then users should know that Google only accepts SSL Certificates from certain Roots.

Google Checkout currently accepts an SSL certificate whose Root
Certificate is from any of the Certificate Authorities listed below:

...

Unfortunatley, my SSL Certificate does not come from one of these Root Providers so I can not use the passback info for Zen Cart.

No Comodo Class 3 (InstantSSL Pro) support? Is that your type of certificate Jeff?

Anyone with ideas why Comodo is not on this list and/or why not supported by Google?

Or even if not on the supported list has anyone with a Comodo certificate successfully configured Zen Cart for Google Checkout and observe the proper passback of info?

Woody

17 Oct 2006, 3:39 PM
#119
colosports avatar

colosports

Zen Follower

Join Date:
May 2005
Location:
Tampa, FL
Posts:
194
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

Comodo InstantSSL uses AddTrust External CA Root.
Comodo works fine on my site.

The Lord gave and the Lord has taken away; may the name of the Lord be praised (Job 1:21 NIV)

17 Oct 2006, 6:29 PM
#120
misticjeff avatar

misticjeff

New Zenner

Join Date:
Dec 2004
Posts:
42
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

My Root is GlobalSign, so Google told me i'm SOL.

So, i'll use Google Checkout but wont have any updates to my admin area... bummer.