Google Checkout module for ZC 1.3.x (beta)

Hi all,

I have successfully managed to integrate Google Checkout UK into my test site and have made several transactions using Sandbox and all seems to be working well (gift vouchers aren't working though!!).

Anyway, I am about to go live with an affiliate network here in the UK and have been trying desperately to get the code to work with Google Checkout. I know Affiliate Window is accepted by GC but I cannot work out where I put, which file I need to add to or what code I need to use to pass the information to GC for them to transfer that to AW upon completion of the transaction (it would be so simple if GC had a callback page on my site!!)

The example code I have been given by AW is below (which is working using my current payment gateway):

---

<script language="JavaScript" type="text/javascript"> <!-- // AW sale tracker for **** // Set your transaction parameters var aw_mid = '****'; var aw_sale = '<?php echo round($subtotal->fields['value'], 2); ?>'; var aw_extra = '<?php echo (int)$orders->fields['orders_id']; ?>'; var aw_parts = '<?php echo (int)$manufacturers->fields['manufacturers_id']; ?>:<?php echo round($subtotal->fields['value'], 2); ?>'; var aw_test = '0'; // Do not edit below here. call = location.protocol.toLowerCase()+'//www.aw'; call += 'in1.co'+'m/sread.j'+'s?a='+aw_mid+'&b='+aw_sale+'&c='+aw_extra+'&d='+aw_parts; call += '&t='+aw_test+'&l='+escape(window.location.href)+'&tv=1.0'; document.write('<s'+'cript language="JavaS'+'cript" type="text/javas'+'cript" src="'+call+'&tt=js" id="aw_tag"></s'+'cript>'); var oImage = new Image; oImage.src = call+'&tt=ia'; --> </script> <noscript> <img src="https://www.awin1.com/sread.img?tt=ns&tv=1.0&merchant=****&amount=<?php echo round($subtotal->fields['value'], 2); ?>&ref=<?php echo (int)$orders->fields['orders_id']; ?>&parts=<?php echo (int)$manufacturers->fields['manufacturers_id']; ?>:<?php echo round($subtotal->fields['value'], 2); ?>&testmode=0" /> </noscript> <!-- EOF AW Code -->

---

To help me categorise my commissions, you will note that I am pulling and passing the manufacturers ID to AW and have set up a commission category in their system to pay the amount I wish to pay for a confirmed sale so any code I pass to GC would have to include the same.

I have studied and studied the files but cannot work out which one I need to add the code to and what php script I need to add to make it work and I wondered if someone would be kind enough to point me in the right direction please?

I would appreciate any help any of you could give me.

Many thanks.

Kind regards,

Big H

Woodymon:

As I understand it the orange icon indicates, among other things, a shipping zone has been applied. So orange is not bad. Just an informational warning.

For testing purposes disable ALL of the shipping modules except for one. Then for the enabled module set the shipping zone to none. Then run the generator. Save the results to a text file. Then enable a shipping zone and run the generator again. Compare your generator output from each attempt and report back with your results.

You might want to consider running the generator with only one ship module at a time. And only run it for the modules you really need employed. Leave all the other ship modules disabled.

Woody

Thanks Woody,

I tried doing as you said and had only one shipping method available, it did nothing different... I tried with a shipping zone (orange) and without (green). Still message is :

It took (Average) 0.00489 Secs.

Thanks for the suggestion!

Michael

OK - I am trying Google Checkout again. Went through the complete install. When I navigate to: https://keyllama.com/googlecheckout/responsehandler.php it requests a user name and password. Is this normal? I don't remember it before. I've tried all the ZenCart/Google passwords I can think of and nothing gets me by it.

I mostly just want to know if this is normal or a sign I have something mis-configured.

Thanks!

-Doug

kenaniah:

Thanks Woody,

I tried doing as you said and had only one shipping method available, it did nothing different... I tried with a shipping zone (orange) and without (green). Still message is :

It took (Average) 0.00489 Secs.

Thanks for the suggestion!

Michael

Okay, so I am going to have to do it the hard way.

First of all, I apologize if this has already come up as this thread should have been a forum to itself and is completely unmanageable. I have gotten the flat rate and table rate to work (I believe the table rate may have been working before but it showed 0 so I assumed it wasn't working). What I think I am seeing is that the current version of Google Checkout has a bug with calculating table rates by Weight (by price and by item seem okay). Can anyone confirm that this is the case.

Thank you!

Michael

P.S. I really like the new version.

I received this message in my response_error.log
:- HTTP Basic Authentication failed. Can't retrive Merchant Id/Key, Installed over CGI??

And google integration shows this error :
Your server returned no data in its response; Checkout requires data of type merchant-calculation-results in response to merchant-calculation-callback

When I run /googlecheckout/responsehandler.php though I get a blank screen which is good.

I then did as TJ decoded from the instructions.

tj1:

...well, first set permissions on the 'googlecheckout' folder to 777

• Then go to the admin section of ZenCart, Modules>Payment, and select googlecheckout and click edit

• select 'True' under .htaccess Basic Authentication Mode

• under '.htaccess Basic Authentication Mode' click the 'here' link where it says "If setted True you MUST configure your .htaccess files here"

• on the .htaccess .htpasswd create window enter your checkout account, sandbox account or both. Put a check on both the 'Check if dir exists' and 'Create Files' checkboxes. Click 'Create' and close that window once it's finished.

• Now click 'update' on the googlecheckout settings.

• Change permissions back 755 on the 'googlecheckout' folder.

After doing this, I get this message once again in my response_error.log
:- HTTP Basic Authentication failed. Can't retrive Merchant Id/Key, Installed over CGI??

And google integration shows this error :
We encountered an error trying to access your server at https://www.mysite.com/googlecheckout/responsehandler.php -- the error we got is: org.apache.commons.httpclient.NoHttpResponseException: The server https://www.mysite.com failed to respond

I also get the error reported by Shawn when I run /googlecheckout/responsehandler.php

:- Invalid

shawnd:

I 've been pouring over the forums for a while now and I just cant seem to get GC to work. I've gotten to the point where the README file calls for a blank page after hitting responsehandler.php.

I get a dialog box from the browser asking for a username/ password combination.

Supporting Info

1. GoDaddy Is my Host, running PHP over CGI
2. I executed the script to generate the proper .htaccess and .htpasswd files.
3. I have a GoDaddy Turbo SSL certificate
4. I used the responsehandler_test_v1.2.php as provided by the developer; this was my result:

XML We Sent:

Authorization: Basic XXXXXX:XXXXXX
Content-Type: application/xml;charset=UTF-8
Accept: application/xml;charset=UTF-8

XML We Received:

HTTP/1.0 200 OK
Date: Tue, 15 May 2007 01:28:46 GMT
Server: Apache
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Pragma: no-cache
Set-Cookie: zenid=ljms6s46bjm0673d9d89v1ldv3; path=/; domain=www.eoverheaddoors.com
Content-Type: text/html; charset=iso-8859-1
X-Cache: MISS from wc02.inet.mesa1.secureserver.net
Connection: close

Mon May 14 18:28:48 MST 2007:- Invalid

Any Ideas, More info needed? Any takers? I appreciate the help.

No one has given Shawn an answer on this .....

Any help would be appreciated!

Thank you!

Michael

dkerfoot:

OK - I am trying Google Checkout again. Went through the complete install. When I navigate to: https://keyllama.com/googlecheckout/responsehandler.php it requests a user name and password. Is this normal? I don't remember it before. I've tried all the ZenCart/Google passwords I can think of and nothing gets me by it.

I mostly just want to know if this is normal or a sign I have something mis-configured.

Thanks!

-Doug

Doug if you ran the .htaccess script it is looking for your Google Merchant ID and Merchant Key

kenaniah:

Okay, so I am going to have to do it the hard way.

What I think I am seeing is that the current version of Google Checkout has a bug with calculating table rates by Weight (by price and by item seem okay). Can anyone confirm that this is the case.

Thank you!

Michael

P.S. I really like the new version.

Michael,

Calculating by weight works OK in Google Checkout in my cart, as does table rate. As far as what makes mine work and yours not, I don't know if I'm much help. One thing I did that helped me was to clean all the shipping methods from my includes/modules/payment/googlecheckout.php file that I was not using. If you do that, be sure that the braces and commas are correct.

kenaniah:

I received this message in my response_error.log
:- HTTP Basic Authentication failed. Can't retrive Merchant Id/Key, Installed over CGI??

And google integration shows this error :
Your server returned no data in its response; Checkout requires data of type merchant-calculation-results in response to merchant-calculation-callback

When I run /googlecheckout/responsehandler.php though I get a blank screen which is good.

I then did as TJ decoded from the instructions.

After doing this, I get this message once again in my response_error.log
:- HTTP Basic Authentication failed. Can't retrive Merchant Id/Key, Installed over CGI??

And google integration shows this error :
We encountered an error trying to access your server at https://www.mysite.com/googlecheckout/responsehandler.php -- the error we got is: org.apache.commons.httpclient.NoHttpResponseException: The server https://www.mysite.com failed to respond

I also get the error reported by Shawn when I run /googlecheckout/responsehandler.php

:- Invalid

No one has given Shawn an answer on this .....

Any help would be appreciated!

Thank you!

Michael

Okay, I am not for certain that this is the problem but it very likely could be. It appears my SSL may not be setup correctly.

http://checkout.google.com/support/sell/bin/answer.py?answer=59779&query=ssl&topic=&type=

I have a valid SSL certificate, but I can't receive notifications. What should I do?

If you have a valid SSL certificate from a Certificate Authority that's accepted by Google Checkout, but you can't receive notifications, please check to be sure you're returning the entire certificate chain when Google Checkout contacts your server. The correct hierarchy should be:

The root CA
Any intermediate CAs
Your website
To view the current certificate chain being returned by your server in Firefox:

Navigate to your callback URL in your browser.
Click the lock icon in your browser's address bar.
Click the 'Security' tab, then click 'View.'
Click the 'Details' tab.
Locate the current certificate chain under 'Certificate Hierarchy.'
To view the current certificate chain being returned by your server in Internet Explorer:

Navigate to your callback URL in your browser.
Double-click the lock icon in your browser's status Bar.
In the window that appears, click the 'Certification Path' tab.
You can also view the current certificate chain being returned by your server by using OpenSSL and issuing the following command:
openssl s_client -connect {website domain}:443 -showcerts < /dev/null

In certain cases, you may still experience errors even though the hierarchy appears correct. These errors occur because, for certain certificate configurations, your browser automatically fills in missing certificates in the chain.

If the certificate hierarchy isn't correct, you won't be able to receive notifications from Google Checkout. Please contact your webmaster or your hosting provider about configuring your server to return the correct information.

Hi, I've just installed this mod and everything has gone along nicely except when I try to do the shipping methods generator, I get this error:

Fatal error: Cannot redeclare class freeoptions in /home/doodlebu/www/www/store/includes/modules/shipping/freeoptions.php on line 10

Any help with this? Everything else seems to be working just great :o)
Amy
https://www.doodlebuckets.com

The tax that is going to Google checkout is wrong, I have two tax zones, one for ontario and other one for rest of Canada, Ontario is 14% and rest of Canada is 6% however Google is only charging tax for rest of canada even though the customers address is from Ontario.

How do I fix this???

Also if my cart is in CDN how do I send the total to Google in USD after converting it to USD, i had to disable Google CO if a customer selects CDN currency, i should be able to convert it to USD using the conversion rate and send USD amount to google CO

My site is currently running on sandbox

its https://www.globalsatfta.com/store

thanks

Hey guys, need a little help with something. Google Checkout works great, but I have an issue. After a bit of work I got it up and running flawlessly, but just now I installed two custom shipping modules. Now I see this error during checkout:
Warning: Invalid argument supplied for foreach() in DirectoryPath/googlecheckout/gcheckout.php on line **389

**And also in the back end when I edit the Google Checkout Module I see this:
Default Values for Real Time Shipping Rates
Default values for real time rates in case the webservice call fails.

Expedited expedited not configured!
**
Standard** standard not configured!

Both Standard and Expedited are the new modules I came up with. Nothing fancy, basically just clones of Per Item. I have looked through gcheckout.php and I can not see any call to the Per Item module. I did see a call to the Table module. I am not sure how to configure the new modules with google checkout. Anyone have any ideas?

Can anyone answer this?

Thanks!

dkerfoot:

OK - I am trying Google Checkout again. Went through the complete install. When I navigate to: https://keyllama.com/googlecheckout/responsehandler.php it requests a user name and password. Is this normal? I don't remember it before. I've tried all the ZenCart/Google passwords I can think of and nothing gets me by it.

I mostly just want to know if this is normal or a sign I have something mis-configured.

Thanks!

-Doug

Yes, that's normal. That's what the .htaccess and .htpasswords files do.
This happens after you configure your GC setting and set the basic authentication for php running over CGI.

It's a good thing too, if you didn't have those set up, anyone would be able to access the files on your /googlecheckout folder.

The user name and password are your GC merchant ID and key.

Long time lurker,, thanks for tolerating my post.
I've used the search feature but have not found this error on this specific line. I hope someone can help.

I am getting an error when I attempt to verify google checkout in the payment-modules in the admin panel.

"Cannot redeclare class googlecheckout line 507.bmp" includes/modules/payment/googlecheckout.php

the only think in this line is a }

I'm am attempting to install v1.3.7 v1.3RC2

Thanks for any help.

Have added anything to that file?
I'm checking that file and I only have 481 lines.

I just downloaded it again here at work, opened the same file and the last line on this file is line 509, and it looks the same as the one that I loaded.. but to specifically answer your question, no, I have not added anything to this file.

:frusty:

tj1:

Yes, that's normal. That's what the .htaccess and .htpasswords files do.
This happens after you configure your GC setting and set the basic authentication for php running over CGI.

It's a good thing too, if you didn't have those set up, anyone would be able to access the files on your /googlecheckout folder.

The user name and password are your GC merchant ID and key.

Thanks for the reply! When I enter the GC merchant ID and key I get a Page not Found 404 error.

I searched for the problem in this thread with no luck. Any suggestions?

dkerfoot:

Thanks for the reply! When I enter the GC merchant ID and key I get a Page not Found 404 error.

I searched for the problem in this thread with no luck. Any suggestions?

Follow-up:

I used responsehandler_test_v1.2.php and got this response:

SSL certificate problem, verify that the CA cert is OK. Details: error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failedMy CA - Equifax Secure Global eBusiness CA-1 is on the approved list.

I follow the directions for checking the certificate chain, but don't know if my chain is good or not!

It shows:
Equifax Secure Global eBusiness CA-1

• keyllama.com (my website)

How can you know if there is supposed to be more to it? If there is a problem, how do I communicate it to my sitehost?

Thanks!

-Doug

DarkAzrael:

Hey guys, need a little help with something. Google Checkout works great, but I have an issue. After a bit of work I got it up and running flawlessly, but just now I installed two custom shipping modules. Now I see this error during checkout:
Warning: Invalid argument supplied for foreach() in DirectoryPath/googlecheckout/gcheckout.php on line 389

And also in the back end when I edit the Google Checkout Module I see this:
Default Values for Real Time Shipping Rates
Default values for real time rates in case the webservice call fails.

Expedited expedited not configured!

Standard standard not configured!

Both Standard and Expedited are the new modules I came up with. Nothing fancy, basically just clones of Per Item. I have looked through gcheckout.php and I can not see any call to the Per Item module. I did see a call to the Table module. I am not sure how to configure the new modules with google checkout. Anyone have any ideas?

Can anyone help me with this? I am not sure what is going on with it...