1175 replies to this topic

[rkoechel2004]

parma, on Nov 13 2007, 03:53 PM, said:

Ok you can ignore most of my previous post. I have configured all the shipping options. The only problem remaining is the free shipping option. Has anyone managed to get this working?

Thanks

I just uploaded to the contributions section a new free amount package that adds the tax class and works with google checkout.

here is the link: http://addons.oscommerce.com/info/146

-Ryan

[rkoechel2004]

I can't seem to get the code on login.php working correctly with purchase without account. Does anyone have these two working together correctly?

Thanks for any help

[hotcup]

mark86w, on Nov 6 2007, 02:25 PM, said:

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

Nice trick. I tried doing this and the Google Checkout button takes me right back to the shopping cart page. The button from the code in login.php does work, however. Anyone run into this problem?

[reazson]

I opened up a new Google Checkout account.

What do I have to change in the googlecheckout.php in order for it to work with my new account?

thanks

[ahmetbuba]

Hello,

I've a problem with Google Checkout impelemtation.
I've successfully installed gc module and "gc button" appears on shopping_card.php and post all information to gc if i press then i can make payment... but problem starts here, it does not notify osc about gc succesfull order... and order never appears on admin page.


how can i fix this?

[virtualbum]

OK, so here's a fun one.

I have installed RC1 with GC 1.4.5a

I have also installed Simple Template System (STS) ver. 4.5.8

In a sandbox environment GC works as expected when STS is not in use.

When STS is enabled, upon completion of checkout and returning to the site, I get the following error from gc_return.php

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 ') and pd.products_id = p.products_id and pd.language_id = '1'' a

select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id in () and pd.products_id = p.products_id and pd.language_id = '1'

[TEP STOP]

There are no errors in GC sandbox tools->integration console.

There are no errors in the logs.

User gets created and order gets back to OSC.

Do I have to use gc_return.php to finalize the emptying of the cart? If I use checkout_success.php the cart does not empty.

If I disable STS the error goes away.

I found a reply from Ropu a while back that talked about $data being changed to $gc_data to eliminate some conflicts.

Does anyone else know of what may be causing this issue?

Any help would be greatly appreciated.

Thanks in advance,

-Jim

If I find an answer I will post it here......

[ATise]

I have installed the gogle checkout. But since I have done it so late in the day I will have to wait until Monday to find out what my banks number is to install on googles site. But I don't think this is what is causing my problem.

When I go to look at the response_error.log I get the following message:

Warning: googlecheckout(/www.mysite.com/catalog/googlecheckout//googlecheckout/shipping_methods.php): failed to open stream: No such file or directory in /www.mysite.com/catalog/includes/modules/payment/googlecheckout.php on line 44

Warning: googlecheckout(/www.mysite.com/catalog/googlecheckout//googlecheckout/shipping_methods.php): failed to open stream: No such file or directory in /www.mysite.com/catalog/includes/modules/payment/googlecheckout.php on line 44

Fatal error: googlecheckout(): Failed opening required '/www.mysite.com/catalog/googlecheckout//googlecheckout/shipping_methods.php' (include_path='.:/usr/local/lib/php:.:.') in /www.mysite.com/catalog/includes/modules/payment/googlecheckout.php on line 44



How do I track this down to reslove the problem?

Edited by ATise, 01 December 2007, 23:47.

[johnr3]

help please! i've been developing a new site for a while and it was using google checkout 1.3 - everything was fine but tonight i decided to update to 1.4.5. i got as far as 1.4 and i "removed" the module in admin, but now when i try to put it back I get an error. I even went back to my backup of the site using 1.3 and it still says the same :-

1044 - Access denied for user 'user'@'localhost' to database 'database'

ALTER TABLE configuration CHANGE `configuration_value` `configuration_value` TEXT NOT NULL

[TEP STOP]

any advice please! how can I at least get back to a working installation!

trying to remove or install other modules works fine.

thanks
john

Edited by johnr3, 02 December 2007, 00:30.

[johnr3]

johnr3, on Dec 2 2007, 01:21 AM, said:

help please! i've been developing a new site for a while and it was using google checkout 1.3 - everything was fine but tonight i decided to update to 1.4.5. i got as far as 1.4 and i "removed" the module in admin, but now when i try to put it back I get an error. I even went back to my backup of the site using 1.3 and it still says the same :-

1044 - Access denied for user 'user'@'localhost' to database 'database'

ALTER TABLE configuration CHANGE `configuration_value` `configuration_value` TEXT NOT NULL

[TEP STOP]

any advice please! how can I at least get back to a working installation!

trying to remove or install other modules works fine.

thanks
john

Answering my own question here but removing the following line from the install function of /admin/modules.php made it work (line 230)

//tep_db_query("ALTER TABLE ". TABLE_CONFIGURATION ." CHANGE `configuration_value` `configuration_value` TEXT NOT NULL");

No idea why this line is causing the problem or whether it is bad to remove it?

thanks
John

[virtualbum]

virtualbum, on Nov 30 2007, 07:25 PM, said:

OK, so here's a fun one.

I have installed RC1 with GC 1.4.5a

I have also installed Simple Template System (STS) ver. 4.5.8

In a sandbox environment GC works as expected when STS is not in use.

When STS is enabled, upon completion of checkout and returning to the site, I get the following error from gc_return.php

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 ') and pd.products_id = p.products_id and pd.language_id = '1'' a

select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id in () and pd.products_id = p.products_id and pd.language_id = '1'

[TEP STOP]

There are no errors in GC sandbox tools->integration console.

There are no errors in the logs.

User gets created and order gets back to OSC.

Do I have to use gc_return.php to finalize the emptying of the cart? If I use checkout_success.php the cart does not empty.

If I disable STS the error goes away.

I found a reply from Ropu a while back that talked about $data being changed to $gc_data to eliminate some conflicts.

Does anyone else know of what may be causing this issue?

Any help would be greatly appreciated.

Thanks in advance,

-Jim

If I find an answer I will post it here......

After many hours of research I have discovered that with the template system (STS 4.5.8) turned on, you cannot use the gc_return.php file that Google Checkout provides. Although calling that file works great in a standard osCommerce install, you have to use the checkout_success.php file to return to the site. While in a stock install, this file (checkout_success.php) does not empty the shopping cart after a successful checkout with google checkout - so you have to us gc_return.php - checkout_success.php works just fine with STS 4.5.8 enabled.

Best Regards,

-Jim

[markross]

I have just installed a fresh copy of osCommerce and installed the Google Checkout module v1.4.5_CCS. It appears fine in the backend and I have entered all the relevent settings. However Google Checkout does not appear as a payment option in the store frontend. Am I doing something wrong? I am completely new to osCommerce, so I may have omitted to do something to enable it. Any help or guidance would be much appreciated. Thanks.

[goody974]

Hi

Can anyone tell me if they have this working correctly on a UK store?

For some reason when the order comes back to OSC it is put correctly in the database, but the item line doesnt include tax, so the price says price inc, price exc, total inc and total exc all at the same value, with the tax set to 0.00% (this is on the orders.php page in OSC admin) . However tax is added to the order with the subtotals and totals.

I can get around this by putting "All countries" into the european tax zone and taking it out of the rest of the world zone, but this is obviously incorrect as every country then gets charged VAT.

Any help anyone can give would be really appreciated.

Tony

Edited by goody974, 07 December 2007, 13:39.

[pure11]

Hi all, im using the Free Shipping w/ minimum amount module located here: http://addons.oscommerce.com/info/146


under my google checkout button it displays:

Error: Shipping Methods not configured
freeamount (ignored)


how do i configure this into google checkout so that this error message doest display?


thanks!

[atanub4u]

Silverado05, on Aug 11 2007, 05:33 PM, said:

In order to contain all the support to one thread so I can accurately help those needing help with this module please post your support questions here and I will be more then happy to help you with this to best of my ability.

Contribution can be found below.

Google Checkout module for osCommerce

Current release is version 1.4 Dated 17 Jul 2007

Hi,

I have installed the latest version of the google checkout contribution: http://www.oscommerce.com/community/contri...Google+Checkout in my site. But when clicking to the google checkout button from the front end it is taking me to the https://checkout.google.com with the following error:

"Oops!
Shop559 has sent Google a shopping cart with errors in it. We'll contact them to ask that they fix this problem. As this could be a temporary issue, you can go back in your browser to try checking out again."

Can anybody help me out how this error can be resolved or what is causing the error.

Thanks!

[midwestb]

Seems that everything is mostly fine here....

However in the Admin panel, I cannot get my changes to google Checkout to save after I update the fields with my Google merchant ID, etc. When I hit update, it just goes back to the default values, as if I hadn't changed anything...

any ideas?

[midwestb]

midwestb, on Dec 13 2007, 12:27 PM, said:

Seems that everything is mostly fine here....

However in the Admin panel, I cannot get my changes to google Checkout to save after I update the fields with my Google merchant ID, etc. When I hit update, it just goes back to the default values, as if I hadn't changed anything...

any ideas?

sorry I figured it out myself. For some reason, Programmer's Notepad didn't copy and paste correctly...it did it all in one single line, so most of the code I replaced was commented out!

Fixed.

[pcboy123]

Hello.

Can someone check my site see if its properly working.. im not a big php coder.. when i test it and i select a product and add to cart i get sent to shopping_cart.php and when i select Google CheckOut it just refreshes the page is it suppose to do that?

Store - S & R Computers

it dosent have our inventory yet.. just what came with osc.. its defualt.

[speed777]

virtualbum, on Dec 3 2007, 07:57 PM, said:

After many hours of research I have discovered that with the template system (STS 4.5.8) turned on, you cannot use the gc_return.php file that Google Checkout provides. Although calling that file works great in a standard osCommerce install, you have to use the checkout_success.php file to return to the site. While in a stock install, this file (checkout_success.php) does not empty the shopping cart after a successful checkout with google checkout - so you have to us gc_return.php - checkout_success.php works just fine with STS 4.5.8 enabled.

Best Regards,

-Jim

I worked out a solution to the gc_return.php problem with not emptying the cart after a successful checkout.

insert: <?php
$cart->reset(true);
?>
at the end of the file before <!-- body_text_eof //-->

[speed777]

I want to clarify this a little. I worked out a solution to the gc_return.php problem with not emptying the cart after a successful checkout.

Open catalog/gc_return.php
insert: <?php
$cart->reset(true);
?>

at the end of the file before <!-- body_text_eof //-->

[pcboy123]

pcboy123, on Dec 18 2007, 05:27 PM, said:

Hello.

Can someone check my site see if its properly working.. im not a big php coder.. when i test it and i select a product and add to cart i get sent to shopping_cart.php and when i select Google CheckOut it just refreshes the page is it suppose to do that?

Store - S & R Computers

it dosent have our inventory yet.. just what came with osc.. its defualt.

anybody