Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 2 of 4
Google Checkout Table Rate shipping still not fixed in 1.1.5 (and 1.1.6)!! 
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

not sure i understand what you mean.
this is the entire table dump for the table ‘googlecheckout_api_debug’. i just made another transaction.
it contains 2 google checkout transactions with the following settings;

sandbox: no
secure callback url: yes
debug: yes
new order status: pending
hide cart contents: no

Google Checkout Shipping - Merchant Calculated

Allowed Methods
[tablerate] Standard Expedited Postage

---
google checkout itself within google is configured as suggested in your wiki

sql dump of the 2 tuples:

-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-7
-- http://www.phpmyadmin.net
-- 
-- 
Hostlocalhost
-- Generation TimeOct 162008 at 02:03 PM
-- Server version5.0.32
-- PHP Version5.2.0-8+etch11
-- 
-- 
Database: `magento`
-- 

-- --------------------------------------------------------

-- 
-- 
Table structure for table `googlecheckout_api_debug`
-- 

CREATE TABLE `googlecheckout_api_debug` (
  `
debug_idint(10unsigned NOT NULL auto_increment,
  `
direnum('in','out') default NULL,
  `
urlvarchar(255) default NULL,
  `
request_bodytext,
  `
response_bodytext,
  
PRIMARY KEY  (`debug_id`)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=;

-- 
-- 
Dumping data for table `googlecheckout_api_debug`
-- 

INSERT INTO `googlecheckout_api_debug` (`debug_id`, `dir`, `url`, `request_body`, `response_body`) VALUES 
(1'out''https://checkout.google.com/api/checkout/v2/merchantCheckout/Merchant/xxxxxxxxxx''<?xml version="1.0" encoding="UTF-8"?>\r\n<checkout-shopping-cart xmlns="http://checkout.google.com/schema/2">\n    <shopping-cart>\n        <items>\n            <item>\n                <merchant-item-id><![CDATA[Black-Knob]]></merchant-item-id>\n                <item-name><![CDATA[Premium Chrome Gear Knob]]></item-name>\n                <item-description><![CDATA[]]></item-description>\n                <unit-price currency="GBP">7.1910</unit-price>\n                <quantity>1</quantity>\n                <item-weight unit="LB" value="0.4" />\n                <tax-table-selector>1</tax-table-selector>\n                \n                            <merchant-private-item-data>\n                <quote-item-id>198</quote-item-id>\n            </merchant-private-item-data>\n            </item>\n        </items>\n            <merchant-private-data>\n                <quote-id><![CDATA[168]]></quote-id>\n            </merchant-private-data>\n\n    </shopping-cart>\n    <checkout-flow-support>\n        <merchant-checkout-flow-support>\n            <edit-cart-url><![CDATA[http://www.meanmachines.biz/store/googlecheckout/redirect/cart/]]></edit-cart-url>\n            <continue-shopping-url><![CDATA[http://www.meanmachines.biz/store/googlecheckout/redirect/continue/]]></continue-shopping-url>\n                        <request-buyer-phone-number>false</request-buyer-phone-number>\n                        <merchant-calculations>\n                <merchant-calculations-url><![CDATA[http://www.meanmachines.biz/store/googlecheckout/api/]]></merchant-calculations-url>\n            </merchant-calculations>\n                        <shipping-methods>\n                \n                \n                                        <merchant-calculated-shipping name="Best Way - Standard Expedited Postage">\n                            <address-filters>\n                                <allowed-areas>\n                                    <world-area />\n                                </allowed-areas>\n                            </address-filters>\n                            <price currency="GBP">0</price>\n                        </merchant-calculated-shipping>\n                \n            </shipping-methods>\n                        <tax-tables merchant-calculated="true">\n                \n\n                <!-- default-tax-table>\n                    <tax-rules>\n                        <default-tax-rule>\n                        </default-tax-rule>\n                    </tax-rules>\n                </default-tax-table -->\n\n                <alternate-tax-tables>\n                    <alternate-tax-table name="none" standalone="true">\n                        <alternate-tax-rules>\n                            <alternate-tax-rule>\n                                <tax-area>\n                                    <world-area/>\n                                </tax-area>\n                                <rate>0</rate>\n                            </alternate-tax-rule>\n                        </alternate-tax-rules>\n                    </alternate-tax-table>\n                                            <alternate-tax-table name="2" standalone="true">\n                            <alternate-tax-rules>                                    <alternate-tax-rule>\n                                        <tax-area>\n                                            <us-state-area>\n                                                <state>CA</state>\n                                            </us-state-area>\n                                        </tax-area>\n                                        <rate>0.0825</rate></alternate-tax-rule>                                    <alternate-tax-rule>\n                                        <tax-area>\n                                            <us-state-area>\n                                                <state>NY</state>\n                                            </us-state-area>\n                                        </tax-area>\n                                        <rate>0.08375</rate></alternate-tax-rule>                            </alternate-tax-rules>\n                        </alternate-tax-table>\n                </alternate-tax-tables>\n            </tax-tables>\n            \n                        <platform-id>473325629220583</platform-id>\n                        <analytics-data><![CDATA[X191YWNjdD1VQS00NzM4NTQ1LTE7X191c2Vydj0xO19fdXd2PTQuMztfX3Vmc2M9MTtfX3V0aXRsZT0xO19fdWZsYXNoPTE7X191bWN2YWw9X191dG1hJTNEMTE4NDY2MDY5LjIwMjY3Mjc3Nzg5MzM0ODg2MDAuMTIyNDAwNTYxNS4xMjI0MTAyNDU5LjEyMjQxMTA4MzcuMTAlM0JfX3V0bWIlM0QxMTg0NjYwNjkuMTUxLjEwLjEyMjQxMTA4MzclM0JfX3V0bWMlM0QxMTg0NjYwNjklM0JfX3V0bXolM0QxMTg0NjYwNjkuMTIyNDAwNTYxNS4xLjEudXRtY3NyJTNEJTI4ZGlyZWN0JTI5JTdDdXRtY2NuJTNEJTI4ZGlyZWN0JTI5JTdDdXRtY21kJTNEJTI4bm9uZSUyOSUzQl9fdXRtdiUzRCUzQl9fdXRteCUzRCUzQl9fdXRteHglM0QlM0I7]]></analytics-data>\n        </merchant-checkout-flow-support>\n    </checkout-flow-support>\n    <order-processing-support>\n        <request-initial-auth-details>true</request-initial-auth-details>\n    </order-processing-support>\n</checkout-shopping-cart>''<?xml version="1.0" encoding="UTF-8"?>\r\n<checkout-redirect xmlns="http://checkout.google.com/schema/2" serial-number="165d9cc5-0507-44d0-bf0b-48639150c1a8">\r\n  <redirect-url>https://checkout.google.com/view/buy?o=shoppingcart&amp;shoppingcart=337737886791170</redirect-url>\r\n</checkout-redirect>'),
(
2'out''https://checkout.google.com/api/checkout/v2/merchantCheckout/Merchant/xxxxxxxxxxxxxx''<?xml version="1.0" encoding="UTF-8"?>\r\n<checkout-shopping-cart xmlns="http://checkout.google.com/schema/2">\n    <shopping-cart>\n        <items>\n            <item>\n                <merchant-item-id><![CDATA[2wire-solenoid]]></merchant-item-id>\n                <item-name><![CDATA[2 Wire Solenoid Actuator]]></item-name>\n                <item-description><![CDATA[]]></item-description>\n                <unit-price currency="GBP">3.5910</unit-price>\n                <quantity>1</quantity>\n                <item-weight unit="LB" value="0.3" />\n                <tax-table-selector>1</tax-table-selector>\n                \n                            <merchant-private-item-data>\n                <quote-item-id>202</quote-item-id>\n            </merchant-private-item-data>\n            </item>\n        </items>\n            <merchant-private-data>\n                <quote-id><![CDATA[172]]></quote-id>\n            </merchant-private-data>\n\n    </shopping-cart>\n    <checkout-flow-support>\n        <merchant-checkout-flow-support>\n            <edit-cart-url><![CDATA[http://www.meanmachines.biz/store/googlecheckout/redirect/cart/]]></edit-cart-url>\n            <continue-shopping-url><![CDATA[http://www.meanmachines.biz/store/googlecheckout/redirect/continue/]]></continue-shopping-url>\n                        <request-buyer-phone-number>false</request-buyer-phone-number>\n                        <merchant-calculations>\n                <merchant-calculations-url><![CDATA[http://www.meanmachines.biz/store/googlecheckout/api/]]></merchant-calculations-url>\n            </merchant-calculations>\n                        <shipping-methods>\n                \n                \n                                        <merchant-calculated-shipping name="Best Way - Standard Expedited Postage">\n                            <address-filters>\n                                <allowed-areas>\n                                    <world-area />\n                                </allowed-areas>\n                            </address-filters>\n                            <price currency="GBP">0</price>\n                        </merchant-calculated-shipping>\n                \n            </shipping-methods>\n                        <tax-tables merchant-calculated="true">\n                \n\n                <!-- default-tax-table>\n                    <tax-rules>\n                        <default-tax-rule>\n                        </default-tax-rule>\n                    </tax-rules>\n                </default-tax-table -->\n\n                <alternate-tax-tables>\n                    <alternate-tax-table name="none" standalone="true">\n                        <alternate-tax-rules>\n                            <alternate-tax-rule>\n                                <tax-area>\n                                    <world-area/>\n                                </tax-area>\n                                <rate>0</rate>\n                            </alternate-tax-rule>\n                        </alternate-tax-rules>\n                    </alternate-tax-table>\n                                            <alternate-tax-table name="2" standalone="true">\n                            <alternate-tax-rules>                                    <alternate-tax-rule>\n                                        <tax-area>\n                                            <us-state-area>\n                                                <state>CA</state>\n                                            </us-state-area>\n                                        </tax-area>\n                                        <rate>0.0825</rate></alternate-tax-rule>                                    <alternate-tax-rule>\n                                        <tax-area>\n                                            <us-state-area>\n                                                <state>NY</state>\n                                            </us-state-area>\n                                        </tax-area>\n                                        <rate>0.08375</rate></alternate-tax-rule>                            </alternate-tax-rules>\n                        </alternate-tax-table>\n                </alternate-tax-tables>\n            </tax-tables>\n            \n                        <platform-id>473325629220583</platform-id>\n                        <analytics-data><![CDATA[X191YWNjdD1VQS00NzM4NTQ1LTE7X191c2Vydj0xO19fdXd2PTQuMztfX3Vmc2M9MTtfX3V0aXRsZT0xO19fdWZsYXNoPTE7X191bWN2YWw9X191dG1hJTNEMTE4NDY2MDY5LjIwMjY3Mjc3Nzg5MzM0ODg2MDAuMTIyNDAwNTYxNS4xMjI0MTEwODM3LjEyMjQxNTgwNzYuMTElM0JfX3V0bWIlM0QxMTg0NjYwNjkuOS4xMC4xMjI0MTU4MDc2JTNCX191dG1jJTNEMTE4NDY2MDY5JTNCX191dG16JTNEMTE4NDY2MDY5LjEyMjQxMjc0NjguMTAuMi51dG1jc3IlM0Rnb29nbGUlN0N1dG1jY24lM0QlMjhvcmdhbmljJTI5JTdDdXRtY21kJTNEb3JnYW5pYyU3Q3V0bWN0ciUzRHBldWdlb3QlMjUyMDIwNiUyNTIwd2luZyUyNTIwbWlycm9yJTI1MjBnbGFzcyUyNTIwbWVhbiUyNTIwbWFjaGluZXMlM0JfX3V0bXYlM0QlM0JfX3V0bXglM0QlM0JfX3V0bXh4JTNEJTNCOw==]]></analytics-data>\n        </merchant-checkout-flow-support>\n    </checkout-flow-support>\n    <order-processing-support>\n        <request-initial-auth-details>true</request-initial-auth-details>\n    </order-processing-support>\n</checkout-shopping-cart>''<?xml version="1.0" encoding="UTF-8"?>\r\n<checkout-redirect xmlns="http://checkout.google.com/schema/2" serial-number="5ae81af7-1953-4ea3-9530-b19bf7cce997">\r\n  <redirect-url>https://checkout.google.com/view/buy?o=shoppingcart&amp;shoppingcart=128580071158191</redirect-url>\r\n</checkout-redirect>');
 
Magento Community Magento Community
Magento Community
Magento Community
 
bytestorm
Magento Team
 
Total Posts:  91
Joined:  2008-04-02
 

sandbox: no
secure callback url: yes
<merchant-calculations-url><![CDATA[http://.../store/googlecheckout/api/]]></merchant-calculations-url>

google requires https in merchant calculations url for production use and you have incorrect secure url settings.

please correct https settings in Admin -> Configuration -> General -> Web -> Secure and tell me if your problem persists.

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

booya! that was it.. i hadn’t set the web address to https:// in Admin -> Configuration -> General -> Web
thanks for the help and sorry about the ignorance..

one thing left now - the ‘free shipping’ being applied to google checkout ONLY when an order is above e.g. 50gbp.

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

i just checked and free shipping is being omitted entirely - the customer is only getting the merchant calculated table rate. no free shipping available over the set 50 gbp.
this is almost as crucial as getting table rate working in the first place. please try to squeeze this fix into magento 1.1.7

 
Magento Community Magento Community
Magento Community
Magento Community
 
bytestorm
Magento Team
 
Total Posts:  91
Joined:  2008-04-02
 

yes, currently we have an issue with free shipping in google checkout api and i’m trying to fix it asap
i’ll post a patch here

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

excellent, thanks. it’d be good to get the patch prior to 1.1.7 as 1.1.7 seems to have been pushed back somewhat.
thanks again.

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

will you be posting the patch?
1.1.7 is having many many bugs fixed daily, but even more are being added daily.

a working google checkout would be great! this is holding me back from launching adwords!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Project 14
Jr. Member
 
Avatar
Total Posts:  10
Joined:  2008-09-08
 

I’d love a patch for GCO prior to 1.1.7 too - without it, I have to force people to add a coupon (valid over £50) to discount the postage cost, which isn’t ideal…

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

another day, another 30 bugs added to the to-do list of magento 1.1.7.

Pretty pretty please release the google checkout free shipping fix as I can not launch my marketing initiatives without this fix..
Can’t wait for 1.1.7, but the day it will arrive is getting further and further away..

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

bah, all promises and no cigar.
i’ll do a full scale marketing assault with broken google checkout it seems. not good considering what was promised;

‘yes, currently we have an issue with free shipping in google checkout api and i’m trying to fix it asap
i’ll post a patch here ‘

i am sure you will appreciate we have christmas sales to chase, in which accepting payments correctly is a key issue.
the fix is done, yet the patch has not been posted here. i am disappointed.

 
Magento Community Magento Community
Magento Community
Magento Community
 
bytestorm
Magento Team
 
Total Posts:  91
Joined:  2008-04-02
 

a lot of fixes were made in google checkout and related modules so patching may cause new problems because of old versions of another scripts.
next bugfix release should solve your problems.

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

i guessed as much.
thanks for the update. can’t wait for 1.1.7!

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

i’m afraid to say free shipping still does not work above X amount using google checkout even in Magento 1.1.7.

I have added ‘table rate’ shipping and then ‘free shipping’ in Google Checkout Shipping - Merchant Calculated.
Both Default price: fields are blank.

fyi I am using Google Checkout UK, and this is configured in ‘Location’.

Should I be missing anything, please let me know.

 
Magento Community Magento Community
Magento Community
Magento Community
 
bytestorm
Magento Team
 
Total Posts:  91
Joined:  2008-04-02
 

hi,
just tested google checkout and free shipping on my copy, everything is ok
can you please review these screenshots and tell me where the differences or just post the same screenshots of your settings.

Image Attachments
all ok.gifgoogle settings.gifactions.gifconditions.gif
 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

I have Free Shipping activated in ‘Shipping Methods’ (in the Google API).

Where are you setting the rule ‘free shipping’?  - shopping cart price rules?  Should I understand that I should create a rule there?
Dosn’t that duplicate functionality in Shipping methods - ‘Free Shipping’?

I do not have ‘flat rate’ activated at all - I currently use Table Rate and added the ‘Free Shipping’ to the list of allowed shipping methods in the Google checkout shipping - merchant calculated.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 2 of 4