PayPal Express Checkout IPN Payment Module

shamonsflame · August 10, 2007

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.

Cerberuska · August 27, 2007

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

AlexStudio · August 28, 2007

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.

dayswillfall · August 28, 2007

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][email protected][/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!!

dayswillfall · August 28, 2007

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] = [email protected]
					[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]

Cerberuska · August 28, 2007

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][email protected][/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

AlexStudio · August 28, 2007

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!!!!

Cerberuska · August 29, 2007

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

scared · September 4, 2007

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

el_cachero · September 7, 2007

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 = '[email protected]'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.

September 7, 2007

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][email protected][/BuyerEmail]
[/SetExpressCheckoutRequestDetails]
[/SetExpressCheckoutRequest] 
[/SetExpressCheckoutReq]
[/soap:Body]
[/soap:Envelope]

IS anybody know why?

Any solution?

was working fine before...

AlexStudio · September 10, 2007

... 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.

September 10, 2007

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?

AlexStudio · September 11, 2007

Check the outbound connection problem with your host.

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

September 11, 2007

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://www.oscommerce.com/forums/index.php?s=&...t&p=1133597

thank you very much

AlexStudio · September 12, 2007

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;

September 18, 2007

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

September 18, 2007

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!!

AlexStudio · September 18, 2007

Please read THROUGH the install guide and run the diagnostics script before testing it.

September 18, 2007

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

AlexStudio · September 18, 2007

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.

September 18, 2007

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,

September 19, 2007

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?

September 19, 2007

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 September 19, 2007 by scarlson

AlexStudio · September 20, 2007

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.

PayPal Express Checkout IPN Payment Module

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation