Google Checkout module for ZC 1.3.x (beta)

[Woodymon]

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.

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

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:

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:

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?

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:

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

[ropu]

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

[ropu]

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

[Woodymon]

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

[ropu]

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

[ropu]

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

it emulates Google Checkout.

<?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

[chain_man]

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

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

[Woodymon]

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

[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)

[oeginc]

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..