Google Checkout module for ZC 1.3.x (beta)

[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.

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

[ropu]

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

[BlessIsaacola]

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.

[spf]

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

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

[Gunzanroses]

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.

[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.

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

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

), 

and erase or comment the previous

, 

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

[BlessIsaacola]

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!

[spf]

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

It works! Thanks

[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...

[ropu]

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