Google Checkout module for ZC 1.3.x (beta)

Jefflam:

Hi all
please help me.
ZC137 + 2RC4rev1
server: blueshost.com + its shared SSL
multisocket: enabled
basic authen mode: enabled
error message from GC:We encountered an error trying to access your server at https://my curl/googlecheckout/responsehandler.php -- the error we got is: Sending failed with HTTP response code: 302. Response body was:

<?xml version="1.0" encoding="UTF-8"?> <merchant-calculation-callback xmlns="http://checkout.google.com/schema/2" serial-number="xxxxx"> <shopping-cart> <merchant-private-data>

<session-data>xxxxxxxxxxxxxxxxxxxxx;zenid</session-data>

<product-data>;7</product-data>

<ip-address>68.xxx.xxx.xxx</ip-address>

</merchant-private-data> <items> <item> <tax-table-selector>Taxable Goods</tax-table-selector> <quantity>1</quantity> <unit-price currency="USD">9.99</unit-price> <item-name>xxxxxxxxxxxxxxxxxxxxxxxxx</item-name> <item-description></item-description> <merchant-item-id>xxxxxx==</merchant-item-id> <merchant-private-item-data>xxxxxxxxxxxxxxxxxxxx</merchant-private-item-data> </item> </items> </shopping-cart> <buyer-id>xxxxxxx25262028</buyer-id> <buyer-language>en_US</buyer-language> <calculate> <addresses> <anonymous-address id="xxxxxx4325516"> <country-code>US</country-code> <city>xxxxxxx</city> <region>CA</region> <postal-code>xxxxx</postal-code> </anonymous-address> </addresses> <shipping> <method name="Table: Vary by Weight/Price" /> <method name="USPS: Express Mail" /> </shipping> <tax>false</tax> <merchant-code-strings /> </calculate> </merchant-calculation-callback> thanks jefflam

hi Jefflam

have you tested with responsehandler_test?

here is a new link for an online test

http://demo.globant.com/~brovagnati/tools -> responsehandler Test

try disabling multisocket...

try it and see how it goes...

ropu

eaglewu:

Hello: ropu

I try several versions of GC (from 1.03-1.2). I still met the problem I have before: that is, the order does not show up in zen cart admin. I think this problem has been reported several times before, but I didn't find the solution. BTW, my db has a prefix. When I check the db, two tables were created: google_orders and google_checkout, and the tables don't have a primary key. Should I delete this two tables and create two tables with my db prefix? If that is what should I do, then how? I know little about sql.

Thanks

eaglewu

hi eaglewu

first, there is no need to rename any table. gc table names are defined in the includes/modules/payment/googlecheckout.php class

second, what does the logs say? googlecheckout->settings->integration?

are u installed over CGI? enabled CGI feature?

try this, and tell us

ropu

ropu:

hi Jefflam

have you tested with responsehandler_test?

here is a new link for an online test

http://demo.globant.com/~brovagnati/tools -> responsehandler Test

try disabling multisocket...

try it and see how it goes...

ropu
Hi Ropu,
Thank you for your help.
Here is my test result:
XML We Sent:Authorization: Basic XXXXXX:XXXXXX
Content-Type: application/xml;charset=UTF-8
Accept: application/xml;charset=UTF-8
X-Origin-IP: xx.xxx.xxx.xxx
XML We Received:SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:func(144):reason(134)
Time to response: 0.77490711212158 segs
Ropu, Can you clarify my problem? Do I need to find a good SSL?

Jefflam

ropu:

hi eaglewu

first, there is no need to rename any table. gc table names are defined in the includes/modules/payment/googlecheckout.php class

second, what does the logs say? googlecheckout->settings->integration?

are u installed over CGI? enabled CGI feature?

try this, and tell us

ropu
logs: HTTP Basic Authentication failed.
Tue Nov 21 9:47:59 ART 2006:- Invalid

I followed all the steps of installation instruction. For the remaining questions. I have no idea.
Would you please tell me how to check it is installed over CGI and how to enable CGI. Do I must contact the hoster to do this?

Jefflam:

Hi Ropu,
Thank you for your help.
Here is my test result:
XML We Sent:Authorization: Basic XXXXXX:XXXXXX
Content-Type: application/xml;charset=UTF-8
Accept: application/xml;charset=UTF-8
X-Origin-IP: xx.xxx.xxx.xxx
XML We Received:SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:func(144):reason(134)
Time to response: 0.77490711212158 segs
Ropu, Can you clarify my problem? Do I need to find a good SSL?

Jefflam

Jefflam,

I don't know that this will solve your problem but if you're running an ecommerce site you really should spend $29 - $89 (depending on who you buy from) to get a private certificate. That will for sure get you a dedicated ip (even on shared hosting) as well as an https address that will not confuse your customer.

There is really no point using shared certificate these days if you're serious about your store.

ropu:

in file includes/modules/pages/login/header_php.php

add in line 11

this

zen_redirect('index.php?main_page=shopping_cart');

>  
> this will redirect from idex.php?main_page=login to index.php?main_page=shopping_cart automatically
>  
> ropu
 
 
Works like a charm. THANK YOU!!!

hi all

i've seen many merchant with the issue of no secure popup with Google Analytics feature enabled

this should fix it

replace in googlecheckout/gcheckout.php line 546

    if(!(MODULE_PAYMENT_GOOGLECHECKOUT_ANALYTICS == 'NONE')) {
      echo '<!-- Start Google analytics -->
                        <script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
                        </script>
                        <script type="text/javascript">
                        _uacct = "' . MODULE_PAYMENT_GOOGLECHECKOUT_ANALYTICS . '";
                        urchinTracker();
                        </script>
                        <script src="http://checkout.google.com/files/digital/urchin_post.js" type="text/javascript"></script>    
                        <!-- End Google analytics -->';
    }

with

    if(!(MODULE_PAYMENT_GOOGLECHECKOUT_ANALYTICS == 'NONE')) {
      echo '<!-- Start Google analytics -->
                        <script src="' . (($request_type == 'SSL') ? 'https://ssl.google-analytics.com/urchin.js' : 'http://www.google-analytics.com/urchin.js' ) . '" type="text/javascript">
                        </script>
                        <script type="text/javascript">
                        _uacct = "' . MODULE_PAYMENT_GOOGLECHECKOUT_ANALYTICS . '";
                        urchinTracker();
                        </script>
                        <script src="' . (($request_type == 'SSL') ? 'https' : 'http' ) . '://checkout.google.com/files/digital/urchin_post.js" type="text/javascript"></script>    
                        <!-- End Google analytics -->';
    }

ropu

Ropu,

This is the code that I am currently using to fire up Google Analytics which is not related to GoogleCheckout. This is currently in mind html_header.php:

<?php
// GOOGLE ANALYTICS
 if ($request_type == 'NONSSL') {
  $google_url = 'http://www.google-analytics.com/urchin.js';
 } else {
  $google_url = 'https://ssl.google-analytics.com/urchin.js';
 }
// END GOOGLE ANALYTICS
?>
<script src="<?php echo $google_url; ?>" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "DELETED";
urchinTracker();
</script>

Is this going to conflict with the code above that you suggested for Google Checkout? I am currently still using GCO1.4 so I haven't had to deal with this issue.

I have a second installation of Zen Cart in a subdirectory from my main site. I'm using this for certain customers as there will be extra products and different pricing.

Do I need a second GCO seller's account to process those sales? Since my second site is just a subdirectory off the main site, is there a way to just use the same account?

Ropu the Google Checkout demo @ http://demo.globant.com/~brovagnati/zen_demo1/ is a little bit of a dissapointment. It really doesn't show that USPS, FedEx or UPS works which I believe a lot us are interested in seeing in action that it actually works.

It would be great if you can configure your demo to reflect how merchants/retailers will actually use this mod.

Thanks!

BlessIsaacola:

It would be great if you can configure your demo to reflect how merchants/retailers will actually use this mod.

Agreed. On the demo I observe following S&H options

Shipping & Handling:

Flat rate: Flat rate Per Order (-)
Item: Flat Rate Per Item (-)
Store Pickup: Store Pickup (-)
Zones: Zones Rates (-)

I see no explanation or any "key" to help customer understand what these S&H options mean or the differences between each S&H option. Or maybe that is dependent on which shopper is selected?

I don't see how to select a specific shipping provider.

When I click the "Calculating tax and shipping" button I observe no response.

Am I missing something?

Also Google Checkout documentation says Google Checkout supports shipping internationally. But when I select any country besides the U..S. the checkout demo says it does not ship to that location.

Woody

eva01:

I have a second installation of Zen Cart in a subdirectory from my main site. I'm using this for certain customers as there will be extra products and different pricing.

Do I need a second GCO seller's account to process those sales? Since my second site is just a subdirectory off the main site, is there a way to just use the same account?
Hi eva

thats an issue, you can have 2 sites with just one account and make it work transparently. The main problem is that you have just one API Callback URL setted in the Setting ->Integration

so all notifications sent by Google will go to that url. u cannot separate one site from the other, because google doesnt know witch sell belongs to witch site...

but ill add a request feature to allow multiple sites per merchant,. and in the cart add a tag to tell GC to witch site the cart belongs... i cant tell you this will be implemented, nor commit for dates, but ill do my suggestion, GC team is very open to this suggestions.

hope this helps

ropu

Woodymon:

Agreed. On the demo I observe following S&H options

I see no explanation or any "key" to help customer understand what these S&H options mean or the differences between each S&H option. Or maybe that is dependent on which shopper is selected?

I don't see how to select a specific shipping provider.

When I click the "Calculating tax and shipping" button I observe no response.

Am I missing something?

Also Google Checkout documentation says Google Checkout supports shipping internationally. But when I select any country besides the U..S. the checkout demo says it does not ship to that location.

Woody
Bless, woddy

its true about the USPS, usp and fedex.

the issue with that, is the permission problem, the SRV is on an isolated DMZ and right now it doesnt have perms to go out to any ports, except sandbox. im working with net sec guys to make these feature works. but you should know, the concept is the same, if you can see any merchant calculation callback works, any shipper should work. ill update you when this is available,

you can try playing in the admin section to enable or disable any shipping provider, add coupns, or anything,. also have a look to the notification Viewer that shows how messages are sent to the GC srv, and came back...
regarding Int'l shipping, woody, that featrue, GC just have released. im coding the update and to also support shipping tracking.

http://code.google.com/apis/checkout/developer/release_notes.html

these features changed a lot the way shipping is handled, and gives much more power to the users, also Tax are enhanced.

im working on v1.3

btw, woody, please give me a feedback on witch "explanation or "key"" will help merchants to understand better the module, u know this kind of feedback are very welcome, as a coder, sometimes i assume things that merchants dont "know by default" :blush:

hope this helps

ropu

hello, I wanted to know if the current download is working on Anyones site??? Does the current download work, or does it need to fixed?

thank so much.
Hugs..

Melissa

jewelrylady:

hello, I wanted to know if the current download is working on Anyones site??? Does the current download work, or does it need to fixed?

thank so much.
Hugs..

Melissa
hi jewelrylady

have a look to the demo site.
http://demo.globant.com/~brovagnati/zen_demo1/

hope by the end of the week i have the demo with full int'l shipping and tax features.

ropu

Is there anyway to add the google checkout button the product listing page? Or does it have to be in the Product information page?? This way its one less button for someone to push.

jewelrylady:

Is there anyway to add the google checkout button the product listing page? Or does it have to be in the Product information page?? This way its one less button for someone to push.
hi jewelrylady

yes, of course is possible, but not yet implemented... i can add it in the TODO list.

ropu

Ropu,

Attached is an image file of the shipping option that we would like to offer through GoogleCheckout. Can you please assist me in properly configuring this in includes/modules/payment/googlecheckout.php in the mc_shipping_methods
parameter.

I tried to comment out what I don't want but then I get error, perhaps I am not commenting it right.

Be very careful with current GCO module in handling coupon. I just found out Zen-CART does not physically delete the coupon when I delete them. They just put them in inactive state. Using other checkout methods, Zen-Cart will not allow using those inactive coupon. However, GCO still use those coupon regardless whether they are inactive, or they have already been expired. The only way to prevent people using those expired coupon is to increase minimal order to some large number, say $9999.

ropu, can you verify this is the bug and come up with a quick fix? thanks

spf:

Be very careful with current GCO module in handling coupon. I just found out Zen-CART does not physically delete the coupon when I delete them. They just put them in inactive state. Using other checkout methods, Zen-Cart will not allow using those inactive coupon. However, GCO still use those coupon regardless whether they are inactive, or they have already been expired. The only way to prevent people using those expired coupon is to increase minimal order to some large number, say $9999.

ropu, can you verify this is the bug and come up with a quick fix? thanks

Thx spf, im taking note of this!

thx for ur report

ropu