Google Checkout module for ZC 1.3.x (beta)

I am having trouble integrating this.

the website is www.phresolutions.com or https://www.phresolutions.com

Followed README and INSTALL instructions.

Responsehandler.php does not give any errors.

Added both merchant number and auth key to checkout.

When try and test the transaction it never redirects or opens any item for credit card entry on the website. it goves from the choose your payment option, then goes to the confirm order, and when you press confirm order. it goes through (the order) and puts it into processing queue, without accepting payment.

The paypal IPN works fine. Its just googlecheckout...not sure whats going on any help would be great.

Quote:

---

Originally Posted by apursell

I am having trouble integrating this.

the website is www.phresolutions.com or https://www.phresolutions.com

Followed README and INSTALL instructions.

Responsehandler.php does not give any errors.

Added both merchant number and auth key to checkout.

When try and test the transaction it never redirects or opens any item for credit card entry on the website. it goves from the choose your payment option, then goes to the confirm order, and when you press confirm order. it goes through (the order) and puts it into processing queue, without accepting payment.

The paypal IPN works fine. Its just googlecheckout...not sure whats going on any help would be great.

---

I have this same problem and questioned it on the 25th of November. I have yet to be answered... :blink:

Quote:

---

Originally Posted by TripleMoons

I have this same problem and questioned it on the 25th of November. I have yet to be answered... :blink:

---

Awesome, i'm glad i signed up for a merchant account with google.

Just curious what version of PHP are you running, i'm thinking this may have to do with it.

Quote:

---

Originally Posted by TripleMoons

I have this same problem and questioned it on the 25th of November. I have yet to be answered... :blink:

---

Do you guys see a google checkout button that looks like this on your page:
http://www.magneticone.com/store/ima...demo-small.jpg

If not, then it means you GCO module isn't correctly installed. Check templates, because if you are modifying the files in one area, but zen cart is pulling template files out of somewhere else then it won't run the GCO code you installed. Its relatively easy to do this. This link:
https://www.zen-cart.com/tutorials/i...hp?article=230
explains the override system that zen cart uses to load different files for different templates.
Brian

I am in a similar boat as others.

GCO mod successfully installed, however when order is completed it does not show up in admin section of zen cart.

To be honest I don't really care about this, since I'd be fine just using the orders system on google's site to process my orders. The bigger problem, in my opinion, is that after the user completes the order they:

1. return to my website homepage, not a checkout success page that lets them know all went well
2. back on my homepage their cart is still sitting there with items in it!

The inevitable result of this is that user will be unsure, did it really go through?

I have to say, as far as the Google Checkout in general (not its integration) I am extremely impressed. It beats the snot out of paypal in a lot of ways. I have faith that Google will see this integration through.

To any of the developers, let me know if I can help contribute code. I'm interested in getting this working well for my own store and helping others would be good as well.

Thanks,
Brian

Quote:

---

Originally Posted by colosports

To all users:
Attach is a screenshot of what the admin ui should look like after the order is placed with Google Checkout.

---

Colosports,

If I'm not mistaken this is what everyone is trying to figure out how to do, right? You posted a screen shot of it so you must have it working in some form. How did you do it?

Brian

Quote:

---

Originally Posted by krypton1

Do you guys see a google checkout button that looks like this on your page:
http://www.magneticone.com/store/ima...demo-small.jpg

If not, then it means you GCO module isn't correctly installed. Check templates, because if you are modifying the files in one area, but zen cart is pulling template files out of somewhere else then it won't run the GCO code you installed. Its relatively easy to do this. This link:
https://www.zen-cart.com/tutorials/i...hp?article=230
explains the override system that zen cart uses to load different files for different templates.
Brian

---

no i don't but that doesn't tell me how to install this, i followed the module instructions to the teeth.

Quote:

---

Originally Posted by apursell

no i don't but that doesn't tell me how to install this, i followed the module instructions to the teeth.

---

Hi Apursell,

Ok, you probably did the instructions exactly, but it might have been on the wrong file (that looked like the right file). Zen cart has copies of files in different template folders that look almost identical. Depending on which template you use it will use different files. See the part in the install instructions where they talk about "YOUR_TEMPLATE". This needs to be replaced with your correct directory. Pull up your zen cart admin -> tools -> template selection. See whats listed under "template directory"? I think there should just be one. This is what you should use in place of that variable, "YOUR_TEMPLATE".

Anything in the install instructions in caps is meant to be replaced with your own values. Same for "YOUR_ZENCART_FOLDER" too.

Good luck, let me know if that helps.
Brian

Quote:

---

Originally Posted by krypton1

I am in a similar boat as others.

GCO mod successfully installed, however when order is completed it does not show up in admin section of zen cart.

To be honest I don't really care about this, since I'd be fine just using the orders system on google's site to process my orders. The bigger problem, in my opinion, is that after the user completes the order they:

1. return to my website homepage, not a checkout success page that lets them know all went well
2. back on my homepage their cart is still sitting there with items in it!

The inevitable result of this is that user will be unsure, did it really go through?

I have to say, as far as the Google Checkout in general (not its integration) I am extremely impressed. It beats the snot out of paypal in a lot of ways. I have faith that Google will see this integration through.

To any of the developers, let me know if I can help contribute code. I'm interested in getting this working well for my own store and helping others would be good as well.

Thanks,
Brian

---

I installed it successfully too and have the same issues. Its not really a problem since the sale goes through but what to tell the customer when they dont return to a checkout success page?

Jason

it's weird before i had created a folder in the main page area called googlecheckout
and copied the info in there like i was told...and it would only pop up that the person had checked out in admin without them paying...then i copied the files from there into the admin/googlecheckout folder and boom suddenly people were paying with google checkout instantly...but no admin orders for google checkout customers and no attributes working.

I'm thinking it has to do with google not being allowed in the admin area which we need it to be in order to notify us on the website

Quote:

---

Originally Posted by brimsjewelry

I installed it successfully too and have the same issues. Its not really a problem since the sale goes through but what to tell the customer when they dont return to a checkout success page?

Jason

---

Ok I have a fix for the issue about orders not showing up in zen cart admin. I got this off the oscommerce site, they have a similar thread.

Basically you can comment out some lines in responsehandler.php and it goes through. Cart gets deleted, and the order shows up correctly in zen cart admin.

In googlecheckout/responsehandler.php

Change

Code:

---

  $headers = getallheaders();
  if(isset($headers['Authorization'])) {
    $auth_encode = $headers['Authorization'];
    $auth = base64_decode(substr($auth_encode, strpos($auth_encode, " ") + 1));
    $compare_mer_id = substr($auth, 0, strpos($auth,":"));
    $compare_mer_key = substr($auth, strpos($auth,":")+1);
  } else {
      error_func("Line 119: headers['Authorization'] is NULL.\n");
      exit(1);
  }
  $googlepayment = new googlecheckout();
  $merchant_id =  $googlepayment->merchantid;
  $merchant_key = $googlepayment->merchantkey;

  if($compare_mer_id != $merchant_id || $compare_mer_key != $merchant_key) {
    error_func("Line 127: merchant_id or merchant_key does not match.\n");
    exit(1);
  }

---

to

Code:

---

/*  $headers = getallheaders();
  if(isset($headers['Authorization'])) {
    $auth_encode = $headers['Authorization'];
    $auth = base64_decode(substr($auth_encode, strpos($auth_encode, " ") + 1));
    $compare_mer_id = substr($auth, 0, strpos($auth,":"));
    $compare_mer_key = substr($auth, strpos($auth,":")+1);
  } else {
      error_func("Line 119: headers['Authorization'] is NULL.\n");
      exit(1);
  }*/
  $googlepayment = new googlecheckout();
  $merchant_id =  $googlepayment->merchantid;
  $merchant_key = $googlepayment->merchantkey;

  /*if($compare_mer_id != $merchant_id || $compare_mer_key != $merchant_key) {
    error_func("Line 127: merchant_id or merchant_key does not match.\n");
    exit(1);
  }*/

---

basically you are commenting out all except these three lines:

Code:

---

$googlepayment = new googlecheckout();
  $merchant_id =  $googlepayment->merchantid;
  $merchant_key = $googlepayment->merchantkey;

---

You are removing the security checks. Is this safe? I have no idea. But it does work, so I decided to post it. It may provide clues to help others come up with better solutions or provide you something good enough to go with for now until Google fixes this bug.
Brian

Quote:

---

Originally Posted by krypton1

Hi Apursell,

Ok, you probably did the instructions exactly, but it might have been on the wrong file (that looked like the right file). Zen cart has copies of files in different template folders that look almost identical. Depending on which template you use it will use different files. See the part in the install instructions where they talk about "YOUR_TEMPLATE". This needs to be replaced with your correct directory. Pull up your zen cart admin -> tools -> template selection. See whats listed under "template directory"? I think there should just be one. This is what you should use in place of that variable, "YOUR_TEMPLATE".

Anything in the install instructions in caps is meant to be replaced with your own values. Same for "YOUR_ZENCART_FOLDER" too.

Good luck, let me know if that helps.
Brian

---

Yeah i understand that, and its set to classic, so i put it/edited the files for "classic" template.

Next, I'm going to try getting google checkout working with JROX affiliate manager. GCO currently breaks it since the user never gets to the checkout_success.php page

If anyone has tips on this please post.

Brian

Quote:

---

Originally Posted by apursell

Yeah i understand that, and its set to classic, so i put it/edited the files for "classic" template.

---

Hi Apursell,

Ok, could be something else. Bottom line is that the the code you added on the shopping_cart page is not getting run. Basically, don't worry about getting the install right...just worry about finding the right place in the right file to modify. Just test some different files, in different places, put a big red "hello" (or print("hello"); if its php) somewhere in the code, then save it, and reload the page. Does it show up? Try seeing if you can modify ANYTHING on the shopping_cart page...then put in some google code.

Also, double check you have the GCO mod installed and enabled in admin->payment modules

after that i might be out of ideas! :lookaroun
B

did you make the googlecheckout folder in the admin...

what api callback are you using? any other google checkout settings would be appreciated.

thanks

Quote:

---

Originally Posted by krypton1

Hi Apursell,

Ok, could be something else. Bottom line is that the the code you added on the shopping_cart page is not getting run. Basically, don't worry about getting the install right...just worry about finding the right place in the right file to modify. Just test some different files, in different places, put a big red "hello" (or print("hello"); if its php) somewhere in the code, then save it, and reload the page. Does it show up? Try seeing if you can modify ANYTHING on the shopping_cart page...then put in some google code.

Also, double check you have the GCO mod installed and enabled in admin->payment modules

after that i might be out of ideas! :lookaroun
B

---

Thats what i'm trying to do why do you think i'm here....HAHA

I think i'm getting somewhere, on the "checkout/login" page, where you can login to Zen or Create new account, it now has a "Or use" and shows a link (with broken image) to Googlecheckout. But for some reason the image is not showing up so it just shows ALT tag and the empty square where the image should be. HOWEVER, this would be pointless b/c it is before shipping charges are added, and well then i would be losing money. so....its a start but not the right one.
I'm know its probably something simple at this point.

hold your breath, i'm about to give it a shot with my alter ego with your responsehandler.php mods....

i see i just had an order go through and again it did not pick up in admin nor in the attributes(Size) in this case.

Again it did not pop up in my Admin Panel in zen-cart

Current checkout integration settings:
https://www.mystore.com/googlechecko...nsehandler.php

Email notifications
Email me each time I receive an order, cancellation or other transaction.
You will receive an email with each new order, cancellation or other transaction.
**ENABLED**
Shopping cart type
Allow shopping carts with name/value pairs to be sent to Google.
**ENABLED**

Callback Method:
name/value pairs


I'm currently receiving orders just not in my admin section of my website.

Quote:

---

Originally Posted by krypton1

Ok I have a fix for the issue about orders not showing up in zen cart admin. I got this off the oscommerce site, they have a similar thread.

Basically you can comment out some lines in responsehandler.php and it goes through. Cart gets deleted, and the order shows up correctly in zen cart admin.

In googlecheckout/responsehandler.php

Change

Code:

---

  $headers = getallheaders();
  if(isset($headers['Authorization'])) {
    $auth_encode = $headers['Authorization'];
    $auth = base64_decode(substr($auth_encode, strpos($auth_encode, " ") + 1));
    $compare_mer_id = substr($auth, 0, strpos($auth,":"));
    $compare_mer_key = substr($auth, strpos($auth,":")+1);
  } else {
      error_func("Line 119: headers['Authorization'] is NULL.\n");
      exit(1);
  }
  $googlepayment = new googlecheckout();
  $merchant_id =  $googlepayment->merchantid;
  $merchant_key = $googlepayment->merchantkey;

  if($compare_mer_id != $merchant_id || $compare_mer_key != $merchant_key) {
    error_func("Line 127: merchant_id or merchant_key does not match.\n");
    exit(1);
  }

---

to

Code:

---

/*  $headers = getallheaders();
  if(isset($headers['Authorization'])) {
    $auth_encode = $headers['Authorization'];
    $auth = base64_decode(substr($auth_encode, strpos($auth_encode, " ") + 1));
    $compare_mer_id = substr($auth, 0, strpos($auth,":"));
    $compare_mer_key = substr($auth, strpos($auth,":")+1);
  } else {
      error_func("Line 119: headers['Authorization'] is NULL.\n");
      exit(1);
  }*/
  $googlepayment = new googlecheckout();
  $merchant_id =  $googlepayment->merchantid;
  $merchant_key = $googlepayment->merchantkey;

  /*if($compare_mer_id != $merchant_id || $compare_mer_key != $merchant_key) {
    error_func("Line 127: merchant_id or merchant_key does not match.\n");
    exit(1);
  }*/

---

basically you are commenting out all except these three lines:

Code:

---

$googlepayment = new googlecheckout();
  $merchant_id =  $googlepayment->merchantid;
  $merchant_key = $googlepayment->merchantkey;

---

You are removing the security checks. Is this safe? I have no idea. But it does work, so I decided to post it. It may provide clues to help others come up with better solutions or provide you something good enough to go with for now until Google fixes this bug.
Brian

---

OK, i did this and i also created a folder googlecheckout in the store main level so it's now in your public_html or wherever.

in the checkout folder i copied everything over from the admin/googlecheckout/
folder into my new created one.

In google i have under integration:
API Callback URL
https://www.MYSTORE.com/googlechecko...nsehandler.php
Callback Method: XML
Email Notifications **enabled
Shopping Cart Type **disabled


I am currently receiving orders properly but without the attributes(Size, Color, etc.) I also don't have google factoring in shipping costs right now so everyone that uses google checkout gets free shipping which is a big problem for me because i can end up with some heavy items. Those are the least of my worries, i want the attributes to work as of right now.

Instead of having to email someone every order to find out what they really did order. It does not show me in my Zen-Cart Admin either.

Quote:

---

Originally Posted by anjordan77

did you make the googlecheckout folder in the admin...

---

nope, just in the root web directory, so the url is
http://<url-site-url>/googlecheckout/responsehandler.php

Quote:

---

Originally Posted by anjordan77

what api callback are you using? any other google checkout settings would be appreciated.

thanks

---

API callback is just as it says in install,
http://<url-site-url>/googlecheckout/responsehandler.php

I'm using xml, instead of name/val pairs

Google checkout has been successfully integrated with JROX affiliate manager. I stayed up all night trying to fix it and finally got it working, only to discover the JROX team posted a fix right before me:

http://www.zen-cart.com/forum/showthread.php?t=51485

Ok, another issue i'm seeing is the Quantity when it posts the transaction into Zen-Admin as an order.

someone ordered a quantity of 4 things, the total was right, but the quantity that popped up on the admin was just 1 X ITEM

Just thought i'd bring this up. I am really liking what i'm seeing so far.

I wouldn't mind googcheckout having an option to print invoice, label, etc.

Thanks for your hard work and hopefully i can start making use of my free processing.

I've now done a FULL re-install of everything, still does not work.

ok make a folder in the main listing called googlecheckout:

www.yourstore.com/googlecheckout

copy all of the files from your admin/googlecheckout
into the folder you created.


do the editing of code as posted a few posts ago of the responsehandler in the main folder

make sure you have the google checkout info correct inyour website merchant ID and key

make sure you have the API Call Back url https://www.yourstore.com/googlechec...nsehandler.php

check whatever you want in there. I test in live mode with a 2nd email account and CC# and just decline the transaction.


anyways, hope it helps you out.

I edited the code in responsehandler.php as suggested but I'm still not getting orders in admin. It behaved exactly as it did before I made the changes.

Any other ideas?

Has anyone purchased and installed the mod from MagneticOne?

Jason

do you have the following files in googlecheckout:
gcheckout.php
responsehandler.php
xmlbuilder.php
xmlparser.php
response_message.log
response_error.log

you need those files in admin/googlecheckout and in googlecheckout

considering it's in beta form and a member from google has been contacting with me about how they are still working on certain aspects, i don't know if i would purchase a mod from somewhere online.

Quote:

---

Originally Posted by anjordan77

you need those files in admin/googlecheckout and in googlecheckout

considering it's in beta form and a member from google has been contacting with me about how they are still working on certain aspects, i don't know if i would purchase a mod from somewhere online.

---

Yes, I have all those files in both admin/googlecheckout and /googlecheckout. I'm not gonna worry about it for now. as long as its processing payments properly I'm ok with it not sending the info to admin. I'm sure the guys at google will get it working correctly soon.

But thanks for the suggestions.

Jason

I'm thinking it's somewhere in here for the attributes:

Quote:

---

//Insert entries into orders_products_attributes
$orders_products_id = $db->insert_ID();
if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) {
while (list($option, $value) = each($products[$i]['attributes'])) {
$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 = '" . $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 . "'");

$sql_data_array = array('orders_id' => $orders_id,
'orders_products_id' => $orders_products_id,
'products_options' => makeSqlString($attributes->fields['products_options_name']),
'products_options_values' => $attributes->fields['products_options_values_name'],
'options_values_price' => makeSqlFloat($attributes->fields['options_values_price']),
'price_prefix' => makeSqlString($attributes->fields['price_prefix']));
$db->Execute(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array);
}
}
}

---

And somewhere in here for the quantity issue:

Quote:

---

'products_quantity' => makeSqlInteger($products[$i]['quantity'] ));

---

Sihpping is a whole other monster

What is the status of this add-on?

still in the beta, i think we are getting close to getting mine working, i just need help with 3 issues.

I'm accepting payments via google checkout but i don't get the following:
correct Quantity, attributes, shipping charged.

I'm hoping to have my php expert scope it out whenever he can get some time.

I've been working with this in the sandbox for a while tonight. I've mostly concentrated on the section of the responsehandler.php in the area where you parse the header: //Parse the http header to verify the source
/* $headers = getallheaders(); etc.

When I leave these two sections, mentioned a few posts ago, as original I get an error in the response_error.log like:
Sat Dec 9 20:58:28 PST 2006:- Line 119: headers['Authorization'] is NULL.

When I comment out the two sections mentioned the error changes to:
Sat Dec 9 21:04:07 PST 2006:- InvalidSat Dec 9 21:04:09 PST 2006:- InvalidSat Dec 9 21:04:13 PST 2006:- Invalid

In neither case does the order appear in the Admin screens, although GCO says the order went through.

I've deactivated GCO in my cart for now.

Can anyone tell me if I'm getting close?

Thanks.

I'm running into the same problem. Zencart accepts the choice of Google Checkout, but the information never makes it to Google. Anyone have any luck?

Quote:

---

Originally Posted by chain_man

I've been working with this in the sandbox for a while tonight. I've mostly concentrated on the section of the responsehandler.php in the area where you parse the header: //Parse the http header to verify the source
/* $headers = getallheaders(); etc.

When I leave these two sections, mentioned a few posts ago, as original I get an error in the response_error.log like:
Sat Dec 9 20:58:28 PST 2006:- Line 119: headers['Authorization'] is NULL.

When I comment out the two sections mentioned the error changes to:
Sat Dec 9 21:04:07 PST 2006:- InvalidSat Dec 9 21:04:09 PST 2006:- InvalidSat Dec 9 21:04:13 PST 2006:- Invalid

In neither case does the order appear in the Admin screens, although GCO says the order went through.

I've deactivated GCO in my cart for now.

Can anyone tell me if I'm getting close?

Thanks.

---

I'm having the exact issues with GC and my ZC , same errors on edit of responsehandler.php. Though i still offer GC as for of checkout, and have to add the info to admin manually. Hope this will be resolved soon.

Quote:

---

Originally Posted by Alik

I'm having the exact issues with GC and my ZC , same errors on edit of responsehandler.php. Though i still offer GC as for of checkout, and have to add the info to admin manually. Hope this will be resolved soon.

---

Does anyone know how to cancel their Google Checkout account? because this is pointless as far as i'm concerned.

I think it's worth trying to get it running for the most part. It can be a pain if you do have attributes on things because you will have to email the customer to figure out what color, size, etc. someone ordered for every order.

Now interms of payment choices i have the following:
authorize.net AIM
Echeck
Paypal
Google checkout

about 40% of customers are using google checkout now.

I suggest everyone change the code that was mentioned before to comment out a big chunk of the responsehandler. copy your googlecheckout folder from the admin folder and into a new created one in your main area (yourstore.com/googlecheckout)

That's what i did and i'm getting lots of orders through there now.

I guess this is a beta for a reason...i've enabled table shipping and it's been going into google checkout so far charging shipping charges.

Quote:

---

Originally Posted by anjordan77

I suggest everyone change the code that was mentioned before to comment out a big chunk of the responsehandler. copy your googlecheckout folder from the admin folder and into a new created one in your main area (yourstore.com/googlecheckout)

That's what i did and i'm getting lots of orders through there now.

I guess this is a beta for a reason...i've enabled table shipping and it's been going into google checkout so far charging shipping charges.

---

I haven't tried having the modules in two places (admin and not...), only at the (yourstore.com/googlecheckout) level. Does that make a difference?

I also have table shipping selected, but the GC selection is offered before the shipping method is even selected by the customer. How do you get the shipping charges to GC?

Thanks,

I tried copying the googlecheckout folder to Admin. No difference.

I enabled Table Shipping and then created a table of values. These shipping charges were passed to GC along with the order. But I generally use mzmt tables and usps. These are evidently not supported yet with the GC module. Has anyone configured it for these shipping modules?

I still get the Invalid error in the error log. Could this be because I am still testing in the Sandbox?

And the order does not appear in New Orders. Also because of the sandbox?

Thanks,

I am using GCO and have a few issues...

its not responding back to my admin area with what was sold. but then im not sure it is supposed to...

shipping works fine. i have it set to charge a flat rate though so i dont know if that makes a diffrence or not.

it does not tell me the model number of the product bought but it does tell me the name of it, so it not to bad, i can look it up (id have to either way since each item is one of a kind and i have to know what im looking for)

Woo Hoo!!!

I got it working!!!

I've incorporated the commented out sections as suggested by anjordan77. What did the trick, I think, was that I re-entered the GC key in the Admin->GC module. I probably did a copy and paste from the integration screen and and grabbed an extra space at the end of the key. Thus the "Invalid" message I was getting.

Or the fact that I selected XML as the callback method instead of named pairs. This makes sense when you consider the XML parser functions included with the GC module...

The order showed up in my Admin screen and the Shopping Cart was emptied for my customer! And shipping was there - as configured in the Table method!

I noticed today that some quantities popped up in google checkout carts today, i'm thinking they might have just fixed that feature. Still no attributes popping up which kinda stinks, but oh well....free transactions for me.

Ok, now I'm completely confused. :yuck:

I just reinstalled the Google Checkout in hopes that it would straighten out and it would work in Step 3 and allow the customer to log in and check out. Now instead, I lost my Google radio button in Step 2 and have to click the Google Checkout in the shopping cart (no steps). While that's all fine and dandy and appears to work, it does not charge shipping!

Someone fix this mod and just provide a working ZIP file!!!

Install the table rates for shipping and that should work

The version I released 1.0.4 work on two different servers that I have tested on. I haven't updated the version lately because everything is working fine on my server. And due to the lack of time, I couldn't assist you guys as much as I would of like.

I just wanted to clear some stuff up:
1. First of all, you should not have to have the googlecheckout folder in the admin. If you have it in admin folder and it works, it means that you made a change to the path of one of the files that you shouldn't.
2. Most people that fixed the getallheaders() function also run into the Line 119: headers['Authorization'] is NULL error. This is a error that I cannot fix because none of my server reports this problem. If someone will create a temporary ftp account for me, I can re-create the error and try to solve the problem.
3. If the orders are getting to GoogleCheckout and does not show up in Admin, it means that there is an error with googlecheckout/responsehandler.php.
The errors will either be logged in GoogleCheckout->Integration page or in the response_error.txt file

Quote:

---

Originally Posted by anjordan77

still in the beta, i think we are getting close to getting mine working, i just need help with 3 issues.

I'm accepting payments via google checkout but i don't get the following:
correct Quantity, attributes, shipping charged.

I'm hoping to have my php expert scope it out whenever he can get some time.

---

anjordan77,
Which version of GoogleCheckout are you making changes from? These bugs were fixed on one of my earlier release.

Quote:

---

Originally Posted by Woodymon

Does the GCO for ZC mod support custom ship rate configurations where ship cost is charged for each item in order and handling fee is charged only once per order. Such as the following two S&H configs:

Total S&H (USA) =
$3 ship cost + $2 handling fee
w/ shipping zone = USA
(USA is only country in this zone)

So in this instance a one item order is $5 total S&H and each add'l item adds $3 so total S&H for a two item order would be $8.

Total S&H (Non-USA) =
$4 ship cost + $6 handling fee
w/ shipping zone = international
(all countries except USA are in this zone)

So in this instance a one item order is $10 total S&H and each add'l item adds $4 so total S&H for a two item order would be $14.

---

Hello again,

1. Any thoughts on if GCO supports the above Zen Cart shipping policy configuration? I've been employing such shipping terms in Zen Cart for a thlong time now and works well with PayPal and authorize.net.

2. As an update just had a chance to test GCO mod via e sandbox and for the most part it is working rather nicely. After I updated the order status to "delivered" in Zen Cart admin, I observed on the Google sandbox site, in the customer account, the receipt/purchase history shows "Your order has shipped"!. Nice touch.

3. However the product item name, item quantity and item price did not show up in Zen Cart admin. But the correct subtotal, shipping (default) and total amount displayed correctly along with all other order and customer info. It appears others have posted about the same issue but also sounds as some have solved the issue. Any recommends?

4. I'm using colosports 1.04 GCO mod version (including the patches he suggested after release on 10-16-06) ion Zen Cart 1.36 with PHP 4.4.4. Is there a new mod update available or patch code which I should be employing?

5. Anyone test the GCO mod with "instant" downloads yet? If so is the customer web browser redirected to a Zen Cart checkout success page with "download" link? If not any description of the process? Hoping for customer friendliness ;-)

6. In my cart's I have change the status name of "delivered" to "shipped" (I think this is more clear and closer to the truth... thinking customer interprets "delivered" to mean they have received the package vs. s"shipped' indicating order is in the mail). If I change this term will GCO choke? Or is the renaming ok as long as the status is numbered [3]?

7. When testing ordering via the sandbox, at the end of the order I see on the page with URL:
https://sandbox.google.com/sell/conf...ahblahblahblah

Quote:

---

Woody, thanks for your order!
• A copy of your receipt will be emailed to you and saved in your Google Checkout purchase history.
• You can check your receipt at any time for up-to-date order status.

---

Was my browser suppose to be redirected to the Zen Cart site after this? Or was a link suppose to be rendered on the above page so could navigate back to Zen Cart site manually? I was hoping a redirect to a Zen Cart checkout success page would be supported (as it is with PayPal IPN). Otherwise it will be constant source of confusion for both customers and shop owners. For both hard goods and soft goods orders. Or am I misunderstanding something regarding completing the order?

Thanks for any insights,
Woody

Quote:

---

Originally Posted by apursell

I think i'm getting somewhere, on the "checkout/login" page, where you can login to Zen or Create new account, it now has a "Or use" and shows a link (with broken image) to Googlecheckout. But for some reason the image is not showing up so it just shows ALT tag and the empty square where the image should be..

---

1. Follow the readme step-by-step. I missed a few important steps the first time through and had the same issue. Just checking... DO you have your "sandbox" account and normal sellers account registered with Google and you have configured the GCO payment module in Zen Cart with that information?

2. When you have added an item to your shopping cart does the GCO button then display in "color", on either the login page or on the shipping cart page?

Quote:

---

Originally Posted by anjordan77

I wouldn't mind googcheckout having an option to print invoice, label, etc.

---

You should be able to do this via the Zen Cart admin orders page (once everything is working correctly).

Do you have attributes, and item quantities working yet (appearing in Zen Cart admin)?

Woody

Quote:

---

Originally Posted by anjordan77

do you have the following files in googlecheckout:
gcheckout.php
responsehandler.php
xmlbuilder.php
xmlparser.php
response_message.log
response_error.log

---

Quote:

---

Originally Posted by anjordan77

you need those files in admin/googlecheckout and in googlecheckout

considering it's in beta form and a member from google has been contacting with me about how they are still working on certain aspects, i don't know if i would purchase a mod from somewhere online.

---

I am confused on this. The 'installation' text file only states to put those six files in the store root.

Are you certain they also need to be in /admin ? If so where is this documented?

I see two other files need to go into admin (edit for orders.php and also the added function file).

Woody

Quote:

---

Originally Posted by Woodymon

I am confused on this. The 'installation' text file only states to put those six files in the store root. Are you certain they also need to be in /admin ? If so where is this documented? I see two other files need to go into admin (edit for orders.php and also the added function file).

---

I discovered colosports already answered this a few posts up. Too late to edit my previous post. Sorry.

Quote:

---

Originally Posted by chain_man

Woo Hoo!!! I got it working!!! I've incorporated the commented out sections as suggested by anjordan77.

---

Congrats! So do you mean the post by krypton1 (7th December 2006, 09:43 AM - post #312)? Need to be sure before I monkey with the code.

Quote:

---

Originally Posted by chain_man

What did the trick, I think, was that I re-entered the GC key in the Admin->GC module. I probably did a copy and paste from the integration screen and and grabbed an extra space at the end of the key. Thus the "Invalid" message I was getting.

---

Ha! I found I did the same thing capturing the extra space. ;-)

Quote:

---

Originally Posted by chain_man

Or the fact that I selected XML as the callback method instead of named pairs. This makes sense when you consider the XML parser functions included with the GC module...

---

Yes the readme or installation doc files don't mention the setting. But mentioned by colosports earlier in this thread.

Question: On On https://sandbox.google.com/sell/sett...on=Integration
I observe the following:

Quote:

---

API callback URL

XML
e.g. <google-order-number>123</google-order-number>

name/value pairs
e.g. google-order-number=123&

---

I selected XML. However I also observe an unchecked checkbox for:

Quote:

---

Shopping cart type
Allow shopping carts with name/value pairs to be sent to Google.

---

Should this be left unchecked or not? Or does it not matter?

Quote:

---

Originally Posted by chain_man

The order showed up in my Admin screen and the Shopping Cart was emptied for my customer! And shipping was there - as configured in the Table method!

---

So are you seeing on the Zen Cart admin order page, product item names, quantities and individual item prices, and any attributes listed?

When you state the shopping cart was emptied, after order processing was completed on Google site was your browser redirected to your Zen Cart shop site, possibly a checkout success page?

Another question: I registered for a regular Google sellers account and the deposit from Google showed up in the checking account. And I also registered for a sandbox account. However no second deposit showed up. And when I log into https://sandbox.google.com/sell I continue to observe:

Quote:

---

Bank account verification required.
Your bank account is currently unverified and ineligible to receive payouts. Please verify your bank account as soon as possible.

---

Is it necessary to have the account verified for proper sandbox testing? Anyone else not see the deposit show up for the sandbox account?

Also I wonder if GCO supports different "per-item rates" for different zones? If so can this be configured via table method?

As always thanks for any info...

Woody

Quote:

---

Originally Posted by chain_man

Woo Hoo!!!

I got it working!!!

I've incorporated the commented out sections as suggested by anjordan77. What did the trick, I think, was that I re-entered the GC key in the Admin->GC module. I probably did a copy and paste from the integration screen and and grabbed an extra space at the end of the key. Thus the "Invalid" message I was getting.

Or the fact that I selected XML as the callback method instead of named pairs. This makes sense when you consider the XML parser functions included with the GC module...

The order showed up in my Admin screen and the Shopping Cart was emptied for my customer! And shipping was there - as configured in the Table method!

---

Hi all, as anjordan77 suggested, the fix works, but with security issues. anyone can post you a order emulating Google checkout.

The fix is at version 1.0.5
http://google-checkout-zencart.googl...com/svn/trunk/

this week the contribution page will be updated

this are the update for version 1.0.5
11/28/2006 v1.0.5 (ropu)
- Add support for Merchant Calculated Shipping Rates.
- Fixed minor bugs in responsehandler.php and orders.php files
- Change the XML parser and builder
- Removed getallheader() function
- Fixed wrong Qty in Admin UI
- Fixed modules not saving their settings
- Fixed Notify Customer option
- Add state change, Risk and charge notification into the Admin UI
- Add support for coupons
- Fix Shopping cart not obtained from session. See TROUBLE SHOOTING.

ropu

Quote:

---

Originally Posted by colosports

The version I released 1.0.4 work on two different servers that I have tested on. I haven't updated the version lately because everything is working fine on my server. And due to the lack of time, I couldn't assist you guys as much as I would of like.

I just wanted to clear some stuff up:
1. First of all, you should not have to have the googlecheckout folder in the admin. If you have it in admin folder and it works, it means that you made a change to the path of one of the files that you shouldn't.
2. Most people that fixed the getallheaders() function also run into the Line 119: headers['Authorization'] is NULL error. This is a error that I cannot fix because none of my server reports this problem. If someone will create a temporary ftp account for me, I can re-create the error and try to solve the problem.
3. If the orders are getting to GoogleCheckout and does not show up in Admin, it means that there is an error with googlecheckout/responsehandler.php.
The errors will either be logged in GoogleCheckout->Integration page or in the response_error.txt file

---

As i said in the last post, point 2 ( getallheaders() )must not be a problem any more, as far as version 1.0.5

Please, read the INSTALLATION and README file.

ropu

1. Bingo!

As Krypton1 recommended and Chainman referred to, I commented out the two code segments in googlecheckout/responsehandler.php and then submitted another order. And indeed the item quantity, product name, model, and item price showed up in Zen Cart admin orders page.

However, as krypton1 referred to, is there a security issue created by commenting the code? Or is it a violation of GCO TOS? Or both? Hoping the "experts" can chime in.

2. On the "Thanks for your order page" on Google site I found the link to return to the shop page. The small red link was blending in with the red watermarks in the sandbox background. It needs to be bold ;-)

3. We can configure in the Google Sellers account server settings which Zen Cart shop page customer will return to when the customer clicks on the "Return to shop" link. It does not have to be the shop's home page.

So it may be good idea to author a custom ez-page for Google Checkout customers, something that provides GCO customer with an order confirmation on the Zen Cart site and possibly some other helpful information specific to GCO customers.

4. Keep in mind if it was a guest customer which ordered via Google Checkout they will have no shop login account and will not be able to visit a "My Account page" to view their order history Zen Cart order number. And most importantly some shop-owners customer will not be able to visit Zen Cart order history page to download softgoods items which they may have ordered via GCO method.

5. So until the GCO service/mod is updated to support instant downloads (if that is the plan), how can we disable softgoods products from being ordered via GCO method?

6. And if "instant" downloads are eventually supported by the GCO, what happens if customer has trouble downloading instantly at time of order and/or needs to download again? How will customers manage purchased downloads, after the order, using Google Checkout? Something we can do using PayPal IPN.

7. And if during the checkout process on Google site, if the customer checks the box "Keep my address confidential" how will shop-owners be able to email PDF attachments to customer? That is, will Google Checkout mail system forward large email attachments to customer?

I understand these are some of the same issues which have been discussed over and over in this forum regarding instant or quick checkout methods. Will Google Checkout get around these issues by employing some unknown or yet to be attempted tricks ;-)

8. And it would be a nice touch if oogle allowed shop-owner to place a small version of their own logo up on the Google Checkout pages (along with the GCO logo).

EDIT: I did not observe Ropu's 1.05 announce before submitting this post so some of the issues I present may no longer apply?

Any info/plans regarding GCO for Zen Cart mod supporting softgoods would be most appreciated.

Woody

Quote:

---

Originally Posted by Woodymon

Congrats! So do you mean the post by krypton1 (7th December 2006, 09:43 AM - post #312)? Need to be sure before I monkey with the code.


Ha! I found I did the same thing capturing the extra space. ;-)


Yes the readme or installation doc files don't mention the setting. But mentioned by colosports earlier in this thread.

Question: On On https://sandbox.google.com/sell/sett...on=Integration
I observe the following:


I selected XML. However I also observe an unchecked checkbox for:


Should this be left unchecked or not? Or does it not matter?


So are you seeing on the Zen Cart admin order page, product item names, quantities and individual item prices, and any attributes listed?

When you state the shopping cart was emptied, after order processing was completed on Google site was your browser redirected to your Zen Cart shop site, possibly a checkout success page?

Another question: I registered for a regular Google sellers account and the deposit from Google showed up in the checking account. And I also registered for a sandbox account. However no second deposit showed up. And when I log into https://sandbox.google.com/sell I continue to observe:



Is it necessary to have the account verified for proper sandbox testing? Anyone else not see the deposit show up for the sandbox account?

Also I wonder if GCO supports different "per-item rates" for different zones? If so can this be configured via table method?

As always thanks for any info...

Woody

---

Hi all again,

regarding the setting at the integration section of googlecheckout page,
see readme
6. In the checkout.google.com/sell settings->integration, set Callback method: XML and "Allow shopping carts with name/value pairs to be sent to Google." is indistinct if is checked or not.


ropu

hi, this is a code to test ur responsehandler.php

it emulates Google Checkout.

Code:

---

<?php
/*
 * Created on 06/11/2006
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */

list($start_m, $start_s) = explode(' ', microtime());
$start = $start_m + $start_s;

send_google_req('http://ur-site/googlecheckout/responsehandler.php');
list($end_m, $end_s) = explode(' ', microtime());
$end = $end_m + $end_s;

echo "\n\nTime to response: ". ($end-$start) ." segs";
 
 function send_google_req($url) {
    // Get the curl session object
    $session = curl_init($url);
    $merid = '';
    $merkey = '';

    $header_string_1 = "Authorization: Basic ".base64_encode($merid.':'.$merkey);
    $header_string_2 = "Content-Type: application/xml";
    $header_string_3 = "Accept: application/xml";
   
   
    // here put the xml u want to emulate! u can take the ones from catalog/googlecheckout/response_message.log
    $postargs = '<xml replace!>';

    //fwrite($message_log, sprintf("\r\n%s %s %s\n",$header_string_1, $header_string_2, $header_string_3));
    // Set the POST options.
    curl_setopt($session, CURLOPT_POST, true);
    curl_setopt($session, CURLOPT_HTTPHEADER, array($header_string_1, $header_string_2, $header_string_3));
    curl_setopt($session, CURLOPT_POSTFIELDS, $postargs);
    curl_setopt($session, CURLOPT_HEADER, true);
    curl_setopt($session, CURLOPT_RETURNTRANSFER, true);
    // set to valir ssl.crt certification
    //curl_setopt($session, CURLOPT_CAINFO, "C:\\Program Files\\xampp\\apache\\conf\\ssl.crt\\ca-bundle.crt");

    // Do the POST and then close the session
    $response = curl_exec($session);
    if (curl_errno($session)) {
        echo (curl_error($session));
    } else {
        curl_close($session);
    }

    //fwrite($message_log, sprintf("\r\n%s\n",$response));
   
    // Get HTTP Status code from the response
    $status_code = array();
   
    echo "<xmp>";
    print_r($response);
    preg_match('/\d\d\d/', $response, $status_code);
   
    //fwrite($message_log, sprintf("\r\n%s\n",$status_code[0]));
   
   
    // Check for errors
    switch( $status_code[0] ) {
      case 200:
      // Success
        break;
      case 503:
        echo ('Error 503: Service unavailable. An internal problem prevented us from returning data to you.');
          break;
      case 403:
        echo ('Error 403: Forbidden. You do not have permission to access this resource, or are over your rate limit.');
        break;
      case 400:
        echo ('Error 400: Bad request. The parameters passed to the service did not match as expected. The exact error is returned in the XML response.');
        break;
      default:
        echo ('Error :' . $status_code[0]);
    }
  }
 
?>

---

make sure to change the url to yours and set the correct merchant id/key.

in the $postargs variable put an XML with the request you want to emulate (there are plenty of examples in response_message.log),they can be merchant calculations, new order notifications, or any valid GC Request.

hope this helps to debug

ropu

Thanks Ropu! I can't wait to try the new version...

Woodymon - looks like you answered all your questions for me...

Quote:

---

Originally Posted by ropu

Hi all again,

regarding the setting at the integration section of googlecheckout page,
see readme
6. In the checkout.google.com/sell settings->integration, set Callback method: XML and "Allow shopping carts with name/value pairs to be sent to Google." is indistinct if is checked or not.

---

Hi Ropu,

Thanks for the 105 update!

Just to clarify, most of us were working with the previous 1.04 version. The above item was not referred to in the 1.04 readme, thus my post ;-)

Yes it is indeed in the NEW 1.05 readme which most of us were unaware was available until your announce post just hours ago. ;-)

BTW many of my previous aquestions were answered by your new release (which I just packaged up and beginning to test).

However do you have thoughts regards to softgoods/instant downloads support? Thanks again.

Woody

I have been happily testing GCO with no problem , thanks to all folks here. Suddenly today, clients complained that they were getting errors on submitting carts using GCO. Seems that suddenly the shipping data has become incorrect ... it seems that my ZC is sending

<shipping-methods>
<flat-rate-shipping name="Standard flat-rate shipping- Table Rate">
<price currency="USD"></price> <<<< $ value missing
<shipping-restrictions>
<allowed-areas>
<us-country-area country-area="ALL"></us-country-area>
</allowed-areas>
</shipping-restrictions>
</flat-rate-shipping>
</shipping-methods>

XML failed to validate against the schema at line: 26, column: 26, with error: cvc-datatype-valid.1.2.1: '' is not a valid value for 'decimal'.
XML failed to validate against the schema at line: 26, column: 26, with error: cvc-complex-type.2.2: Element 'price' must have no element [children], and the value must be valid.


while GCO is expecting a value for shipping
<price currency="USD">9.00</price>

can anyone suggest a) how to get ZC to include a value here, or b) suggest what setting I may have changed .. I have for shipping options table rate and UPS..

Enable Table Method: True
Shipping Table: 45:8,45.01:0
Table Method: price
Handling Fee: 0
Tax Class --none--
Tax Basis Shipping
Shipping Zone --none--
Sort Order 0

this used to work ..... help !!! (please)

Quote:

---

Originally Posted by ropu

Hi all, as anjordan77 suggested, the fix works, but with security issues. anyone can post you a order emulating Google checkout.

The fix is at version 1.0.5
http://google-checkout-zencart.googl...com/svn/trunk/

this week the contribution page will be updated

this are the update for version 1.0.5
11/28/2006 v1.0.5 (ropu)
- Add support for Merchant Calculated Shipping Rates.
- Fixed minor bugs in responsehandler.php and orders.php files
- Change the XML parser and builder
- Removed getallheader() function
- Fixed wrong Qty in Admin UI
- Fixed modules not saving their settings
- Fixed Notify Customer option
- Add state change, Risk and charge notification into the Admin UI
- Add support for coupons
- Fix Shopping cart not obtained from session. See TROUBLE SHOOTING.

ropu

---

Seems like this version broke my table shipping rates. 1.0.4 table rates worked fine, I tried the latest version in the repository and now my rates show up as "Table $0.00" when the user gets to Google...

I'm going to try going back to 1.0.4, but stick with the latest version of responsehandler.php and see where I get..

i loaded 1.0.5 .... this took care of the problem of getting past the error of invalid shipping methods ...but now we get

Error parsing XML; message from parser is: Error on line -1: Premature end of file.

and an xml output like this

<?xml version="1.0" encoding="UTF-8"?>
<merchant-calculation-callback xmlns="http://checkout.google.com/schema/2" serial-number="23412341234123412341234">
<shopping-cart>
<merchant-private-data>
<session-data>231412342234234123;zenid</session-data>
<product-data>;57</product-data>
<ip-address>xx.xx.xx.xx</ip-address>


</merchant-private-data>
<items>
<item>
<quantity>1</quantity>
<unit-price currency="USD">25.95</unit-price>
<item-name>6” Heat Resistant Cover</item-name>
<item-description></item-description>
<tax-table-selector>Taxable Goods</tax-table-selector>
</item>
</items>
</shopping-cart>
<buyer-id>xxxxxxxxxxxxxx</buyer-id>
<calculate>
<addresses>
<anonymous-address id="xxxxxxxxxxxxxxx">
<country-code>US</country-code>
<city>Atlanta</city>
<region>GA</region>
<postal-code>234234</postal-code>
</anonymous-address>
<anonymous-address id="xxxxxxxxxxxxxxxxxxx">
<country-code>US</country-code>
<city>Atlanta</city>
<region>GA</region>
<postal-code>234324</postal-code>
</anonymous-address>
</addresses>
<merchant-code-strings />
<tax>false</tax>
<shipping>
<method name="Table: Table Rate (vary by weight/price)" />
<method name="UPS: Next Day Air Early AM" />
<method name="UPS: Next Day Air Early AM Letter" />
<method name="UPS: Worldwide Expedited" />
</shipping>
</calculate>
<buyer-language>en_US</buyer-language>
</merchant-calculation-callback>

Any clues ? Much thanks

Quote:

---

Originally Posted by anjordan77

Install the table rates for shipping and that should work

---

What's a table rate?

Ok, I see what you mean by table rate. It's FLAT RATE shipping, which I do not want. It will not be the same shipping price as if you were useing Paypal, which is a BIG problem.

I have tried to install the google payment module and I have received this error. Does anyone know anything about how to solve this issue?

We encountered an error trying to access your server at https://www.jercocomputers.com -- 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 Warnings:

XML We Sent:<?xml version="1.0" encoding="UTF-8"?><order-state-change-notification xmlns="http://checkout.google.com/schema/2" serial-number="a9066db2-2995-4141-91e3-597df527a0d7"> <timestamp>2006-10-26T16:25:53.759Z</timestamp> <google-order-number>264229364221993</google-order-number> <new-fulfillment-order-state>PROCESSING</new-fulfillment-order-state> <new-financial-order-state>CHARGING</new-financial-order-state> <previous-fulfillment-order-state>NEW</previous-fulfillment-order-state> <previous-financial-order-state>REVIEWING</previous-financial-order-state></order-state-change-notification>

ok everything was working fine, but now when i try to checkout with google it gives me this error.

<error serial-number="c21664a6-1d98-47ac-802c-e91c0e799d81">
<error-message>No seller found with id 121418258075668</error-message>
</error>

is this a problem on google's side or mine?

you can check it out at www.airinfantry.com/catalog

I tried v1.0.5.

Many problems, starting with shipping choices. Had a full string of mailing options from USPS. I only offer a couple... There was a textbox pre-filled with a zero for each option. No explanation in README or INSTALLATION about what this all means or how to decide what entries to make.

Had a large label with Multi-zone, multi-table description (which is the method I prefer) but no way to select it. Also had Table shipping option configured and activated but no way to select it in GCO setup.

Tried test customer. Got error message in checkout screen about invalid parameter in foreach function in gcheckout.php. Could still use GCO button, but shipping options in Google screen each showed $14.70 when at least media mail (which wasn't an option) should only be $2.50.

Had to roll back all files except responsehandler.php, xmlparser.php and xmlbuilder.php to 1.0.4 versions. Reselected Table shipping option. Was successful in sending order through sandbox.

The merchant-defined shipping is a great concept and I wish it worked...

Thanks for those posting experiences with v.105. I will await implementing GCO for ZC mod into production until better news is posted in regards to Zen Cart shipping tables support and instant downloads support. But I will continue testing.

Below is a helpful resource for general GCO info:
http://groups.google.com/group/googl...erchants-forum

Woody

Quote:

---

Originally Posted by Woodymon

Thanks for those posting experiences with v.105. I will await implementing GCO for ZC mod into production until better news is posted in regards to Zen Cart shipping tables support and instant downloads support. But I will continue testing.

Woody

---

On the other hand - I got a sale from the v1.0.4 install the same day I deployed it into production...!

Quote:

---

Originally Posted by chain_man

On the other hand - I got a sale from the v1.0.4 install the same day I deployed it into production...!

---

My issue with 1.04 is GCO would not work correctly without applying the fix (commenting out the code) as krypton1 posted.

However ropu previously reported in this thread:

Quote:

---

as anjordan77 suggested, the fix works, but with security issues. anyone can post you a order emulating Google checkout.

---

So are you using v.1.04 with or without the krypton1 "fix"? And if you applied the "fix" then are you ok with security issue as suggested by ropu?

Woody

Quote:

---

Originally Posted by chain_man

Had to roll back all files except responsehandler.php, xmlparser.php and xmlbuilder.php to 1.0.4 versions. Reselected Table shipping option. Was successful in sending order through sandbox.

---

Quote:

---

Originally Posted by Woodymon

So are you using v.1.04 with or without the krypton1 "fix"? And if you applied the "fix" then are you ok with security issue as suggested by ropu?

---

Chain_man stated above he is using responsehandler.php from v.1.05, replacing the patched 1.04 file. So I assume this fixes security issues?

Thus I configured the install as chain_man suggests (using v.1.04 except for the three files from v.1.05). And I found the order was processed and and two email messages sent to customer (Order receipt and Purchase receipt) and email sent to store-owner (purchase receipt) were delivered.

However order did not show up in Zen Cart admin.

Then I observed v. 105 contains two new files in /googlecheckout :
- googleresult.php
- googlemerchantcalculations.php

So I uploaded those files also.

And submitted a new order. Order processed successfully, email messages delivered to customer and store-owner AND order with product details displayed in admin.

Follows is the order status table on order page in Zen Cart admin.

Quote:

---

Date Added Customer Notified Status Comments

12/12/2006 14:52:27 True Pending
Google Checkout Order No: ###############
Merachnat Calculations:

12/12/2006 14:52:30 False Pending
Risk Information:
Elegible for Protection: true
Avs Response: U
Cvn Response: U
Partial CC number: 1111
Buyer account age: 1

12/12/2006 14:52:50 False Processing
Time: 2006-12-12T02:18:49.635Z
New state: CHARGED

12/12/2006 14:52:50 False Processing
Latest charge amount: USD 25.0
Total charge amount: USD 25.0

12/12/2006 14:59:34 True Delivered
Testing 1,2,3... My Comments here

12/12/2006 14:59:34 True Delivered
Time: 2006-12-14T02:23:34.291Z
New state: DELIVERED

---

Not sure about the blank entry for "Merachnat Calculations: " (sic). I selected Table Rate for shipping in both the GCO mod configuration and on Google Accounts admin website.

(I have not tested ordering products with attributes since the only need I have per attributes is supporting instant downloads, which GCO does not).

My wishlist:

1. "zone" based table-rate shipping support;
2. instant download support.

Woody

Quote:

---

Originally Posted by Woodymon

Chain_man stated above he is using responsehandler.php from v.1.05, replacing the patched 1.04 file. So I assume this fixes security issues?

---

Not an expert opinion but it appears that issue is repaired in v.1.05.

Also in v.1.05 responsehandler.php an edit on line 715 is needed ;-)

Change 'Merachnat Calculations: '
to
'Merchant Calculations: '

I note major changes were implemented in v.1.05 responsehandler.php , yet the file id line in file header still shows:
"* File ID: responsehandler.php 10/14/2006 11:00 colosports"
which is the same time/date stamps shown in v1.04 version.

To Google developers (ropu, etc):

We all appreciate your efforts and understand this is still beta and that you may be somewhat new to zen cart magick... But please, when updating/editing mode files please do update the date/timestamp, version number and developer name in the file id line (in file header). And please inicate in the readme for the new version (within changelog) which files were changed, which files are new, and which have been removed since the previous mod version/distribution, etc.

This will make it much easier for us beta testers to test and update. Thanks.

Hint: Zone based table rate shipping & instant download support ;-)

P.S. Any plans for eCheck support in Google Checkout?

Time for me to roll this puppy out and see how well it works in the real world.

Thanks again,
Woody

Quote:

---

Originally Posted by Woodymon

Not an expert opinion but it appears that issue is repaired in v.1.05.

Also in v.1.05 responsehandler.php an edit on line 715 is needed ;-)

Change 'Merachnat Calculations: '
to
'Merchant Calculations: '

I note major changes were implemented in v.1.05 responsehandler.php , yet the file id line in file header still shows:
"* File ID: responsehandler.php 10/14/2006 11:00 colosports"
which is the same time/date stamps shown in v1.04 version.

To Google developers (ropu, etc):

We all appreciate your efforts and understand this is still beta and that you may be somewhat new to zen cart magick... But please, when updating/editing mode files please do update the date/timestamp, version number and developer name in the file id line (in file header). And please inicate in the readme for the new version (within changelog) which files were changed, which files are new, and which have been removed since the previous mod version/distribution, etc.

This will make it much easier for us beta testers to test and update. Thanks.

Hint: Zone based table rate shipping & instant download support ;-)

P.S. Any plans for eCheck support in Google Checkout?

Time for me to roll this puppy out and see how well it works in the real world.

Thanks again,
Woody

---

Woody, thanks for the advise on the version matter. ill take note on it, and change it for any new version

please know that version 1.0.5 is a prerelase for testing. im being really busy this weeks. im looking at the bugs all of you reported and try to fix ir as soon as possible.

regarding softgoods, is not in the agenda right now, i must have a look, but there are other important issues to solve before adding a new functionality.

ropu

Quote:

---

Originally Posted by regenbauma

I have been happily testing GCO with no problem , thanks to all folks here. Suddenly today, clients complained that they were getting errors on submitting carts using GCO. Seems that suddenly the shipping data has become incorrect ... it seems that my ZC is sending

<shipping-methods>
<flat-rate-shipping name="Standard flat-rate shipping- Table Rate">
<price currency="USD"></price> <<<< $ value missing
<shipping-restrictions>
<allowed-areas>
<us-country-area country-area="ALL"></us-country-area>
</allowed-areas>
</shipping-restrictions>
</flat-rate-shipping>
</shipping-methods>

XML failed to validate against the schema at line: 26, column: 26, with error: cvc-datatype-valid.1.2.1: '' is not a valid value for 'decimal'.
XML failed to validate against the schema at line: 26, column: 26, with error: cvc-complex-type.2.2: Element 'price' must have no element [children], and the value must be valid.


while GCO is expecting a value for shipping
<price currency="USD">9.00</price>

can anyone suggest a) how to get ZC to include a value here, or b) suggest what setting I may have changed .. I have for shipping options table rate and UPS..

Enable Table Method: True
Shipping Table: 45:8,45.01:0
Table Method: price
Handling Fee: 0
Tax Class --none--
Tax Basis Shipping
Shipping Zone --none--
Sort Order 0

this used to work ..... help !!! (please)

---

try this, change in googlecheckout/gcheckout.php line ~335

PHP Code:

---

            else {
               $price = $googlepayment->getShippingPrice($module_name, $cart, $quote['methods'][0]['cost'], $handling, $table_mode);
                $gcheck->element('price', $price, array ('currency' => 'USD'));
            } 


---

with

PHP Code:

---

            else {
                $module = new $module_name;
                $quote = $module->quote($method);
                $price = $quote['methods'][0]['cost'];
                $gcheck->element('price', $price, array ('currency' => 'USD'));
            } 


---

im working on this to support any shipping module with just declarating it at googleckeckout class.

ill post here when any new update is uploaded in the SVN

ropu

Quote:

---

Originally Posted by Woodymon

To Google developers (ropu, etc):

We all appreciate your efforts

---

I second this wholeheartedly!

Quote:

---

Originally Posted by ropu

Woody, thanks for the advise on the version matter. ill take note on it, and change it for any new version

please know that version 1.0.5 is a prerelase for testing. im being really busy this weeks. im looking at the bugs all of you reported and try to fix ir as soon as possible.

regarding softgoods, is not in the agenda right now, i must have a look, but there are other important issues to solve before adding a new functionality.

ropu

---

change log from ver 1.0.4 to 1.0.5
files changed
/admin/orders.php
/admin/includes/functions/extra_functions/added_function_for_google_checkout.php
/googlecheckout/gcheckout.php
/googlecheckout/responsehandler.php
/googlecheckout/xmlbuilder.php
/googlecheckout/xmlparser.php
/includes/modules/payment/googlecheckout.php

files added
/googlecheckout/googleresult.php
/googlecheckout/googlemerchantcalculations.php



ropu

Quote:

---

Originally Posted by ropu

change log from ver 1.0.4 to 1.0.5

---

Ropu,

Thanks for providing this helpful changelog info!

Another question:

Noting that the mod will not be supporting instant downloads anytime soon, can anyone suggest techniques on how to filter out certain products (e.g. downloadables) so they cannot be purchased with GCO. I can post "warning" notes throughout the site and on productInfo and product_listing pages, but I'm hoping for something a bit more elegant.

When adding items to the shopping cart, maybe a compare can be done on the product database and if any product just added to the shopping cart has a specific "download" attribute option applied to it, the functions which controls the GCO button (makes it color/hot) not enable the button?

Or if this is inefficient can I manually maintain a list of "banned" product ID's (downloadable products) and/or Attribute ID's which can be screened against when customers add items to their shop cart? (We don't have many products so maintaining such a list manually not be a burden).

And when adding an item to the shopping cart maybe display a warning banner or flag of some sort reporting: "one or more products just added to your shopping cart is not available for purchase via Google Checkout, but is available through standard Zen Cart Checkout" or something to this effect.

I know these are some clunky ideas but half our products are books and the other half are downloads (eBooks/eDocs) and we really would like to utilize Google Checkout (for non-profit health information/education website).

Any and all ideas appreciated.

We do not currently utilize coupons or gift vouchers so can wait on the GCO mod supporting that functionality. But I'm likely not likely in the majority on this ;-)

Woody

Quote:

---

Originally Posted by Woodymon

Noting that the mod will not be supporting instant downloads anytime soon, can anyone suggest techniques on how to filter out certain products (e.g. downloadables) so they cannot be purchased with GCO. I can post "warning" notes throughout the site and on productInfo and product_listing pages, but I'm hoping for something a bit more elegant.

---

You'll need something like this:

Code:

---

    if ($_SESSION['cart']->content_type == 'virtual') .... blah blah blah ...

---

... during checkout, if this is found to be 'virtual', it indicates that everything in the cart is not defined as a physical product. eg. only contains GV's or downloads or other virtual items.

I just got another sale through GoogleCheckOut. That's 2 in the 3 days that I've had it installed.

The significance of this is that I have not been getting sales that frequently even though I offer merchant card payments and PayPal.

I think that means that GCO is stepping in where the planned-but not-yet-built ability for customers to buy without creating accounts directly in our zen carts would have been. These customers are going directly to GCO from their shopping carts, while they are still in Guest mode. The fact that they can (and do) complete their transactions while a Guest is a great boon to us.

I finally got the GoogleCheckout v1.05 module working properly on a (relatively) fresh install of Zen Cart v1.3.6. I thought I'd share a couple problems that came up (and solutions that worked for me) in case someone else encountered the same issues:

Problem #1: USPS calculated shipping was always returning the lowest value in Google Checkout, regardless of the weight of the items in the shopping cart. For example, Priority Mail would always show $4.05 (my default value set for Priority Mail in the ZC GC Payment GUI was $8.10 so I knew it was using a calculated value, and not the default).

Solution #1: I added $total_weight to the list of global variables on line 353 in googlecheckout/responsehandler.php. I also added $total_count to the same line, however it didn't seem to affect the shipping cost calculations (although I left it in there anyway).

Problem #2: Anything that is shipped within my same state needs to have the shipping taxed. When I set the USPS shipping module to add tax, the Google Checkout button would become disabled. In the README it stated that "if the shipping tax rates differ, a disabled Checkout button will appear on the Checkout page", which is exactly what was happening (but didn't tell me where I had to change it).

Solution #2: I updated the 2 hard-coded values in googlecheckout/responsehandler.php, lines 449 and 463, to the tax rate I had set up in the ZC Admin GUI.

Thanks to everyone that's been working on this module! Great job!

Shawn

I'm thinking lots of customers are using this GCO because it's in perty colors and available right after they click on their last product that they added to their cart. I received one order the past however many days that had the persons contact info and also their phone number. This order went through with no glitches and had sizes and colors specified. I'm thinking this person logged into my website and decided to use google checkout instead of going thru the zen-cart checkout procedure.

Is there a way to make customers log into zen before they can checkout with GCO?

If so, this would save me about 15-20 reverse lookups, and anything i can on the internet to find a way to contact the person.

Quote:

---

Originally Posted by anjordan77

I'm thinking lots of customers are using this GCO because it's in perty colors and available right after they click on their last product that they added to their cart. I received one order the past however many days that had the persons contact info and also their phone number. This order went through with no glitches and had sizes and colors specified. I'm thinking this person logged into my website and decided to use google checkout instead of going thru the zen-cart checkout procedure.

Is there a way to make customers log into zen before they can checkout with GCO?

If so, this would save me about 15-20 reverse lookups, and anything i can on the internet to find a way to contact the person.

---

No.. that would be against TOS from my understanding. GC is supposed to be an "express checkout" method.. having to have a user register/login breaks the express part :P

well what works works, what doesn't doesn't...if googz would hurry up and go cha chunk and fix this bad boy we'd all be some happy customers.

What's the link for the newest version?

I can't seem to find it through all the pages...
####################__

I ran a test through with GCO with a Gift Certificate and the order didn't show up in the Admin or GC Queue.

Quote:

---

Originally Posted by TripleMoons

What's the link for the newest version?

I can't seem to find it through all the pages...

---

It appears ropu has yet to submit 1.05 version or yet to be approved for listing on Zen Cart downloads area (1.04 is still listed as latest version). Ropu posted the svn link in a thread post several days ago which contains the individual 1.05 files. Note that you have to "package" it up yourself. If you are not sure how to do this best to wait for listing update in downloads area.

BTW there is a change, between version 1.04 and 1.05, at the very end of the replacement code in /admin/orders.php. If you are upgrading from previous version it is easy to miss. (see 1.05 readme for the full code snippet).

Code:

---

  }
          }
        }
 google_checkout_state_change($check_status, $status, $oID, $customer_notified, $notify_comments);
// ** END GOOGLE CHECKOUT *

---

Woody

Found downloaded & installed...Thank you...

BUT...

Admin's still not working...I even tried commenting out that code from a few pages ago.

I'm assuming this patch by colosports (from post #223 of this thread) is no longer recommended as GCO cannot (or rather should not) be integrated into the regular Zen Cart checkout process?

Or can this patch still be useful?

Quote:

---

Originally Posted by colosports

If a customer tries to select Google Checkout as payment from the Step 2 - Payment Page, it will act like they were paying by check.

To fix this, you have to edit templates\tpl_checkout_confirmation_default.php page:

---

Woody

Ok, whatever's in the newest version doesn't allow me to use Google Checkout any longer. So I downloaded the approved version from here.

How do I get the admin to work properly?

And what is the XML that everyone is talking about? I can not locate that on Google or my Admin.

Quote:

---

Originally Posted by TripleMoons

Admin's still not working...I even tried commenting out that code from a few pages ago.

---

@Triplemoons: When you say it's "not working" can you be more specific?

Are you receiving any customer and/or admin email messages from Zen Cart when the order is submitted?

Are you testing the 1.05 mod with the sandbox account? And in your Google Sandbox account did you set your:

1. API callback URL
2. Callback method: XML

Did you try ropu's posted code to help test/debug the response handler?

Note Chain_mans recent post stating that he only did a partial update to 1.05 (continues to use some 1.04 files). I followed his advice successfully (Zen Cart 1.36).

Woody

Quote:

---

Originally Posted by Woodymon

@Triplemoons: When you say it's "not working" can you be more specific?

---

It will not allow you to use Google at all in the shopping cart.

Quote:

---

Originally Posted by Woodymon

Are you receiving any customer and/or admin email messages from Zen Cart when the order is submitted?

---

No admin. That is the problem. I removed 1.05, it's gone. I'm just going to work with the approved version until all of this is fixed. I don't have time to keep going back and changing code.

Quote:

---

Originally Posted by Woodymon

Are you testing the 1.05 mod with the sandbox account?

---

Sandbox account does not work.

Quote:

---

Originally Posted by Woodymon

And in your Google Sandbox account did you set your:

1. API callback URL
2. Callback method: XML

---

I do not have those options. I do not know what a callback URL is.

Quote:

---

Originally Posted by Woodymon

Did you try ropu's posted code to help test/debug the response handler?

---

This thread it's impossible to find anything. It's all mixed up with people going back and forth between different things. So my short anwer is no.

:D

Quote:

---

Originally Posted by TripleMoons

It will not allow you to use Google at all in the shopping cart.
No admin. That is the problem. I removed 1.05, it's gone. I'm just going to work with the approved version until all of this is fixed. I don't have time to keep going back and changing code. Sandbox account does not work. I do not have those options. I do not know what a callback URL is. This thread it's impossible to find anything. It's all mixed up with people going back and forth between different things. So my short anwer is no.

---

Many of your questions are answered in the readme and installation docs. Please reread. (I had to read several times myself).

You need to successfully setup a sandbox account with Google. Please don't proceed any further until you do. Then when testing via the sandbox account you should be receiving email messages from Google (as customer and storeowner) when the order is submitted and the orders should show up in your Google Checkout sandbox account. Once you confirm that is the case then you can proceed troubleshooting your issue of the orders not appearing in Zen Cart admin.

The XML should appear in your google checkout log files you created in /googlecheckout. Is there any info in the error log which may assist?

You did not respond to the question if you tried the responsehandler debug code provided by ropu.

Note this mod is till in "beta' and not ready for those who just want a plug and play solution and who do not want to research the issues. This thread is mainly for providing continued testing feedback and suggestions. If you don't have the time to try out different things then it is agreed that you wait for a packaged up non-beta release.

BTW my testing has not utilized any of the coupon or voucher features or taxes or calculated shipping.

Woody

Thought I would inquire here before contact Google Support.

Anyone else observing issues with the GCO button not being displayed and timing out when connecting to sandbox.google.com, from shopping cart or login page in Zen Cart? Issue just started a couple hours ago and I have not made any changes to system. Previously GCO sandbox was working well. Observing on two different PC's on different networks in both FF2 and IE6.

I logged in to my sandbox account on Google and everything appears in order.

SSL certificate appears to be working well and normal Zen Cart checkout functionality is fine.

I visited http://groups.google.com/group/googl...elopers-forum? but did not find anything applicable.

I do not know the URL where Google reports current GCO server/system status.

Woody

Quote:

---

Originally Posted by Woodymon

Anyone else observing issues with the GCO button not being displayed and timing out when connecting to sandbox.google.com, from shopping cart or login page in Zen Cart? Issue just started a couple hours ago and I have not made any changes to system.

---

OK now the text link "Checkout" renders where the GCO checkout button should render. At least now the link is hot to sandbox.google.com and is connecting properly so can checkout.

Just the graphic image of the button is not rendering now.

Me thinks Google is currently doing some "maintentance" work, which could not be tested out on development servers ;-)

But after all it's a sandbox and we're all having fun playing the guessing game are we not?... is it the mod, is it the mod configuration, is it Zen Cart, is it my webhost, is it my Google Checkout account configuration, is it Google Checkout server, is it my network provider, is it the internet, is it me, is it too much fun, is it not enuff sleep, ...

Woody

Woody -

It could very well be the Sandbox. I have my module pointing to production and a nice sale came through there today.

Quote:

---

Originally Posted by chain_man

It could very well be the Sandbox. I have my module pointing to production and a nice sale came through there today.

---

Thanks for the report. Another beta tester also PM'd me to report he is also observing same issue with sandbox. So it must be a Google issue. Maybe Google purposely disabled displaying the garphic icon for sandbox testers? Not a big deal as the sandbox still works. But would be cool if Google could make available a status page, including announcing (pre-announce) functionality changes, so we "beta testers" don't unnecessarily invest time troubleshooting. And that would limit my posting to this thread ;-)

Woody

Quote:

---

Originally Posted by Woodymon

You did not respond to the question if you tried the responsehandler debug code provided by ropu.

---

Yes, I did. See below.

Quote:

---

Originally Posted by TripleMoons

This thread it's impossible to find anything. It's all mixed up with people going back and forth between different things. So my short anwer is no.

---

It would be helpful if the "approved" Mod for this was updated with whatever it is that is wrong with it that causes the Admin to not work properly.

I ran the /googlecheckout/responsehandler.php on my site & I do get an error:

Code:

---

Fatal error: Call to undefined function: getallheaders() in /home/www/keystoneexoticssupply.com/shoponline/googlecheckout/responsehandler.php on line 112

---

But that section I had commented out & I'm not sure why it's giving me an error.

The sandbox GCO button is now working again, and sandbox.google.com in general is responding faster that it previously had been. I think Google must've just been having some issues.

And I get this from Sandbox:

Quote:

---

<error serial-number="4d14d924-6527-47fe-9bba-197dd6f20f8a">
<error-message>No seller found with id 233870035457987</error-message>
</error>

---

Quote:

---

Originally Posted by TripleMoons

I ran the /googlecheckout/responsehandler.php on my site & I do get an error:

Code:

---

Fatal error: Call to undefined function: getallheaders() in /home/www/keystoneexoticssupply.com/shoponline/googlecheckout/responsehandler.php on line 112

---

But that section I had commented out & I'm not sure why it's giving me an error.

---

The code generating that error was removed from v.1.05 (as mentioned by ropu recently in this thread).

Copy responsehandler.php from svn location at
http://google-checkout-zencart.googl...nsehandler.php

Then paste into text editor, and save as same file name (ensure no spaces before opening php tag and after closing php tag).

(Or right click on the filename listed http://google-checkout-zencart.googl...ooglecheckout/
and choose save as or save link as to save file to your hard drive).

Then upload to your /googlecheckout directory.

See if that helps.

Also do the same for xmlbuilder.php and xmlparser.php. Then try out other changed files also.

Woody

Quote:

---

Originally Posted by Woodymon

The code generating that error was removed from v.1.05 (as mentioned by ropu recently in this thread).

Copy responsehandler.php from svn location at
http://google-checkout-zencart.googl...nsehandler.php

Then paste into text editor, and save as same file name (ensure no spaces before opening php tag and after closing php tag).

(Or right click on the filename listed http://google-checkout-zencart.googl...ooglecheckout/
and choose save as or save link as to save file to your hard drive).

Then upload to your /googlecheckout directory.

See if that helps.

Also do the same for xmlbuilder.php and xmlparser.php. Then try out other changed files also.

Woody

---

Awesome, worked like a charm. :flex:

Any ideas about the error from Sandbox? The information IS correct.

I just noticed something else...The API callback thing required an https:// but when I put that in front of my URL, it bounces to the Admin login for a hosting server. Why is it doing that, and would that affect the items not showing up in the Zen Admin?