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.

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.

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>

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.

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.

Quote:

---

Originally Posted by 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???

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.

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

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?

Quote:

---

Originally Posted by 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

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.

Thanks colosports! I can't wait to test it out!

Very Nice!!!

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

Quote:

---

Originally Posted by 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.

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.

Quote:

---

Originally Posted by 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

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

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.

Quote:

---

Originally Posted by colosports

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

---

Thanks for the info Colo.

When I first posted on this I was viewing the certificate info via Firefox Certificate Viewer. The general tab did not show any root info for the certificate supplied by Comodo.

But later when I clicked on the details tab I observed "GTE CyberTrust Global Root" which appears on the list.

And thanks for the mod update. Any idea when it might be approved for downloading? DrByte is probably very busy packaging Zen Cart v.1.36 for release ;-) Is is possible you could post the mod upodate as an attachment to this thread?

Woody

Hello Zenos,

I installed the Google Checkout Module and this is the error I get:

Oops!
Web-Smart Publishing has sent Google a shopping cart with errors in it. We'll contact them to ask that they fix this problem. If you're feeling lucky, you can go back in your browser and try to checkout again with your fingers crossed.

How can I fix this?
Does it have to do with the key?
Is the Merchant ID the same as the Merchant Key?

Thansk for all the help

Issy

I uploaded it 3 days ago and it still hasn't appeared.
I will temporary host the updated module until it appears in the download section.

google-checkout-zencart_1.0.2.zip can be found at
http://www.kaptivaimports.com/pub/go...cart_1.0.2.zip

Note: I will remove the file once it appears in the download section. So if you get redirected because the file does not exist, you should go to
http://www.zen-cart.com/index.php?ma...roducts_id=314

Demo site: http://70.103.140.123/~kaptivai/kaptiva/index.php

For those whose are aren't sure if they installed Google Checkout module correctly (or if you want to test it out before you install it), you may test out the customer and admin side of things at the demo site above.

colosports,

I tried out vs. 1.0.2 and it is working much better. Google is now updating my admin UI. The only problem is that now I am getting this error when trying to update the status of the order.


Fatal error: Cannot use object of type queryFactoryResult as array in x/x/x/x/x/added_function_for_google_checkout.php on line 101

Quote:

---

Originally Posted by gid

colosports,
Fatal error: Cannot use object of type queryFactoryResult as array in x/x/x/x/x/added_function_for_google_checkout.php on line 101

---

Try uploading the original added_function_for_google_checkout.php file from the older version. I made some changes to the file. I am still trying to debug the admin section. Currently, the admin order section still have bugs.

Yeah, that did not work. I forgot to mention earlier (last week) that installing the google mod messed up my ability to update my order status. In order to update the order status I have had to uninstall the mod.

Quote:

---

Originally Posted by gid

Yeah, that did not work. I forgot to mention earlier (last week) that installing the google mod messed up my ability to update my order status. In order to update the order status I have had to uninstall the mod.

---

ya i had same problem. I think a little more time in the oven is needed. And some way of implementing live rate postage like usps, ups, and fedex before I can use it properly.

Are you installing this to fresh Zen Cart or Zen Cart with mods? Have you renamed or made changes to your Order Status (Such as renaming "Pending" to "foobar")

I use the perunit shipping module. I set it up so that a pound of weight for the product equals $1 in shipping cost. Any chance of being able to incorporate this shipping module into Google Checkout in the near future, or is it something that can't be done for some reason?

Quote:

---

Originally Posted by colosports

Are you installing this to fresh Zen Cart or Zen Cart with mods? Have you renamed or made changes to your Order Status (Such as renaming "Pending" to "foobar")

---

My install is an upgrade from 1.2.6 to 1.3.5x but I have not made any modifications except those needed to install google-checkout. I am using the paypal mod.

And I have not made any changes to the order status. As for the way I am handling shipping I am using Zone Rates with Shipping Tables.

gid, I would try installing the google checkout on a new fresh zencart for testing purposes. See if you still get the same error. This will let you know if the error is caused from the google module or if there is issue web your webserver.
I had many problems when upgrading to 1.3. It turn out to be something in the database when I was transisting from 1.2 to 1.3. I started from srcatch on 1.3 and slowing starting to add mods to fix the problem.

Quote:

---

Originally Posted by gid

colosports,

I tried out vs. 1.0.2 and it is working much better. Google is now updating my admin UI. The only problem is that now I am getting this error when trying to update the status of the order.

Fatal error: Cannot use object of type queryFactoryResult as array in x/x/x/x/x/added_function_for_google_checkout.php on line 101

---

gid,

If you get this error, try modifying the object reference by adding 'fields' as follows:

From
check_status->['order_status']

To
check_status->fields['order_status']

Hope this helps,

Jacob

Quote:

---

Originally Posted by colosports

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.

---

Colosports,

Thank you very much for your contribution. I believe everyone can benefit from your contribution now. :)

I was fixing bugs as well but did not have enough time to address them as quickly as I wanted to. Thanks so much for staying on top of it, and please let me know if you need any help in understanding any part of the Google Checkout API.


Thanks,
Jacob

Hi! Thanks for this module. It works great! Just a little problem though.

There are two lines
//** GOOGLE CHECKOUT **>>
and
//** END GOOGLE CHECKOUT **>> near the icon of google checkout on the checkout page.

They are supposed to be commented out. But I don't know why they still appear on the page. Should be something relatively easy to fix. But due to my limited knowledge, I cannot find the right file to modify. Anyone can help?

This is a fresh zencart 1.3.5 install with google checkout installed, haven't modified anything other than that.

Thanks!

Quote:

---

Originally Posted by stargre

Hi! Thanks for this module. It works great! Just a little problem though.

There are two lines
//** GOOGLE CHECKOUT **>>
and
//** END GOOGLE CHECKOUT **>> near the icon of google checkout on the checkout page.

They are supposed to be commented out. But I don't know why they still appear on the page. Should be something relatively easy to fix. But due to my limited knowledge, I cannot find the right file to modify. Anyone can help?

This is a fresh zencart 1.3.5 install with google checkout installed, haven't modified anything other than that.

Thanks!

---

yeah, those lines are not inside of the php code block. Either delete them or change the lines to:
<!-- //** GOOGLE CHECKOUT **>> -->

<!-- //** END GOOGLE CHECKOUT **>> -->

Hi! Thanks for your quick response. I understand that. But I just don't know where those codes were. They appeared to be on the shopping cart page, right above and below the google-checkout button. What file(s) should I modify? Thanks very much!

I got it. Thanks again!

I've got the same issue and cannot find the file to edit.

I made the changes suggested by gid above to orders.php but the same annoying

//** GOOGLE CHECKOUT **>>
and
//** END GOOGLE CHECKOUT **>> near the icon of google checkout on the checkout page.


is still on the shopping cart page

Just had another order go through and GC posted the customer name and address and product price but not the product name or amount. Is anyone else seeing this? It's kind of hard to generate an invoice without a product.

Thanks all
GlobalVillage

Just tried the latest module (1.0.2c) with a fresh install of Zen 1.3.5 and...argh, I'm still having the problem where orders are successfully sent to the Google Checkout sandbox but never appear in admin on the Zen side. This appears in response_error.log:

Fri Oct 20 8:23:51 PDT 2006:- Line 90: Authentication failed. headers[Authorization] is not set!

Any suggestions would be greatly appreciated.

I have use it but for some reason the shipping rate was not added into the total

Questions

1. when a customer adds a product to the cart, but does not login the google check out is available is there reason to allow a customer to check out without login to the site?

2. is there a way to only have the google check out show up in the login area, like the credit cards and other payment opptions do?

3. why doesn't shipping show up when a customer uses the google check out? I am use table rate...

4. how or where do i set google to return the sale like paypal does?

This is a message for Jacob at google
in the list fo CA's accepted by gogle at page 12 of this forum you list 2 certs from the large registrar godaddy
Go Daddy Class 2 Certification Authority Root Certificate
Starfield Class 2 Certification Authority Root Certificate
theproblem is that if you look at
https://certificates.godaddy.com/OtherRoot.go,
these certs are not used by godaddy. What can we do to ask you to change the acceptable ca certs from godaddy to just read
Go Daddy Secure Certification Authority
Starfield Secure Certification Authority
that way we get $20 certs and you get more people using google checkout ....


ALso ....while at it ..for testing purposes .... can you add
Thawte Test CA Root
that way we can use free test certs from Thawte to test google checkout !!

Quote:

---

Originally Posted by gid

Yeah, that did not work. I forgot to mention earlier (last week) that installing the google mod messed up my ability to update my order status. In order to update the order status I have had to uninstall the mod.

---

I have the same problem, has anyone found the problem with updating the order status? I get this error if I try and change order status.

Code:

---

Warning: require_once(includes/languages//modules/payment/googlecheckout.php) [function.require-once]: failed to open stream: No such file or directory in /home/.ankelfraeseren/pissmonk/purexm.com/kendi/orders.php on line 90

Fatal error: require_once() [function.require]: Failed opening required 'includes/languages//modules/payment/googlecheckout.php' (include_path='.:/usr/local/php5/lib/php') in /home/.ankelfraeseren/pissmonk/purexm.com/kendi/orders.php on line 90

---

Lextechs-

The whole idea behind Google checkout is to be able to checkout without creating an account in your Zen Shop...

Thank you Kim, so how come the shiping doesn't show up when i test it out?

Quote:

---

Originally Posted by Kim

Lextechs-

The whole idea behind Google checkout is to be able to checkout without creating an account in your Zen Shop...

---

Hello,
I am new to this module and to programming in general.

I fixed most of my problems, one of them was that "googlecheckout" payment module name in ZenCart is "GoogleCheckout" not "googlecheckout", so look out for that.

I am having a problem right now with the most important thing. When a customer selects Googlecheckout (GCO), and confirms the purchase, the customer is automatically routed to the checkout_success page and doesn't even go through the google checkout. The customer doesn't even get a chance to pay, and becomes a paid customer in zencart.

Where have I gone wrong? I didn't change anything except for what was mentioned at top. I am using production with correct IDs

Oh by the way, if the customer clicks on the googlecheckout icon, everything goes through perfect. But when the customers chooses the radio button in the checkout screen, that's where the problem happens.

HELP :down: :lamo:

Quote:

---

Originally Posted by Kim

Lextechs-

The whole idea behind Google checkout is to be able to checkout without creating an account in your Zen Shop...

---

So Google Checkout cannot be utilized in a similar way to the PayPal IPN? I had thought that was what the Zen Cart Level 2 mod for Google Checkout (based on the Google Checkout API) was all about? I must have been just wishing. Time for some more research. Anyone know of a good objective resource comparing Google Checkout Level 2 with PayPal (IPN)?

tried to install google checkout and get the following after install and set-up:


Warning: Variable passed to each() is not an array or object in /homepages/34/d131739436/htdocs/dsc038476945/shop/includes/classes/db/mysql/query_factory.php on line 112

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /homepages/34/d131739436/htdocs/dsc038476945/shop/includes/classes/db/mysql/query_factory.php:112) in /homepages/34/d131739436/htdocs/dsc038476945/shop/includes/functions/sessions.php on line 102

Warning: Cannot modify header information - headers already sent by (output started at /homepages/34/d131739436/htdocs/dsc038476945/shop/includes/classes/db/mysql/query_factory.php:112) in /homepages/34/d131739436/htdocs/dsc038476945/shop/includes/init_includes/init_templates.php on line 76



how can i fix this ?

UPS, FedEx integration with google checkout would be awesome.... cant use google checkout on our site until then. Any idea if this is in the works? Thanks for the help!

Hi, I read through this entire thread and didn't see anyone posting the problem I am having.

I have a fresh install of Zen-Cart v. 1.3.5, Database Patch Level 1.3.5
Running on a Linux server
I just uploaded the Google Checkout module, installed it as instructed and when I attempted to test it (using Sandbox Google account), it's like the module is not even there.

I put an item in my shopping cart, then go to Checkout and never does the Google Checkout button appear.

I have enabled it in the control panel with the appropriate Sandbox merchant ID and key. I've done everything I know to do (which isn't much - I'm no programmer). It's just like it's not even there.

Any suggestions?

I keep getting this from google:

We encountered an error trying to access your server at https://www.mystore.com/admin/google...nsehandler.php -- the error we got is: Sending failed with HTTP response code: 404.

does anyone know where google falls under the federal reserve banking system? ie, are they like paypal and can freeze your account for little to no reason at any time?

i'm trying to find the difference - anyone here with this mod installed (and actually working) care to share their experience, good or bad?

well so far in 16 pages i haven't seen anyone that's gotten this mod working completely properly. They are alot like paypal but charge less.

Quote:

---

Originally Posted by anjordan77

I keep getting this from google:

We encountered an error trying to access your server at https://www.mystore.com/admin/google...nsehandler.php -- the error we got is: Sending failed with HTTP response code: 404.

---

I believe it's because there is no admin/googlecheckout/resp...

it's in -www_mystore_com/googlecheckout/responsehandler.php[/url]-

Installed in 1.3.5 with SO 2.0
Everything is working except NO Updates in Admin of the new order. There is no record of it.

Orders are placed, and seen in sellers/buyer account, also the response_message.log shows all details

no errors shown in google integration log.

Quote:

---

Originally Posted by Alik

I believe it's because there is no admin/googlecheckout/resp...

it's in -www_mystore_com/googlecheckout/responsehandler.php[/url]-

---

I keep getting the same thing also and i even change it to the correct url but google seem to be looking for the admin url

Quote:

---

Originally Posted by jacob13moon

gid,

If you get this error, try modifying the object reference by adding 'fields' as follows:

From
check_status->['order_status']

To
check_status->fields['order_status']

Hope this helps,

Jacob

---

Thanks for your reply Jacob. Sorry it has taken me so long to get back to this. I did make some changes. Everything seems to be working except I get an error now when I move from pending to processing.
This is what I get:
Error 400: Bad request. The parameters passed to the service did not match as expected. The exact error is returned in the XML response.



Looking in my response this is what I get:

Quote:

---

HTTP/1.1 400 Bad Request
Content-Type: application/xml; charset=UTF-8
Transfer-Encoding: chunked
Cache-control: private
Set-Cookie: S=payments=3_bK64uKbUw; Path=/
Server: GFE/1.3
Date: Fri, 27 Oct 2006 01:29:47 GMT

<?xml version="1.0" encoding="UTF-8"?>
<error xmlns="http://checkout.google.com/schema/2" serial-number="dec3cb0f-cabb-4f9c-be8c-e1a896d255ae">
<error-message>Charge amount too large. This order can't be charged for more than USD 0.00</error-message>
</error>
400

---

Also, even though I have the checkbox checked to notify about the status change through e-mail, no e-mail is sent. And, the google standbox is never updated once I start updating the order status from my zen-cart admin. I assume it should be, correct?

Looks like it needs to be:

https://yourstore.com/googlecheckout...nsehandler.php

Quote:

---

Originally Posted by ############llc.com

does anyone know where google falls under the federal reserve banking system? ie, are they like paypal and can freeze your account for little to no reason at any time?

i'm trying to find the difference - anyone here with this mod installed (and actually working) care to share their experience, good or bad?

---

No, they are not under the federal reserve banking system, its in their terms and conditions. It under section 4. Also, read section 10 about termination.

https://checkout.google.com/termsOfService?type=Seller

So the answer to your question is, yes they can freeze your account for no reason and they will hold money for 90 days.

Does GC v1.3.5 work with ZC 1.3.6?

Quote:

---

Originally Posted by gems14k

Does GC v1.3.5 work with ZC 1.3.6?

---

As far as I can tell, only the /admin/orders.php is affected, and that was only a minor adjustment. You could easily merge the differences using WinMerge.

Zen Cart 1.3.5, here is the issue, I have GoogleCheckout disabled, if disabled should not affect orders.php..

Warning: main(includes/languages//modules/payment/googlecheckout.php) [function.main]: failed to open stream: No such file or directory in /home/bodybump/public_html/admin/orders.php on line 90

Fatal error: main() [function.require]: Failed opening required 'includes/languages//modules/payment/googlecheckout.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bodybump/public_html/admin/orders.php on line 90

Any help would be appreciated.

Installed on 1.3.6 everything is working.
but NO orders in admin ?

Intergration page shows no errors ! but for some reason it's not being updated in the admin page. googlecheckout folder/files are set to 777 and the response_message.log is being updeted by google.

where should i look for a fix ?
which files are involved in updating the admin with new orders ?

I have the same exact problem.
Orders not showing in admin, but the response_message.log is updating and has all the current info.

Quote:

---

Originally Posted by trinorthlighting

No, they are not under the federal reserve banking system, its in their terms and conditions. It under section 4. Also, read section 10 about termination.

https://checkout.google.com/termsOfService?type=Seller

So the answer to your question is, yes they can freeze your account for no reason and they will hold money for 90 days.

---

so let me get this right: they can hold your $ for little to no reason for 90 days and according to section 4.5, they can essentially say it's not their problem?

"Unless otherwise expressly waived by GPC, Seller agrees to release, and does hereby release, GPC and its affiliates, and its and their agents, contractors, officers and employees, from claims, demands and damages (actual and consequential) of every kind and nature, known and unknown, suspected and unsuspected, disclosed and undisclosed, arising out of or in any way connected with such Disputes."

not sure why anyone would want this kind of account... but i love a world where we can make such choices if we want!

Errors encountered, I installed a stock Zen-Cart with only the Google Checkout module installed, same error in orders.php. All other payment modules not enabled. I tried it a second time with only moneyorders.php enabled, error occurred again. Same location, same error linking back to error in googlecheckout. ???

Check your config file
includes/languages//modules/payment/googlecheckout.php

I double checked the module, it is in the correct place, but it appears there is an issue in the installation, it should be applied against the root template directory not /YOUR TEMPLATES/templates, etc

/mht

Quote:

---

Originally Posted by ############llc.com

so let me get this right: they can hold your $ for little to no reason for 90 days and according to section 4.5, they can essentially say it's not their problem?

"Unless otherwise expressly waived by GPC, Seller agrees to release, and does hereby release, GPC and its affiliates, and its and their agents, contractors, officers and employees, from claims, demands and damages (actual and consequential) of every kind and nature, known and unknown, suspected and unsuspected, disclosed and undisclosed, arising out of or in any way connected with such Disputes."

not sure why anyone would want this kind of account... but i love a world where we can make such choices if we want!

---

That is standard for any company, it protects them from fraud. Read the fine print from the big processors like authorize.

Paypal is notorious for holding account and not giving any reason. Google will more than likely respond quicker and better if there is an issue.

I suggest you consult with an attorney on the google checkout procedures. Their policies are much better than pay pals and their fees are lower.

So, when will this module work with calculated shipping?

Quote:

---

Originally Posted by anjordan77

Looks like it needs to be:

https://yourstore.com/googlecheckout...nsehandler.php

---

I keep getting e-mails from google stateing
"We've made several unsuccessful attempts to send order notifications to your notification callback URL, https://www.lextechs.com/admin/googl...nsehandler.php As a result, you aren't receiving order status, risk, or other notifications. "

In my google setting it https://www.lextechs.com/googlecheck...nsehandler.php

So iam not sure why they keep looking in admin

Quote:

---

Originally Posted by lextechs

I keep getting e-mails from google stateing
"We've made several unsuccessful attempts to send order notifications to your notification callback URL, https://www.lextechs.com/admin/googl...nsehandler.php As a result, you aren't receiving order status, risk, or other notifications. "

In my google setting it https://www.lextechs.com/googlecheck...nsehandler.php

So iam not sure why they keep looking in admin

---

Since you original set your url callback to https://www.lextechs.com//admin/goog...nsehandler.php (which is incorrect), Google will send all updated for your previous order to that url.
For orders that were place after you changed it to https://www.lextechs.com//googlechec...nsehandler.php (which is correct), Google will use that url for updates.

The only solution is to call Google and have them stop sending updates for the old orders or copy responsehandler.php to your admin/googlecheckout/ folder.
Mark the previous orders complete/ship, wait a few days. Once the error stop appearing, you can safey delete the admin/googlecheckout/ folder.

Admin section currently does not work. It is a known bug.
The next update should fix it.

I've seen something similar to this error earlier, but not the solution for it.

I am using 1.3.0 for ZC and 1.0.2 for the G checkout mod.

Whenever I try to send data to Google (make a purchase), it 'visibly' forwards to the thank you page of ZC and never makes it to Google. The admin on ZC is updated with the order and I (as the customer) get an email that my order has been placed.

Nothing ever makes it to Google, I never see their pages, and I am not being charged by them.

The system is using PHP 4.3.0 on FreeBSD 4.8 with libCURL 7.10 installed and supported by PHP. The site is secured by a valid cert authority (recognized by Google) which shouldn't matter as the payment data is transferred and the user is redirected to Google.

This is a rather heavily modded version of the cart, but I have been installing mods on stuff for years and this seemed to go rather smooth... until testing :(

No one has asked this yet:

- Is there a way to bring customers back to YOUR site's Thank You / Order Confirmation page?

- If you offer downloads, is there anyway to have googlecheckout support it? (I mean, can customers get back to your Thank You page so they can get their downloads?)

Thanks for the replies in advance.

Has this worked for anyone?

I do not know if it has worked for anyone. I really want to get this installed especially since google is offering no processing fees between November 8th and January 1st now.

Hi Guys....

Just installed Zen (GREAT cart program!)....grabbed googlecheckout mod, installed, testing against sandbox for now, talking to sandbox, no problem in what I see coming/going me->goog->me Seeing state changes coming/going in the response_message.log.

I may be missing something, but in watching the orders in admin->cust->orders, I see the order come in, but it NEVER sees a status change from the original of "Pending". From there, I charge/ship/etc in google, the logs are seeing the status changes but no updates to zen....

Something wrong with my install? or am I just looking in the wrong place ?

Any help appreciated!
Thanks

Can someone please answer this question? In order to use GG checkout do you need ssl? Thanks!

According to the readme sandbox works without it, but production will require it..........

Dave...

I've got Google Checkout working on my site (version 1.3.0.2) but have 1 question .... is it possible to change the size and background color of the google checkout button? I've searched through all the files and can't find the button properties referenced anywhere.

TIA

flightoffancy:: Did you do any modifications to get google checkout to work? Also, do the google buy now button show up when you login in & check out? Thanks!

Does anyone know why the Google Checkout Button shows up when someone logs in and then it displays "not available for these items?" Is it necessary to have that button display for logins? Thanks.

I got google checkout to work once when i had a friend purchase a 1$ item but of course i started getting those api kickbacks and they haven't stopped.

Quote:

---

Originally Posted by Linux

flightoffancy:: Did you do any modifications to get google checkout to work? Also, do the google buy now button show up when you login in & check out? Thanks!

---

I didn't do any modifications to the code except for 1 of the language files. The google checkout button does still show up on the shopping cart page when logged in (kind of pointless) but it doesn't affect any of the normal cart functions.

Hi guys, I will throw my 2cents in here to share where I am at this point......

Yes, it is working flawlessly, all but the result codes. The key is in the readme and install docs.....regarding chmoding 777 both logs, and using sandbox to test against (that doesn't require SSL, pretty sure that was your question yesterday.....)
The install doc points you to sandbox.google.com/sell to setup your sandbox (dummy) google acct. Then the callback API gets pointed to it in the zen setup. I setup a sandbox acct. with PayPal a few months ago to test another app talking to PayPal....it is a bit scarey at first, seems like you are setting up a *real* acct, but you aren't. YOU have to do this to confirm all your settings, OR your going to be shoving all to live google (not good) and any errors, it will clammer bigtime at you. Example, I gave the api callback the wrong path by accident the first time thru, google would'nt leave me alone, errors, blah, blah, blah.......

So
1. follow docs to the "T" they are well written, and a treasure trove of info, once I slowed down grabbed some coffee and read them......
You can NOT miss copying any files over (I did option A in the install, since mine is a fresh install) don't miss *any* or it won't work.
2. setup a sandbox acct. sandbox.google.com/sell
3. tell the zen setup side to go there, NOT live
4. this requires NO SSL
5. once happy, you will need SSL on the callback server for the live to work (that could be your problem now?)

Asside from all that, like i said, mine is working, ONLY thing I can't get figured is the state changes from revewing-charging-processing-shipping....I am seeing the logs populate with google info, but zen isn't doing a thing with them.........that was my orig. question........still no answer from the gurus........google? Dr. Byte? care to chime in?

If you get yours working, and your orders status takes the changes, lets talk again!

Dave........

I have another question.

We want to use only Google Checkout for payment, but need to get rid of the ZC checkout button.

If Google is the only payment module installed, and one clicks the Zencart checkout button, Google Checkout is shown as the only option. If you go ahead through the ZC checkout, it seems to work, however, it never goes to Google Checkout, and never asks for a credit card. The customer may think everything is ok, but nothing is processed.

Is there a way to remove the ZC checkout button, and just have the Google Checkout button?

Thanks.

OK.........just noticed an update for this (ver 1.0.3) posted, grabbed it, installed, everything remains the same, however, all logging to response*.log stopped.

Double checked everything, reinstalled 1.0.2 and logging picked up.

So at least here on this one we be broke on ver 1.0.3

My setup:
zen 1.3.6
goog 1.0.3

Dave.....

OK....ver 1.0.3 now logging........

responsehandler.php

syntax error, unexpected ';', expecting ')' in /home/dwellsin/public_html/jerkynet/store/go
oglecheckout/responsehandler.php on line 344

But still no admin order page updates.........arg.................

I'm having the same problem, that it does not update the orders in ZC. I tried both 1.0.2 and 1.0.3. I tested the api callback url in my browser and did not get an error.

With 1.0.2, I don't get an error on the Google Checkout Settings>Integration page, but with 1.0.3, I always get a "Read Timed Out" error.

Could this be a browser issue? I am using Firefox (newest release).

BTW, I edited line 344 in the responsehandler.php file for 1.0.3, and removed the semi-colon near the end of the line.

500 error.... Any idea why?


We encountered an error trying to access your server at https://trinorthlighting.com/Store/g...nsehandler.php -- the error we got is: Sending failed with HTTP response code: 500. Response body was: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <HTML><HEAD> <TITLE>500 Internal Server Error</TITLE> </HEAD><BODY> <H1>Internal Server Error</H1> The server encountered an internal error or misconfiguration and was unable to complete your request.<P> Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.<P> More information about this error may be available in the server error log.<P> <P>Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. <HR> <ADDRESS>Apache/1.3.37 Server at trinorthlighting.com Port 443</ADDRESS> </BODY></HTML>

I am getting this message as well in my error logs:

[2006-11-10 17:39:38]: error: file is writable by others: (/home/trinorth/public_html/Store/admin/googlecheckout/responsehandler.php)

Trinorth........

Your last one looks like an easy one....my docs show your googlecheckout dir as a child of your store root, ie;
you have
store/admin/googlecheckout
should be
store/googlecheckout

Just shakin the bush over here to, wishing i could figure whats up with no admin order updates from this, everything else is wonderful!

Dave.....

Quote:

---

Originally Posted by jerkynet

Trinorth........

Your last one looks like an easy one....my docs show your googlecheckout dir as a child of your store root, ie;

should be
store/googlecheckout

Just shakin the bush over here to, wishing i could figure whats up with no admin order updates from this, everything else is wonderful!

Dave.....

---

Tried that as well. It passes orders to google fine, but when google tries to communicate back it hits the server error....

The passback url for the api is not allowed to feed into the admin the orders..... That is where my issue is, google communicating back....

You might want to check the integration on google checkout to see what kind of errors your getting on the pass back.

Quote:

---

Originally Posted by trinorthlighting

Tried that as well. It passes orders to google fine, but when google tries to communicate back it hits the server error....

The passback url for the api is not allowed to feed into the admin the orders..... That is where my issue is, google communicating back....

You might want to check the integration on google checkout to see what kind of errors your getting on the pass back.

---

No errors on google, it be happy.......
Dave......

The one thing that baffles me on the whole level two and ssl intergration. If you think about it, when the customer has items in his cart its not secure at the point. When the customer hits the google checkout, then it goes to google in a secure mode. Customer types in his info which is secure....

The only thing that google passes bach which should go to the admin at that point is secure. Since google is not passing back and there are issues with this, is the API even necessary?

I just got this back from Google support when I asked if there is a way to export orders from Google Checkout, and I mentioned I was using ZC:
----------------------------------------------------------------------------------------

Thank you for your email. I understand that new orders don't appear in
your Zencart Admin UI.

We apologize for the inconvenience this may be causing you, we're actively
working to resolve this issue as soon as possible.

Thank you for your patience; we'll make an announcement in the Zencart
forum when this is fully resolved.


Thanks,

Jacob
Google Checkout API Support

Quote:

---

Originally Posted by trinorthlighting

The one thing that baffles me on the whole level two and ssl intergration. If you think about it, when the customer has items in his cart its not secure at the point. When the customer hits the google checkout, then it goes to google in a secure mode. Customer types in his info which is secure....

The only thing that google passes bach which should go to the admin at that point is secure. Since google is not passing back and there are issues with this, is the API even necessary?

---

Having your cart app talking intimently with the processor back and forth, is very cool, other option would be to use PayPal thier IPN works pretty well, but then you have to put up with the payPal crapola......my vote is Google.....once I get mine working, I am going into bigtime marketing mode, take advantage of those FREE ccard processing thru 12/31..........I am pushing folks into google by only offering coupons if checkout with google.......they are all over it.

So....where is our colosports or google guy?? seems there are few remaining issues here.

Dave....
Dave........