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 1 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
 

The title says it all.. when will Table Rate shipping with Google Checkout finally get fixed in Magento?

I hit GOOGLE CHECKOUT and shipping is at 0 as always..

Serge at Varien was working on a solution and tracked the bugs down, promised a fix would be included in the next release, yet here it is and it STILL does not work.. this is a CRUCIAL FUNDAMENTAL feature, which should get very high priority!

Has anyone gotten this to work?!

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

This long thread has been tracking this problem. Serge from Varien has been attempting to resolve this.

http://www.magentocommerce.com/boards/viewthread/5960/P90/#t51116

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

Hi,
please try applying this patch onto your app/code/core/Mage/GoogleCheckout/Model/Api/Xml/Callback.php.
And please tell me if your problem still exists.

File Attachments
Callback.php.txt  (File Size: 2KB - Downloads: 426)
 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

how do I apply the patch?
I have just done a fresh install of 1.1.6 which claims to have fixed Google Checkout Table rate.. still no joy - shows 0. :(

 
Magento Community Magento Community
Magento Community
Magento Community
 
mikefifield
Member
 
Avatar
Total Posts:  49
Joined:  2008-05-24
 

I have the same issue Google checkout is showing 0.0 for table rate shipping after upgrading to 1.1.6

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

Hi all,
Do you have proper prices for table rates in one page checkout?

 
Magento Community Magento Community
Magento Community
Magento Community
 
mikefifield
Member
 
Avatar
Total Posts:  49
Joined:  2008-05-24
 

Thanks for the response:) Yes the table rate prices are showing up correctly in onepage checkout, just not in google checkout.

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

Please enable ‘Debug’ option in Google Checkout settings and give me all the records that are being stored during test checkout.
Actually i have table rates on my dev store and everything seems to be ok. I can’t understand what’s wrong there.

EDIT: remember to remove confidential information (merchant ID etc) from request/response sequences =)

 
Magento Community Magento Community
Magento Community
Magento Community
 
mikefifield
Member
 
Avatar
Total Posts:  49
Joined:  2008-05-24
 

Here is the Debug info dump, looks like it is still sending the unsecure url for “merchant-calculations”.

INSERT INTO `magento_googlecheckout_api_debug` (`debug_id`, `dir`, `url`, `request_body`, `response_body`) VALUES
(1'out''https://checkout.google.com/api/checkout/v2/merchantCheckout/Merchant/xxxxx''<?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[1]]></merchant-item-id>\n                <item-name><![CDATA[TEST item]]></item-name>\n                <item-description><![CDATA[]]></item-description>\n                <unit-price currency="USD">230.0000</unit-price>\n                <quantity>1</quantity>\n                <item-weight unit="LB" value="25" />\n                <tax-table-selector>2</tax-table-selector>\n                \n                            <merchant-private-item-data>\n                <quote-item-id>281</quote-item-id>\n            </merchant-private-item-data>\n            </item>\n        </items>\n            <merchant-private-data>\n                <quote-id><![CDATA[213]]></quote-id>\n            </merchant-private-data>\n\n    </shopping-cart>\n    <checkout-flow-support>\n        <merchant-checkout-flow-support>\n            <edit-cart-url><![CDATA[https://www.domain.com/googlecheckout/redirect/cart/]]></edit-cart-url>\n            <continue-shopping-url><![CDATA[https://www.domain.com/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.domain.com/googlecheckout/api/]]></merchant-calculations-url>\n            </merchant-calculations>\n                        <shipping-methods>\n                \n                \n                                        <merchant-calculated-shipping name="Best Way - Table Rate">\n                            <address-filters>\n                                <allowed-areas>\n                                    <postal-area><country-code>CA</country-code></postal-area>\n<postal-area><country-code>VI</country-code></postal-area>\n<postal-area><country-code>US</country-code></postal-area>\n<postal-area><country-code>UM</country-code></postal-area>\n\n                                </allowed-areas>\n                            </address-filters>\n                            <price currency="USD">20</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[xxxxxxxx]]></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="af3287d1-b824-4f27-9a84-b4a6448bcd35">\r\n  <redirect-url>https://checkout.google.com/view/buy?o=shoppingcart&amp;shoppingcart=xxxxxxxx</redirect-url>\r\n</checkout-redirect>');
 
Magento Community Magento Community
Magento Community
Magento Community
 
bytestorm
Magento Team
 
Total Posts:  91
Joined:  2008-04-02
 

hmm… try to enable ‘Secure Callback URL’ option in Google Checkout configuration section (it’s required for production use)
hope this helps…
but if your problem persists - please tell me, i’ll investigate it one more time…

 
Magento Community Magento Community
Magento Community
Magento Community
 
Yosuke
Jr. Member
 
Total Posts:  3
Joined:  2008-08-23
 

But, for “Secure Callback URL,” you are supposed to have SSL, right(especially for production)?

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

@Yosuke, only production version requires this option to be enabled. sandbox works ok without this one.
yes, you need ssl…
also google _requires_ ssl url for merchant calculations and new order notifications in production environment

 
Magento Community Magento Community
Magento Community
Magento Community
 
mikefifield
Member
 
Avatar
Total Posts:  49
Joined:  2008-05-24
 

@bytestorm Thanks for the help. Enabling secure callback fixed it. I had this enabled before the update so didn’t even think to double check it. Thanks again!

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

well for me it is still not working. table rate is simply not showing up in google checkout. always showing 0.
onepage checkout is showing correct rates, yes. paypal payments are working perfectly with the correct postage amounts, yes.
Secure Callback URL is set, yes. i am not in a sandbox environment.

from what i can see below, google is being fed 0 by magento as a shipping amount.
i do not know why it is passing the amount in LBS as i have it set up in kg (at least i thought this is the default weight unit)

dump follows;

url:

https://checkout.google.com/api/checkout/v2/merchantCheckout/Merchant/xxxxxxxxx

request body:

<?xml version="1.0" encoding="UTF-8"?>
<checkout-shopping-cart xmlns="http://checkout.google.com/schema/2">
    <
shopping-cart>
        <
items>
            <
item>
                <
merchant-item-id><![CDATA[Black-Knob]]></merchant-item-id>
                <
item-name><![CDATA[Premium Chrome Gear Knob]]></item-name>
                <
item-description><![CDATA[]]></item-description>
                <
unit-price currency="GBP">7.1910</unit-price>
                <
quantity>1</quantity>
                <
item-weight unit="LB" value="0.4" />
                <
tax-table-selector>1</tax-table-selector>
                
                            <
merchant-private-item-data>
                <
quote-item-id>198</quote-item-id>
            </
merchant-private-item-data>
            </
item>
        </
items>
            <
merchant-private-data>
                <
quote-id><![CDATA[168]]></quote-id>
            </
merchant-private-data>

    </
shopping-cart>
    <
checkout-flow-support>
        <
merchant-checkout-flow-support>
            <
edit-cart-url><![CDATA[http://www.meanmachines.biz/store/googlecheckout/redirect/cart/]]></edit-cart-url>
            
<continue-shopping-url><![CDATA[http://www.meanmachines.biz/store/googlecheckout/redirect/continue/]]></continue-shopping-url>
                        
<request-buyer-phone-number>false</request-buyer-phone-number>
                        <
merchant-calculations>
                <
merchant-calculations-url><![CDATA[http://www.meanmachines.biz/store/googlecheckout/api/]]></merchant-calculations-url>
            
</merchant-calculations>
                        <
shipping-methods>
                
                
                                        <
merchant-calculated-shipping name="Best Way - Standard Expedited Postage">
                            <
address-filters>
                                <
allowed-areas>
                                    <
world-area />
                                </
allowed-areas>
                            </
address-filters>
                            <
price currency="GBP">0</price>
                        </
merchant-calculated-shipping>
                
            </
shipping-methods>
                        <
tax-tables merchant-calculated="true">
                

                <!-- default-
tax-table>
                    <
tax-rules>
                        <default-
tax-rule>
                        </default-
tax-rule>
                    </
tax-rules>
                </default-
tax-table -->

                <
alternate-tax-tables>
                    <
alternate-tax-table name="none" standalone="true">
                        <
alternate-tax-rules>
                            <
alternate-tax-rule>
                                <
tax-area>
                                    <
world-area/>
                                </
tax-area>
                                <
rate>0</rate>
                            </
alternate-tax-rule>
                        </
alternate-tax-rules>
                    </
alternate-tax-table>
                                            <
alternate-tax-table name="2" standalone="true">
                            <
alternate-tax-rules>                                    <alternate-tax-rule>
                                        <
tax-area>
                                            <
us-state-area>
                                                <
state>CA</state>
                                            </
us-state-area>
                                        </
tax-area>
                                        <
rate>0.0825</rate></alternate-tax-rule>                                    <alternate-tax-rule>
                                        <
tax-area>
                                            <
us-state-area>
                                                <
state>NY</state>
                                            </
us-state-area>
                                        </
tax-area>
                                        <
rate>0.08375</rate></alternate-tax-rule>                            </alternate-tax-rules>
                        </
alternate-tax-table>
                </
alternate-tax-tables>
            </
tax-tables>
            
                        <
platform-id>473325629220583</platform-id>
                        <
analytics-data><![CDATA[X191YWNjdD1VQS00NzM4NTQ1LTE7X191c2Vydj0xO19fdXd2PTQuMztfX3Vmc2M9MTtfX3V0aXRsZT0xO19fdWZsYXNoPTE7X191bWN2YWw9X191dG1hJTNEMTE4NDY2MDY5LjIwMjY3Mjc3Nzg5MzM0ODg2MDAuMTIyNDAwNTYxNS4xMjI0MTAyNDU5LjEyMjQxMTA4MzcuMTAlM0JfX3V0bWIlM0QxMTg0NjYwNjkuMTUxLjEwLjEyMjQxMTA4MzclM0JfX3V0bWMlM0QxMTg0NjYwNjklM0JfX3V0bXolM0QxMTg0NjYwNjkuMTIyNDAwNTYxNS4xLjEudXRtY3NyJTNEJTI4ZGlyZWN0JTI5JTdDdXRtY2NuJTNEJTI4ZGlyZWN0JTI5JTdDdXRtY21kJTNEJTI4bm9uZSUyOSUzQl9fdXRtdiUzRCUzQl9fdXRteCUzRCUzQl9fdXRteHglM0QlM0I7]]></analytics-data>
        </
merchant-checkout-flow-support>
    </
checkout-flow-support>
    <
order-processing-support>
        <
request-initial-auth-details>true</request-initial-auth-details>
    </
order-processing-support>
</
checkout-shopping-cart>

response_body:

<?xml version="1.0" encoding="UTF-8"?>
<checkout-redirect xmlns="http://checkout.google.com/schema/2" serial-number="165d9cc5-0507-44d0-bf0b-48639150c1a8">
  <
redirect-url>https://checkout.google.com/view/buy?o=shoppingcart&amp;shoppingcart=337737886791170</redirect-url>
</checkout-redirect>

i need this resolved, DESPARATELY. please assist!

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

also, free shipping over 50 gbp is not working as magento is straight up giving the buyer the option to have table rate shipping or free shipping, even when the order is below the set 50 gbp.
again, all this works fine with paypal.

google checkout is broken, please resolve asap.

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

@alex.bsc,
please give me also request/response sequences from your debug table
that are marked with ‘merchant-calculation-callback’ url and are related to your table rate test checkout.

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