Zen Cart Logo
Forums / Addon Payment Modules / Google Checkout module for ZC 1.3.x (beta)

Google Checkout module for ZC 1.3.x (beta)

Locked

Views: 1,099,648

Results 921 to 940 of 3,921
This thread is locked. New replies are disabled.
27 Mar 2007, 7:00 PM
#921
ropu avatar

ropu

Zen Follower

Join Date:
Oct 2006
Location:
argentina
Posts:
243
Plugin Contributions:
0

Google Checkout module for ZC 1.3.x (beta)

BlessIsaacola:

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.

Bless, i'll be glad to hep you.

but please try firt this tool i made to generate that code

http://demo.globant.com/~brovagnati/tools -> shipping methods generator

this tool will generate the correct values for the mc_shipping_methods AND **mc_shipping_methods_name
**
hope this helps

ropu

27 Mar 2007, 7:20 PM
#922
ropu avatar

ropu

Zen Follower

Join Date:
Oct 2006
Location:
argentina
Posts:
243
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

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

Spf

thx again for the report.

try this patch

responsehandler.php line 284

change

             $coupon = $db->Execute("select * from " . TABLE_COUPONS . " where coupon_code = '" . zen_db_input($curr_code['code']) . "' and  coupon_type != 'G'");

with

             $coupon = $db->Execute("select * from " . TABLE_COUPONS . " where coupon_code = '" . zen_db_input($curr_code['code']) . "' and  coupon_type != 'G' and coupon_active  = 'Y' and coupon_expire_date >= now() and coupon_start_date < now()");

tell us if it worked, iv just tried with the demo site, and expired coupons, not yet available ones and not active one are not more valid coupons.

hope this helps!

thank you very much

ropu

27 Mar 2007, 9:42 PM
#923
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

ropu:

Bless, i'll be glad to hep you.

but please try firt this tool i made to generate that code

http://demo.globant.com/~brovagnati/tools -> shipping methods generator

this tool will generate the correct values for the mc_shipping_methods AND **mc_shipping_methods_name
**
hope this helps

ropu

I am not sure how your tool is going to help me. USPS, FedEx and UPS are already part of the mc_shipping_methods. However, by default you offer some shipping options that our site doesn't offer and you do not offer some shipping options that your default offers. For example Parcel Post and Library rate are offer by default and we don't want that.

When I comment a line using // I get error.

27 Mar 2007, 10:27 PM
#924
spf avatar

spf

New Zenner

Join Date:
Jan 2007
Posts:
37
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

ropu:

Spf

thx again for the report.

try this patch

responsehandler.php line 284

change

         $coupon = $db->Execute("select * from " . TABLE_COUPONS . " where coupon_code = '" . zen_db_input($curr_code['code']) . "' and  coupon_type != 'G'");
>  
> with
> ```php
             $coupon = $db->Execute("select * from " . TABLE_COUPONS . " where coupon_code = '" . zen_db_input($curr_code['code']) . "' and  coupon_type != 'G' and coupon_active  = 'Y' and coupon_expire_date >= now() and coupon_start_date < now()");

tell us if it worked, iv just tried with the demo site, and expired coupons, not yet available ones and not active one are not more valid coupons.

hope this helps!

thank you very much

ropu

ropu, thanks for the quick fix. I will try that today and let you know

28 Mar 2007, 9:08 AM
#925
gunzanroses avatar

gunzanroses

New Zenner

Join Date:
Mar 2007
Posts:
15
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

Hello all, I've read through this thread all the way back to page 70 something and i still haven't figured out how to make google checkout calculate the shipping. After proceeding to GC i get a drop down box with a whole list of shipping options using the flat rate defined in the admin even if they are unchecked. I went to Ropu's http://demo.globant.com/~brovagnati/tools , however i don't understand "The Method Code is the internal code that each shipping module uses." I'm completely clueless on what that means so i have no idea what to enter in that text box. If anyone could help me with this i would be very much thankful.

28 Mar 2007, 12:59 PM
#926
ropu avatar

ropu

Zen Follower

Join Date:
Oct 2006
Location:
argentina
Posts:
243
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

BlessIsaacola:

I am not sure how your tool is going to help me. USPS, FedEx and UPS are already part of the mc_shipping_methods. However, by default you offer some shipping options that our site doesn't offer and you do not offer some shipping options that your default offers. For example Parcel Post and Library rate are offer by default and we don't want that.

When I comment a line using // I get error.

bless, perhaps u are commenting wrongly
this is the actual code for usps

     array('usps' => array(     'domestic_types' =>
                                                                array(    'Express' => 'Express Mail',
                                                                        'First Class' => 'First-Class Mail',
                                                                        'Priority' => 'Priority Mail',
                                                                        'Parcel' => 'Parcel Post',
                                                                        'BPM' => 'Bound Printed Material',
                                                                                            'Library' => 'Library'),
                                                               'international_types' =>
                                                                   array(    'GXG Document' => 'Global Express Guaranteed Document Service',
                                                                        'GXG Non-Document' => 'Global Express Guaranteed Non-Document Service',
                                                                        'Express' => 'Global Express Mail (EMS)',
                                                                        'Priority Lg' => 'Global Priority Mail - Flat-rate Envelope (large)',
                                                                        'Priority Sm' => 'Global Priority Mail - Flat-rate Envelope (small)',
                                                                        'Priority Var' => 'Global Priority Mail - Variable Weight Envelope (single)',
                                                                        'Airmail Letter' => 'Airmail Letter Post',
                                                                        'Airmail Parcel' => 'Airmail Parcel Post',
                                                                        'Surface Letter' => 'Economy (Surface) Letter Post',
                                                                        'Surface Post' => 'Economy (Surface) Parcel Post')
                                                        ),
```and this is the correct way you should comment parcel and library

```php
array('usps' => array(     'domestic_types' =>
                                                                array(    'Express' => 'Express Mail',
                                                                        'First Class' => 'First-Class Mail',
                                                                        'Priority' => 'Priority Mail',
//                                                                        'Parcel' => 'Parcel Post',
                                                                        'BPM' => 'Bound Printed Material' //,
//                                                                                           'Library' => 'Library'
                                                                                            ),
                                                               'international_types' =>
                                                                   array(    'GXG Document' => 'Global Express Guaranteed Document Service',
                                                                        'GXG Non-Document' => 'Global Express Guaranteed Non-Document Service',
                                                                        'Express' => 'Global Express Mail (EMS)',
                                                                        'Priority Lg' => 'Global Priority Mail - Flat-rate Envelope (large)',
                                                                        'Priority Sm' => 'Global Priority Mail - Flat-rate Envelope (small)',
                                                                        'Priority Var' => 'Global Priority Mail - Variable Weight Envelope (single)',
                                                                        'Airmail Letter' => 'Airmail Letter Post',
                                                                        'Airmail Parcel' => 'Airmail Parcel Post',
                                                                        'Surface Letter' => 'Economy (Surface) Letter Post',
                                                                        'Surface Post' => 'Economy (Surface) Parcel Post')
                                                        ),
```note that for parcel you just need just to comment that line, but in library, as it is the las one in the array, you should comment it, but not comment the last ```php
),
```and erase or comment the previous ```php
,
```this way, the structure of the multiarray is still valid

hope this helps, ill figure out a way to create a script to add and remove in an easier way methods...

ropu
28 Mar 2007, 3:07 PM
#927
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

Ropu,

Thanks for the clarification. This is exactly why I asked couple of weeks ago to see if that file can be cleaned up. It would be nice if the arrays are left justfied so it's easier to figure out where exactly each line starts. There are so many white space that it's not as intuitive to work with that file.

I will attempt again with the new instruction you provided above.

Thanks!

28 Mar 2007, 4:52 PM
#928
spf avatar

spf

New Zenner

Join Date:
Jan 2007
Posts:
37
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

ropu:

Spf

thx again for the report.

try this patch

responsehandler.php line 284

change

         $coupon = $db->Execute("select * from " . TABLE_COUPONS . " where coupon_code = '" . zen_db_input($curr_code['code']) . "' and  coupon_type != 'G'");
>  
> with
> ```php
             $coupon = $db->Execute("select * from " . TABLE_COUPONS . " where coupon_code = '" . zen_db_input($curr_code['code']) . "' and  coupon_type != 'G' and coupon_active  = 'Y' and coupon_expire_date >= now() and coupon_start_date < now()");

tell us if it worked, iv just tried with the demo site, and expired coupons, not yet available ones and not active one are not more valid coupons.

hope this helps!

thank you very much

ropu

It works! Thanks

28 Mar 2007, 5:14 PM
#929
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

Ropu,

When I enable Free Shipping Option I get the following error when trying to checkout with Google:

Oops!
Clevershoppers.com has sent Google a shopping cart with errors in it. We'll contact them to ask that they fix this problem. As this could be a temporary issue, you can go back in your browser to try checking out again.

Any ideas?

If I disable Free Shipping Option then when I go to checkout none of the shipping cost are the calculated cost they are all the default value I entered.

The error message I get in response_error.log is Wed Mar 28 12:23:34 EDT 2007:- Shopping cart not obtained from session.

One other thing, although the button is enabled on the shopping cart page. It's not the same button as version 1.0.4 which shows a button with $10 off.

I don't even know where to start...

28 Mar 2007, 5:31 PM
#930
ropu avatar

ropu

Zen Follower

Join Date:
Oct 2006
Location:
argentina
Posts:
243
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

BlessIsaacola:

Ropu,

When I enable Free Shipping Option I get the following error when trying to checkout with Google:

Oops!
Clevershoppers.com has sent Google a shopping cart with errors in it. We'll contact them to ask that they fix this problem. As this could be a temporary issue, you can go back in your browser to try checking out again.

Any ideas?

If I disable Free Shipping Option then when I go to checkout none of the shipping cost are the calculated cost they are all the default value I entered.

The error message I get in response_error.log is Wed Mar 28 12:23:34 EDT 2007:- Shopping cart not obtained from session.

One other thing, although the button is enabled on the shopping cart page. It's not the same button as version 1.0.4 which shows a button with $10 off.

I don't even know where to start...

For the first issue, have a look to the integration section, a full detail of the error will be show

you can also use http://demo.globant.com/tools -> cart decode to see how the cart is generated. that error is because the cart is malformed

the second issue could be because GC is detected as a spider. try disabling spiders or remove from includes/spider.txt strings ling jakarta

hope this helps

ropu

28 Mar 2007, 7:13 PM
#931
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

ropu:

For the first issue, have a look to the integration section, a full detail of the error will be show

you can also use http://demo.globant.com/tools -> cart decode to see how the cart is generated. that error is because the cart is malformed

the second issue could be because GC is detected as a spider. try disabling spiders or remove from includes/spider.txt strings ling jakarta

hope this helps

ropu

ropu,

  1. There is no jakarta in the includes/spider.txt

  2. I am not sure that the googlecheckout is coded to account for Free Shipping Option when order doesn't meet the requirement. When Free Shipping Option is enabled and set to give free shipping for orders > or = $149.99, Googlecheckout doesn't throw error if order placed is > or = $149.99. If the order is < $149.99 then googlecheckout returns error message " Oops!
    Clevershoppers.com has sent Google a shopping cart with errors in it. We'll contact them to ask that they fix this problem. As this could be a temporary issue, you can go back in your browser to try checking out again
    ." Basically, the googlecheckout code is not taking into account the condition when shopping cart order total is less than the stated condition.

  3. Googlecheckout currently doesn't return calculated shipping, just displays the default values configured on the admin side. I assume there is a timeout issue still.

  4. Enabling multi-socket to speed shipping calculation returns error that our store currently does not ship to customer's location no matter what their location is.

  5. Googlecheckout still does not support tax calculation if a customer belongs to a zone that requires tax.

28 Mar 2007, 7:52 PM
#932
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

ropu,

When I ran the responsehandler_test.php this is the error I got:

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

What exactly do this mean and how can I resolve this. The .crt, .key and .ca file are installed on the server so I don't know why this is problem.

28 Mar 2007, 8:52 PM
#933
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

ropu,

I am rolling back to version 1.0.4 so we can at least take advantage of Google Checkout. Our customers are enjoying the free $10 they get from google and there is too much problem with merchant calculated shipping right now.

I ran the responsehandler_test.php which returned less than 1 seconds and yet googlecheckout is still timing out even though it's suppose to work if it's less than 3 seconds.

It would be great the day this mod actually works flawlessly.

29 Mar 2007, 7:33 PM
#934
ropu avatar

ropu

Zen Follower

Join Date:
Oct 2006
Location:
argentina
Posts:
243
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

BlessIsaacola:

ropu,

I am rolling back to version 1.0.4 so we can at least take advantage of Google Checkout. Our customers are enjoying the free $10 they get from google and there is too much problem with merchant calculated shipping right now.

I ran the responsehandler_test.php which returned less than 1 seconds and yet googlecheckout is still timing out even though it's suppose to work if it's less than 3 seconds.

It would be great the day this mod actually works flawlessly.

hi bless and all
These are the points im planning to release tomorrow

xx/xx/2007 v1.3 (ropu)

  • Add tracking data to the Zencart Admin UI Orders
  • Int'l Shipping
  • Enhanced Tax Features (int'l)
  • Fixed Tax for zones
  • Fixed Tax for products
  • Coupon disabled bug
  • Added coupon zone restriction validation (Based on delivery address, not billing)
  • Added coupon product/category restriction validation

ropu

29 Mar 2007, 8:17 PM
#935
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

ropu:

hi bless and all
These are the points im planning to release tomorrow

xx/xx/2007 v1.3 (ropu)

  • Add tracking data to the Zencart Admin UI Orders
  • Int'l Shipping
  • Enhanced Tax Features (int'l)
  • Fixed Tax for zones
  • Fixed Tax for products
  • Coupon disabled bug
  • Added coupon zone restriction validation (Based on delivery address, not billing)
  • Added coupon product/category restriction validation

ropu

Thanks for the update. We are eagerly awaiting this release so we can test it. I am sure Woody will be happy to see this post :)

Thanks for all the efforts you put into this mod.

29 Mar 2007, 11:17 PM
#936
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Google Checkout module for ZC 1.3.x (beta)

BlessIsaacola:

I am sure Woody will be happy to see this post :) .
You are correct sir! :wink2:

And thanks for the news Ropu. Will be sure to test and report back.

When you have a moment, could you make any recommends on how to go about disabling the ordering of some products with Google Checkout. Specifically, disable the ordering of PDF eBook products through Google Checkout but enable all other products.

How to implement such an idea? Would need to be easy for customer to understand.

DrByte offered this tidbit previously in this thread in response to my post:
http://www.zen-cart.com/forum/showpost.php?p=303620&postcount=378

Woodymon:

Noting that the mod will not be supporting instant downloads anytime soon, can anyone suggest techniques on how to filter out certain products (e.g. downloadables) so they cannot be purchased with GCO. I can post "warning" notes throughout the site and on productInfo and product_listing pages, but I'm hoping for something a bit more elegant.

DrByte:

You'll need something like this:

if ($_SESSION['cart']->content_type == 'virtual') .... blah blah blah ...
> ... during checkout, if this is found to be 'virtual', it indicates that everything in the cart is not defined as a physical product.  eg. only contains GV's or downloads or other virtual items.

I'm a bit clueless on whow to go about implementing such an idea.

Whenever customer clicks Google Checkout on the shopping cart page (or login page), then the order needs validated so no virtual products are in customer shopping cart. 

Order would need to be all physical products to be able to proceed with Google Checkout. So we also need to prevent customer from attempting to submit a "combo" order, that is, part physical product and part virtual product.  

Also need such order validation to occur on Zen Cart side. That is, customer should not have to have to go through most of the Google Checkout process just to find their order is "invalid".

If a virtual product exists in shop cart, then if Google Checkout button is pressed, Zen Cart should provide custom error:

"We're sorry. One or more items currently in your SC cannot be purchased through GC at this time. Please return to your SC and use an alternative payment/checkout method -OR- remove all eBook items from your shop cart then click the GC button again."

As previously stated, we just don't have resources/time to be emailing PDF's. And besides that, customers who order PDF's want to see them now, not wanting to wait for to receive in email.

So until Google Checkout supports Zen Cart download orders in seamless fashion (such as is done with PayPal IPN or most other instant payment methods) we must be able to prevent orders for downloads from being processed through Google Checkout.

Hope you can understand.

Woody
29 Mar 2007, 11:33 PM
#937
tj1 avatar

tj1

Totally Zenned

Join Date:
Mar 2005
Location:
California
Posts:
628
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

I think there's an error in the readme file.
It reads like this:

"In order to provide this support (as required for Level 2 integration), update
the API callback request field in the seller account to
https://<url-site-url>/admin/googlecheckout/responsehandler.php"

I think the correct address should be https://<url-site-url>/googlecheckout/responsehandler.php, correct?

There are few other references in the readme file to 'admin/googlecheckout/'. There's no googlecheckout folder in the admin folder. Am I missing something?

30 Mar 2007, 9:52 PM
#938
tj1 avatar

tj1

Totally Zenned

Join Date:
Mar 2005
Location:
California
Posts:
628
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

ropu:

hi bless and all
These are the points im planning to release tomorrow

xx/xx/2007 v1.3 (ropu)

  • Add tracking data to the Zencart Admin UI Orders
    **- Int'l Shipping **
  • Enhanced Tax Features (int'l)
  • Fixed Tax for zones
  • Fixed Tax for products
  • Coupon disabled bug
  • Added coupon zone restriction validation (Based on delivery address, not billing)
  • Added coupon product/category restriction validation

ropu

That's great, anxiously awaiting.

My technical knowledge is so limited, yet I managed to install the GoogleCheckout module and it works great without any errors. :)

P.S. I think the readme file needs some editing as it has references to folders not used anymore.

30 Mar 2007, 10:43 PM
#939
ropu avatar

ropu

Zen Follower

Join Date:
Oct 2006
Location:
argentina
Posts:
243
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

tj1:

I think there's an error in the readme file.
It reads like this:

"In order to provide this support (as required for Level 2 integration), update
the API callback request field in the seller account to
https://<url-site-url>/admin/googlecheckout/responsehandler.php"

I think the correct address should be https://<url-site-url>/googlecheckout/responsehandler.php, correct?

There are few other references in the readme file to 'admin/googlecheckout/'. There's no googlecheckout folder in the admin folder. Am I missing something?

HI tj

thx for pointing that

already corrected in the docs of v1.3RC1!

ropu

30 Mar 2007, 10:52 PM
#940
ropu avatar

ropu

Zen Follower

Join Date:
Oct 2006
Location:
argentina
Posts:
243
Plugin Contributions:
0

Re: Google Checkout module for ZC 1.3.x (beta)

Author: ropu
Date: Fri Mar 30 15:38:20 2007
New Revision: 46

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:
03/30/2007 v1.3RC1 (ropu)

  • Add tracking data to the Zencart Admin UI Orders
  • Fixed SSL issue with Google Analytics feature
  • International Shipping Features
  • Restricting Shipping Options for Post Office (P.O.) Box Addresses feature
  • International Tax Features
  • Selecting a Rounding Policy for Tax Calculations
  • Fixed Tax for zones
  • Fixed Tax for products
  • Added support for All Areas Zones
  • Coupon disabled bug
  • Added coupon zone restriction validation (Based on delivery address, not billing)
  • Added coupon product/category restriction validation
  • Add a configuration to disable Google Checkout Button when are virtual good in the cart
    (double check http://checkout.google.com/seller/policies.html#4)
  • Disable multisocket Option :(

Ropu