Google Checkout module for ZC 1.3.x (beta)

[Woodymon]

Hi ropu-

This question relates to a workaround to the current lack support for instant downloads. Regards to the script you provided to test if a product is a virtual product, and if it is then print a warning message on the product description page.

I can see your code works fine on the login and shopping cart pages. That is, when a non-physical product is added to the shopping cart, then a message "Some download products in your cart are currently not available via Google Checkout" displays below the disabled Google Checkout button.

Have you had an opportunity to test the code you provided on tpl_product_info_display.php?

Unfortunately I cannot get it to work. It appears the script is tied to the contents of the shopping cart session? (e.g. ['cart']) which does not apply to what I'm attempting to do. I've attempted to adapt your code for my described purpose but so far have been unsuccessful.

Here again is what I'm trying to do:
1. View product_info_display page for a specific product.
2. Display a warning message if product is a download product.

I see three files are of concern here:
1. a template file (tpl_product_info_display.php) which calls an include;
2. an include which first loads application_top;
3. a class file with a function;

And the 'products' table contains two relevant columns: 'products_id' and 'products_virtual'

So I created my own includes and class files below. But I'm havnig some issues as described below. Could you please take a look to see if the ideas should work.

The function gets the value of 'products_virtual' for a specific 'products_id'. If it contains a "1" then "virtual" should be returned. Otherwise return "physical".

I think my problem is passing the 'products_id' (for the product description page which is currently displayed) from the template file to the includes file and to the class/function. And then how do I return the value evaluated by the class/function file back to the includes and template files?

1. Template: /includes/templates/MY_TEMPLATE/templates/tpl_product_info_display.php
Insert this code snippet somewhere:

<?php
include('download_type_include_for_gc.php');

$download_type = $_GET['products_id']->get_download_type(); 

if ( MODULE_PAYMENT_GOOGLECHECKOUT_VIRTUAL_GOODS == 'True' && $download_type != 'physical' ) {
    echo '<p class="productGeneral">This download product is currently not available via Google Checkout. However it is available through regular shopping cart checkout.</p><br />';
      }
?>

2. Includes: file /download_type_include_for_gc.php

<?php
/*
 * download_type_include_for_gc.php
 * to display download_type on product description pages for Google Checkout
 *
 */

include_once('includes/application_top.php');
//print_r($_GET['products_id']->get_download_type());

?>

3. Class/function: /includes/classes/get_download_type.php

<?php
/**
 * get_download_type.php class
 */

class get_download_type {

    function get_download_type() {
        global $db;
    
        $download_check = $db->Execute("select products_virtual 
                    from " . TABLE_PRODUCTS . " 
                    where products_id = '" . zen_get_prid($products_id) . "'");
    
        if ($download_check->fields['products_virtual'] == '1') {
            $this->download_type = 'virtual';
                } else {
            $this->download_type = 'physical';
            } 
    
        return $this->download_type;
    }
}
?>

However the product description page stops rendering when arriving at the template snippet code above.
Error in error log is:

[error] [error] PHP Fatal error: Call to a member function get_download_type() on a non-object in /home/MY_ACCOUNT/public_html/MY_SHOP/includes/templates/MY_TEMPLATE/templates/tpl_product_info_display.php on line 134

What to I do to make it "unknown"? Do I have to register the class file or something special? Or do I put the class file in a special directory?

Or is there something wrng with this:

$_GET['products_id']->get_download_type() 

Am I getting close or am I completely off on a wrong roller coaster track?

Thanks for any pointers,
Woody

[ropu]

thanks for such a quick reply - I spent several hours going thru the install and the forums trying to find out what was going on.

I think all mods need a thorough description in the read me - something I'll remember when I get time to package mine!

Hi delia

here is the introduction of the module in the README

INTRODUCTION
============
The Google Checkout module for Zen Cart adds Google Checkout as a Checkout
Module within Zen Cart.
This will allow merchants using Zen Cart to offer Google Checkout as an
alternate checkout method.

Please send me some feedback about how to improve it, as a coder sometimes i assume things that merchants dont know.

thx in advance,

ropu

[ropu]

Ropu,

I am still getting this error when I use you tool to test responsehandler but I do not get the same error when I enter the url directly on our site for responsehandler.php

SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:func(144):reason(134)

Please use the HTTP address of ur site and NOT the HTTPS

ropu

[delia]

first change alternate to alternative (picky, I know but it's better).

Next line, then specify what you mean:

"The mod places a button on the login page and in the cart so that the customer can bypass the rest of the zencart checkout and use google checkout instead. Googlecheckout will be listed on the payments page but there is no way to use it then if one goes through the entire checkout procedure."

I know that probably most folks wanting to install this will have more knowledge of googlecheckout than I. I was hired to install the mod into someone's cart and kept thinking I didn't have it installed right or it was missing something since there was no way on the payments page to select it. My customer was wanting it to be the only way to checkout of the cart.

Now I can certainly change a zencart so that the customer can't go thru the rest of the checkout but it was an unpleasant surprise and a massive waste of time. Should I have researched it first? Sure - but this forum thread is just way too long and I couldn't fine any answer to my question anywhere. I think it's time to start a new thread or several threads from this one!

Thanks for all the work, by the way!

[ropu]

Hi ropu-

Finally had an opportunity to test your new 1.3RC2 version. Below are some questions, comments and requests for the wishlist.

1. Shipping config is funny. For instance when purchasing a regular book the "review and place order" page listed two options in the Shipping & Handling dropdown:

"S&H Free Shipping (USA) ($0.00)"
"S&H (USA): USPS Media Mail ($5.00)"

I employ free shipping only on few items but not the item I was ordering. Why does the Free Shipper appear in the drop down for products which are not set for free shipping?

Here are my two arrays in /includes/modules/payment/googlecheckout.php

$this->mc_shipping_methods = array(
                        'freeshipper' => array(
                                    'domestic_types' =>
                                      array(
                                          'freeshipper' => 'Free Shipping (USA)'
                                           ),

                                    'international_types' =>
                                      array(
                                          'freeshipper' => 'Free Shipping (Intl)'
                                           ),
                                        ),
                        'itemnational' => array(
                                    'domestic_types' =>
                                      array(
                                          'itemnational' => 'USPS Media Mail',

                                           ),

                                    'international_types' =>
                                      array(

                                           ),
                                        ),
                        'iteminternational' => array(
                                    'domestic_types' =>
                                      array(

                                           ),

                                    'international_types' =>
                                      array(
                                          'iteminternational' => 'USPS Air Mail',

                                           ),
                                        ),
                                  );

    $this->mc_shipping_methods_names = array(    
                                         'freeshipper' => 'S&H',
                                         'itemnational' => 'S&H (USA)',
                                         'iteminternational' => 'S&H (Intl)',
                                        );

2. Can Google please make the shipping drop down wider (display more characters). The second shipping option above is cut off.

3. Can something be done to delay the display of the "Place your order now" button, at least until the shipping dropdown menu and the pay with and ship to info is fully displayed and the grand total is updated to include shipping.

This is a serious flaw. The wait between the order button rendering and the shipping drop down and other ship info appearing can be fifteen seconds and more. I suspect many customers will be clicking the order BUTTON before they should be (before shipping is added to the total) and will be confused. I know I would be (or I am).

Better yet if a "Still Loading..." could be displayed until the ship info is updated. Then display the Order button.

4. In the payment module configuration I changed the URL for the page to return to after checkout, to be the shop home page URL. However after clicking the place order button I still see Google's "Thanks yourname you're done" page. And the "Return to" link still points to the shopping cart page. Am I missing something?

OK I see now, rather than entering a proper URL, I changed the entry to "index" and the link then pointed to the shop home page. Stating "URL" in the instructions is not really correct but I understand it's difficult to come up with the correct term... maybe just provide a couple examples, e.g. for shop home page = index).

Relatedly, be sure to state in the readme that the return page cannot be the Zen Cart checkout_success page or any other Zen Cart page that requires you to be logged in.

5. How about dynamically creating and displaying a secure special one-time only "google_checkout_success" page which would display when customer is returned from Google Checkout server back to the Zen Cart shop. Include on that page the Google Checkout order details, the Zen Cart order number and the Zen Cart password (which the Google Checkout mod created for the customer), and include a link to "My Account" (similar to what is displayed on Zen Cart Checkout success page). And include on the page a define where shop-owner could include custom text (e.g. further instructions, etc) to the shops customers. Maybe call the page "google-checkout_success".

6. It would be good if customer could include some "comments" within the order 9directed to shop-owner), then display the comments in the order confirmation emails and in the zen cart admin orders page.

7. How about the option of placing a small shop-owner logo on the Google checkout "review and place order" page along with Google Checkout logo.

Thank you for the mod update and your assistance,
Woody

Woody
hi

im forwarding this post too google

Thx again for ur suggestions.

please also note this page. Is intended to work as a features suggestion

http://groups.google.com/group/googl...oogle-checkout
ropu

[ropu]

Can you please post how and what you did? Thanks!

Have a look to the README for the state change mapping

View your Google Checkout customers and their orders in the Reports tab.
For each order, the default starting state is PENDING.
The state changes to PROCESSING and DELIVERED as follows; corresponding
messages will be sent out to the Checkout server for order processing.

| Original State | New State | Action | Customer Notification |
| PENDING | PROCESSING | charging the order | Processing order message |
| PROCESSING | DELIVERED | marking the order for delivery | Shipped order message |

You can add a Tracking Number in the state change from PROCESSING to DELIVERED.
A text field and a combo with the shipping providers will be show when the order
is in the PROCESSING state.

Any comments added during state change will be sent to the buyer account page
if you have selected the Append Comments option.

ropu

[ropu]

If I complete a transaction through my sandbox account should it come back to my zencart database as an order?

yes i does...

I have answered my question above, after logging into the sandbox account I'm getting the following integration issue

" We encountered an error trying to access your server at https://www.(MYSERVER).com/shop/googlecheckout/responsehandler.php; the error we got is: Sending failed with HTTP response code: 503. Response body was: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>ERROR: The requested URL could not be retrieved</TITLE> <STYLE type="text/css"><!--BODY{background-color:#ffffff;font-family:verdana,sans-serif}PRE{font-family:sans-serif}--></STYLE> </HEAD><BODY> <H1>ERROR</H1> <H2>The requested URL could not be retrieved</H2> <HR noshade size="1px"> <P> While trying to retrieve the URL: <A HREF="www.(MYSERVER).com:443">www.(MYSERVER).com:443</A> <P> The following error was encountered: <UL> <LI> <STRONG> Connection Failed </STRONG> </UL> <P> The system returned: <PRE><I> (110) Connection timed out</I></PRE> <P> The remote host or network may be down. Please try the request again. <P>Your cache administrator is <A HREF="mailto:admin">admin</A>. <BR clear="all"> <HR noshade size="1px"> <ADDRESS> Generated Thu, 19 Apr 2007 23:13:36 GMT by proxy.google.com (squid) </ADDRESS> </BODY></HTML> Warnings:

double check that the Merchant Callback URL in the integration section is correct

ropu

[ropu]

i didnt use the response handler script but i run phpinfo()
and what i got from GATEWAY INTERFACE is CGI/1.1

is that means my php is configured as CGI?
but i did configure it as apache module, as in httpd file
i set them as below
LoadModule php5_module "C:\\Program Files\\PHP\\php5apache2_2.dll"
AddType application/x-httpd-php .php
AddType application/x-httpd-php .php3
AddType application/x-httpd-php .php4

im using latest google checkout and zen-cart and got the same error as eva in the responsehandler error file,
HTTP Basic Authentication failed. Can't retrive Merchant Id/Key, Installed over CGI??

I cant find how eva solved it.....sorry if the answer is already here in this thread.

U must enable the .htaccess feature in the Admin UI->modules->payment->google checkout, and then create the .htaccess files to protect the directory

ropu

[ropu]

I have installed the Google Checkout and had my bank account authorised, but the Google logo is greyed out and not accessible.

It says

"not available for these items"

Am I doing something wrong and will Google charge everything including delivery without additional setup

Regards

Richard

hi

double check this

* A disabled button is displayed in the following cases:
* 1. If merchant id or merchant key is not set
* 2. If there are multiple shipping options selected and they use different
* shipping tax tables or some dont use tax tables

ropu

[Woodymon]

Woody
hi

im forwarding this post too google

Thx again for ur suggestions.

please also note this page. Is intended to work as a features suggestion

http://groups.google.com/group/googl...oogle-checkout
ropu

ropu-

You completely forgot to respond to my #1 question in the post regarding free shipping showing up when it should not be.

If you are not able to help me resolve that issue then I cannot use the mod or Google Checkout.

Others have recently posted to this thread shipping and tax issues which have not yet been responded to!

Also regards to posting wishlist items to this thread vs posting on the Google support site it is difficult to presume if the issues I observe and features I recommend are specifically relevant to the mod or they apply to Google Checkout service in general. I guess your copying to the Google forum indicates that ALL the issues I have brought to your attention have nothing to do with the programming of the mod? That is difficult to comprehend.

I would think the Google Checkout Product managers should be checking out this thread for ideas and unresolved issues.

When you say "ur" do you mean "your" ?

Thanks for your soonest response,
Woody