Google Checkout module for ZC 1.3.x (beta)

Hi ropu,

Just PM'd info below:

National and International Per Item Shipping
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_51&products_id=334

Basically the shipping "mod" above just includes the easy steps to create your own two basic flat rate/per-item Zen Cart shipping modules, one for shipping to USA addresses and one for all other addresses. Very simple in concept and implementation. The Zen Cart founders turned me on to the idea several years ago and I have employed ever since.

The idea is you set a different handling charge for domestic and international addresses. And then you add a per item shipping charge, which is also different for domestic and international addresses. It very well approximates the actual shipping costs for USPS Media Mail and USPS Air Mail services, without the need to log in to shipping provider for shipping estimates and third party shipping charges. Really saves on confusion for the customer and shop owner. It is only recommended for those shops shipping items of similar size, shape, packaging and value. In our case books and DVD's.

Hope this clarifies the need.

Woody

ropu:

Hi global

have u tried with newer releases?

ropu

I did try the new release and I got this error:

Error parsing XML; message from parser is: Invalid value for body of allowed-areas in checkout-shopping-cart/checkout-flow-support/merchant-checkout-flow-support/shipping-methods/merchant-calculated-shipping/address-filters: Must be a U.S. 2-letter postal code or state name
<<

I restored it back to the old version to at least have it online.

I was told to direct this question to this part of the forum. Can anybody PLEASE help me?

Any assistance is appreciated.

theangel2g:

How do I make the below changes what files etc. I was referred back to Zen Cart for this information. I did the first part now I need help with the 2nd part.

Answer:
(This is a copy and paste from Jrox forum:)
actually, we've been approved for tracking.

In order to use JAM with Google Checkout, you need to contact Google and ask them to whitelist your domain.

Secondly, you will need to edit the shopping cart you are using with Google Checkout to add some XML code in it:

**http://code.google.com/apis/checkout/developer/checkout_pixel_tracking.html**

QUESTION: what file exactly to edit? Im using zen cart

Answer:
this is actually done on the shopping cart side, not JAM.

once we get more information on this, we'll post it.

I got this error today

We encountered an error trying to access your server at .../googlecheckout/responsehandler.php -- the error we got is: roproxy.prod.google.com

Anyone knows what causes this?

I regenerated my .htaccess and .htpasswd files today using only my sandbox merchant account and password, and set the CHMOD on my googlecheckout directory to 755. These actions eliminated the error message above and replaced it with this new one:

We timed out waiting for your server at *http://www.Jay42.com/googlecheckout/responsehandler.php* -- the error we got is: Read timed out Your server must respond faster to merchant calculation callback requests.

Am I getting warmer....or colder? :blink:

Woodymon:

While continuing to troubleshoot my Google Checkout shipping config issues, I am also observing some peculiar order processing behaviors in ZC admin.

1. When I attempted to submit an order status "update" via ZC admin, with standard boilerplate text entered into the order comments box, and clicked the "update" button I observed error:

Error 400: Bad request. The parameters passed to the service did not match as expected. The exact error is returned in the XML response.

> 
> I observe no errors in response_error.log.
> 
> However I observe in response_message.log
> ```
Messages cannot be longer than 255 characters.
```Why the limitation?
> 
> My same boilerplate test works with other payment modules including PayPal.
> 
> 2. The original order submission email was delivered to admin email address and to customer email address.
> 
> However the order "update" email message was not delivered to the admin address, only to the customer email address. I had both the 'Notify Customer" and "Append Comments' checkboxes checked. (copies of the order update emails should be delivered to admin address as well as to the customer, or at least an option provided to enable/disable delivery of order updates to admin email).
> 
> 3. "Shipper Tracking Information" form field with tracking number and shipper type dropdown displays at bottom of orders page, even though not employing third party or MC type shipping. Would like to be able to disable the display of this info on admin orders form (so helpers won't get confused).
> 
> 4. ALL Google Checkout server responses are displayed in the comments column. This info is accessible to customers via their MyAccount link (that is if they had a password initialized for them to allow them to log into Zen Cart). Thinking best if much of this info is displayed on the admin orders page (like PayPal IPN does) and not accessible to customer.
> 
> 5. On a related note if no shipping tracking info is submitted in order status update this is info is indicated in server response comments. 
> 
> ```
04/03/2007 12:23:17     True     Shipped     
Shipping Tracking Data:
Carrier:
Tracking Number: 
```Would like option to be able to disable inclusion of this info in the server response messages/comments. We will manually include tracking info in order status update comments as needed.
> 
> 6. Also the time in message above indicates time for web hosting provider. When possible would prefer time based on timezone location of shop be applied. Otherwise all the various order update comments get out of synch in listing on admin orders page. I will provide more detailed observations on this later.
> 
> 7. What happens if customer creates a ZC account. And then later checks out though Google Checkout (not logged into ZC) and submits an order thru GC using the same email address which was used to register ZC account?
> 
> Is a second ZC account with that same email addy created in ZC admin? Will customer whom created the ZC account be able to login to ZC and view the details of the GC order?
> 
> And then vice versa, if no ZC account is created, customer submits order thru GC. This auto creates a ZC account (but customer would not have a password). and then later attempts to sign up for ZC account. Does the customer see a message that an account with that email addy already exists? Can i click password forgotten link on login page to retrieve a password for an account created by GC? What are the validation issues and what should be expected behaviors here? 
> 
> 8. If customer is logged into ZC account and clicks "Checkout" in main menu, browser is directed to step one page of standard ZC checkout procedure. That means they will miss opportunity to checkout via Google Checkout.
> 
> Just some casual observations. Even if GC is only suppose to be an "Express" checkout option for ZC, there are many interaction possibilities (permutations) between Zen Cart and Google Checkout to think about. Wrapping one's head around all the code and logic needed to deal with the possibilities must be mind numbing. I'm sure Ropu can infom us in detail. 
> 
> Suggestions or comments on the above?
> 
> Woody

im taking note of this. i'll be answereing each point when they are solved or have an answer


thx again
ropu

Woodymon:

Hi, I've been asking in this thread about supporting "instant downloads". The responses I've received have appeared to indicate that Google Checkout does not support instant downloads

However I've been scanning through the Google Checkout forums for ideas, tips, solutions and workarounds. On the Merchants discussion forum I found this Q&A:

So this appears to indicate Google Checkout supports "instant downloads", does it not?.

Ropu, I know you have much on your plate with supporting other Zen Cart/Google Checkout features. But is "instant downloads" support something you plan to eventually (soon) integrate into your mod? If you need a tester for such functionality please let me know.

Thanks,
Woody
The continue shipping url could work fine

but have some issues!

1: it can bee seen in the cart you sent to google, so buyer can know the url!

2: if u dont anable the url until new order notif arrives will solve problem 1, but, google do not warranty when New order notif arrives. it usually take few secs, but is NOT synchronic, so it may take some time and the continue url wont be enabled, making the buyer confuse...

but im open to ideas...

ropu

Woodymon:

Here's an answer.
http://groups.google.com/group/google-checkout-api-integration/browse_thread/thread/da5f4a838712d4c2/02019e1e5c8ac29e#02019e1e5c8ac29e

And ropu you are suppose to be on a one-week holiday. Not just a vacation from the Zen Cart community :wink2:

Woody
sorry about that, those msg get to my gmail account... even in vacations i can log out from gmail :P

ropu

Woodymon:

Regards to emails sent by Google Checkout to (both Buyer & Seller/admin). We do all our email in text (not HTML). The text email messages we receive back from Google Checkout are not well formatted messages and very difficult to read.

1. Adding simple line breaks to the email template would fix most of the text formatting issues.

2. Could the "From" and Reply-To email address for the messages sent out by Google be configured with our shop (sellers) email address? And then allow customers to respond to the email message. Stating "Please do not reply to this message." is VERY BAD customer service and will turn off our customers!!!

3. Also at the bottom of message I observe: "Have questions about this order? Contact SellerName".

Besides the SellerName it would also be good to include the sellers email address.

4. On the test "buyers" shipping status message which I received, I observe the address under "Purchased From" is only half correct. That is only street number but not the street name is included. (might be a problem with my account set-up at Google, will check into it).

5. Need a location for the buyer to enter "Attn To:" when submitting order, and then if entered by customer, display Attn To: within the "Ship to:: address.

6. Ability to remove "Shipping Tracking line" in the email message.

7. Method to include Shop (Zen Cart) order number as well as Google Order number.

8. Shipping Status label and the word Shipped are not adjacent to each other.

9. Itemize each ordered product on it's own item line (item qty, item price, total amt for the line).
   Then a dashed line (separator)
   Then a SUBTOTAL line.
   Then a S&H line.
   Then a Tax line (if applies...keep in mind some locales charge S&H before tax, others after tax).
   Then a dashed line (separator)
   Then the TOTAL line (Emphasize IN CAPS).

10. Remove "(includes Tax (State) $0.00)" from Total line and move to under SubTotal as above. And for locales that don't apply tax, remove Tax line altogether.

11. In email to buyers, add a URL link to Buyers Account login, adjacent to "Check the status of this order anytime in your Google Account".

12. Best to look at how Zen Cart formats customer and admin email messages (for both HTML and text formats). And check out how PayPal IPN does it and emulate. no need to reinvent the wheel here.

Below I've ADDED line breaks and improved formatting of the Order "Status" change email message which Buyers currently receive. Hopefully similar formatting can be incorporated into future GC ZC integration:

Purchased from:
FNAME LNAME
Street Address
City ST POSTALCODE
COUNTRY

Ship to:
FNAME LNAME
Street Address
City ST POSTALCODE
COUNTRY

Hello FNAME,

Great news! Your order has shipped, and should arrive soon. Your credit card has successfully been charged for this order.

Track USPS package #n/a

Order Details - DATE - TIME TZ-00:00
Google Order #123456789012345

Shipping Status:
Qty Item Price <<<< This line is out of sequence and needs moved down!!!!
Shipped

ITEM_QTY ITEM_NAME $ITEM_PRICE
Shipping & Handling (Shipping Method) : $SHIP_AMT
Total: $TOTAL_AMT (includes Tax (Zone) $TAX_AMT)

Check the status of this order anytime in your Google Account.

Have questions about this order? Contact SELLER_NAME

Need help? Visit the Google Checkout help center. Please do not reply to this message. ©2007 Google

--
Thanks,
Woody
im emailing google guys with this suggestions..

ropu

tj1:

Thanks Woodymon.
I sell true wholesale so profit margin is very small and I also offer free shipping on all domestic orders.
The low order fee is not for using a credit card to pay, but rather a convenience service fee for such a small order regardless of payment method.
I believe this is acceptable, I've literally seen thousands of merchants implementing something similar.
I did a few searches trying to find if this is a violation of the credit card companies' TOS, but I couldn't come up with anything. If you find something please let me know.

I hope ropu can come up with a solution. I'll leave it as it is for now, hopefully I won't get many small orders through GC and customers won't notice and abuse this loophole.

hi, im not sure how it works internally min sell, but waht u can do is add an item in the GC cart that contemplates the charge...

this can be done in googlecheckout/gcheckout.php after the block that start in line 108

if need further help, will try to figure out a solution, but please try to fins out how the module works, how it detects witch is the minimum order, how to get the cost of not reaching that minuium, and all info regarding that module so i can guide u to the solution

hope this helps, ropu

Woodymon:

I agree that a bit more clarification in the readme of who should run /admin/htpasswd.php and who should run the provided tool on Ropu's site (and why the difference). And the readme should not include http:// to describe an absolute path.

Woody

thx woody!

the .htaccess satarted as a hack, later a tool and now part of the module distro.

:D

this is why i still have it hosted in tools, because it can also be used by other non zencart merchants...

but all zencart merchants are encouraged to use the one that is provided in the module, because is easier and automatically detects the directory and creates the necessary files

ropu

Sojourner:

My orders are showing up in the Customer Orders section and are listed as pending. When I log in to my sandbox account there are no orders there.

If I do https://www.mydomain.com/cart/googlecheckout/responsehandler.php

I see the following:
Mon Apr 9 15:37:02 US Mountain Standard Time 2007:- Invalid

Is that causing the problem?
I'm in Michigan so the time should be eastern time; however, I do not see where to change it in the admin section.

Other than no orders showing up in my sandbox account everything else seems to be working great. I go through the order process and the confirmation email is sent to my test user.

Misc Information about my setup:

I am testing using the sandbox for googlecheckout with the latest versions of zen-cart and googlecheckout. (downloaded from Ropu's sig)

I have activated the sandbox account and set the Integration settings to the following:

API callback: https://www.mydomain.com/cart/googlecheckout/responsehandler.php

Callback method: XML

Shopping cart post security checkbox is checked.

I do have SSL enabled.
I am on a shared windows server that has PHP4 and curl installed.
The MySQL 5 database is set to cache to the database.

Since I do not have the getallheaders function I had to comment out the security authentication checks. I did Ropu's recommendation of creating the .htaccess and .htpassword files.

I've checked for spaces in my merchant key and merchant ID and both look good. I got them from the sandbox account and double checked that I am not using my production keys.

hi

one thing, there is no need to comment the auth code, just enable 2. .htaccess Basic Authentication Mode with PHP over CGI?
from the admin UI in the google checkout moudule, and will be done automaticaly by the program

2. double check that ur orders arnet in the archive tab in sandbox

ropu

DragonLord:

I posted earlier with a problem with google checkout

I upgraded my zen cart from 1.3.5 to 1.3.7 and I also upgraded to the latest version of google checkout module.

My host runs php as cgi and I set up the htaccess files using the generator code supplied.

The problem is that when I place an order as a customer through google checkout I get an error screen that says "oops zencart has sent google a bad shopping cart."

When I go to my google checkout merchant account it in my integration issues it says " Duplicate shipping name Table Rate found."

In the xml there are 2 different lines that read

<flat-rate-shipping name="Table Rate">

I have not been able to find out what is causing this error. I have been looking through this thread for the last 2 days trying different suggestions but nothing seems to work.

Please help me

flat rates items are an issue right now

a fast solution is recommended,.

in the includes/modules/payment/googlechekout.php line 50

change this

    $this->shipping_support = array("flat", "item", "table",  'freeoptions', 'freeshipper', 'perweightunit', 'storepickup');

with

    $this->shipping_support = array();

this is a TEMPORAL fast solution, but not the best

it will do merchant callculation callback for flat rate shippings. the issue is in the creation of the cart, im working on it to fully support all flat rate shippings

ropu

vrwired:

I'm having the same problem, but I did successfully install the SSL certificate and have dedicated IP on shared host. When I run the Responsehandler Test for URL https://www.diamondsonthesolesofhershoes.com/googlecheckout/responsehandler.php,
I get:
SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:func(144):reason(134)

I'm not sure why this is because I have verified the integrity of the certificate in more than one browser.
The most peculiar thing though, is that if i test an order and enter a coupon code, it is now working almost, the coupon can now be applied (it couldn't verify before I had installed SSL) HOWEVER, there is no discount --> the discount remains at $0.00 even though I have it set up to take 20% off. :frusty:

I tried creating more coupons to test with but get the same result everytime if i make the coupon based on % discount. If i make it based on $ off, I get this:
Invalid coupon code Retry
The minimum order total for this coupon is $40.00 (tester)

Incidentally, i'm using google-checkout-osc-v1.2RC3rev1 contribution for the coupon support - and got this from http://code.google.com/p/google-checkout-oscommerce/

I also looked at error logs in the google merchant checkout account (at integration settings) but I am no longer getting errors there (I was when I didn't have the certificate)... and this point bring me back to my first note that responsehandler says there's a certificate problem... ??? something seems wrong with the script, Ropu.

Any ideas what I can do? ~thanks for your consideration

that issue is because of a proxy config in my srv, try to point to ur server with an HTTP address instead of an HTTPS

thx

ropu

Jay42:

Hi Ropu,

Welcome back...hope you had a nice vacation!

I wrote a couple of posts a few days ago, and Woody helped me out a bit, but I am still having the same problem - GCO does not give the UPS shipping rates and uses the default rates instead. My host is running PHP as CGI so I have created the ht files as indicated. I have set my API callback according to the instructions. Here is the error message I get:

Any suggestions to correct this would be appreciated. Thanks.

it seams that u have the wrong credentials!

try entering http://www.jay42.com/googlecheckout/responsehandler.php and put as user ur merchant id and password ur merchant key

if u cannot enter, u must re run the htaccess.php generator.

also some people reported that some hosting do not allow access to folders with 777 perms... have u turned back to original permission??

hope this helps

ropu

Woodymon:

Hi ropu,

Just PM'd info below:

National and International Per Item Shipping
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_51&products_id=334

Basically the shipping "mod" above just includes the easy steps to create your own two basic flat rate/per-item Zen Cart shipping modules, one for shipping to USA addresses and one for all other addresses. Very simple in concept and implementation. The Zen Cart founders turned me on to the idea several years ago and I have employed ever since.

The idea is you set a different handling charge for domestic and international addresses. And then you add a per item shipping charge, which is also different for domestic and international addresses. It very well approximates the actual shipping costs for USPS Media Mail and USPS Air Mail services, without the need to log in to shipping provider for shipping estimates and third party shipping charges. Really saves on confusion for the customer and shop owner. It is only recommended for those shops shipping items of similar size, shape, packaging and value. In our case books and DVD's.

Hope this clarifies the need.

Woody

htx woody, i've seen it and working with it!

thx again for all ur help to me and all merchants! very appreciated!!

ropu

GlobalVillage:

I did try the new release and I got this error:

Error parsing XML; message from parser is: Invalid value for body of allowed-areas in checkout-shopping-cart/checkout-flow-support/merchant-checkout-flow-support/shipping-methods/merchant-calculated-shipping/address-filters: Must be a U.S. 2-letter postal code or state name
<<

I restored it back to the old version to at least have it online.
hi
this error must be that some of ur tax us zones has a not valid state code name.

please use http://demo.globant.com/~brovagnati/tools Decode Shopping Cart to see how ur cart is created, (or have a look in the integration section)

there u must find witch state is wrong (or empty, etC)

ropu

theangel2g:

I was told to direct this question to this part of the forum. Can anybody PLEASE help me?

Any assistance is appreciated.

hi

u need to modify googlechekcout/gcheckout.php near line 188

hope this helps

ropu

Jay42:

I regenerated my .htaccess and .htpasswd files today using only my sandbox merchant account and password, and set the CHMOD on my googlecheckout directory to 755. These actions eliminated the error message above and replaced it with this new one:

We timed out waiting for your server at *http://www.Jay42.com/googlecheckout/responsehandler.php* -- the error we got is: Read timed out Your server must respond faster to merchant calculation callback requests.

Am I getting warmer....or colder? :blink:
hi
try using Responsehandler Test

this looks like ur shipping provider timed out,

ropu

try using Responsehandler Test

this looks like ur shipping provider timed out,

Here's my results:

*Time to response: 5.2493069171906 segs

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

Any way to shorten response time?