Google Checkout module for ZC 1.3.x (beta)

Hi everyone,

This is Jacob from the Google Checkout team.

I'd like to let you know that we just released Google Checkout module for Zen Cart. This module provides Level 2 implementation of Google Checkout with Zen Cart, enabling you to provide Google Checkout to buyers and process orders through your admin UI.

This project is hosted at http://code.google.com/p/google-checkout-zencart where you can find the latest release at any time.


Thanks,
Jacob

UPDATE:
GOOGLE HAS ABANDONED AND NO LONGER SUPPORTS THEIR GOOGLE CHECKOUT ADDON


UPDATE:
As of July 2012 a community member has picked up where Google left off. Please report any issues/ideas to: https://github.com/mattclements/Goog...Zencart/issues
NEW DISCUSSION ON THE NEWER MODULE can be found at: http://www.zen-cart.com/showthread.php?199125-Google-Checkout

what are the requirements?
lib xml?
php?
dom?

Quote:

---

Originally Posted by Merlinpa1969

what are the requirements?
lib xml?
php?
dom?

---

Everyone, you can also download the module from http://www.zen-cart.com/index.php?ma...roducts_id=314

It runs on PHP with libcurl installed. However, it does not require DOM or DOMXML (libxml) libraries installed.


Thanks,
Jacob

how about php 5,
I mean the requirements google said required php 4

Thank you for providing this. I look forward to implementing it into our sites. I took a look at the download file and although it is clear (somewhat) how to install it, it is not the most user friendly way to present it and is definetly a different way of approaching it.

Please don't get me wrong. I'm not complaining, but am grateful that this is being provided by Google. I'm just stating that if the intent is to encourage as many shops as possible to implement and use google checkout, the presentation of it may scare the more novice/intermediate users away. The majority of shop owners / creators are not your typical programmers.

Anyways, thanks again!
Mike

Thanks for info/module, hopefully Google's UK supporters will soon
get the chance to try out Google Checkout
:smile:

I tried installing it but the patch script hangs. :-(

ok....so I figured out to install it w/o hanging. This is the command I used with the patch in the root of the store where admin is a sub directory

patch -p1 </eStore/google-checkout-zencart.patch

With version 1.3.5 I got errors where sections of the file did not merge. It does say that it is for version 1.3.0. - so shame on me...I could go merge the sections that failed manually but I don't really see the profit.

patch is a Linux utility used to patch the Linux kernel among other things. It's pretty nifty as it uses a file comparison utility called diff to compare the files and the patch script tells whether to add, subtract, or overwrite code blocks at specified line numbers. I am grateful to google for releasing this but I really wish it was released in standard format..this really slows me down so I will not plan on integrating it right now until it is easier to install.

I'm waiting to hear back from the contributor about their intentions regarding releasing a simpler-to-install version of their code.

Im still wondering if it works with php 5.
the last info I got from google was that it was for php4 only and that libxml was required

Quote:

---

Originally Posted by Merlinpa1969

Im still wondering if it works with php 5.
the last info I got from google was that it was for php4 only and that libxml was required

---

Hi,

I just updated the original module so it runs on both PHP4 and PHP5. It does not require libxml since it doesn't use any of the DOM functions for constructing and parsing XML. The only requirement is cURL (libcurl) installed and enabled on your server.

Hope this helps,

Jacob

Quote:

---

Originally Posted by willalbro

patch is a Linux utility used to patch the Linux kernel among other things. It's pretty nifty as it uses a file comparison utility called diff to compare the files and the patch script tells whether to add, subtract, or overwrite code blocks at specified line numbers. I am grateful to google for releasing this but I really wish it was released in standard format..this really slows me down so I will not plan on integrating it right now until it is easier to install.

---

Aha! That makes sense. I haven't seen that before. The format did look rather peculiar to me . . .

Kool looks good,
will you make this more user friendly ( zen user )
and for more than just the 1.3.0
4 out of 5 hunks fail in our 1.3.5 demo ( has mods )

Jacob,

I have a few questions about the purpose of some of the code altered in core files.

1. /admin/modules.php
I don't see anything that requires this edition of the added makeSqlString() function. You declare this same function in two other places, but this is the only one that is set to return a value enclosed by $single_quote. Again, it seems that this file does not need to be touched, as this sole function is not used from here.

2. /admin/orders.php
I don't see anything in your code that uses the $payment_value variable defined:
$payment_value= MODULE_PAYMENT_GOOGLECHECKOUT_TEXT_TITLE;

3. two of your added files are duplicated, with ~ appended to the filename. I gather these are simply backups generated by an editor? However, since they are identical to each other, they don't appear to be merely backups. I see no references to ~ elsewhere in your changes, so it appears these files are not used/required.

Ok...I bitched enough yesterday and I have since decided to get back to being solution minded. I downloaded version 1.3.0 and applied the patch. Following is the command line output. In short one hunk failed and that block of code is a comment and is inconsequential.

patch -p1 </home/will/Test/zen- cart-v1.3.0-full-fileset/google-checkout-zencart.patch
patching file admin/includes/functions/general.php
Hunk #1 FAILED at 17.
1 out of 3 hunks FAILED -- saving rejects to file admin/includes/functions/gener al.php.rej
patching file admin/modules.php
patching file admin/orders.php
patching file googlecheckout/gcheckout.php
patching file googlecheckout/gcheckout.php~
patching file googlecheckout/response_error.log
patching file googlecheckout/response_message.log
patching file googlecheckout/responsehandler.php
patching file googlecheckout/xmlparser.php
patching file googlecheckout/xmlbuilder.php
patching file includes/languages/english/modules/payment/googlecheckout.php
patching file includes/modules/payment/googlecheckout.php
patching file includes/modules/payment/googlecheckout.php~
patching file includes/templates/template_default/templates/tpl_checkout_payment _default.php
patching file includes/templates/template_default/templates/tpl_login_default.ph p
patching file includes/templates/template_default/templates/tpl_shopping_cart_de fault.php


(Following is the general.php.rej hunk that failed, as you can see it's a comment.:)

***************
*** 17,23 ****
// | to obtain it through the world-wide-web, please send a note to |
// | license AT zen-cart DOT com so we can mail you a copy immediately. |
// +----------------------------------------------------------------------+
- // $Id: general.php 4316 2006-08-28 21:27:21Z drbyte $
//

////
--- 17,23 ----
// | to obtain it through the world-wide-web, please send a note to |
// | license AT zen-cart DOT com so we can mail you a copy immediately. |
// +----------------------------------------------------------------------+
+ // $Id: general.php 3415 2006-04-11 04:51:22Z drbyte $
//

////

I am going to now patch this file set into 1.3.5 or upgrade 1.3.0 to 1.3.5...or maybe I will take the files and make them into a Zen Friendly mod that would install the standard way?...any feedback?

Thanks,

Will
www.brooksestore.com

Quote:

---

Originally Posted by willalbro

...or maybe I will take the files and make them into a Zen Friendly mod that would install the standard way?...any feedback?

---

If you do, please post it here for the masses :D.

Ok...I made it into a zen friendly mod that can be installed and used right away :-D

I submitted it into the downloads section and it is under review. In the meantime you can find it here:

www.brooksestore.com/eStore/Google_Checkout.zip

Use it at your own risk and have fun. BTW it's on my site and functions great.

God Bless!

Will
Brooks eStore
www.brooksestore.com

does it integrate with super orders?

Personally, Im not sure. It is exactly what google coded, except I ran the patch utility on a fresh, non-modded 1.3.0 version and then used a file comparing utility to upgrade google_checkout to a fresh, non-modded version of 1.3.5.

I would guess yes, but I would test it on a non-production store.

Best of luck!

Will
www.brooksestore.com

Will,

Thanks for your efforts. They are appreciated.

I took it one step further for you ...

I did the same thing last night, and when I studied the code changes while converting to 1.3.5, I came up with a number of changes to the code in order to make it more Zen-friendly and easier to plug in, etc. Some of the issues encountered are listed earlier in this thread in the form of questions.

Like you, I've packaged it as a set of files which can be uploaded by FTP. The readme explains which files should be modified to suit your own custom template, etc.

Extraneous unused code is also removed from the updated module.

The update is now available as an update to the original contribution:
http://www.zen-cart.com/index.php?ma...roducts_id=314

Thanks to you all for your modifications - I trust you implicitly. (Google I'm not so sure)

Novice question for you: I'm running Zen 1.3.0.1 and am wondering if your modified version for 1.3.5 would work as well on my current version.
I realize that I need to upgrade but it will be the first time for me and it is, to say the least, a daunting task. I'm avoiding it like the plague. (But would still like to implement this mod asap)

Thanks again - Tim

Should be fine on 1.3.0.1 and 1.3.0.2, if you consider the following:

-/admin/orders.php ... in 1.3.5 there were some corrections made to some of the legend icons on the page. Those may or may not show up properly using the GC version of the file.

- the 3 template-file changes enclosed will need to be manually merged into your existing template files, or simply added to your custom template if you haven't made customizations to them already.

Quote:

---

Originally Posted by DrByte

Will,

Thanks for your efforts. They are appreciated.

I took it one step further for you ...

I did the same thing last night, and when I studied the code changes while converting to 1.3.5, I came up with a number of changes to the code in order to make it more Zen-friendly and easier to plug in, etc. Some of the issues encountered are listed earlier in this thread in the form of questions.

Like you, I've packaged it as a set of files which can be uploaded by FTP. The readme explains which files should be modified to suit your own custom template, etc.

Extraneous unused code is also removed from the updated module.

The update is now available as an update to the original contribution:
http://www.zen-cart.com/index.php?ma...roducts_id=314

---

Awesome!! Thanks for taking it further. I applied your updates this morning!

I got everything working except for the display on "Step 2 of 3 - Payment Information" /index.php?main_page=checkout_payment page.

When I enable Google Checkout I get only one selection and GC is not visible.

If I go to "Shopping Cart" /index.php?main_page=shopping_cart The Google Checkout button appears.

I am getting GC to function but it is only visible from the shopping cart.

Thanks all

GlobalVillage

I had just started coding something like this last week and find this is great that Google did this.

I'm wondering though if there is a reason why Google Checkout doesn't appear in the main checkout process along with the other payment modules. Instead it is a separate button that goes to the Google Checkout page.

Also why is it that no other shipping types currently supported?

If I am missing something please let me know.

I think there may be a bit of confusion, as GC is not merely a "payment method" (in the traditional sense of payment methods use in Zen Cart or other systems) ....
Google Checkout is in fact an alternate checkout method, not another payment method.

(according to Google's words, anyway)

Doc,

Is that why it does not show in "Step 2 of 3 - Payment Information" in the checkout?

Quote:

---

Originally Posted by DrByte

I think there may be a bit of confusion, as GC is not merely a "payment method" (in the traditional sense of payment methods use in Zen Cart or other systems) ....
Google Checkout is in fact an alternate checkout method, not another payment method.

(according to Google's words, anyway)

---

Okay, got it going on 1.3.0.2 (yes, i know, update!!! i'm working on it, the cart is heavily mod'ed).

Am I supposed to see any purchases on the main admin panel page? (admin home) or is there any place in the zen cart admin side where I see any google checkout orders? Just checking. Cause if there is, then it's not working afterall. Being an "alternative checkout" I wasnt sure.

Thanks in advance for the info

I need some help... I want to use Google checkout, yet I am using version 1.3.2
I cant upgrade becuase my site is already fully moded and it would take years to put them back together...

Anyway my question is how do you add the google checkout to 1.3.2 also I am a novice user and I dont know how to put that .patch file into my zencart... I tried adding it to "Install SQL Patches" but I keep getting an error or something...

Is there a zip file with simple instructions to add this Google checkout feature???
Please note that my site is fully moded... Please help....

Keep up the good work...

J.

Did anyone get the attribute name to display in the GC shopping cart?
Currently the attribute name shows as ' - '.
I tried playing with the code but wasn't able to fix it.
I think the problem lies at
gcheckout.php Line 128:

Code:

---

      while (list($option, $value) = each($products[$i]['attributes'])) {
        $products_name .= "\n" .'- ' .
            $products[$i][$option]['products_options_name'] . ' ' .
            $products[$i][$option]['products_options_values_name'] . '';
      }

---

It's going through the while loop but the values seem to be NULL.
I'm running it on ZC 1.3.5.

JVSS which modules have you added,
if they were done ring upgrade shouldnt be that hard

Dr. Byte,

In your instructions, you have us rename the admin folder if we changed its name. In the /googlecheckout/gcheckout.php file, the first line is

Code:

---

require_once('admin/includes/configure.php');

---

If you don't change that to the new foldername as well, it simply leaves the rest of your page blank.

Is there a better way then hard coding that?

Thanks,

Rick


P.S. Is there any way to use this to integrate with Zen without an SSL cert? Seems google wants an HTTPS link to send data back.

I installed the google checkout, and it seemed to work fine, however the google checkout button doesn't actually show up on the page.

Do I have to put the button on manually using the code given to me by google?

Thanks.

did you use the google checkout that Dr Byte provided?

Yes, the most recent one. I also just recently installed zen, so I have the newest version and it is unmodded if that helps at all.

I am seeing this error in the Integration Issue Detail:

XML failed to validate against the schema at line: 48, column: 48, with error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'shipping-taxed'. One of '{"http://checkout.google.com/schema/2":rate, "http://checkout.google.com/schema/2":tax-area}' is expected.

Has anyone using GC had a sale complete yet?

I had several test orders complete,
all was good

Two things....

1. If anyone finds any problems between this and Super Orders, let me know.
2. I think it's pretty damn cool that Zen-Cart is big enough to get the attention of the Google people, in any explicit fashion. Big thumbs up ya'll! :thumbsup:

How would you recommend integrating this with superorders? The mod calls for two edits to the file in admin/orders.php. If you use super orders, the file used it admin/super_orders.php?

Quote:

---

Originally Posted by BlindSide

Two things....

1. If anyone finds any problems between this and Super Orders, let me know.
2. I think it's pretty damn cool that Zen-Cart is big enough to get the attention of the Google people, in any explicit fashion. Big thumbs up ya'll! :thumbsup:

---

i recently installed zencart 1.35 and the patch.. then the dr byte revision of thegoogle checkout payment module.. when i make a test order google checkout shows up as a payment option, i select it, then the order just finishes without any errors. it mails a confirmation to the user and adds it to my orders page in admin. however it doesnt do anything with google. it doesnt ask the customer for their credentials and nothing shows up in my googlecheckout account.

I have the EXACT same issue. Haven't figured it out yet...

Quote:

---

Originally Posted by brownsgreens

I have the EXACT same issue. Haven't figured it out yet...

---

if you mean the same thing i posted, do you have your bank account verified with google yet? I dont, but I assumed I could still receive payments, or atleast would get an error.

What do you mean it finishes without any errors? Does it not take you to the google checkout page and ask for shipping info and payment info? Please be a little more clear.

Quote:

---

Originally Posted by njpins

i recently installed zencart 1.35 and the patch.. then the dr byte revision of thegoogle checkout payment module.. when i make a test order google checkout shows up as a payment option, i select it, then the order just finishes without any errors. it mails a confirmation to the user and adds it to my orders page in admin. however it doesnt do anything with google. it doesnt ask the customer for their credentials and nothing shows up in my googlecheckout account.

---

Quote:

---

Originally Posted by voltage

What do you mean it finishes without any errors? Does it not take you to the google checkout page and ask for shipping info and payment info? Please be a little more clear.

---

Yes, its almost as if i chose check/moneyorder. I select google checkout as the payment option. I click next. It takes me to the confirmation page. I click next again. Then it takes me to the thankyou page.


Since my last post I made sure that i was using the flat rate shipping module and had that option checked in the googlecheckout payment module settings. still didnt help though.

I have problem with product with options and shipping charge. All the options are displayed something like "---" in google cart. Shipping fee is not add to google cart also. Please share your soultion.
Many thanks

Quote:

---

Originally Posted by njpins

Yes, its almost as if i chose check/moneyorder. I select google checkout as the payment option. I click next. It takes me to the confirmation page. I click next again. Then it takes me to the thankyou page.

---

I figured it out, and im feeling kind of dumb for being a tech who didnt rtfm.
the reason is because i didnt not rename the templates folder when copying everything over for google checkout, so the checkout button doesnt show up on the shipping page. i just copied the files to where they need to be and it works now.


I didnt read the readme this morning when i installed it because it didnt format correctly in notepad. i used vi just now and felt really dumb.

Thats interesting. I'm using 1.3 (not 1.35) and I didn't realize that I don't have it working either! :wacko: I have the button in the shopping cart page, but no button shows up in the checkout payment screen. Meaning, the customer can choose the zencart checkout or google checkout from the shopping cart page, but if the customer chooses the zencart checkout from the shopping cart, there is no option for google payment on the checkout payment page. And I DID copy over the templates.

Any thoughts?

Quote:

---

Originally Posted by voltage

Thats interesting. I'm using 1.3 (not 1.35) and I didn't realize that I don't have it working either! :wacko: I have the button in the shopping cart page, but no button shows up in the checkout payment screen. Meaning, the customer can choose the zencart checkout or google checkout from the shopping cart page, but if the customer chooses the zencart checkout from the shopping cart, there is no option for google payment on the checkout payment page. And I DID copy over the templates.

Any thoughts?

---

I am pretty sure that is how it is supposed to work. Dissapointing, I know. The main reason for installing the module instead of just making a link is for the notifications via the API callback. So now I have to figure out how to get ssl working in apache2, but thats a differant forum

Well, not so much disappointing as surprising. But its a good thing in my opnion. One of the most confusing thing about the paypal mod is that the customer signs up for an account, goes through the whole checkout process, hits confirm, is take to a new screen asking if they have an account, they then re input their info or at least confirm their payment and shipping info and then hit confirm. Whew! Too much work.

In fact, for all of those people who use paypal only and have been screaming for a checkout not requiring an account, this is it.

Quote:

---

Originally Posted by GlobalVillage

I am seeing this error in the Integration Issue Detail:

XML failed to validate against the schema at line: 48, column: 48, with error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'shipping-taxed'. One of '{"http://checkout.google.com/schema/2":rate, "http://checkout.google.com/schema/2":tax-area}' is expected.

Has anyone using GC had a sale complete yet?

---

I got the same warning...

XML failed to validate against the schema at line: 46, column: 46, with error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'shipping-taxed'. One of '{"http://checkout.google.com/schema/2":rate, "http://checkout.google.com/schema/2":tax-area}' is expected.

What is this warning? Is it becuase I have multiple flat rates?

Thank you,

Quote:

---

Originally Posted by gems14k

I got the same warning...

XML failed to validate against the schema at line: 46, column: 46, with error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'shipping-taxed'. One of '{"http://checkout.google.com/schema/2":rate, "http://checkout.google.com/schema/2":tax-area}' is expected.

What is this warning? Is it becuase I have multiple flat rates?

Thank you,

---

I am using the table rate but I was not putting enough info in the rate table. Under $30 I charge $6.95 and over $30 shipping is free.

I assumed this was what the rate table needed:
29.99:6.95,30:0.00

Anything over thirty would be 0.00

Nope ya gotta do it this way
29.99:6.95,5000:0.00

This way any amount over 29.99 up to 5000 will show 0.00

The error I was getting from GC was because it was not passing a shipment amount. Check your flat rate setup as it may not be passing the shipping on to GC

I'm getting the same XML error (Invalid content was found starting with element 'shipping-taxed'. One of '{"http://checkout.google.com/schema/2":rate, "http://checkout.google.com/schema/2":tax-area}' is expected), using table-based shipping. The table seems to be fine; the proper shipping amounts are being passed on to Google Checkout and added to my test orders, but I'm still getting the error. Thus far, it's got me stumped.

Also, for test orders placed through Google Checkout (using the sandbox), no sign of the order ever shows up in the Zen admin pages...nothing in reports, no customer details, etc. I'm not sure if the XML error above is preventing the API callback from working correctly, or if this is a completely separate and unrelated issue. I'd be interested in hearing if any other people with the XML error are having the same problem.

Any thoughts or advice would be most appreciated, and I apologize if I've committed any newbie faux pas in my inaugural post...

I got my earlier issue worked out with the checkout button not appearing.

Now, when I'm using sandbox mode, I seem to have the same problem as the previous post. I'm not getting xml errors, but the order processes at google, then sends me back the my site, however my purchase is still sitting in my shopping cart and zen hasn't processed it as an order.

Any ideas?

Quote:

---

Originally Posted by GlobalVillage

I am seeing this error in the Integration Issue Detail:

XML failed to validate against the schema at line: 48, column: 48, with error: cvc-complex-type.2.4.a: Invalid content was found starting with element 'shipping-taxed'. One of '{"http://checkout.google.com/schema/2":rate, "http://checkout.google.com/schema/2":tax-area}' is expected.

Has anyone using GC had a sale complete yet?

---

Everyone,

Thanks for reporting this issue. It's a bug in the code; there's an extra statement that does not belong.

Here's what you can do to fix it:

1. Open the following file in a text editor:
/admin/googlecheckout/gcheckout.php

2. Remove the following statement @ Line 317 (Please note that similar statement @ Line 267 should NOT be removed)
$gcheck->element('shipping-taxed', 'true');

Please reply back if this doesn't help.


Thanks,
Jacob

Jacob, thanks for the fix! The XML errors are gone now.

Unfortunately, it does look like the other integration problem experienced by browngreen and I (items still remain in the shopping cart after completing the order, and the order isn't processed by Zen) is indeed a separate issue. Google Checkout doesn't report anything as being wrong, but it seems something just isn't happening with the callback.

Quote:

---

Originally Posted by voltage

How would you recommend integrating this with superorders? The mod calls for two edits to the file in admin/orders.php. If you use super orders, the file used it admin/super_orders.php?

---

Whatever the mods are for orders.php, find the quivalent line in super_orders.php and make the same change. Remember, super_orders.php is based on orders.php, and has all the same features (hence the same code), just more bells and whistles.

Everyone,

For those of you who have other modules installed on your Zen Cart installation, overwriting your files might break your exising installation. So I updated the contribution which now includes step-by-step installation instructions: http://www.zen-cart.com/index.php?ma...roducts_id=314

I hope this helps many people. Please don't hesitate to leave any questions or feedback; I'd be more than happy to help you get started.


Thanks,
Jacob

Please add your contribution to the Downloads Section.

Attribute bug.
If the attribute are not showing up at Google CheckOut page, you can edit the following code to fix it. This is a temporary fix.

Change following on line 91 and 101.

Code:

---

        $attributes = $db->Execute("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix
                                      from " . TABLE_PRODUCTS_OPTIONS . " popt, " .
                                      TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " .
                                      TABLE_PRODUCTS_ATTRIBUTES . " pa
                                      where pa.products_id = '".makeSqlInteger($products[$i]['id']).
                                      "'and pa.options_id = '" . makeSqlString($option) . "'
                                      and pa.options_id = popt.products_options_id
                                      and pa.options_values_id = '" . makeSqlString($value) . "'
                                      and pa.options_values_id = poval.products_options_values_id
                                      and popt.language_id = '" . $languages_id . "'
                                      and poval.language_id = '" . $languages_id . "'");

---

to

Code:

---

        $attributes = $db->Execute("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix
                                      from " . TABLE_PRODUCTS_OPTIONS . " popt, " .
                                      TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " .
                                      TABLE_PRODUCTS_ATTRIBUTES . " pa
                                      where pa.products_id = '".makeSqlInteger($products[$i]['id']).
                                      "'and pa.options_id = '" . makeSqlString($option) . "'
                                      and pa.options_id = popt.products_options_id
                                      and pa.options_values_id = '" . makeSqlString($value) . "'
                                      and pa.options_values_id = poval.products_options_values_id
                                                                                ");

---

Your are removing 2 lines:
and popt.language_id = '" . $languages_id . "'
and poval.language_id = '" . $languages_id . "'

The value of $languages_id is NULL causing no attribute to appear. By removing it, the attribute will appear. Website with only one language should not be have any problems. Websites with 2 or more languages may or may not have problems. I have not tested it out on multilanguage sites.

** MAJOR BUG: **
If you place an order through Google Checkout, it will appear in your Admin orders.
The address of the order will be added/link to the Customers address book If it finds a customer with the same name.
If you delete the Google Checkout order, the address book for the customer will be ruin!
All the addresses in the address book will be change to same address. (i.e. If you have 10 address entry in your address book. All 10 will have the same address.)

If you are attempting to re-create the error, make sure you backup your database before you delete the order.

Colosports: I'd been seeing the attribute bug, and your fix partially solved it - thanks! I am noticing that when a product has a complex set of attributes, the Google Checkout page truncates them with an ellipsis. Do you have any idea if there's a way to display the attributes in their entirety? I'm not sure if it's a hard limit of Google Checkout or what.

Google set the max limit to about 94 character for the title (+attribute).
This should not matter since, we can have Google send the attribute values back to Zencart and have all the attributes listed in Admin Orders.

I have found a solution to the address book bug. I am running a few more test and will list the fix later on tonight.

What is supposed to happen when you're using sandbox mode and you place an order?

After it says thanks, shouldn't it send you back to checkout_success? And shouldn't it take the products out of your cart? And shouldn't it show you in admin that you have a new order?

Or do those things only happen when you go to live?

After you place an order (in sandbox or live mode),
Your will get a Thank You page from Google that you placed an order.
If you return to the website, you will not get a Checkout Success.
The items in your cart disappears.
The shipping address is stored in the database. In admin, you will see the new order like regular orders. Google user will not apear in Admin->Customers.

If you get the Thank You page from Google but the orders does not show. Check the error page in your Google Checkout->Settings->Integration page.
Also make sure that the fill in the callback URL link. (Instruction in Readme file)

Everything goes fine, Google says thank you, but when it returns me to my site, it doesn't show the order as completed and the items are still in the shopping cart.

I know others are having the same issue...?

Brownsgreens, still having the same problem here, yeah. Callback URL is filled in as per the README, and no errors pertaining to the order in Settings->Integration, but the cart isn't emptied and the order doesn't show in Admin. Weird.

Here's a solution to the Address Book fix.
Instead of updating the address book and ruining all the address book, the code below will add a new address entry to the customer's address book. A possible problem is that the address may become full if they ship to a lot of different address.

Change on line 309

Code:

---

    zen_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array, $oper, $params);

---

to

Code:

---

    zen_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);

---

For those that are having problems, please post:
1. Version of Google Checkout.
2. Version of ZenCart running on.
3. Your website.
4. You Callback URL.
5. If you are on Sandbox or Live mode.
6. Errors (if any) listed at Google's website (under Setting Tab->Integrations)

I'm running the most recent version of zen, google checkout.

My website is valleymeals.com

It's on sandbox, the callback url is set properly, I have no errors on the google side, everything works perfectly there. I can log into my sandbox merchant account and see the orders there.

The customer then is sent back to index, and the items are still in the cart and the admin panel doesn't show the order.

You have errors:
Fatal error: Call to undefined function: getallheaders() in /homepages/25/d178655344/htdocs/zen/googlecheckout/responsehandler.php on line 83

from http://www.valleymeals.com/googleche...nsehandler.php
This page should show up as an blank page.

Fix your errors and try again. I'm not sure what the error relates to. Maybe someone with more knowledge can help you out. Or try searching the web for more info.

Hey Gang,

Got an odd error for you all....

New Install 1.3.5
Google Checkout Installed and verified functioning

Here's the issue:

Whenever I go into an order and select to update to "processing", "Shipped", etc... I get a db error:

Warning: fopen(/home/misticr/public_html/store/googlecheckout/response_message.log) [function.fopen]: failed to open stream: Permission denied in /home/misticr/public_html/store/admin/includes/functions/extra_functions/added_function_for_google_checkout.php on line 93

Fatal error: Call to undefined function: error_func() in /home/misticr/public_html/store/admin/includes/functions/extra_functions/added_function_for_google_checkout.php on line 94

Anyone have a clue?? Need to resolve this.


Edit: I do not have an SSL server/site so am not using an API Callback URL...

Google Checkout still works fine except that orders are not sent to my store. Is there a way around this as this could be the issue.

Thanks

Jeff

Quote:

---

Originally Posted by misticjeff

/home/misticr/public_html/store/googlecheckout/response_message.log) [function.fopen]: failed to open stream: Permission denied

---

It's attempting to write a message-logging file, but has no permissions to do so. Try making that file/folder writable.

colosports:
A-ha! I have exactly the same error in line 83 if I pull up responsehandler.php directly, so I'm definitely in the same boat as brownsgreens. No idea yet why it's happening...I'm not very conversant in php...but I appreciate the lead.

Quote:

---

Originally Posted by DrByte

It's attempting to write a message-logging file, but has no permissions to do so. Try making that file/folder writable.

---

That was it... Thanks so much!

This module appears to be incompatible with other payment mods. When installed, if you install others such as COD or Skipjack it gives these errors throughout the site:

Code:

---

Warning: Variable passed to each() is not an array or object in /home/moissan/public_html/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 /home/moissan/public_html/includes/classes/db/mysql/query_factory.php:112) in /home/moissan/public_html/includes/functions/sessions.php on line 100

Warning: Cannot modify header information - headers already sent by (output started at /home/moissan/public_html/includes/classes/db/mysql/query_factory.php:112) in /home/moissan/public_html/includes/init_includes/init_templates.php on line 78

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCT' at line 6
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) > to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

---

BTW, I'm using 1.3.02

I may have been wrong. I made my 1.3 site go live and my cache was messed up. The mod found here fixed it and I think it solved the problem.

Quote:

---

Originally Posted by voltage

BTW, I'm using 1.3.02

---

Well, whatever...I give up. I'm just going to use a merchant account myself. Google is a hassle.

Ok, now that its not throwing errors in the cart, I'm trying to test if it works. The problem is if I select the sandbox, it says that my account # doesn't exist?! :blink: If I put it in regular mode, I can get all the way to the second screen where you confirm the charges, but once I hit confirm, it says I can't purchase from myself! So I'm not sure how to test if its working at this point.

Any ideas on why it says I don't exist in with sandbox enabled, but apparently I do exist with the regular mode. (?)

Sandbox and Live mode are 2 complete separate accounts. You will have to sign up for sandbox account.
If you need to make test purchases, you will also have to create a 2nd account account to make the purchase since you can not purchase from yourself.

I have been working to get GoogleCheckout installed over the last few days. My main issues had to do with getting the SSL installed correctly. Finally tonight I was able to get an order through in the SandBox and it not throw and warnings or errors.

The thing is that the orders do not show up in my admin UI.

Any thoughts?

Hi,

Great module.

I'm looking for a firm to develop an add-on for Zen Cart. Can you please tell me who I should direct my request to?

Thank you,
Jean

I have been working to get GoogleCheckout installed over the last few days. My main issues had to do with getting the SSL installed correctly. Finally lastnight I was able to get an order through in the SandBox and it not throw and warnings or errors.

The thing is that the orders do not show up in my admin UI.

Any thoughts? I am using 1.3.5 and 1.0.1

I have installed the google checkout mod. It went very easily and no problems occured. I setup a table shipping chart (integration with UPS or FedEx would sure be better).

My question is about taxes.
I dont see away to specify which states I charge taxes in.
Ive looked through the readme docs and serched the forums here and on the google dev site and also looked through all the settings under my google-checkout account. I cant find it.

Any help would be great,
Thanks

Is there anyone who could help me on my question above? Could it be that I am not seeing orders in my Admin UI because I messed up on my upgrade from 1.2.7 to 1.3.5? If so where should I start snooping around?

Any help would be appreciated.

Gid:

I'm having the same problem on a fresh install, never upgraded. Haven't had any luck fixing or working around it yet.

Good to hear that HeadBeeGuy....Well not for you but for me. I'm glad it is not something I'm doing. Though, maybe we are both doing the same thing.

It is interesting that you are on a fresh install and I'm on a upgrade.

One other thing. I am getting nothing in my response_error.log or response_message.log. Should that tell me something?

Well I am getting messages in my response_message.log now but nothing is being updated in my DB.

Any Thoughts?

Quote:

---

Originally Posted by gid

Well I am getting messages in my response_message.log now but nothing is being updated in my DB.

Any Thoughts?

---

Are the orders showing up at Google?

Yes, they are showing up in the sandbox. It seems everything works except the updating of my database from the google call back.

Please clarify what you mean by updating.
Do you mean that new orders are not being sent to admin interface?
Or do you mean that the order status is not being updated?

Currently, I can not get the orders to update the order status of each order. I was able to fix a few bugs and add more options to make it more ZenCart friendly. I am currently having someone else testing it out and I will release it soon.

So this may have already been asked, but any chance in the near future of getting this working with USPS/UPS/FEDEX rate based shipping? I know it kinda defeats the normal design of google checkout, but can't the button be hidden until step 2 when u select a payment method and take the total price including shipping before it sends to the google site to follow TOS?

Or perhaps a middle man. When you click "Checkout quickly with Google Checkout" have it link to a shipping estimator type window where the customer can enter his postal code and select his shipping choice based on usps/ups/fedex/ etc rates, then click submit and it sends the new full price to google checkout where the customer can continue.

Quote:

---

Originally Posted by colosports

Please clarify what you mean by updating.
Do you mean that new orders are not being sent to admin interface?
Or do you mean that the order status is not being updated?

---

Sorry about that, I mean both. I am not having any tables uptaded or inserted into by google checkout once an order is made.

If you are getting orders in Google but it's not in your database or admin, the problem lies in googlecheckout/responsehandler.php

The most common issue seems to be the getallheaders() error or people forgetting to set the the file attributues to 777 for response_error.log and response_message.log

I had an interesting problem with Google Checkout

A customer used the GC checkout and when they added an address to ship to they go this error message:

(My Store) does not ship to this address:

I thought that maybe it was because the shipping address and the bill to address were different but they were the same.

Also has anyone from Google been back here to the board to address the bugs and issues or has it just been the ZenCart staff and users?

I know that it is impolite to perhaps question the coder that hands you something like this MOD but it's not like Google doesn't get something for their efforts.

I would think that maybe they could put some of their code staff to really put an effort into getting this MOD functioning well, it's not like they don't' have the resources to just that?

Yeah, I had initially was unaware of the 777, which was why at one point I was having nothing written to those files. Now I am though.

I get all these steps being written out to the file:
Fri Oct 13 14:23:03 EDT 2006:- new-order-notification
Fri Oct 13 14:23:06 EDT 2006:- order-state-change-notification
Fri Oct 13 14:23:07 EDT 2006:- risk-information-notification
Fri Oct 13 14:23:25 EDT 2006:- order-state-change-notification
Fri Oct 13 14:23:26 EDT 2006:- charge-amount-notification



I was looking at line 250 where it says:
global $db;

Does anyone know where $db gets set? Looking at the code it looks like my issues are taking place in: function process_new_order_notification

I just don’t think it is hitting my database for some reason. It is almost like it does not have a connection.

GlobalVillage I did try and e-mail jacob13moon but never heard back from him. I am sure he is busy writing mods for other companies, and does not have the time come back here and answer our million + questions. I don't blame him :-)

Quote:

---

Originally Posted by gid

GlobalVillage I did try and e-mail jacob13moon but never heard back from him. I am sure he is busy writing mods for other companies, and does not have the time come back here and answer our million + questions. I don't blame him :-)

---

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?

Quote:

---

Originally Posted by colosports

If you are getting orders in Google but it's not in your database or admin, the problem lies in googlecheckout/responsehandler.php

The most common issue seems to be the getallheaders() error or people forgetting to set the the file attributues to 777 for response_error.log and response_message.log

---

Google Checkout is working fine for me with two exceptions:

1. What is the API Callback URL. I have SSL on my site but not sure what URL to use here?

2. No order is created in my admin order area. I'm using Super Orders but see no order at all when Google is used. Any suggestions?

Yes, I have both response_error.log and response_message.log set to 777.