Offical Google Checkout module for osCommerce Support Thread
#221
Posted 29 October 2007, 21:33
This is probably a really basic issue, but I have set a unix oscommerce store up and sucessfully (well it works!) integrated googlecheckout. However, I am uneasy about setting the /googlecheckout/response_message.log file to have permissions of 777 - it strikes me anyone can then read it and access names, addresses etc of customers. I am sure I am just ignorant of unix set up, so please can someone help me...
Thanks
#222
Posted 30 October 2007, 20:20
I'm in the UK and have had this GC contribution working perfectly until I added in discount codes from my site.
Reading the Google Checkout halp pages it seems that in the UK, entering the discount as a negative item in the basket is the only way of getting a discouny code into GC.
Anyway, for some reason when the data is passed back to the response handler ready to be inserted into the various tables, the promo code line item seems to stop the process dead. I presume this is down to the negative amount being posted back.
All the values are correct in my GC admin but the SQL with response hanlder stops when it reaches this coupon as a line item. The result is my values are not inserted into order_totals or order_status_history. orders is fully inserted but orders_products is only inserted until it reaches the discount code then it stops.
If my users don't use a promo code, then all the order details are inserted into the database correctly so I can safely assume it is this line item that is the problem.
Help!
#223
Posted 30 October 2007, 20:47
Ihave just installed the Google CheckOut Contribution, hwever i can not modify it from the module menu in the control panel.
I install it which is fine, then when i go to configure it, enter my google id etc etc i get the following error....
"Fatal error: Call to undefined function: gc_cfg_select_shipping() in /data/members/paid/t/h/thevisiononline.co.uk/htdocs/www/admin/modules.php(259) : eval()'d code on line 1"
Any Ideas?
Help is muchly appreciated
Andy
#224
Posted 31 October 2007, 11:09
For the correct working version you should use the following one found at http://code.google.com/p/google-checkout-oscommerce/ (currently 1.4.5_a) which has the correct SQL
Now, maybe someone can help me... ?
I have a UK store and I have noticed that when a user pays with Google Checkout they return back to the store and all of a sudden store prices are calculated without VAT. Checking the users address in the UI it states their country as GB and not united kingdom. When logging in to the admin UI and viewing the order it gives their country as GB and tax is set to 0.0% for each individual item, although tax is added at the end of the page... this means that invoices are incorrect.
Checking the user account details in the admin UI their country is set to Afghanistan (?!?) and my guess is that this is the reason that the tax is set to 0.0%.
How are other people in the UK getting on with this? Is it working correctly for you? Im just wondering if this is something quirky with my OSC installation or if this is coming from google checkout.
#225
Posted 31 October 2007, 12:03
goody974, on Oct 31 2007, 11:09 AM, said:
Checking the user account details in the admin UI their country is set to Afghanistan (?!?) and my guess is that this is the reason that the tax is set to 0.0%.
How are other people in the UK getting on with this? Is it working correctly for you? Im just wondering if this is something quirky with my OSC installation or if this is coming from google checkout.
Note: when doing this whole ordering process without taking the user off site (ie using the default credit card checkout routine) the address is populated just fine, so why with GC does it not populate the country_id?
#226
Posted 01 November 2007, 16:38
XML We Sent: Authorization: Basic XXXXXX:XXXXXX
Content-Type: application/xml;charset=UTF-8
Accept: application/xml;charset=UTF-8
X-Origin-IP: 212.32.115.23
XML We Received: SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
i have a working ssl installed on my server that i have to problems with.
Also anouther question, google is going to be my only payment method but then i click on checkout with out clikcing google button there are no payment methods listed so someone can get throught the checkout with out buying. what i would like to to turn the oscommerce standard checkout button in the the google button to bypass the whole procedure.
i look forward to your reply
regards,
mark
www.swws.biz/swws1
#227
Posted 01 November 2007, 20:52
I'm trying to configure Google checkout, but I don't know how to do Read Me step #4.
4. .htaccess Basic Authentication Mode with PHP over CGI? If your site is
installed on a PHP CGI you must disable Basic Authentication over PHP.
To avoid spoofed messages (only if this feature is enabled) reaching
responsehandler.php, set the .htaccess file with the script linked
(http://your-site/admin/htaccess.php).
I think that's why my sandbox order returns error 400 messages from catalog/googlecheckout/responsehandler.php.
I'm assuming my GoDaddy Linux server is PHP over CGI (I don't know how to tell except for mental telepathy). My OsCommerce site has been running for a year, so I must have done .htaccess before (the memory is gone), but I don't know what 'set' in "set the .htaccess file" means.
What script? Am I creating a new .htaccess in http://your-site/admin/htaccess.php? Not http://your-site/catalog/admin/htaccess.php? Does this file have to have my merchant ID & key or something?
I've searched for days trying to find out how to do this (this forum & Google's). If you could explain it to me or direct me to more detailed instructions, I would be grateful to the point of smiling.
Please fill my empty head.
Thank you.
#228
Posted 04 November 2007, 19:45
puggybelle, on Sep 26 2007, 11:12 PM, said:
why is the google checkout button only showing on the viewcart page and not the payment page?
It's not supposed to show up ANYWHERE other than the shopping cart and the login page.
Google Checkout does not want to be perceived as a payment 'method'....therefore, it is designed to show up ONLY in the shopping cart and login pages.
Look at it this way...it's a checkout method. Rather than click thru screen after screen to go thru normal checkout...one places items in their carts and clicks on Google Checkout...enters their info...and they're done. It's a beautiful thing, really.
just added Google Checkout v1.4 ropu 17 Jul 2007 to our store and i'm wondering if you add a tracking number and change the status from processing to shipped in the osC admin, will this automatically update in the Google Checkout admin?
Yes. That's exactly what should happen. Login to your actual Google Checkout merchant account and view Orders to verify that is what's happening. The status of their order should change in both your website AND in your Merchant account.
is there a way then to make the google checkout button the last thing they see, forcing them to click it instead of goign thru the checkout process?
#229
Posted 05 November 2007, 17:06
I need this Google Checkout mod installed on our UK OSC store as I cannot do it myself
If you can help, please PM me and we can reach an arrangement.
Thanks
#230
Posted 06 November 2007, 04:55
gub, on Nov 1 2007, 08:52 PM, said:
I'm trying to configure Google checkout, but I don't know how to do Read Me step #4.
4. .htaccess Basic Authentication Mode with PHP over CGI? If your site is
installed on a PHP CGI you must disable Basic Authentication over PHP.
To avoid spoofed messages (only if this feature is enabled) reaching
responsehandler.php, set the .htaccess file with the script linked
(http://your-site/admin/htaccess.php).
I think that's why my sandbox order returns error 400 messages from catalog/googlecheckout/responsehandler.php.
#231
Posted 06 November 2007, 14:25
GoTTi, on Nov 4 2007, 07:45 PM, said:
#232
Posted 07 November 2007, 04:54
I found that if you insert this code:
<?php
// ** GOOGLE CHECKOUT **
// Checks if the Google Checkout payment module has been enabled and if so
// includes gcheckout.php to add the Checkout button to the page
if (defined('MODULE_PAYMENT_GOOGLECHECKOUT_STATUS') && MODULE_PAYMENT_GOOGLECHECKOUT_STATUS == 'True') {
include_once('googlecheckout/gcheckout.php');
}
// ** END GOOGLE CHECKOUT **
?>
into your checkout_payment.php it will work for checkout. I created separate tables, moved the continue button into the table which houses my money order checkout so those who want to send a check will continue through my regular checkout, and I created another table (infobox) and added text for google checkout (ie: Would you like to pay with a credit or debit card? and Continue credit card payment via google checkout) before the button. This way buyers still have a choice during checkout (I only offer google and the money order checkout) if they didnt use the button in the cart, now they are certainly aware that if they want to pay with a credit card, they'll have to use google checkout without being that obvious. Just be careful about that </form> code, you'll need to move it above your google checkout button.
I have the button in both the cart and the checkout_payment page now and they work perfectly fine and I am not violating any of googles rules since buyers dont have to create an account to use it, but if they ignore the button in the cart and login pages, they'll have yet another chance to use it in my onsite checkout.
I also discovered that you can make the google checkout button smaller by replacing "large" with "small" or "medium" in googlecheckout/library/googlecart.php. there were several places I replaced it, I didnt take the time to see which one actually worked, just changed them all (except, did not change any of the "case "large":" ones). Just wanted to share a tip in case anyone was looking to do the same. Feel free to expand on that if you do figure out which one actually changed it in the cart for those here who dont want to change them all.
I would have wrote it up with instructions and a contrib, but I just dont have the time, sorry.
#233
Posted 07 November 2007, 13:28
Website running on Oscommerce 2.2
Until now I am using
Google Checkout v1.3RC2 rev2 (By Ropu)
Now Most of time when customer reach to Google wesite for payment Google doesnot show right or sometime no price at all for Shipping.
I just saw new version v1.4.5a with Carrier Calculated Shipping By Ropy Released on 02nd October 2007.
Please advise me Upgrade Procedure, or if I have to remove it please advise whare are Steps to remove and upgrade to new one.
Regards
Zee
#234
Posted 07 November 2007, 13:47
Problem is, the module--payment-gco- shows
-------
"
Default Values for Real Time Shipping Rates
Default values for real time rates in case the webservice call fails.
Set Default Value to 0 to disable the method
Shipping Generator
No merchant calculation shipping selected"
-----
There is no option to enable/disable or set any value.
I used the shipping_generator, generated a code, copied to shipping_generator.php
and there is no change on the above display.
I don't want to use any of those "domestic" "international" "fedex" "UPS" whatever.
I want the simplest shipping cost per item (e.g. $1) passed to google for
tallying to the subtotal. Right now it shows "--" in google sandbox and doesn't move
past that screen.
Thank you for all pointers.
#235
Posted 07 November 2007, 14:41
zeeshop, on Nov 7 2007, 08:28 AM, said:
Website running on Oscommerce 2.2
Until now I am using
Google Checkout v1.3RC2 rev2 (By Ropu)
Now Most of time when customer reach to Google wesite for payment Google doesnot show right or sometime no price at all for Shipping.
I just saw new version v1.4.5a with Carrier Calculated Shipping By Ropy Released on 02nd October 2007.
Please advise me Upgrade Procedure, or if I have to remove it please advise whare are Steps to remove and upgrade to new one.
Regards
Zee
I used to have that one too, I just went through the instructions backwards and removed all the previous code so I could start fresh with the most recent update.
#236
Posted 07 November 2007, 16:08
Faithfully,
Dawn
#237
Posted 07 November 2007, 16:30
dstegall, on Nov 7 2007, 04:08 PM, said:
Faithfully,
Dawn
Since you already have customized OSC files, you need to manually
edit several files for google checkout implementation. While those
are not hard to do, other related support for google checkout
implementation appear severely lacking in details and even tiny
misteps owing to poorly designed instruction set cause agony for
lengthy durations. The error messages are poorly documented with
solutions.
However, my impression is, after setting it up it may be easier
than PayPal for customers.
If your shop is already open for business, the pain level might be
even greater than just setting it up.
#238
Posted 08 November 2007, 16:36
I installed the newest version as found on Google's site; v1.4.5
It works, after a fashion, via the Sandbox, but I have several problems:
1) It doesn't add postage costs
2) When I try and generate postage costs I get a load of code warnings:
Warning: shipping::include(includes/languages/english/modules/shipping/gCheckout_flat.php) [function.shipping-include]: failed to open stream: No such file or directory in /home/blackdra/public_html/includes/classes/shipping.php on line 36 Warning: shipping::include(includes/languages/english/modules/shipping/gCheckout_flat.php) [function.shipping-include]: failed to open stream: No such file or directory in /home/blackdra/public_html/includes/classes/shipping.php on line 36 Warning: shipping::include() [function.include]: Failed opening 'includes/languages/english/modules/shipping/gCheckout_flat.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/blackdra/public_html/includes/classes/shipping.php on line 36 Warning: shipping::include(includes/languages/english/modules/shipping/gCheckout_item.php) [function.shipping-include]: failed to open stream: No such file or directory in /home/blackdra/public_html/includes/classes/shipping.php on line 36 Warning: shipping::include(includes/languages/english/modules/shipping/gCheckout_item.php) [function.shipping-include]: failed to open stream: No such file or directory in /home/blackdra/public_html/includes/classes/shipping.php on line 36 Warning: shipping::include() [function.include]: Failed opening 'includes/languages/english/modules/shipping/gCheckout_item.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/blackdra/public_html/includes/classes/shipping.php on line 36
And, although it shows the shipping options (Royal Mail First Class etc) all the values are set at 0. Is this supposed to happen?
3) In my admin panel I get more code in "Payment Modules":
Warning: include(/home/blackdra/public_html/includes/languages/english/modules/payment/gCheckout.php) [function.include]: failed to open stream: No such file or directory in /home/blackdra/public_html/admin/modules.php on line 152 Warning: include() [function.include]: Failed opening '/home/blackdra/public_html/includes/languages/english/modules/payment/gCheckout.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/blackdra/public_html/admin/modules.php on line 152
And under "Shipping":
Warning: include(/home/blackdra/public_html/includes/languages/english/modules/shipping/gCheckout_flat.php) [function.include]: failed to open stream: No such file or directory in /home/blackdra/public_html/admin/modules.php on line 152 Warning: include() [function.include]: Failed opening '/home/blackdra/public_html/includes/languages/english/modules/shipping/gCheckout_flat.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/blackdra/public_html/admin/modules.php on line 152 Warning: include(/home/blackdra/public_html/includes/languages/english/modules/shipping/gCheckout_item.php) [function.include]: failed to open stream: No such file or directory in /home/blackdra/public_html/admin/modules.php on line 152 Warning: include() [function.include]: Failed opening '/home/blackdra/public_html/includes/languages/english/modules/shipping/gCheckout_item.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/blackdra/public_html/admin/modules.php on line 152
4) And finally on the "What's In My Cart?" section of my store:
Warning: include_once(/home/blackdra/public_html/includes/languages/english/modules/shipping/gCheckout_flat.php) [function.include-once]: failed to open stream: No such file or directory in /home/blackdra/public_html/googlecheckout/gcheckout.php on line 344 Warning: include_once() [function.include]: Failed opening '/home/blackdra/public_html/includes/languages/english/modules/shipping/gCheckout_flat.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/blackdra/public_html/googlecheckout/gcheckout.php on line 344 Warning: include_once(/home/blackdra/public_html/includes/languages/english/modules/shipping/gCheckout_item.php) [function.include-once]: failed to open stream: No such file or directory in /home/blackdra/public_html/googlecheckout/gcheckout.php on line 344 Warning: include_once() [function.include]: Failed opening '/home/blackdra/public_html/includes/languages/english/modules/shipping/gCheckout_item.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/blackdra/public_html/googlecheckout/gcheckout.php on line 344
I've tried searching for a solution, but I can't seem to find any! Any advice would be grately appreciated!
Cheers,
Loups
...Then ask for help!
#239
Posted 08 November 2007, 21:25
#240
Posted 09 November 2007, 10:08
Thanks for the reply. I've got UK Shipping Methods installed. I did have the Estimated Shipping contrib as well, but I removed it. At least, I removed all the bits I could find!
...Then ask for help!














