Google Checkout module for ZC 1.3.x (beta)

Hi all,
well after hard work i have finished coding the new release.

• It has support for CGI installation
• Bug fixing
• Improved way of getting quotes
• And a multisocket way to parallelize this calls.The truth is that i just finished coding, and didnt test it fully. And docs are missing. I know i told you ill have it for today, but some issues arrived, regarding the multisock feature.:blush:

So ill pack and ship this release, completed, on monday.

Sorry for this delay, but waiting a little more for a better thing is worthwhile. :D

Have a good weekend.

ropu

jhaase83:

Ok Now I need help with this.

Warning: main(/home/jhaase83/public_html/googlecheckout/googlemerchantcalculations.php): failed to open stream: No such file or directory in /home/jhaase83/public_html/googlecheckout/responsehandler.php on line 37

Fatal error: main(): Failed opening required '/home/jhaase83/public_html/googlecheckout/googlemerchantcalculations.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/jhaase83/public_html/googlecheckout/responsehandler.php on line 37

Jhaase

Those files are also in the svn, you should download them. But i recommend you, to wait till monday to the new release.

ropu

Ok will do. Thanx!

I'm still having this problem, but I have a bit more info now...

mpayson:

GC 1.5 is installed & working, but orders are still not showing up in Admin. responsehandler.php opened directly returns the error:

Fatal error: Call to a member function on a non-object in /home/mpayson/public_html/zc137/includes/languages/english/credit_cards.php on line 57

What I just discovered is that I only get this message when I load the page via my my shared host URL (ie: https://myhost.com/~mydomain/store/%29. If I load it by my URL directly, it returns no errors. Unfortuanely, GCO doesn't like my SSL cert, so I have to use my hosts shared cert. I do know that that cert is valid, since I'm currently using it with the Graith GCO module.

Any thoughts?
Thanks!

I wonder if anyone has actually sorted out GCO?

I am in the second month of frustrations. I have hired three different people, paid a tidy sum by now, and the latest from Jacob suggests that it is not permissible to install GCO after the login, but when I had it earlier, everyone was able to checkout without paying shipping. Putting it later means it comes after the login.

This is a Catch-22 and I'm fairly fed up and wonder what some reasonable options are?

Mindful,

In order to have shipping show up on the GCO checkout you have to install the Table and Flat shipping options without changing any wording ... as if it were a fresh install(Yuck!). Thus, you have two shipping options and the customer really doesn't know what each stands for. I have opted for just the flat which is standing for 1st class mail.... I do tell my customer where the "- or use -" used to be, to click a link to a product that allows them to upgrade their shipping. Some people have used and I wonder if some people have abandoned because of it?

Issues I have found with Google Checkout

1. Optional Shipping Extras cannot be easily put in (insurance, gift wrapping, order tracking)
2. Currently only 2 shipping options.... flat and table (maybe fixed in Monday's version?)
3. Cannot setup GCO to ONLY work in USA or the country of your choice. (Only two shipping options)
4. Cannot change text labels of Flat or Table or they will not show up as options
5. Data Related
   order.order_total is not being populated by google checkout.
   order.order_tax is not being populated
   orders_products.prid is not being populated (i don't know the significance)
   orders_products_attributes.products_attributes_wei ght is not being populated
   orders_products_attributes.products_attributes_wei ght_prefix is not being populated
   orders_products_attributes.attributes_qty_prices is not being populated
   orders_products_attributes.attributes_qty_prices_o netime is not being populated
   orders_products_attributes.products_options_id is not being populated
   orders_products_attributes.products_options_values _id is not being populated
   orders_products_attributes.products_prid is not being populated (i don't know the significance)

Along with this google checkout is placing abbreviated State and Country information in the order table fields.
Also, with orders_total.title a different tax title is being placed into the field instead of the one that Zen Cart places in.

6. Most orders show up fine... I have had one order show up without the products in the order. (But Google told me what they ordered)

MindfulWanderer:

I wonder if anyone has actually sorted out GCO?

I am in the second month of frustrations. I have hired three different people, paid a tidy sum by now, and the latest from Jacob suggests that it is not permissible to install GCO after the login, but when I had it earlier, everyone was able to checkout without paying shipping. Putting it later means it comes after the login.

This is a Catch-22 and I'm fairly fed up and wonder what some reasonable options are?

I was wondering why GCO didnt include shipping fee after I changed to Zone Rate, now I know the reason. We will give up on GCO and this mod for now until a stabler version comes out.

I'm using Zen Cart 1.3.7 just upgraded from 1.3.6. I also upgraded to 1.0.4r Google Checkout. My problem is it's not going through at all, I'm using the sandbox. Here's what happens when I test:

Add item to cart, checkout, choose shipping method (only have table as an option), choose payment method (it says google checkout only, but no gc logo, just plain text), continue checkout, confirm order, then a thank you message. It never goes to google checkout to enter any CC info or gc login. Nothing shows up in my GC seller's page/e-mail. I check my ZC orders and they are all pending.

Anyone know what I'm missing? Did something go wrong from either upgrading to ZC 1.3.7 or GC 1.0.4r?

eva01:

I'm using Zen Cart 1.3.7 just upgraded from 1.3.6. I also upgraded to 1.0.4r Google Checkout. My problem is it's not going through at all, I'm using the sandbox. Here's what happens when I test:

Add item to cart, checkout, choose shipping method (only have table as an option), choose payment method (it says google checkout only, but no gc logo, just plain text), continue checkout, confirm order, then a thank you message. It never goes to google checkout to enter any CC info or gc login. Nothing shows up in my GC seller's page/e-mail. I check my ZC orders and they are all pending.

Anyone know what I'm missing? Did something go wrong from either upgrading to ZC 1.3.7 or GC 1.0.4r?

I also have experienced the same problem. The logo show up fine when I turn on live mode. Will wait for the newest release that is supposed to be posted today to see if that fixes the issue.

When do you expect the latest update to be available. I am not being pushy - just asking. Cuz when I use the Google module, and close its window, it shuts me down entirely... so I lose the store, and my connection. Have I missed something.
Respectfully,
John Underwood

mpayson:

I'm still having this problem, but I have a bit more info now...

What I just discovered is that I only get this message when I load the page via my my shared host URL (ie: https://myhost.com/~mydomain/store/%29. If I load it by my URL directly, it returns no errors. Unfortuanely, GCO doesn't like my SSL cert, so I have to use my hosts shared cert. I do know that that cert is valid, since I'm currently using it with the Graith GCO module.

Any thoughts?
Thanks!

Any thoughts on this at all? I'd appreciate any help or suggestions anyone can offer... (see Here for complete details).

With google checkout can you sell downloaded Products? I mean will it work, and send the customer back to download there product.

This is a response on the problem with people's Google Checkout Images NOT appearing when they select sandbox mode:

1. You MUST sign up for a customer and merchant account on sandbox, here:
   
   http://sandbox.google.com/checkout/sell/

2. If you have NOT ran the install script for googlecheckout:

To fix your button, you must change in line 200 in your includes\modules\payment\googlecheckout.php

everywhere it says "https://sandbox.google.com/" change this to "https://sandbox.google.com/checkout/"

3. If you HAVE ran the install script for googlecheckout, you must modify your MySQL database.

Go to PHPmyadmin for your SQL database, select your zencart database (mine is called "_zc1").

Scroll down to zen_configuration and click it.

click SQL tab, then put the following into the form and click go:

**UPDATE zen_configuration SET configuration_value = 'https://sandbox.google.com/checkout/' WHERE zen_configuration.configuration_value="https://sandbox.google.com/" LIMIT 1 ;

**and if that succeed's, proceed with:

**UPDATE zen_configuration SET set_function = 'zen_cfg_select_option(array(''https://sandbox.google.com/checkout/'', ''https://checkout.google.com/''),' WHERE zen_configuration.configuration_value="https://sandbox.google.com/checkout/" LIMIT 1 ;

**Your sandbox image and link is now fixed.

Anticide

anticide:

This is a response on the problem with people's Google Checkout Images NOT appearing when they select sandbox mode:

1. You MUST sign up for a customer and merchant account on sandbox, here:
   
   http://sandbox.google.com/checkout/sell/

---

2. If you have NOT ran the install script for googlecheckout:

To fix your button, you must change in line 200 in your includes\modules\payment\googlecheckout.php

everywhere it says "https://sandbox.google.com/" change this to "https://sandbox.google.com/checkout/"

---

3. If you HAVE ran the install script for googlecheckout, you must modify your MySQL database.

Go to PHPmyadmin for your SQL database, select your zencart database (mine is called "_zc1").

Scroll down to zen_configuration and click it.

click SQL tab, then put the following into the form and click go:

**UPDATE zen_configuration SET configuration_value = 'https://sandbox.google.com/checkout/' WHERE zen_configuration.configuration_value="https://sandbox.google.com/" LIMIT 1 ;

**and if that succeed's, proceed with:

**UPDATE zen_configuration SET set_function = 'zen_cfg_select_option(array(''https://sandbox.google.com/checkout/'', ''https://checkout.google.com/''),' WHERE zen_configuration.configuration_value="https://sandbox.google.com/checkout/" LIMIT 1 ;

**Your sandbox image and link is now fixed.

Anticide

I already manually did your number 2 but had the same problem. I just tried your number 3, and for each step it says rows affected 0. Same problem. I guess I'll just wait for an update, unless anyone else has a fix?

Hi all.

This release had me really busy these last 5 days.

I finally package the code in a .zip and added to the googlecode site as my signature links.

These are the changes.

Merged with Zencart** 1.3.7 **(have a look to admin/orders.php)

Please know that the "multisocket feature for merchant-calculations (alfa)(optional)" is still alfa, since i had to coded from scratch and without any model to be guided with, i couldnt find any similar implementation in the web. This is the first version for this and should evolve a little more. Remember that the feature can be disabled from the Admin UI.

Also added a script to add .htacces and disable PHP basic authentication to those who run PHP over CGI. (for errors: Basic Authentication failed, or headers['Authorization'] is NULL). Accessed from the Admin UI.

Also added a feature to integrate **Google Analytics **to the cart to have a better track of the sales, also configurable from the Admin UI.

Please, remember to upgrade files and **uninstall/install **the module from admin UI->modules->payment.

Any question feel free to ask.

This is the svn update from v.1.0.5 -> 1.2RC1

Author: rovagnati
New Revision: 41

Added:
trunk/admin/images/
trunk/admin/images/googlecheckout/
trunk/admin/images/googlecheckout/gc_multisocket.gif (contents, props changed)
trunk/admin/includes/htaccess.php
trunk/admin/includes/multisock.html
trunk/googlecheckout/multisocket.php
Modified:
trunk/INSTALLATION
trunk/README
trunk/admin/includes/functions/extra_functions/added_function_for_google_checkout.php
trunk/admin/orders.php
trunk/googlecheckout/gcheckout.php
trunk/googlecheckout/responsehandler.php
trunk/includes/modules/payment/googlecheckout.php

Log:
02/26/2007 v1.2 (ropu)

• Tested on Zencart v1.3.7
• Add multisocket feature for merchant-calculations (alfa)(optional)
• Different algorithm to retrieve quotes
• Add Google Analytics Support
• Add support for PHP CGI installations
• Add user and password for Google Checkout buyers
• Items retrieved from Merchant-private-item-data instead of session.
• Many bug fixes

enjoy

ropu

Ropu,

thank you for your hardwork. Will this production release work with ZC 1.3.6? Also, do you plan to upload your file to Zen-Cart's downloads page so it is easier for people to find the source file.

I will try to install it on my system and see how everything goes.

Thanks

Thank you so much ropu. Got a place to send a donation? Your work is really appreciated. I also will try to install the new GCO module this week and report back. Fingers crossed...
Thanks again.

Ropu, I installed the GCO 1.0.5. Everything else looks good, except the shipping charge is not returned back to Google Checkout from my zen-cart. Do you know how to fix this? thanks

Your server returned no data in its response; Checkout requires data of type merchant-calculation-results in response to merchant-calculation-callback

regenbauma:

I have been getting thsi error message in my google callback error page ........

 **Your server returned no data in its response; Checkout requires data of type merchant-calculation-results in response to merchant-calculation-callback**

I see that this arrives in response_message.log but seems that respondhandler is not responding to it ......

does anyone else see this ..... any clues are helpful ..... thanks

Regenbauma, how did you fix this problem? I am having the same problem with ropu's new release. Thanks

Couldn't resolve host 'ur-site'

Time to response: 0.12273311615 segs

Note: This script MUST response in less than 3 sec. so GC srv doesn't timeout.'

The above error is what I get when running responsehandler_test.php. Any idea what's causing this? Thanks!