Jump to content



Photo
* * * * * 1 votes

PayPal Express Checkout IPN Payment Module


  • Please log in to reply
405 replies to this topic

#341   a.niedermann

a.niedermann
  • Members
  • 139 posts
  • Real Name:Andreas Niedermann

Posted 21 April 2008 - 19:54

Hi Alex

I double checked all modifications necessary for your contribution, including checking the address pages, since you wrote it could also have to do something with this. Unfortunately it did not help. Now, I have the problem which I had before only with firefox -> rerouting to the login.php.

Here's what I realised

The "PAY" Button on the express_checkout has no session ID or token on it, in my store it is just a simple link to checkout_process.php.

When then clicking on the pay button it first sends me back to the checkout_process.php before it resends me back to the login.php.

If I have the 'Allow Edit Shipping Address at PayPal?' to 'Yes' it first sends me to the shipping page which says that Paypal modified the address and that I should confirm that, although the addresses are exactely the same. when confirming that the story is the same as mentioned three sentences before...

I appreciate very much your help!!

Andreas

#342   AlexStudio

AlexStudio
  • Members
  • 1,092 posts
  • Real Name:Alex Li
  • Gender:Male
  • Location:Taipei, Taiwan

Posted 21 April 2008 - 20:39

1. rerouting to login.php means that you have a session problem. The 'Pay' button shouldn't need a session id or token if sessions are working properly.

2. When setting 'Allow Edit Shipping Address at PayPal?' to 'Yes', PayPal will replace the address with one in their record, even without your clicking on the edit link. The address may look the same, but the matching can still fail, depends on the address settings in your store and database. An empty 'state' entry is not the same as a NULL 'state' entry, you might need to replace NULL state entries with empty strings in your database address_book table.
Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

#343   noppie

noppie
  • Members
  • 306 posts
  • Real Name:Naomi
  • Gender:Female

Posted 22 April 2008 - 06:46

I have v0.4.2 update ready, but need someone to test it with CCGV before releasing.
If you have CCGV installed and want to test v0.4.2, please PM me. I will send you a copy for testing. Please include in the PM which version of CCGV installed.
And make sure your server mets the requirements:

  • osCommerce 2.2ms2
  • PHP 4.3.0+
  • cURL
A PayPal premier or business account is required as well.



Do you still need help with this..
I really want to get the coupons and points and awards working.
thank you again for a wonderful mod
noppie /rolleyes.gif' class='bbc_emoticon' alt=':rolleyes:' />
Peace is possible.. Please don't give up.

"War is --the old betraying the young"

#344   a.niedermann

a.niedermann
  • Members
  • 139 posts
  • Real Name:Andreas Niedermann

Posted 22 April 2008 - 07:27


Hey Alex

Since it seems to be that I have a session problem I compared the two session.php but also this did not help....

Do you have any idea what else I have to check??

Thanks
Andreas

#345   AlexStudio

AlexStudio
  • Members
  • 1,092 posts
  • Real Name:Alex Li
  • Gender:Male
  • Location:Taipei, Taiwan

Posted 22 April 2008 - 07:39

If it only happens with firefox, it probably is your firefox settings.
Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

#346   noppie

noppie
  • Members
  • 306 posts
  • Real Name:Naomi
  • Gender:Female

Posted 22 April 2008 - 18:50

sorry double post..

Edited by noppie, 22 April 2008 - 18:51.

Peace is possible.. Please don't give up.

"War is --the old betraying the young"

#347   tanicos

tanicos
  • Banned
  • 152 posts
  • Real Name:cosminel

Posted 24 April 2008 - 23:21

hello

i installed this module and then when i click the checkout paypal button nothing happens. the page is trying to get somewhere, it stops and then it tries again.i've set up the API in paypal and in admin but it;s not working...am i doing something wrong?
lastly after 4 min i get this on the url:
..../ppeb.php?shec=a
and internet explorer cannot display this page

?

#348   a.niedermann

a.niedermann
  • Members
  • 139 posts
  • Real Name:Andreas Niedermann

Posted 25 April 2008 - 08:41


Hi Alex

Sadly it happens with all browsers....!! Any Idea?

Andreas

#349   a.niedermann

a.niedermann
  • Members
  • 139 posts
  • Real Name:Andreas Niedermann

Posted 28 April 2008 - 15:41

Hi Alex

Sadly it happens with all browsers....!! Any Idea?

Andreas



No idea around??

#350   zebraplayer

zebraplayer
  • Members
  • 48 posts
  • Real Name:Lou
  • Gender:Male

Posted 03 May 2008 - 21:41

Just installed PayPal Express Checkout V2.11 put in the Paypal data and everything apears to be working fine. I log into Paypal using a personal account. I get to the "Review Your Information" page and when I press continue I get the following message.

I am new at this, so any help would be appreciated.


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
select customers_default_address_id from customers where customers_id =
[TEP STOP][


Thanks for your time.

#351   sunrise99

sunrise99
  • Members
  • 207 posts
  • Real Name:David
  • Gender:Male
  • Location:HongKong

Posted 18 May 2008 - 17:06

Hi Alex:
After I install it, run checkout, go to paypal , it display : Connection timed out.

ec_diagnostics.php okay except SSL is NO.

But Standard Paypal checkout is okay.

Would you please give some advise asap?

Thanks & Best Regards,

#352   sunrise99

sunrise99
  • Members
  • 207 posts
  • Real Name:David
  • Gender:Male
  • Location:HongKong

Posted 20 May 2008 - 07:22

Hi Alex:
Here is the dump report i receive:
In function: pre_confirmation_check()
Response from PayPal:
[Security] = N/A
[RequesterCredentials]
   [0]
	   [Credentials]
		   [0]
			   [Username] = N/A
			   [Password] = N/A
			   [Subject] = N/A
[SetExpressCheckoutResponse]
   [0]
	   [Timestamp] = 2008-05-20T07:22:22Z
	   [Ack] = Success
	   [CorrelationID] = a43d53d5c3aad
	   [Version] = 2.000000
	   [Build] = 576518
	   [Token] = EC-6DF00473xxxx59152

From this request: (WARNING!!) DO NOT expose your API Username/Password to the public!!
[?xml version="1.0" encoding="utf-8"?]
[soap:Envelope xmlns:soap="[url="http://schemas.xmlsoap.org/soap/envelope/"]http://schemas.xmlsoap.org/soap/envelope/[/url]" xmlns:xsi="[url="http://www.w3.org/2001/XMLSchema-instance"]http://www.w3.org/2001/XMLSchema-instance[/url]" xmlns:xsd="[url="http://www.w3.org/2001/XMLSchema"]http://www.w3.org/2001/XMLSchema[/url]"]
[soap:Header]
[RequesterCredentials xmlns="urn:ebay:api:PayPalAPI"]
[Credentials xmlns="urn:ebay:apis:eBLBaseComponents"]
[Username][url="http://paypal_api1.daurian.com/"]xxxx[/url][/Username]
[Password]xxxxxxxx[/Password]
[Subject][/Subject]
[/Credentials]
[/RequesterCredentials]
[/soap:Header]
[soap:Body]
[SetExpressCheckoutReq xmlns="urn:ebay:api:PayPalAPI"]
[SetExpressCheckoutRequest]
[Version xmlns="urn:ebay:apis:eBLBaseComponents"]2.0[/Version]
[SetExpressCheckoutRequestDetails xmlns="urn:ebay:apis:eBLBaseComponents"]
[OrderTotal currencyID="EUR"]10.48[/OrderTotal]
[ReturnURL][url="http://xxx.com/en/express_checkout.php[/ReturnURL]"]http://xxx.com/en/express_checkout.php[/ReturnURL][/url]
[CancelURL][url="http://xxx.com/en/checkout_payment.php?payment_error=paypal_ec[/CancelURL]"]http://xxx.com/en/checkout_payment.php?payment_error=paypal_ec[/CancelURL][/url]
[ReqConfirmShipping]0[/ReqConfirmShipping]
[NoShipping]0[/NoShipping]
[AddressOverride]0[/AddressOverride]
[LocaleCode]US[/LocaleCode]
[PageStyle]PayPal[/PageStyle]
[Address]
[Name]sunrise sunrise[/Name]
[Street1]aaaawewqe[/Street1]
[Street2][/Street2]
[CityName]aaaa[/CityName]
[StateOrProvince][/StateOrProvince]
[PostalCode]213213[/PostalCode]
[Country]BE[/Country]
[Phone][/Phone]
[/Address]
[BuyerEmail]xxx[email="xxx@gmail.com"]@gmail.com[/email][/BuyerEmail]
[/SetExpressCheckoutRequestDetails]
[/SetExpressCheckoutRequest]
[/SetExpressCheckoutReq]
[/soap:Body]
[/soap:Envelope]

any help would be GREATLY appreciated! Thanks!!

Edited by sunrise99, 20 May 2008 - 07:28.


#353   AlexStudio

AlexStudio
  • Members
  • 1,092 posts
  • Real Name:Alex Li
  • Gender:Male
  • Location:Taipei, Taiwan

Posted 20 May 2008 - 07:37

[SetExpressCheckoutResponse]
[0]
[Timestamp] = 2008-05-20T03:52:02Z
[Ack] = Success
[CorrelationID] = 492dd73f40166
[Version] = 2.000000
[Build] = 576518
[Token] = EC-8NL35362A2714091A

There seems to be no problem at all. Please refer to install guide if you don't want to get Every Transaction Dumping Email.
Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

#354   sunrise99

sunrise99
  • Members
  • 207 posts
  • Real Name:David
  • Gender:Male
  • Location:HongKong

Posted 21 May 2008 - 16:12

There seems to be no problem at all. Please refer to install guide if you don't want to get Every Transaction Dumping Email.


But the issue is Connection timed out under www.xxx.com/express_checkout.php

Would you please give some advise asap?

Thanks & Best Regards,

#355   AlexStudio

AlexStudio
  • Members
  • 1,092 posts
  • Real Name:Alex Li
  • Gender:Male
  • Location:Taipei, Taiwan

Posted 21 May 2008 - 16:22

php code has nothing to do with connection problems. Please ask your host for help.
Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

#356   potatocake

potatocake
  • Members
  • 38 posts
  • Real Name:y y l

Posted 02 June 2008 - 18:57

Hi Alex,

Great contribution btw. Just would like to double check something with you regarding the Paypal IPN dump email. My shopping cart is in MYR(Malaysian Currency) i have set the following options within paypal to accept payments in other currencies and convert to USD which is the currency set for both test merchant and buyer accounts.

Though the transactions are going through completed I am getting this below on the dump (bold text):
This order has been updated to the following status and requires your attention.

New status: Pending

The IPN response contained following message:

[Completed (PayPal account:Verified; USD 3.19)]
[b]Total amount did not match
Address status: unconfirmed[/b]

OrderTotal= MYR 10.28

As well as on my admin orders page:
PayPal IPN Verified
[Completed (PayPal account:Verified; USD 3.19)] --> though it has converted the amount to usd correctly
Total amount did not match
Address status: unconfirmed

Sorry I am not sure exactly what is the correct output of the IPN email dump. Is this something I should be worried about? as in would that be a problem with the transaction through IPN? If you could kindly explain what it means it would be much appreciated.

Thanks alot

#357   AlexStudio

AlexStudio
  • Members
  • 1,092 posts
  • Real Name:Alex Li
  • Gender:Male
  • Location:Taipei, Taiwan

Posted 02 June 2008 - 23:28

There is a bug in the ipn.php where it checks the order total with the payment amount if you have some complicated currencies setup. It's redundant and I have posted in this thread about how to comment off the checking. Please search for it.
Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

#358   potatocake

potatocake
  • Members
  • 38 posts
  • Real Name:y y l

Posted 03 June 2008 - 04:55

[quote name='AlexStudio' date='Jun 3 2008, 07:28 AM' post='1257005']

Hi Alex,

Thanks for replying so quickly, I have actually did the fix in the ipn.php searched on one of your threads. Its not displaying in admin anymore but still is in the email labelled:
PayPal EC IPN Error
[Completed (PayPal account:Verified; USD 3.19)]
Toatl amount did not match
Address status: unconfirmed

But the IPN contribution is fine right? Theres no problems with the transactions going back and forth at all in the long term? Sorry just double checking before going live.


Another question is if I would like to change anything on the language file do I have to reinstall the paypal IPN to show the changes?
Thanks alot /smile.gif' class='bbc_emoticon' alt=':)' />

Edited by potatocake, 03 June 2008 - 04:56.


#359   yacpro13

yacpro13
  • Members
  • 76 posts
  • Real Name:Sam

Posted 04 June 2008 - 21:49

Hi all,
I just finished installing paypal_express_checkout_IPN_v0.4.1

ALL the files are properly uploaded in their respective locations as instructed; new files have been added and the required files have been modified.

At a glance everything works but when a transaction is attempted I get the error:

PayPal Express Checkout IPN module installation incomplete! There should be XML files located in [blah blah blah] /store//catalogincludes/ec_xml/ !

I've done my fair amount of research on the topic.

My host is Netfirms, and the Register Globals are turned on.
My configure.php looks like this (and has the final '/' ) :

<?php
/*
  $Id: configure.php,v 1.14 2003/07/09 01:15:48 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
  define('HTTP_SERVER', 'http://canadabicycleparts.com'); // eg, http://localhost - should not be empty for productive servers
  define('HTTPS_SERVER', 'https://secure.sslpowered.com/canadabicycleparts.com'); // eg, https://localhost - should not be empty for productive servers
  define('ENABLE_SSL', true); // secure webserver for checkout procedure?
  define('HTTP_COOKIE_DOMAIN', 'canadabicycleparts.com');
  define('HTTPS_COOKIE_DOMAIN', 'secure.sslpowered.com');
  define('HTTP_COOKIE_PATH', '/store//catalog/');
  define('HTTPS_COOKIE_PATH', '/store//catalog/');
  define('DIR_WS_HTTP_CATALOG', '/store//catalog/');
  define('DIR_WS_HTTPS_CATALOG', '/store//catalog/');
  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
  define('DIR_WS_INCLUDES', 'includes/');
  define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
  define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
  define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
  define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
  define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

  define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
  define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/');
  define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
  define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

// define our database connection
  define('DB_SERVER', 'MYSQLHOST'); // eg, localhost - should not be empty for productive servers
  define('DB_SERVER_USERNAME', 'u70433059');
  define('DB_SERVER_PASSWORD', '41b9f3');
  define('DB_DATABASE', 'd60393742');
  define('USE_PCONNECT', 'false'); // use persistent connections?
  define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

Like I said, all files are there I can see them.

Any ideas ????????
Thanks so much!

#360   yacpro13

yacpro13
  • Members
  • 76 posts
  • Real Name:Sam

Posted 04 June 2008 - 23:38

After countless trial and error checks.....double checking the installation, configuration, server settings, permissions, I had a thought.
I also had the money order module installed. I unistalled it and voila, everything works A1.

Edited by yacpro13, 04 June 2008 - 23:39.