Hi,
I've attached the added_function_for_google_checkout that I as using. Maybe that would help?
Printable View
Hi,
I've attached the added_function_for_google_checkout that I as using. Maybe that would help?
the file is the correct one. but still i cant find where the error is.Quote:
Originally Posted by michelle_rvc
could you provide some more info on the error? how, step by step, to reproduce it, full error response, etc
ropu
I have been getting thsi error message in my google callback error page ........
Your server returned no data in its response; Checkout requires data of type merchant-calculation-results in response to merchant-calculation-callback
what google sends to me is --------------
<?xml version="1.0" encoding="UTF-8"?>
<merchant-calculation-callback xmlns="http://checkout.google.com/schema/2" serial-number="16439351-4dd7-4453-828b-c655a76e1f0d">
<shopping-cart>
<merchant-private-data>
<session-data>4869fb81b0ddd4fcc902e497e4764d0;zenid</session-data>
<product-data>;147</product-data>
<ip-address>68.zzz.yyy.xxx</ip-address>
</merchant-private-data>
<items>
<item>
<quantity>1</quantity>
<unit-price currency="USD">299.95</unit-price>
<item-name>20619 - 7pc Classic Set w/free 8&quot; frypan &amp; free Stack &amp; Steam</item-name>
<item-description></item-description>
<tax-table-selector></tax-table-selector>
</item>
</items>
</shopping-cart>
<buyer-id>12234563</buyer-id>
<calculate>
<addresses>
<anonymous-address id="1112234549972">
<country-code>US</country-code>
<city>Carmel</city>
<region>IN</region>
<postal-code>46033</postal-code>
</anonymous-address>
</addresses>
<merchant-code-strings />
<tax>false</tax>
<shipping>
<method name="Table: Table Rate (vary by weight/price)" />
<method name="UPS: Next Day Air Early AM" />
<method name="UPS: Next Day Air Early AM Letter" />
<method name="UPS: Worldwide Expedited" />
</shipping>
</calculate>
<buyer-language>en_US</buyer-language>
</merchant-calculation-callback>
=======================
I see that this arrives in response_message.log but seems that respondhandler is not responding to it ......
does anyone else see this ..... any clues are helpful ..... thanks
This is what google sandbox tells me when I place an order.Quote:
Originally Posted by ropu
Error: Error parsing XML; message from parser is: Unexpected element (div) encountered: div
Warnings: The namespace of all API requests and postings should be "http://checkout.google.com/schema/2", but this document has: "". Try <div xmlns="http://checkout.google.com/schema/2" ...> for your root element.
XML We Received: <div class="systemError">1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1<br />in:<br />[select products_id, products_weight from products p where products_id in ()]<br /></div>
XML We Sent: <?xml version="1.0" encoding="UTF-8"?>
<merchant-calculation-callback xmlns="http://checkout.google.com/schema/2" serial-number="a8eb5f94-641d-4190-81cc-cb0feaf8c5f9">
<shopping-cart>
<merchant-private-data>
<session-data>f8ea59fda244b925edf63b1a7a885d69;zenid</session-data>
<product-data>;83;45</product-data>
<ip-address>69.128.165.201</ip-address>
</merchant-private-data>
<items>
<item>
<quantity>5</quantity>
<unit-price currency="USD">3.99</unit-price>
<item-name>Robert Kaufman Kona White 42&quot;-45&quot;</item-name>
<item-description></item-description>
<tax-table-selector></tax-table-selector>
</item>
<item>
<quantity>2</quantity>
<unit-price currency="USD">7.49</unit-price>
<item-name>Large Flying Geese</item-name>
<item-description></item-description>
<tax-table-selector></tax-table-selector>
</item>
</items>
</shopping-cart>
<buyer-id>326975014161047</buyer-id>
<calculate>
<addresses>
<anonymous-address id="924377622528329">
<country-code>US</country-code>
<city>Salisbury</city>
<region>NH</region>
<postal-code>03268</postal-code>
</anonymous-address>
</addresses>
<merchant-code-strings />
<tax>false</tax>
<shipping>
<method name="UPS: Next Day Air Early AM" />
<method name="UPS: Next Day Air Early AM Letter" />
<method name="UPS: Worldwide Expedited" />
<method name="USPS: Express Mail" />
<method name="USPS: First-Class Mail" />
<method name="USPS: Priority Mail" />
<method name="USPS: Parcel Post" />
<method name="USPS: Bound Printed Material" />
<method name="USPS: Library" />
</shipping>
</calculate>
<buyer-language>en_US</buyer-language>
</merchant-calculation-callback>
I wonder which version of responsehandler.php are you using? I got very similar errors when I used the file from GldRush98 and I found the reason that I explained in post #472Quote:
Originally Posted by michelle_rvc
(the calculation of $total_weight depends on the merchant-item-id tag which simply does not exist in the actual XML, even though it is mentioned in Google API document.)
I don't know if you may have had the same problem.
Yes, I am using the file from GldRush98 and the updated gco105_zc137 files. When I use any other responsehandler I get the error that I don't ship to that address.Quote:
Originally Posted by dhan99
That address they wouldn't allow you to ship to, is it a US address or a foreign address? I got that "don't ship to that address" error every single time if my ship-to address is non-US. But for US addresses I'm fine (with gco105_zc137 and nothing else).Quote:
Originally Posted by michelle_rvc
Is anyone getting this error in the admin side:
Warning: Invalid argument supplied for foreach() in /admin/includes/functions/extra_functions/added_function_for_google_checkout.php on line 267
saying somethings wrong with the foreach() - it looks good to me.
The problem you're encountering is shown in the "XML We Received" part:Quote:
Originally Posted by michelle_rvc
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
in:
[select products_id, products_weight from products p where products_id in ()]
This SQL string is coming from GldRush98's responsehandler.php line 393:
Prior to line 393, the code is supposed to populate the $item_id_list variable with a list of products id from the merchant-item-id value in the XML- which as dhan99 mentioned a couple posts back, doesn't exist. So $item_id_list just returns nothing (which is why there is nothing in between the parenthesis at the end of the SQL string), which causes your SQL error.Code:$item_weights_result = $db->Execute("select products_id, products_weight from " . TABLE_PRODUCTS . " p where products_id in (" . $item_id_list . ")");
I'm not using GldRush98's responsehandler.php, but perhaps someone else who is using it can help you out.
Shawn
[FONT=Arial]Hi everyone,[/FONT]
[FONT=Arial]I could not get google checkout payment module 1.0.4 option in my 1.3.7 zencart"s admin-modules-payments. I did follow all the instructions but failed again and again.[/FONT]
[FONT=Arial]Please give me a hand/hint. Thanks alot.[/FONT]
As you know, that particular line contains:Quote:
Originally Posted by kebeid
I'd suggest checking the mc_shipping_methods array (starting at line 66 in original GCO 1.0.5) in includes/modules/payment/googlecheckout.php to make sure they're all valid arrays. If you modified them (such as to add/remove shipping methods), it's possible you may have missed a closing parenthesis, a comma or something small like that.Code:foreach($googlepayment->mc_shipping_methods[$select_array[$i]['code']]['domestic_types'] as $method => $method_name) {
Shawn
Give US a hint -Quote:
Originally Posted by Jefflam
How far did you get? What are you seeing? Or not seeing?
But I didn't modify them I just got it from GCO 1.0.5 and installed. Is that b/c I don't have MZMT in the array, could that be the source of the problem?Quote:
Originally Posted by BBG
Pete
It's possible it could be related to specific shipping options you've chosen. I haven't run into your particular error, however, I've only tried to get GCO to work with USPS shipping. So, I guess my next suggestion would be to experiment by removing all the other shipping methods except for Flat Rate (or some shipping method not MZMT) and see if your foreach error goes away. If you haven't done so already, try searching the forum for "foreach", I believe someone else mentioned a foreach error a while back.Quote:
Originally Posted by kebeid
I'm kind of swinging in the dark here, so perhaps someone more knowledgeable or someone who has run into this error before can chime in.
Good luck,
Shawn
this issue was solved with the BBG's help. thanks alot to BBG.Quote:
Originally Posted by Jefflam
Shawn, thanks for your suggestions.
I'm noticing that I get this particular error only when I edit the GCO payment mod in the admin. So I commented that out, but I'm getting the same error from gcheckout on the cart side. I'm also noticing some errors from google when I go into my account so I'll look at that.
One suggested change:
Zencart stores the order total in two places - the orders_total table, and in the orders table in the field order_total. The responsehandler.php file updates the orders_total table just fine, but misses the second place. This make some third-party code (such as super orders) that relies on the order_total field to break.
The fix is in responsehandler.php:
Find the section that looks like:
Just after the 'currency' => "USD", line, add the following line:Code:'ip_address' => $data[$root]['shopping-cart']['merchant-private-data']['ip-address'],
'cc_type' => '',
'cc_owner' => '',
'cc_number' => '',
'cc_expires' => '',
'date_purchased' => 'now()',
'orders_status' => 1,
'currency' => "USD",
'currency_value' => 1);
Then check that your change didn't break anything by going to http://<yoursitehere>/googlecheckout/responsehandler.php, like in the google checkout instructions.Code:'order_total' => $data[$root]['order-total'],
Hi everyone,
ZC 137 + GCO 105
2 problems
(1) Google checkout icon does not appear on the shopping cart page, but shown on login page. after finished login page, ZC checkout to step 2 and there is no payment options there.
(2) PP express checkout added, GCO disappeared
thank you for any hints and points.
jeff
http://fastener-outlet.com
Quote:
Originally Posted by Jefflam
Have you merged the PayPal Express code with the GCO code on the three template files that GCO uses?
See posts 490, 491.
Check that sort order is different for PayPal Express and GCO in Payment Module setup.
And after following chain_man's recommends, keep in mind that both Google Checkout and the new PayPal Express Checkout are not standard Zen Cart checkout procedures.Quote:
Originally Posted by Jefflam
So you will not see either of the two Express Checkout options listed on the "Step 2 - Select Payment Method" page.
But the step 2 page will continue to display standard PayPal IPN payment method (unless you disabled) which completely integrates into Zen Cart's standard checkout process.
- Woody
Thank you, Woody. I solved all the problems except that I still see 2 express checkout (PP & GCO) on the step 2 of 3. Could you tell me how to not show these options in the page step 2 of 3.Quote:
Originally Posted by Woodymon
In the ZC1.3.7 tpl_checkout_payment_default.php, you need to skip the radio button for GCO after line 134:Quote:
Originally Posted by Jefflam
For Paypal it should be fine because the radio button would represent the traditional (non-express) paypal payment. On the other hand, GCO does not have a non-express mode so it will need to be excluded from this page.PHP Code:<?php
$radio_buttons = 0;
for ($i=0, $n=sizeof($selection); $i<$n; $i++) {
// ** GOOGLE CHECKOUT **
if($selection[$i]['id'] == "googlecheckout")
continue;
// ** END GOOGLE CHECKOUT **
?>
Hi everybody,
thank you all of your help. This is the last issue i THINK.
ZC137 + GCO104
I moved fast to the testing GCO now but received 2 errors from https://sandbox.google.com/checkout
1) bad signature on cart
<?xml version="1.0" encoding="UTF-8"?>
<error xmlns="http://checkout.google.com/schema/2" serial-number="824fd998-b770-42fe-905a-edfffa028e9e">
<error-message>Bad Signature on Cart</error-message>
</error>
2) the http get method is invalid to use for sending requests.
<?xml version="1.0" encoding="UTF-8"?>
<error xmlns="http://checkout.google.com/schema/2" serial-number="eeb470d3-6a0d-493d-97c0-9165b2d75234">
<error-message>The Http Get method is invalid to use for sending requests.</error-message>
</error>
I did setup 2 accounts for seller and buyer and activated them for test.
Callback method: name/value pairs; shopping cart type: allow shopping cart with name/value pairs to be sent to google.
Please give me help. Thank you in advance.
http://fastener-outlet.com
a wrong key number was added in the GCO.Quote:
Originally Posted by Jefflam
If you're still having problems, you might want to change the callback method to XML.Quote:
Originally Posted by Jefflam
Just thought I would check back in here today.
I hope the file I posted isn't causing more problems for people.
It looks like it doesn't help most people, but those are changes that had to be made to our file to get it to work as it should and it's working for us, so who knows :)
Some short feedback ..... installed GCO approx 3 weeks ago ..various hiccups with shipping rates but finally arrived at a Zencart 1.3.6 + GCO 1.5 working pretty well
As of today, I am receiving approx 40+ % of my sales as GCO sales, and will save more than $10k this year on card processing fees. Since migrating to ZC + GCO im amazed at how many people prefer to pay with GCO ... wonderful ....keep up the good work to all the folks who's suggestions here helped me to get to this situation.
small pointer : after long discussion with Godaddy , it seems that their $19.95 123 SSL certs DO work with GCO if the full ca-bundle is installed.
Thanks !!
Wishlist suggestion to the GC for ZC mod developers-
Would it be possible to emulate the code employed by the new PayPal Express for ZC mod, to support "downloads" in Google Checkout. That is, send an email to the customer (purchasing the download) containing their shop account login credentials which they can then use to download the files they just purchased? I assume the account name and password are auto-generated by PayPal Express mod?
Please say yes to this idea ;-)
Woody
I'm not sure but I think Jefflam may have been referring to PayPal Express appearing on Step 2 page, not the "traditional" PayPal IPN radio button.Quote:
Originally Posted by dhan99
with ZC1.3.7 and GC 1.0.4, tax is always zero, and, USPS shipping is not working. If I use a differend payment method, the shipping and tax is correct in all cases.
I've deleted and reinstalled GC 1.0.4 to no avail. I have no other mods and not sure what might be wrong.
ideas?
It's good to see some of the major issues with this mod before I install it.
Review this thread starting about page 32. Most of the answers you need are there.Quote:
Originally Posted by reichard
Do you know when GCO module 1.0.5 will exit beta? I am really interested in setting it up on my store once it is officially released. thanksQuote:
Originally Posted by chain_man
I am waiting, as you are, for ropu to have the opportunity to finish it. I'm sure he places his paying work ahead of his efforts on this project.Quote:
Originally Posted by spf
Chainman, in fact my work is doing this projects.Quote:
Originally Posted by chain_man
Im working on a stable version, to avoid the problem we had with the last release. Im fixing several issues regarding merchant calculation, timeouts, and other implementation problems.
Im pretty sure next week ill have good news for all of you.
ropu
Hi ropu,
I installed ZC137 + GCO105 and activated productive USPS but I got the problem.
checkouting with GCO, "shipping and hangdling" shows up some options which are not exactlly specified in the ZC admin-modules-shipping-USPS (all the other options turned off and all GCO's shipping options unchecked), and all the shown amounts are "0" zero. In short, USPS doesn't send data to GCO while GCO shows calculating the amonuts.
Now I uninstalled them and go to install ZC136 and GCO105, trying to make it work like BBG's doing.
jeff
Http://www.fastener-outlet.com
Ropu.. I'd like to tackle a few problems I'm having with the svn version of gco..
1) adwords conversion tracking - I think I did it right but want to run my modification by you..
2) checkout allowing outside of the US addresses for shipping.. now sure what to do there.
Quote:
Originally Posted by Jefflam
i am having the same issue, found this on google's integration page:
"the error we got is: Read timed out Your server must respond faster to merchant calculation callback requests."
any thoughts on how to fix this?
www.strangefamousrecords.com is the site
Question, I added the code for tpl_login_default.php to my template and when I get ready to login I see the grey and white button right under the login section. Why is it their? wouldn't it confuse customers?
The Google Checkout button is a smart button, it changes based on customer state. Assuming that you have everything configured right, if you add something to your shopping cart and go to the login page you will notice that the button changes. You can visit the web in my signature to see the different behavior of this button from login, shopping cart and checkout page.Quote:
Originally Posted by ctcentralinfo
ah.. doh! you need it to be SSL. set that up now, i'll let you know how it progresses.Quote:
Originally Posted by tjthecat3
Isaacola, How'd you get the table rate to work for you in GCO?
Pete
I enabled table rate under shipping in Admin and set up my rate as follows:Quote:
Originally Posted by kebeid
.8:2.49,2:5.99,4:7.99,6:9.99,8:11.99,10:12.99,15:15.99,20:19.99,100:24.99,150:0. 00
Unfortunately, you cannot just use the table for one zone (when using GCO), it doesn't work. We posted a note for our customers during checkout to inform them that table rate and flat rate should only be selected for continental USA. The two customers who either didn't see this or ignored it were refunded since they didn't pay enough for shipping.
Trying to figure out ehy I am getting this error message:
Quote:
Time of occurence: Jan 12, 2007 7:12:35 AM EST
Error: Error parsing XML; message from parser is: Invalid value for
body of tax-table-selector in
checkout-shopping-cart/shopping-cart/items/item: Required
field must not be blank
Warnings: XML failed to validate against the schema at line: 10,
column: 10, with error: cvc-minLength-valid: Value '' with
length = '0' is not facet-valid with respect to minLength '1'
for type 'null'.XML failed to validate against the schema at
line: 10, column: 10, with error: cvc-type.3.1.3: The
value '' of element 'tax-table-selector' is not
valid.
Hi every one, this error arises due to a recent change in Google Checkout system.Quote:
Originally Posted by ctcentralinfo
In a few hours ill post the fix and the problem description.
ropu
Merchants because some of the shopping carts generated might fail to post to Google Checkout due to some of the recent changes in our system.
In particular, Google Checkout now strictly requires a value in the tag <tax-table-selector>. Therefore, if the shopping cart XML contains the tag <tax-table-selector> without a value ( i.e. <tax-table-selector/>), it will not be accepted by Google Checkout anymore.
In order to make sure that your system doesn't fail to post any shopping carts to Google Checkout due to this issue, please ensure that the tag <tax-table-selector> contains a value ( e.g. <tax-table-selector>food</tax-table-selector>) if it's used at all.
If you're currently using the Google Checkout module for osCommerce as your shopping cart software, please follow the instructions below to resolve this issue:
Step 1:
- Open the following file from your Zencart directory for edit: /googlecheckout/gcheckout.php
Step 2:
- Find the following line:
- Replace the above line with the following:PHP Code:if(!in_array($products[$i]['tax_class_id'], $tax_array)) {
Step 3:PHP Code:if(!empty($tt) && !in_array($products[$i]['tax_class_id'], $tax_array)) {
- Find the following line:
- Replace the above line with the following:PHP Code:$gcheck->element('tax-table-selector', $tt);
Step 4:PHP Code:if(!empty($tt)) $gcheck->element('tax-table-selector', $tt);
- Save the changes.
Note: Empty Tax Classes names are NOT valid and will be ignored.
Also have in mind the new sandbox URL, this fix is also added in both version (v1.0.4r and 1.0.5b1) You must uninstall/install GC module to take effect
(have a look to Readme please)
Files are updated at http://code.google.com/p/google-checkout-zencart/ and http://www.zen-cart.com/index.php?ma...roducts_id=314Quote:
Hello,
We'd like to inform you of an upcoming change to the Google Checkout sandbox, the
system that allows you to test your Checkout integration.
On January 17, we're changing the Google Checkout sandbox URL to
sandbox.google.com/checkout. The current URL, sandbox.google.com, will no longer
work after this change takes place. The integration and testing process itself will be
unaffected.
As a reminder, the following URLs will change:
- Checkout buttons: http://sandbox.google.com/checkout/buttons/checkout.gif
- Buyer UI: http://sandbox.google.com/checkout
- Seller UI: http://sandbox.google.com/checkout/sell
- Cart post:
https://sandbox.google.com/checkout/cws/v2/Merchant/[[Merchant-ID]]/checkout
- Command post:
https://sandbox.google.com/checkout/cws/v2/Merchant/[[Merchant-ID]]/request
- Diagnose cart post:
https://sandbox.google.com/checkout/cws/v2/Merchant/[[Merchant-ID]]checkout/diagnose
- Diagnose command post:
https://sandbox.google.com/checkout/cws/v2/Merchant/[[Merchant-ID]]/request/diagnose
If you have any questions about accessing the sandbox , please review our Developer's
Guide at
http://code.google.com/apis/checkout/devel...ration_overview. You
can also contact us at http://checkout.google.com/support/sell/bin/request.py.
Sincerely,
The Google Checkout Team
any questions please feel free to ask.
ropu
created a coupon called "xxxx" on xencart with conditions that coupon is only to be used 1x and can only be used if sale is $100 or more .
If i place a product of less that $100 in my ZC, and use google checkout ..it correctly fetches the coupon upon entering "xxxx" , but it fetches the coupon despite the ZC rules ...... it allows the coupon for any transaction, and it also allws the coupon multiple times for the same customer.
Anyone find the same thing ? Any suggestions
=====================
also ..ship rates for table work ok ..but when we add UPS for certain categories, those ups categories always display as $0 on GCO .. so customers can select 2nd day air at $0 !! had a hard enough time getting table rates to work ...has anyone manged to get UPS rates to work ?
=====================
when we mark a product a shipped in ZC using ty tracker, that is not being transferred back to GCO , so we have double work in going to GCO to mark products as shipped ... is this supposed to work..or is this a known feature that requires completion ?
=====================
has anyone had experience with the "non free" GCO apps for zencart ..do they work better than the free one ..does anyone have any experience with them ?
thanks for the great work guys .....
Thanks Ropu, that did the trick.
I posted about this exact issue a week ago in this thread, where the minimum amount set by the coupon is ignored by GCO.Quote:
Originally Posted by regenbauma
Here's the link to that post: http://www.zen-cart.com/forum/showpost.php?p=310083
Shawn
Isaacola, Thanks for your reply I have it setup the same way you do for the 48 states' zone. but it doesn't show up/shows up as 0 on GCO payment page and I see the same thing in the xml when I had a problem w/xml today (with changing the tax code stuff). I'll keep it on the site for you to try it (its linked to checkout.google.com).
Pete
Can you do me a favor and select None for your zone for the table rate instead of selecting 48 states zone and report back what happens?Quote:
Originally Posted by kebeid
Thanks!
ok.. so i set up SSL for my server, and google is receiving the info just fine. but when i get to the payment page on google checkout, it just reports whatever the numbers are set to in the admin settings for google checkout.. it doesn't actually calculate the postage. can someone please help me out?Quote:
Originally Posted by tjthecat3
Alrighty got that done, and its still not showing the shipping . . .
Did you get an answer to this issue? We are experiencing the same thing all of a sudden.
Thanks, tdslori
Quote:
Originally Posted by issy
Found my own answer...on an osc forum:
Quote:
Merchants because some of the shopping carts generated might fail to post to Google Checkout due to some of the recent changes in our system.
In particular, Google Checkout now strictly requires a value in the tag <tax-table-selector>. Therefore, if the shopping cart XML contains the tag <tax-table-selector> without a value ( i.e. <tax-table-selector/>), it will not be accepted by Google Checkout anymore.
In order to make sure that your system doesn't fail to post any shopping carts to Google Checkout due to this issue, please ensure that the tag <tax-table-selector> contains a value ( e.g. <tax-table-selector>food</tax-table-selector>) if it's used at all.
If you're currently using the Google Checkout module for OsC as your shopping cart software, please follow the instructions below to resolve this issue:
Step 1:
- Open the following file from your OsC directory for edit: /catalog/googlecheckout/gcheckout.php
Step 2:
- Find the following line:
- Replace the above line with the following:Code:if (!in_array($products[$i]['tax_class_id'], $tax_array)) {
Step 3:Code:if (!empty($tt) && !in_array($products[$i]['tax_class_id'], $tax_array)) {
- Find the following line:
- Replace the above line with the following:Code:$gcheck->element('tax-table-selector', $tt);
Step 4:Code:if(!empty($tt)) $gcheck->element('tax-table-selector', $tt);
- Save the changes.
Please! READ the latest post!
I published that same fix for OSC and Zencart
http://www.zen-cart.com/forum/showpo...&postcount=547
fix is also uploaded in the latest download page and google code
http://www.zen-cart.com/index.php?ma...roducts_id=314
http://code.google.com/p/google-checkout-zencart/
ropu
REMINDER: Today sandbox URL will change for good,
https://sandbox.google.com will not be valid, the now url is https://sandbox.google.com/checkout/
Have a look to the latest package in the contribution page. Only googlecheckout/gcheckout.php and includes/modules/payment/googlecheckout.php are modified.
Quick fix:
googlecheckout/gcheckout.php line ~384
change
withPHP Code:if ($srv_mode == 'https://sandbox.google.com/' && $http_mode == 'http') {
andPHP Code:if ($srv_mode == 'https://sandbox.google.com/checkout/' && $http_mode == 'http') {
includes/modules/payment/googlecheckout.php line ~327
change
withPHP Code:$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Select Mode of Operation', 'MODULE_PAYMENT_GOOGLECHECKOUT_MODE', 'https://sandbox.google.com/', 'Select either the Developer\'s Sandbox or live Production environment', '6', '3', 'zen_cfg_select_option(array(\'https://sandbox.google.com/\', \'https://checkout.google.com/\'),',now())");
Those working with production server wont need the fix right now, but if you turn to sandbox it wont work,PHP Code:$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Select Mode of Operation', 'MODULE_PAYMENT_GOOGLECHECKOUT_MODE', 'https://sandbox.google.com/checkout/', 'Select either the Developer\'s Sandbox or live Production environment', '6', '3', 'zen_cfg_select_option(array(\'https://sandbox.google.com/checkout/\', \'https://checkout.google.com/\'),',now())");
IMPORTANT:
To apply this you must Uninstall/Install the Google Checkout module in Admin UI->Modules->Payments->google Checkout
Or for advanced User use PhpMyAdmin and Execute this SQL
Any questions please feel free to askCode:UPDATE `configuration` SET `configuration_value` = 'https://sandbox.google.com/checkout/',
`set_function` = 'zen_cfg_select_option(array(''https://sandbox.google.com/checkout/'', ''https://checkout.google.com/''),' WHERE `configuration_key` = 'MODULE_PAYMENT_GOOGLECHECKOUT_MODE' and `configuration_value` = 'https://sandbox.google.com/';
UPDATE `configuration` SET `configuration_value` = 'ttps://checkout.google.com/',
`set_function` = 'zen_cfg_select_option(array(''https://sandbox.google.com/checkout/'', ''https://checkout.google.com/''),' WHERE `configuration_key` = 'MODULE_PAYMENT_GOOGLECHECKOUT_MODE' and `configuration_value` = 'https://checkout.google.com/';
Ropu
Are you using production or sandbox? Your current Google button doesn't appear to be the current production button unless you've changed something. I am not sure how you have things set up. Do you have the right shipping optin checked on the google configuration page on the admin page?Quote:
Originally Posted by kebeid
I am wondering if someone can help with getting Googlecheckout to calculate tax. It's shows the tax order on order information but it's always zero. Please help if you have googlecheckout calculating tax right.
Thanks!
Ropu, I tried to test your 1.05beta R37... got the following error..Quote:
Originally Posted by ropu
Warning: main(/home/xyzstore/public_html/beta/includes/languages/english/modules/payment/show_google_components.php) [function.main]: failed to open stream: No such file or directory in /home/xyzstore/public_html/beta/Color1/modules.php on line 174
I don't think file "show_google_components.php" should be even in that folder, /includes/languages/english/modules/payment/ Can you help explain this?
BTW, when you expect to release 1.05 this week? thanks
Where can I get the latest beta of this mod?
Here is the svn with the latest versionQuote:
Originally Posted by fc10
http://code.google.com/p/google-checkout-zencart/source
ropu
spf, i do a new update to the SVN.Quote:
Originally Posted by spf
http://google-checkout-zencart.googl...com/svn/trunk/
Files modified are
googlecheckout/gcheckout.php
googlecheckout/responsehandler.php
includes/modules/payment/googlecheckout.php
please send feedback.
ps: ill be on vacations next week, so i wont be answering the forum, but ill be back on mon-29 to resume with the work.
ropu
ropu, it still does not work.. When I access my payment page from admin site, I got the same warnings.. It seems something was broken in the new beta..Quote:
Originally Posted by ropu
He will be back to fix it at the end of the month. I hope he went somewhere warm for vacation. :cool:
You are correct, the file "show_google_components.php" should be in the folder: /includes/modules This is where it is located in the files that ropu linked.Quote:
Originally Posted by spf
ropu,Quote:
Originally Posted by ropu
I tried to put all the files from 1.0.5b1 in place. Here's what I found:
Using USPS shipping still does not work. In addition to missing Media Mail as a shipping option in includes/modules/payment/googlecheckout.php, the amounts transmitted to GCO are the defaults I set in the payment module for GCO. No calculated rates from USPS. I realize this may be hard for you to troubleshoot as you may not have access to the USPS shipping API.
This may be related to an warning message that I got when trying to set up the GCO payment options. I believe it was something like "Warning: Invalid argument in foreach line 267 in gcheckout.php" This message occured with the strictly stock versions of the files you currently have in R38.
I could only get table rates to be included if I did not have a zone selected in the table rate shipping module. Otherwise table rates were not even an option. This works OK in 1.0.4. A few others have reported on this previously.
Ultimately I rolled back googlecheckout/gcheckout.php and
includes/modules/payment/googlecheckout.php to the 1.0.4 versions and used only table rates. I was able to use the 1.0.5b1 files for all the rest (after some modifications to accommodate the PayPal Express features of 1.3.7 zen cart.)
Chain_man, do you have the similar problem? How did you work around it? Or should I move the show_google_components.php to folder includes/languages/english/modules/payment/? ThanksQuote:
Originally Posted by chain_man
spf -Quote:
Originally Posted by spf
I had the same type of error message as you got (in modules.php line 174) when I was mixing up files from different versions. What the problem turned out to be was that the "added_function_for_google_checkout.php" file I had was an older version. When I had all the v1.0.5b1 files in the right places (the same locations as ropu has in the svn), THAT error went away.
trying to get the latest 1.05 from svn working, but now if i click on "google checkout" I get this error:
<error serial-number="2eb681ef-be54-4dce-8936-a3dd81b9104d">
−
<error-message>
Malformed URL component: expected id: (\d{10})|(\d{15}), but got 6403XXXXXXX12
</error-message>
</error>
(X's added intentionally)
Doug,Quote:
Originally Posted by chain_man
I think i am seriously retarded for the SVN stuff.. Do you mean the R38 does not work either? How do I see 1.05B1 code from ropu link? I can only see code under Trunk for Revision 38. Apparently, I am downloading the wrong source code..
OK, spent an hour this morn with the latest SVN and got my USPS shipping calulations and sales tax working! wo-hoooo!!!!
Perhaps this may help some out there:
0. backup mysql table configuration
1. modules->payment->google checkout->remove
2. delete all google checkout configuration keys in table "configuration" :
delete from configuration where configuration_key like "%GOOGLE_CHECKOUT%";
3. upload new SVN files
4. modules->payment->google checkout->install
Also in latest SVN release, comment out line 538 in gcheckout.php:
change this:
<?
print_r($gcheck->getXml());
?>
to:
<?
// print_r($gcheck->getXml());
?>
spf -Quote:
Originally Posted by spf
The R38 code under Trunk is what I'm talking about. You have the right place.
This version still seems to have problems, at least for me.
Reichard, in the post above, solved one of them I didn't mention: XML code appearing at the bottom of the page under the GCO button. My guess is that the Print XML statement was used for troubleshooting and didn't get commented out again the last time.
I get the impression from ropu's post that he still has work to do and that this version is still very much beta.
Tried to do install as suggested by reichard. Same results as indicated in quote. Actual error message during setup of GCO module in admin is:Quote:
Originally Posted by chain_man
Warning: Invalid argument supplied for foreach() in /public_html/admin/includes/functions/extra_functions/added_function_for_google_checkout.php on line 267
Chain Man,
I rechecked my install and I have the base gc1.05 +SVN. I had problems last week with GC1.05 which precipitated a ground-up reinstall (delete everything). I had my admin directory renamed to xxxadminxxx (as per security FAQ), but somewhere the admin directory with files came back.
perhaps you're having a similar issue?
reichard -Quote:
Originally Posted by reichard
I ran into the problem with the renamed admin folder a while back and altered the gcheckout.php file accordingly. The problems I have had with 1.05 are still there. It's not a big deal, so far, as I am only missing having USPS calcs for GCO. And that's only the best shipping option for for my international customers. Table rate, as available in 1.04, is still the best option for most of my buyers.
Quote:
Originally Posted by jacob13moon
hello
i install this addon, but not apear google checkout when purchase a product.
i also use Direct Bank Deposit , Check/Money Order and Paypal IPN with this google checkout module.
i use zencart1.36 and google checkout modul "google-checkout-zencart-v1.0.4r"
help me what is this problem?
I didn't see anything for shipping selection on GCO on the admin side, I'll update GCO with the latest one and let you know what happens.Quote:
Originally Posted by BlessIsaacola
Thanks,
Pete
That did the trick. Now the shipping shows up on GCO's pages. Now doesn't the sandbox respond back to put an order in the zencart admin?
Pete
my problem:Quote:
Originally Posted by kebeid
google checkout not show in my live shop? why?
Sorry if this has been asked and answered but I have been trying to wade through all 59 pages of this thread along with searching it, but haven't found the answer to the issue I am having.
GC's button is huge and appears only on the shopping cart page. It prompts the customer to place an order without creating an account. That's all good and well, but I have to contact them with order updates via zc admin. It's imperative that I am able to communicate with them in this fashion. But if they have not created an account, when I send them an order update email it contains a link to their order that, when clicked, takes them to the login page. Has the issue of the admin order updates being basically useless been addressed already?
Thanks for any input. :D I'm still in the testing phase on my site (live gc but a test cart) so it's not a huge problem, just something I would like to work out if I am going to be able to actually use it.
Other than that issue, it works like a charm.
signs
Am I correct in thinking that google will not show up on step 2 of the checkout page? If so like the poster above is there a fix for that?
There is no fix for GC not showing on step 2. It's against their policy of being an express checkout, not a choice of payment to be mixed in with the rest.
I do have a suggestion for anyone wishing to be able to use the order update feature of zen.
I wrote to support at GC and posed my dilemma of needing to update my customers using ZC but that, since google created the account on the customer's behalf, it's impossible for them to log in to view the order.
Support wrote back asking if there was any way I could create a "generic" password to give GC customers. Well, I have Master Password installed but there's no way I am going to run the security risk of making that known to every GC customer I have, so I came up with this idea...
It's a clunky work around, I'm aware, but if they have no way to log in, then by offering GC we have basically allowed Google to hijack the entire order process and any additional functions of the admin post sales.Quote:
On the order page in admin I can tell if they used GC or not. When I update this order for the first time, I will include the following note:
NOTICE: To log in to view your order on my site please follow these instructions:
1. click the link that says "Forgot your password?" on the login page
2. enter the email address you gave Google Checkout.
A new password will be sent to that email address and you can use this to log in and view your order.
GC doesn't even give the order the same order number as what's on my cart, so I forsee a lot of needless time spent having to play detective and match up GC orders to ZC orders. Frankly, I am too busy for that and depend heavily on the admin features. If I didn't need all the tools in admin I might as well just have an html page with "buy now" buttons. :wacko:
Do you realize that when you update status on Google Checkout, it notifies the customer as well as update Zen Cart admin side so that you don't need to be tracking ZC?Quote:
Originally Posted by signs
Also, if you want google checkout radio button on step 2 you can have it there but it will basically do what the originally button will do. It doesn't work like paypal or regular credit card radio button.
Assuming that your GCO is correctly installed it shows up on page 2. I actually had to manually remove the radio button for GCO on step 2 because when it's there, if the customer selects it they are able to checkout of the store without paying for it :DQuote:
Originally Posted by zyllah
Mine's installed right and works perfectly and the radio button does NOT appear on step 2 in my cart.Quote:
Originally Posted by BlessIsaacola
As to your info about updating orders from GC instead of ZC, I wasn't aware that it updates the cart that way if you are only sending communication emails to the buyer, but that's still having to deal with orders using 2 admins. One for GC and one for all other payment forms. It would be like having to go to Paypal every time I needed to get a message to a customer and update their order. It's just crazy to have to use 2 admins especially since I use it to not only update status, but to converse with customers about their custom orders.
GC doesn't even assign the orders any reference to the ZC order number. The only way you can search orders at GC is by entering a GC order number.
It might be a fee-free checkout option, but personally I would rather pay a tiny per-trasaction fee and be able to use my cart admin the way it was intended...as a central location for all info pertaining to orders. JMHO I'm not giving up the whole function of my site from checkout through post sales management to anyone. Not even google, as much as I love ya. :wink2:
BTW, Great work all, on the efforts put into making it ZC compatible, but I guess I will have to wait until it's out of beta testing and more (admin) user friendly. I have my hands full with the one admin as it is. :D
Isnt it possible just to add a google checkout button to tpl_product_display so it appear on every product? Or is this against google checkout rules?
Was just on google checkout site, and it doesnt appear Zencart is a integrated partner with them? is zencart planning on being one so we can use API??
thanks.
I only offer payment of Google checkout. The problem is when I checkout it allows me pay nothing if I do not selection the google checkout.
That's very strange.
http://www.hotdealspot.net/
Thanks,
Is it strange that I can place an order without any kind of payment?
I only offer payment method of Google checkout. When I checkout it I go normal steps of 1, 2 3 instead of google checkout, then in the step 3 although the payment method is list as Google checkout, and I can confirm the order without any payment.
When I add another payment method: "check/money order", the payment method is stick to "check/money order", and it does not allow me to add Google checkout. This seems reasonalble.
The problem is if I only accept Google checkout. In step 2 of 3, it should disable the continue if the buyer can not pay full amount by Gift Certificates. Can anyone help me out? Thanks
http://www.hotdealspot.net/
Hi all, im back to work, and yes, i was at the beach :DQuote:
Originally Posted by signs
Well, regarding this issue, we can add something so the buyer can know the password of its account, right now is a "random" number, and send it via email. (must double check GC TOS)
Regarding order number and gc order number correlation, a liitle bug at resposehandlder.php in the last update, just add "true" in comments instead of "Google Checkout Order No: 257655093060590
Merchant Calculations used: False "
fix
line 785-786
ropuPHP Code:'comments' => 'Google Checkout Order No: ' . $data[$root]['google-order-number']['VALUE']. "\n" .
'Merchant Calculations used: '. ((@$data[$root]['order-adjustment']['merchant-calculation-successful']['VALUE'] == 'true')?'True':'False')); //Add Order number to Comments box. For customer's reference.
Bless, it supposed that you dont need to do it manually, the module already does thatQuote:
Originally Posted by BlessIsaacola
includes/templates/YOUR_TEMPLATE/templates/tpl_checkout_payment_default.php line 128-130
ropuPHP Code:if (sizeof($selection) > 1) {
if($selection[$i]['id'] == "googlecheckout")
continue;
i have updated the SVN, this revision corrects the quoted issue, and when in the Admin UI->customers->order->"Any GC order" you just Update it with out changing its state (combo besides Status:) with Notify Customer: checked an email with the comment will be sent to the Buyer.Quote:
Originally Posted by ropu
files modified
googlecheckout/responsehandler.php
admin/includes/functions/extra_functions/added_function_for_google_checkout.php
ropu
ps: Also the password for the user is his GC account number. (user is its email, if he uses a google fowarded mail, it will be that one, NOT the original)
ropu
Quote:
Originally Posted by eaglewu
I'm having the same issue. I am trying to use Google Checkout as my sole payment processor as well. Any insight into this would be much appreciated.
:D
Thats a special feature u r asking. I want to know if everything else is working.Quote:
Originally Posted by slugo
if so, we can proceed to do a custom mod for your needs.
ropu
ropu,Quote:
Originally Posted by ropu
I've had this error in the integration:
We encountered an error trying to access your server at https://kebeid.com/googlecheckout/responsehandler.php -- the error we got is: sun.security.validator.ValidatorException: PKIX path validation failed: java.security.cert.CertPathValidatorException: subject/issuer name chaining check failed
I've found it on the forum to be that the SSL cert. was installed incorrectly, and thats what Google says (the hierarchy isn't returned correctly by the responsehandler.php), but my SSL provider says otherwise - that it is installed correctly and my browsers say the same. Can this at all be from responsehandler.php? I'm just wondering because that is the only logical idea I can come up with right now. Thanks for your help!
-Pete
PS responsehandler.php has no probs loading - blank screen and no errors.
Thought I would revisit the GC support thread and see what's happening with the beta testing process. When I observed a recent GC for ZC update was available I became very happy. But then when I see different version numbers I became confused once again ;-)
A. In the ZC Support downloads area I observe:
- Fix _tax-table-selector_ strict validation.
- Update new sandbox url (must uninstall/install module)
googlecheckout/gcheckout.php and includes/modules/payment/googlecheckout.php are the only files modified.
Author: Ropu
Version: 1.0.4r
Zen Cart™ Version: Unknown
Update added on Jan 12 2007
B. But on the Google Code site at
http://google-checkout-zencart.googl...n/trunk/README
shows the following in the README:
11/28/2006 v1.0.5 (ropu)
- Add support for Merchant Calculated Shipping Rates.
- Fixed minor bugs in responsehandler.php and orders.php files
- Change the XML parser and builder
- Removed getallheader() function
- Fixed wrong Qty in Admin UI
- Fixed modules not saving their settings
- Fixed Notify Customer option
- Add state change, Risk and charge notification into the Admin UI
- Add support for coupons
- Fix Shopping cart not obtained from session. See TROUBLE SHOOTING.
01/12/2007 v1.0.5b1 (ropu)
- Fix <tax-table-selector> strict validation.
But the downloads area at
http://code.google.com/p/google-chec...downloads/list
shows:
google-checkout-zencart-v1.0.4r.zip
Google Checkout for Zencart - v1.0.4r
-> DOES ANYONE SEE THE INCONSISTENCY. The latest package in ZC downloads area has the same date as the latest package on Google site. But the version numbers are completely different. :wacko:
I do understand the latest SVN versions (released after 01-12-07) are different from all of the above, but shouldn't the latest non-SVN downloads, with the same date (Jan 12) show the same version number? That would be my thinking.
BTW how do I observe the date of the latest SVN updates? I do not see any date changes in the files. Do I need to run subversion from the shell to retrieve such file date info?
Thanks.
Woody
Can you tell me if this has been implemented yet?Quote:
Originally Posted by ropu
I don't know what version of the responsehandler.php you are referring to, but the one I have doesn't even go to line 785. It ends at line 625. I am using your link in your signature to get to the latest SVN and if that's incorrect please advise. It states last update was 1/12. I am getting the files from this link:Quote:
Regarding order number and gc order number correlation, a liitle bug at resposehandlder.php in the last update, just add "true" in comments instead of "Google Checkout Order No: 257655093060590
Merchant Calculations used: False "
fix
line 785-786
http://google-checkout-zencart.googl...com/svn/trunk/
The mod in the d/l section is date with last revision of 1/12 also. If there is an updated version of this please let me know. I can't even get the sandbox to work with the version I have installed on a fresh zen cart. The logo does not appear and when you click the word "Google" where the logo should be, it gives the browser error message that the page cannot be loaded. (This is in sandbox mode and I suspect that since the sandbox address recently changed, that I am using an outdated version of the necessary files).
Hi Woodymon, is good to see you here again.Quote:
Originally Posted by Woodymon
First, there is no confusion in the versions.
Version 1.0.4 is the one that does NOT support merchant calculations and is more stable.
Version 1.0.5 is the one that DOES support MC but is in beta.
I did an update in BOTH modules, because, as README says, GC server and sandbox had changed (XML rules and Sandbox URL). The idea is to support Both version until v1.0.5 is more stable. Right now only v 1.0.4 is available to download via package (.zip) in ZC download page and code google. But v.1.0.5 is available via SVN at
http://google-checkout-zencart.googlecode.com/svn/trunk/ (Latest Update 19/01/07) This trunk SVN path is for Beta Testing, not latest Stable release
There is also an svn with all versions.
http://google-checkout-zencart.googl.../svn/branches/ (There youll find V1.0.4 too)
To see the latest modification Run an SVN update.
Hope this clear your confusion.
ropu