Jump to content
AlexStudio

PayPal Express Checkout IPN Payment Module

Recommended Posts

Express Checkout IPN & Discount Coupon

 

Hello,

 

I am having a hell of a time getting PayPal Express Checkout IPN to work with Discount Coupon Codes (http://www.oscommerce.com/community/contributions,4269)

 

I do not know how to pass the coupon info from "ec_shipping.php" to "express_checkout.php".

 

You can view my site at: http://www.sonadei.com/catalog/index.php

 

I will send you any files you want, I know you are busy but I really need your help.

 

Please let me know what more information you need. Thank you!

 

I was able to fix this issue. The website works now.

Share this post


Link to post
Share on other sites

I'm lost. I been checking threds for this contribution, but I cannot find the answer.

I installed the IPN 0.4.1 to the 2.2MS2

Everything is working I'm using for now sandbox paypal test account.

When I'm leaving to the paypal link with id is https://www.trytoo.ca/checkout_payment.php?...3nhvtfht1hdo5t3

In PayPal Sandbox is :https://www.sandbox.paypal.com/us/cgi-bin/webscr?cmd=_flow&SESSION=-mmd_BAKc6tAXW3q0TnQLe7HiR8ED5VimaWDdIZE1emLnDmADPwLJN1jfZNS1_GkS9Jd60&dispatch=bc5314bce0773f1548350520788c6b0a4d66515263d4079e73db2de28fccf29d

When I'm back in OScommerce:

https://www.trytoo.ca/express_checkout.php?...D=WRD3MT9Y8F8N6

And NOW when I hit Pay Button I got the back to login page with new id: https://www.trytoo.ca/login.php?osCsid=8634...h6gp1rq9lsg83h7

Where I have problem. What I have wrong. Probably I something oversee.

Help.

Thank you.

Cerberuska

Share this post


Link to post
Share on other sites
Your cookies setting is not working. Please search in this thread for the work around of adding sid at the tail of the return URL.

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.

Share this post


Link to post
Share on other sites

Hi!

 

Almost done with my site - just having one problem with this component.

 

I put the coupon in, get into Paypal, put all my information in, and it passes me back to OSCommerce.

 

Everything looks good, so I hit the "PAY" button, and it kicks me back out to the login.php page.

 

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] = 2007-08-28T14:21:41Z
	[Ack] = Success
	[CorrelationID] = 96ce4e6536623
	[Version] = 2.000000
	[Build] = 1.0006
	[Token] = EC-9WJ73159MV635164B



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="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"]
[soap:Header]
[RequesterCredentials xmlns="urn:ebay:api:PayPalAPI"] [Credentials xmlns="urn:ebay:apis:eBLBaseComponents"]
[Username]XXXXXXXXXX[/Username]
[Password]XXXXXXXXXX[/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="USD"]0.14[/OrderTotal]
[ReturnURL]https://www.2reachamillion.com/express_checkout.php?osCsid=49a9e6ca058865edfadeb7277a2d9dc8[/ReturnURL]
[CancelURL]https://www.2reachamillion.com/checkout_payment.php?payment_error=paypal_ec[/CancelURL]
[ReqConfirmShipping]0[/ReqConfirmShipping]
[NoShipping]0[/NoShipping]
[AddressOverride]1[/AddressOverride]
[LocaleCode]US[/LocaleCode]
[PageStyle]PayPal[/PageStyle]
[Address]
[Name]Jesse Wallace[/Name]
[Street1]6640 Akers Mill Rd[/Street1]
[Street2]Apt. 1939[/Street2]
[CityName]Atlanta[/CityName]
[StateOrProvince]GA[/StateOrProvince]
[PostalCode]30339[/PostalCode]
[Country]US[/Country]
[Phone]6787552237[/Phone]
[/Address]
[BuyerEmail]dayfall.jesse@gmail.com[/BuyerEmail]
[/SetExpressCheckoutRequestDetails]
[/SetExpressCheckoutRequest]
[/SetExpressCheckoutReq]
[/soap:Body]
[/soap:Envelope]

 

I really need to get this site up for a client, so any help would be GREATLY appreciated! Thanks!!

Share this post


Link to post
Share on other sites

Sorry, here is also another dump report i received:

 

In function: ec_get_detail()
Response from PayPal:

[Security] = N/A
[RequesterCredentials]
[0]
	[Credentials]
		[0]
			[Username] = N/A
			[Password] = N/A
			[Subject] = N/A

[GetExpressCheckoutDetailsResponse]
[0]
	[Timestamp] = 2007-08-28T14:21:58Z
	[Ack] = Success
	[CorrelationID] = 366255d46940f
	[Version] = 2.000000
	[Build] = 1.0006
	[GetExpressCheckoutDetailsResponseDetails]
		[0]
			[Token] = EC-9WJ73159MV635164B
			[PayerInfo]
				[0]
					[Payer] = dayfall.jesse@gmail.com
					[PayerID] = 6TMS5BNMYBX2J
					[PayerStatus] = verified
					[PayerName]
						[0]
							[Salutation] = N/A
							[FirstName] = Jesse
							[MiddleName] = N/A
							[LastName] = Wallace
							[Suffix] = N/A

					[PayerCountry] = US
					[PayerBusiness] = N/A
					[Address]
						[0]
							[Name] = Jesse Wallace
							[Street1] = 6640 Akers Mill Rd
							[Street2] = 1939
							[CityName] = Atlanta
							[StateOrProvince] = GA
							[Country] = US
							[CountryName] = United States
							[PostalCode] = 30339
							[AddressOwner] = PayPal
							[AddressStatus] = Confirmed



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="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"]
[soap:Header]
[RequesterCredentials xmlns="urn:ebay:api:PayPalAPI"] [Credentials xmlns="urn:ebay:apis:eBLBaseComponents"]
[Username]XXXXXXXXXXXX[/Username]
[ebl:Password xmlns:ebl="urn:ebay:apis:eBLBaseComponents"]XXXXXXXXXXXX[/ebl:Password]
[/Credentials]
[/RequesterCredentials]
[/soap:Header]
[soap:Body]
[GetExpressCheckoutDetailsReq xmlns="urn:ebay:api:PayPalAPI"] [GetExpressCheckoutDetailsRequest]
[Version xmlns="urn:ebay:apis:eBLBaseComponents"]2.0[/Version]
[Token]EC-9WJ73159MV635164B[/Token]
[/GetExpressCheckoutDetailsRequest]
[/GetExpressCheckoutDetailsReq]
[/soap:Body]
[/soap:Envelope]

Share this post


Link to post
Share on other sites
Your cookies setting is not working. Please search in this thread for the work around of adding sid at the tail of the return URL.

 

 

Here is Dumping email and there is SID on the end of Returning URL

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] = 2007-08-27T16:22:34Z
[Ack] = Success
[CorrelationID] = a8fa116828550
[Version] = 2.000000
[build] = 1.0006
[Token] = EC-5JL49621MR0500749



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="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"]
[soap:Header]
[RequesterCredentials xmlns="urn:ebay:api:PayPalAPI"]
[Credentials xmlns="urn:ebay:apis:eBLBaseComponents"]
[username]xxxxxx.rogers.com[/username]
[Password]xxxxxx[/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="CAD"]237.56[/OrderTotal]
[ReturnURL]https://www.trytoo.ca/express_checkout.php?osCsid=g9tmu4uvavngboi2fqemrlsq34[/ReturnURL]
[CancelURL]https://www.trytoo.ca/checkout_payment.php?payment_error=paypal_ec[/CancelURL]
[ReqConfirmShipping]1[/ReqConfirmShipping]
[NoShipping]0[/NoShipping]
[AddressOverride]0[/AddressOverride]
[LocaleCode]US[/LocaleCode]
[PageStyle]PayPal[/PageStyle]
[Address]
[Name]Test User[/Name]
[street1]1 Main St[/street1]
[street2][/street2]
[CityName]San Jose[/CityName] 
[stateOrProvince]CA[/stateOrProvince]
[PostalCode]95131[/PostalCode]
[Country]US[/Country]
[Phone]1-519-xxx-0078[/Phone]
[/Address]
[buyerEmail]xxxxxxx@rogers.com[/buyerEmail]
[/setExpressCheckoutRequestDetails]
[/setExpressCheckoutRequest] 
[/setExpressCheckoutReq]
[/soap:Body]
[/soap:Envelope]

If that is what I get from PayPal, so where I'm losting it. It is cleaned on the Server Side?

Thank you.

Cerberuska

Share this post


Link to post
Share on other sites

Try the following 'fix' if your cookies is not working.

OK, i think i figured it out, as i don't want to use cookies.

 

In 'paypal_ec.php', i modify the following lines:

 

3 instances of:

$this->form_action_url = FILENAME_CHECKOUT_PROCESS;

modify to

$this->form_action_url = tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL');

 

Seems to work fine.

 

Thanks

And don't post the dumping when there is personal info!!!!


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.

Share this post


Link to post
Share on other sites
Try the following 'fix' if your cookies is not working.

 

And don't post the dumping when there is personal info!!!!

 

Thank you. It is working now.

Thank you.

Cerberuska

Share this post


Link to post
Share on other sites

I have followed the instruction. all I did was upload all the files that came with the package to override the existing files on my server. it all seams to work but I do not get direct payment fields in the payment section. please help

Share this post


Link to post
Share on other sites

Just installed PP EC Checkout IPN, the installation went good, the ec_diagnostics comes up all green. I am having 2 issues. Returning customers cant login to their account. They get the following error:

 

1054 - Unknown column 'createaccount' in 'where clause'

 

select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from customers where customers_email_address = 'abc123@gmail.com'AND createaccount !='N'

 

Not too sure what happened there.

 

Second issue is when paypal kicks you back to my site and I click on the Buy button, it just redirects me to the login page. I did try the cookie fix referenced earlier, I got a 1054 error similar to the one above, it just referenced a different column. I am having my hosting company check to see if register_globals is on, but I am assuming that it is.

 

Is this contribution only compatible with the latest release of OSC?

 

Any help would be appreciated as I am totally stuck.

Share this post


Link to post
Share on other sites

Hello Everybody, start receive an error, all the time:

 

In function: pre_confirmation_check()
Response from PayPal:



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="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"]
[soap:Header]
[RequesterCredentials xmlns="urn:ebay:api:PayPalAPI"]
[Credentials xmlns="urn:ebay:apis:eBLBaseComponents"]
[Username]XXXXXXXXXXXXXX[/Username]
[Password]XXXXXXXXXXXXXX[/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="USD"]25[/OrderTotal]
[ReturnURL]https://XXXXXXXXXXXXXXXXXX/express_checkout.php[/ReturnURL]
[CancelURL]https://XXXXXXXXXXXXXXXXXX/ec_shipping.php?address_error=0[/CancelURL]
[ReqConfirmShipping]1[/ReqConfirmShipping]
[NoShipping]0[/NoShipping]
[AddressOverride]0[/AddressOverride]
[LocaleCode]US[/LocaleCode]
[PageStyle]PayPal[/PageStyle]
[Address]
[Name]xxxxxxxxxxxxx[/Name]
[Street1]xxxxxxxxxxxx[/Street1]
[Street2][/Street2]
[CityName]xxxxxxxxxxxxx[/CityName] 
[StateOrProvince]XX[/StateOrProvince]
[PostalCode]xxxxxxxxxxxxx[/PostalCode]
[Country]US[/Country]
[Phone]111-111-1111[/Phone]
[/Address]
[BuyerEmail]xxxxxxxxxxx@xxxxxxxxxxx.com[/BuyerEmail]
[/SetExpressCheckoutRequestDetails]
[/SetExpressCheckoutRequest] 
[/SetExpressCheckoutReq]
[/soap:Body]
[/soap:Envelope]

IS anybody know why?

Any solution?

was working fine before...

Share this post


Link to post
Share on other sites
... it all seams to work but I do not get direct payment fields in the payment section.....
There is no direct payment in this contribution.

 

This contribution has not been tested with osC RC1. Only stable releases (e.g. osCommerce 2.2 MS2 / 051113 patch release / 060817 release ) are supported.

 

You got no response from Paypal with the initial request. Please check your server for permission of outbound connections.

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.

Share this post


Link to post
Share on other sites
You got no response from Paypal with the initial request. Please check your server for permission of outbound connections.

Please tell me how to do it? Cpanel? but where?

Share this post


Link to post
Share on other sites
Check the outbound connection problem with your host.

 

It could also be your API cetificate. Please run the diagnostics script first.


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.

Share this post


Link to post
Share on other sites
Check the outbound connection problem with your host.

 

It could also be your API cetificate. Please run the diagnostics script first.

I check the diagnostic script, and its giving me an error

===================================

OpenSSL Not Detected!

 

The required OpenSSL functions not detected.

 

PayPal Express Checkout IPN module won't work without OpenSSL installed.

 

Please contact your host for OpenSSL installation. A dedicated or shared SSL certificate is highly recommended.

 

==================================

 

BUT I have installed SSL certificate.

How to fix it??

 

Also run regular paypal IPN do not working also.

Here is error with that script

http://forums.oscommerce.com/index.php?s=&...t&p=1133597

 

thank you very much

Share this post


Link to post
Share on other sites
The openssl function checking is redundant and will be removed in the next update release. Please remove these 2 lines in the ec_diagnostics.php and run it again.

  if (function_exists('openssl_pkcs7_sign') && function_exists('openssl_pkcs7_encrypt')) $ssl_error = false;
 else $ssl_error = true;


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.

Share this post


Link to post
Share on other sites

I just installed this module today and I am having a problem at check-out. Once I choose the PayPal checkout option it asks me if I want to open up ec_checkout.php file. Why is that happening? Did I miss something in the installation?

 

Thanks in advance,

 

Scott

Share this post


Link to post
Share on other sites
I just installed this module today and I am having a problem at check-out. Once I choose the PayPal checkout option it asks me if I want to open up ec_checkout.php file. Why is that happening? Did I miss something in the installation?

 

Thanks in advance,

 

Scott

 

Ok, here is the error dump (or part of it because it contains personal data)

 

 

In function: pre_confirmation_check()
Response from PayPal:



From this request: (WARNING!!) DO NOT expose your API Username/Password
to the public!!

Share this post


Link to post
Share on other sites
Please read THROUGH the install guide and run the diagnostics script before testing 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.

Share this post


Link to post
Share on other sites
Please read THROUGH the install guide and run the diagnostics script before testing it.

 

 

I ran the diagnostics and it showed that I didn't have an SSL cert or something. I do have a SSL cert with GoDaddy already. I had been accessing my site with a WWW.domain_name.com\ec_diagnostics.php that was showing the error but when I do https://domain_name.com/ec_diagnostics it all checks out ok.

 

Do I have to tell my customers to make sure they go to my site by typing in https://blabh balblb every time or is there a way that it always uses https? Or, is there a way to use the https when it gets to the checkout point?

 

Thanks,

 

Scott

Share this post


Link to post
Share on other sites
It should switch to https automatically when the customers logged in, if your osCommerce is configured correctly.

 

The diagnostics script failed to load itself via https probably because the constants HTTP_SERVER and HTTPS_SERVER in your (catalog)/includes/configure.php are not defined correctly.


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.

Share this post


Link to post
Share on other sites
The diagnostics script failed to load itself via https probably because the constants HTTP_SERVER and HTTPS_SERVER in your (catalog)/includes/configure.php are not defined correctly.

 

No the diagnostics loaded fine when I typed in HTTPS but when I go to checkout and logged in, it doesn't switch to SSL. Is there a place to configure this to happen?

 

Thanks again,

Share this post


Link to post
Share on other sites
No the diagnostics loaded fine when I typed in HTTPS but when I go to checkout and logged in, it doesn't switch to SSL. Is there a place to configure this to happen?

 

Thanks again,

 

 

Ok, I have found an area inside of includes/configure.php where I see where to setup HTTPS SERVER and such and I changed the address to https://domain_name.com. I found this suggestion tips and tricks forum on how to setup SSL. I have made these changes and I get the same error as above. The web address does not change to https automatically when I got to check out. What else i'm I missing?

Share this post


Link to post
Share on other sites
Ok, I have found an area inside of includes/configure.php where I see where to setup HTTPS SERVER and such and I changed the address to https://domain_name.com. I found this suggestion tips and tricks forum on how to setup SSL. I have made these changes and I get the same error as above. The web address does not change to https automatically when I got to check out. What else i'm I missing?

 

 

I could really use some help with this. I finally got my site to do SSL when logging in and when it goes to checkout but I still can not check out. I get the same error dump saying not to expose my API username and password to the public.

 

I have followed all the instructions.

 

Please help....

 

Scott

 

Here is the stats from ec_diagnostics;

 

Basic Tests

Using at least PHP 4.3.0? Yes

Is OpenSSL installed? Yes

Does your store have an SSL certificate (shared/dedicated) installed and working? Yes

Is cURL installed? Yes

Does cURL work? (Simple HTTP test) Yes

API Certificate installed? Yes

API Username in place? Yes

API Password in place? Yes

XML Document "doExpressCheckout.xml" exists? Yes

XML Document "getExpressCheckoutDetails.xml" exists? Yes

XML Document "setExpressCheckout.xml" exists? Yes

XML Document "diagnostics.xml" exists? Yes

Advanced Diagnostics

Live server

Able to connect to PayPal through cURL?

Edited by scarlson

Share this post


Link to post
Share on other sites
GoDaddy requires cURL connections to route through a proxy server. Please refer to the insall guide regarding Proxy Address setting under Configuration. If the address no longer works, please ask your host for an updated address.

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×