Google Checkout module for ZC 1.3.x (beta)

Colosports: I'd been seeing the attribute bug, and your fix partially solved it - thanks! I am noticing that when a product has a complex set of attributes, the Google Checkout page truncates them with an ellipsis. Do you have any idea if there's a way to display the attributes in their entirety? I'm not sure if it's a hard limit of Google Checkout or what.

Google set the max limit to about 94 character for the title (+attribute).
This should not matter since, we can have Google send the attribute values back to Zencart and have all the attributes listed in Admin Orders.

I have found a solution to the address book bug. I am running a few more test and will list the fix later on tonight.

What is supposed to happen when you're using sandbox mode and you place an order?

After it says thanks, shouldn't it send you back to checkout_success? And shouldn't it take the products out of your cart? And shouldn't it show you in admin that you have a new order?

Or do those things only happen when you go to live?

After you place an order (in sandbox or live mode),
Your will get a Thank You page from Google that you placed an order.
If you return to the website, you will not get a Checkout Success.
The items in your cart disappears.
The shipping address is stored in the database. In admin, you will see the new order like regular orders. Google user will not apear in Admin->Customers.

If you get the Thank You page from Google but the orders does not show. Check the error page in your Google Checkout->Settings->Integration page.
Also make sure that the fill in the callback URL link. (Instruction in Readme file)

Everything goes fine, Google says thank you, but when it returns me to my site, it doesn't show the order as completed and the items are still in the shopping cart.

I know others are having the same issue...?

Brownsgreens, still having the same problem here, yeah. Callback URL is filled in as per the README, and no errors pertaining to the order in Settings->Integration, but the cart isn't emptied and the order doesn't show in Admin. Weird.

Here's a solution to the Address Book fix.
Instead of updating the address book and ruining all the address book, the code below will add a new address entry to the customer's address book. A possible problem is that the address may become full if they ship to a lot of different address.

Change on line 309

    zen_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array, $oper, $params);	
``` to ```
    zen_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);

For those that are having problems, please post:

1. Version of Google Checkout.
2. Version of ZenCart running on.
3. Your website.
4. You Callback URL.
5. If you are on Sandbox or Live mode.
6. Errors (if any) listed at Google's website (under Setting Tab->Integrations)

I'm running the most recent version of zen, google checkout.

My website is valleymeals.com

It's on sandbox, the callback url is set properly, I have no errors on the google side, everything works perfectly there. I can log into my sandbox merchant account and see the orders there.

The customer then is sent back to index, and the items are still in the cart and the admin panel doesn't show the order.

You have errors:
Fatal error: Call to undefined function: getallheaders() in /homepages/25/d178655344/htdocs/zen/googlecheckout/responsehandler.php on line 83

from http://www.valleymeals.com/googlecheckout/responsehandler.php
This page should show up as an blank page.

Fix your errors and try again. I'm not sure what the error relates to. Maybe someone with more knowledge can help you out. Or try searching the web for more info.

Hey Gang,

Got an odd error for you all....

New Install 1.3.5
Google Checkout Installed and verified functioning

Here's the issue:

Whenever I go into an order and select to update to "processing", "Shipped", etc... I get a db error:

Warning: fopen(/home/misticr/public_html/store/googlecheckout/response_message.log) [function.fopen]: failed to open stream: Permission denied in /home/misticr/public_html/store/admin/includes/functions/extra_functions/added_function_for_google_checkout.php on line 93

Fatal error: Call to undefined function: error_func() in /home/misticr/public_html/store/admin/includes/functions/extra_functions/added_function_for_google_checkout.php on line 94

Anyone have a clue?? Need to resolve this.

Edit: I do not have an SSL server/site so am not using an API Callback URL...

Google Checkout still works fine except that orders are not sent to my store. Is there a way around this as this could be the issue.

Thanks

Jeff

misticjeff:

/home/misticr/public_html/store/googlecheckout/response_message.log) [function.fopen]: failed to open stream: Permission denied

It's attempting to write a message-logging file, but has no permissions to do so. Try making that file/folder writable.

colosports:
A-ha! I have exactly the same error in line 83 if I pull up responsehandler.php directly, so I'm definitely in the same boat as brownsgreens. No idea yet why it's happening...I'm not very conversant in php...but I appreciate the lead.

DrByte:

It's attempting to write a message-logging file, but has no permissions to do so. Try making that file/folder writable.
That was it... Thanks so much!

This module appears to be incompatible with other payment mods. When installed, if you install others such as COD or Skipjack it gives these errors throughout the site:

Warning: Variable passed to each() is not an array or object in /home/moissan/public_html/includes/classes/db/mysql/query_factory.php on line 112

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/moissan/public_html/includes/classes/db/mysql/query_factory.php:112) in /home/moissan/public_html/includes/functions/sessions.php on line 100

Warning: Cannot modify header information - headers already sent by (output started at /home/moissan/public_html/includes/classes/db/mysql/query_factory.php:112) in /home/moissan/public_html/includes/init_includes/init_templates.php on line 78

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCT' at line 6
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) > to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

BTW, I'm using 1.3.02

I may have been wrong. I made my 1.3 site go live and my cache was messed up. The mod found here fixed it and I think it solved the problem.

voltage:

BTW, I'm using 1.3.02

Well, whatever...I give up. I'm just going to use a merchant account myself. Google is a hassle.

Ok, now that its not throwing errors in the cart, I'm trying to test if it works. The problem is if I select the sandbox, it says that my account # doesn't exist?! :blink: If I put it in regular mode, I can get all the way to the second screen where you confirm the charges, but once I hit confirm, it says I can't purchase from myself! So I'm not sure how to test if its working at this point.

Any ideas on why it says I don't exist in with sandbox enabled, but apparently I do exist with the regular mode. (?)

Sandbox and Live mode are 2 complete separate accounts. You will have to sign up for sandbox account.
If you need to make test purchases, you will also have to create a 2nd account account to make the purchase since you can not purchase from yourself.