Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

Offical Google Checkout module for osCommerce Support Thread


1188 replies to this topic

#221 emalrola

  • Community Member
  • 9 posts
  • Real Name:JB

Posted 29 October 2007, 21:33

Security under unix?

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 otsmith1

  • Community Member
  • 35 posts
  • Real Name:neil

Posted 30 October 2007, 20:20

Hello, I hope somebody can help me with this.

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 andy1987

  • Community Member
  • 12 posts
  • Real Name:Andrew Moulton

Posted 30 October 2007, 20:47

Hi there,

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 goody974

  • Validating
  • 59 posts
  • Real Name:wizzy

Posted 31 October 2007, 11:09

For those of you getting the tables not found problem, I discovered that the correct SQL for creating the database entries on installation were commented out in the OSC Contributions version of this script (1.4.5_1)

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 goody974

  • Validating
  • 59 posts
  • Real Name:wizzy

Posted 31 October 2007, 12:03

View Postgoody974, on Oct 31 2007, 11:09 AM, said:

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.
Further to this, looking at the mysql DB the users address book is not being populated with a country. looking at DB > address_book the field "entry_country_id" is set to 0 .

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 mark86w

  • Community Member
  • 14 posts
  • Real Name:marco
  • Gender:Male

Posted 01 November 2007, 16:38

Hello, i have just installed google check out and done as much as i can, it seems that the it works goolge gets all the details and deals with the tranaction but there is no information being sent back to oscommerce i just ran the test document and got the below:

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 gub

  • Community Member
  • 3 posts
  • Real Name:George

Posted 01 November 2007, 20:52

How to set .htaccess file for PHP over CGI?

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 GoTTi

  • Community Member
  • 438 posts
  • Real Name:GoTTi

Posted 04 November 2007, 19:45

View Postpuggybelle, 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 Oscar007

  • Community Member
  • 89 posts
  • Real Name:Oscar

Posted 05 November 2007, 17:06

Hi Guys,

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 gub

  • Community Member
  • 3 posts
  • Real Name:George

Posted 06 November 2007, 04:55

Got it. Thanks to dangermouse (google forum) and wizzy and that thing about googlecheckout.php tables being commented out, I got rid of the 400 errors. It just took me a few days and a few billion new dendrites.

View Postgub, on Nov 1 2007, 08:52 PM, said:

How to set .htaccess file for PHP over CGI?

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 mark86w

  • Community Member
  • 14 posts
  • Real Name:marco
  • Gender:Male

Posted 06 November 2007, 14:25

View PostGoTTi, on Nov 4 2007, 07:45 PM, said:

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?
what i did for a quick fix was to replace the checkout button with a tranparent pixcel so the button wasnt there any more forcing you to checkout wiht google have a look at www.swws.biz/swws1

#232 theantiquestore

  • Community Member
  • 584 posts
  • Real Name:Rachael
  • Gender:Female

Posted 07 November 2007, 04:54

I didnt want to double my code with the ipn contrib so I played with this a little today.

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 zeeshop

  • Community Member
  • 190 posts
  • Real Name:zia

Posted 07 November 2007, 13:28

Hi All,
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 greenberg

  • Community Member
  • 11 posts
  • Real Name:Barani

Posted 07 November 2007, 13:47

What is the easiest way to set a flat-rate shipping costs (e.g. $1) per item?

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 theantiquestore

  • Community Member
  • 584 posts
  • Real Name:Rachael
  • Gender:Female

Posted 07 November 2007, 14:41

View Postzeeshop, on Nov 7 2007, 08:28 AM, said:

Hi All,
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 dstegall

  • Community Member
  • 69 posts
  • Real Name:Dawn
  • Gender:Female
  • Location:Granite City, IL

Posted 07 November 2007, 16:08

I'm looking into Google checkout, I currently use Paypal. I've installed OSC and customized myself and done most contributions as well. I'm not really good with php, just follow instructions and post here with problems. My question is how difficult is the Google checkout contribution? Can I do this myself? Thanks for any input!

Faithfully,

Dawn

#237 greenberg

  • Community Member
  • 11 posts
  • Real Name:Barani

Posted 07 November 2007, 16:30

View Postdstegall, on Nov 7 2007, 04:08 PM, said:

I'm looking into Google checkout, I currently use Paypal. I've installed OSC and customized myself and done most contributions as well. I'm not really good with php, just follow instructions and post here with problems. My question is how difficult is the Google checkout contribution? Can I do this myself? Thanks for any input!

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 Black Dragon

  • Community Member
  • 55 posts
  • Real Name:Loups Garou

Posted 08 November 2007, 16:36

Need some help with this if at all possible? I'm going out of my mind trying to understand why it won't work for the nth time!

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
If at first you don't succeed, try, try, try again...

...Then ask for help!

#239 mark86w

  • Community Member
  • 14 posts
  • Real Name:marco
  • Gender:Male

Posted 08 November 2007, 21:25

google is not very compatable with the shipping moduals what shipping have you got installed, try remvoing them all and just use basic tabel just to see if it works

#240 Black Dragon

  • Community Member
  • 55 posts
  • Real Name:Loups Garou

Posted 09 November 2007, 10:08

Hi,

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! :rolleyes:
If at first you don't succeed, try, try, try again...

...Then ask for help!