Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * * 3 votes

Official PayPal IPN Support Thread


4127 replies to this topic

#4061 ragnew

  • Community Member
  • 7 posts
  • Real Name:Rich Agnew
  • Gender:Male
  • Location:Canada

Posted 08 March 2010, 01:36

Question about paypal login issue.

This is quite strange.
Using my osCommerce with Pay Pal IPN.

I moved servers recently where it was working. But under a differnt Domain Name.

Now, when it comes to the checkout it takes me to the paypal page.
When I try to login into my paypal account it just goes back to the payment page without any kind of an explanation.

No error warning.
No nothing.

When I go to my paypal page on its own, I can login fine.
Yes my store paypal account is different from my personal account.

Any ideas??

Please and Thanks in advance.

#4062 sunrise99

  • Community Member
  • 132 posts
  • Real Name:David

Posted 14 March 2010, 05:39

Hi,
Now I use justhot hosting. Seem Paypal IPN can't work, i can't get email.

I have update according to install_guide_READ_ME.html.
"If your server has register globals off and you need to turn it on by using a custom php.ini file, you need to put that php.ini under the ext folder as well. IPN won't work if register globals turned off. "


Now add php.ini on catalog and http://yourdomain.com/catalog/ext/modules/payment/paypal_ipn/
& put that php.ini under the ext folder as well

php.ini "register_globals = on"

But when I run:

http://yourdomain.com/catalog/ext/modules/payment/paypal_ipn/ipn.php
I got:

Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory.

Thanks & best Regards,
Sunrise99

Edited by sunrise99, 14 March 2010, 05:42.


#4063 Jubbarelly

  • Community Member
  • 6 posts
  • Real Name:Julian

Posted 16 March 2010, 19:24

Hi Everyone...

I have the PayPal IPN v2.3.4.7 installed, also One Page Checkout and Held Orders.

Now the thing that is happening to me is when a customer orders with the PayPal IPN payment method, the order comes through twice in the admin (same order number, just duplicate) and the order emails has this in:

Products
------------------------------------------------------
1 x ASUS SKT-AM3 M4A89GTD PRO/USB3 S/V/L 5200MT/s (102044) = £118.04
------------------------------------------------------
Sub-Total: £118.04
Sub-Total: £118.04
2-3 Day Courier Despatch (2-3 Day Insured Delivery to: le9 9hb): £4.99
2-3 Day Courier Despatch (2-3 Day Insured Delivery to: le9 9hb): £4.99 UK VAT 17.5%: £17.58 UK VAT 17.5%: £17.58
Total: £123.03
Total: £123.03


Anyone have / had the same issue and any ideas on how to fix it??

It doesnt happen for any other payment method just PayPal IPN

Thanks

Julian

#4064 totalnumpty

  • Community Member
  • 242 posts
  • Real Name:Gaz
  • Gender:Male
  • Location:U.K.

Posted 17 March 2010, 05:00

View PostJubbarelly, on 16 March 2010, 19:24, said:

Hi Everyone...
I have the PayPal IPN v2.3.4.7 installed, also One Page Checkout and Held Orders.

Now the thing that is happening to me is when a customer orders with the PayPal IPN payment method, the order comes through twice in the admin (same order number, just duplicate) and the order emails has this in:

Products
------------------------------------------------------
1 x ASUS SKT-AM3 M4A89GTD PRO/USB3 S/V/L 5200MT/s (102044) = £118.04
------------------------------------------------------
Sub-Total: £118.04
Sub-Total: £118.04
2-3 Day Courier Despatch (2-3 Day Insured Delivery to: le9 9hb): £4.99
2-3 Day Courier Despatch (2-3 Day Insured Delivery to: le9 9hb): £4.99 UK VAT 17.5%: £17.58 UK VAT 17.5%: £17.58
Total: £123.03
Total: £123.03

Anyone have / had the same issue and any ideas on how to fix it??
It doesnt happen for any other payment method just PayPal IPN
Thanks
Julian

Hi Julian

I can't give you a definitive answer, but I can give you a few areas to look at for the cause of this.

First though - did you spot that your VAT is not included in the total price?
Here's my guess on that - PayPal has two IPN files in the IPN install. One is in the catalog/ext/..../paypal/ folder - that one is the IPN responder which receives the3 data from PayPal about a transaction and updates the order status in admin. For the order total problem, you can ignore that one, and for the duplication issue, it's very unlikely to be causing it, but you never know, as you say the order number is also duplicated.

The other paypal_ipn file is in catalog/includes/modules/payments/paypal/ this is the one most likely to be the source of the order total problem and there's been loads of discussion posting detailed problems and the fixes, regarding that file. Normally, using the aggregate tax method clears it - don't worry too much about VAT accounting issues on the payment processor - you account for VAT from the invoice and in your accounting system, not at PayPal. This problem has been a long-running "open sore" with the open source PayPal modules.

That second paypal_ipn is possibly, though unlikely, the cause of the order detail duplication - generally though, I'd say that if it was the source, then your invoices would be double the total price too, and you'd be spotting that pretty fast.

My guess would be that the one-page checkout is echoing with the original checkout flow somewhere - probably in the order confirmation area. In the normal checkout flow, the last page of the process is where the order is written to the database and assigned the order/invoice number, then the whole is passed to the customer chosen payment module. Logic says that it's most likely at this point that the database is being written to twice,

You've said the order is duplicated - but did you check if the order.invoice number is identical? (On the admin home page, hover your mouse over each order and look at the status bar at the bottom of the screen - it'll show the order/invoice number in the URL for the order).

If the order number is identical for both, then you have a two step problem - osC is "printing" the order twice to screen as well as to the emails - that should be the easier to kill problem. Look for code duplication, or if the default checkout process is still active and working in parallel to the one-page checkout, instead of being replaced by one-page. If it's identical and in the database as two separate orders with the same number (which should be impossible given the auto-numbering osC uses with SQL) then you've got bigger issues - do you know how to use phpMyAdmin to inspect the database content and structure directly? You'll likely need to do that anyway - to verify if the problem is in the order recording, or in the osC use of the data after it's recorded.

Sorry I can't drill straight to the problem, but hope the above helps you find it.

Gaz
Wearing a seatbelt prevents head injuries when the computer crashes - - - Yeah Right!!! - not in this office.

#4065 Jubbarelly

  • Community Member
  • 6 posts
  • Real Name:Julian

Posted 17 March 2010, 18:23

View Posttotalnumpty, on 17 March 2010, 05:00, said:

Hi Julian

I can't give you a definitive answer, but I can give you a few areas to look at for the cause of this.

First though - did you spot that your VAT is not included in the total price?
Here's my guess on that - PayPal has two IPN files in the IPN install. One is in the catalog/ext/..../paypal/ folder - that one is the IPN responder which receives the3 data from PayPal about a transaction and updates the order status in admin. For the order total problem, you can ignore that one, and for the duplication issue, it's very unlikely to be causing it, but you never know, as you say the order number is also duplicated.

The other paypal_ipn file is in catalog/includes/modules/payments/paypal/ this is the one most likely to be the source of the order total problem and there's been loads of discussion posting detailed problems and the fixes, regarding that file. Normally, using the aggregate tax method clears it - don't worry too much about VAT accounting issues on the payment processor - you account for VAT from the invoice and in your accounting system, not at PayPal. This problem has been a long-running "open sore" with the open source PayPal modules.

That second paypal_ipn is possibly, though unlikely, the cause of the order detail duplication - generally though, I'd say that if it was the source, then your invoices would be double the total price too, and you'd be spotting that pretty fast.

My guess would be that the one-page checkout is echoing with the original checkout flow somewhere - probably in the order confirmation area. In the normal checkout flow, the last page of the process is where the order is written to the database and assigned the order/invoice number, then the whole is passed to the customer chosen payment module. Logic says that it's most likely at this point that the database is being written to twice,

You've said the order is duplicated - but did you check if the order.invoice number is identical? (On the admin home page, hover your mouse over each order and look at the status bar at the bottom of the screen - it'll show the order/invoice number in the URL for the order).

If the order number is identical for both, then you have a two step problem - osC is "printing" the order twice to screen as well as to the emails - that should be the easier to kill problem. Look for code duplication, or if the default checkout process is still active and working in parallel to the one-page checkout, instead of being replaced by one-page. If it's identical and in the database as two separate orders with the same number (which should be impossible given the auto-numbering osC uses with SQL) then you've got bigger issues - do you know how to use phpMyAdmin to inspect the database content and structure directly? You'll likely need to do that anyway - to verify if the problem is in the order recording, or in the osC use of the data after it's recorded.

Sorry I can't drill straight to the problem, but hope the above helps you find it.

Gaz

Hi Gaz

The order numbers in admin are the same in both duplicates..

What kind of code examples would I need to look for?

Thanks

Julian

#4066 totalnumpty

  • Community Member
  • 242 posts
  • Real Name:Gaz
  • Gender:Male
  • Location:U.K.

Posted 18 March 2010, 05:38

Julian Hi

The more I think about this, the more it feels it has to be due to the one page checkout - I've not implemented that on any of my sites yet, but can you check through the install instructions carefully looking for any code that tells you to delete / comment out hooks to the original checkout flow. Make sure you followed those accurately.

Are you getting the same duplication from other payment processor modules? Or is it solely the PayPal one?
Have a look at the module's contribution page in the repository, I seem to remember that the version you're using had some issue with being for German language sites only (or something like that).

Unfortunately I don't have time to root around in this too deeply right now as I've got five complete site build, config, and style jobs to finish before month end and the job only arrived yesterday so nothing's been started on it yet.

Good luck
Gaz
Wearing a seatbelt prevents head injuries when the computer crashes - - - Yeah Right!!! - not in this office.

#4067 mifzal.mufthi

  • Community Member
  • 117 posts
  • Real Name:Mifzal Mufthi
  • Gender:Male

Posted 22 March 2010, 10:30

I have an issue on PayPal e-mail receipt. Assume that there's a product which is USD 1 on the store. If a customer wants to buy 5 of them, in that case the total should be USD 5/-

Once the customer makes the payment, I receive an e-mail from PayPal stating "NOTIFICATION OF PAYMENT RECEIVED". There, it doesn't show the exact QUANTITY. Even though customer has purchased 5 quantities, PayPal e-mail notification still indicates as 1 quantity and the price is accurate.

However, on my osCommerce admin portal, exact quantity and exact price displays. Do you know where the issue is?

#4068 Jubbarelly

  • Community Member
  • 6 posts
  • Real Name:Julian

Posted 25 March 2010, 18:31

View Posttotalnumpty, on 18 March 2010, 05:38, said:

Julian Hi

The more I think about this, the more it feels it has to be due to the one page checkout - I've not implemented that on any of my sites yet, but can you check through the install instructions carefully looking for any code that tells you to delete / comment out hooks to the original checkout flow. Make sure you followed those accurately.

Are you getting the same duplication from other payment processor modules? Or is it solely the PayPal one?
Have a look at the module's contribution page in the repository, I seem to remember that the version you're using had some issue with being for German language sites only (or something like that).

Unfortunately I don't have time to root around in this too deeply right now as I've got five complete site build, config, and style jobs to finish before month end and the job only arrived yesterday so nothing's been started on it yet.

Good luck
Gaz

Hi Gaz,

Thanks for your reply, and I can confirm it nly does it with the PayPal module...

Thanks

Julian

#4069 totalnumpty

  • Community Member
  • 242 posts
  • Real Name:Gaz
  • Gender:Male
  • Location:U.K.

Posted 26 March 2010, 04:40

View PostJubbarelly, on 25 March 2010, 18:31, said:

Hi Gaz,

Thanks for your reply, and I can confirm it nly does it with the PayPal module...

Thanks

Julian

Have you by any chance got more than one PayPal module active and installed? Just a wild thought that popped into my head.
Also, don't know if this is possible or not, but have you got hard-coded embedded calls to an inactive PayPal module as well as to your active IPN? On-screen duplication I would expect to be due to duplicate code, but not normally to cause duplicate entries in the database - the "unique key" per table should prevent that. If you could check your database tables using phpMyAdmin and grab the row numbers and unique key column entries, it might help reveal if the problem is with the database, the write-to-database code, or with duplicate transaction (PayPal) code inside your site. If you see what I mean? If the problem is there and you can't fix it yourself, you'll probably need to put out a call for paid support from a competent PHP/SQL developer.

Busy deep in the throes of site building - don't count on me being around here much before the end of next week.

Gaz
Wearing a seatbelt prevents head injuries when the computer crashes - - - Yeah Right!!! - not in this office.

#4070 Jenica77

  • Community Member
  • 39 posts
  • Real Name:Jenica

Posted 04 April 2010, 23:29

I have been searching this thread for four hours, I hope someone can help me out!! I installed 2.3.4.7 which appears to me to be the last english version. I've been testing it and here's what I'm getting:

Orders do show up in Admin
Payment does show up in Paypal, I get normal confirmation email from Paypal

I never get a confirmation email (as the customer or the shop owner)
I get error emails from Paypal:

Quote

PayPal IPN Invalid Process
$_POST:

mc_gross=15.00
invoice=6

protection_eligibility=Eligible
address_status=confirmed
payer_id=xxxxxxxxxx
tax=0.00
address_street=xxxxxxxxxx
payment_date=15:31:28 Apr 04 2010 PDT

payment_status=Completed
charset=windows-1252
address_zip=xxxxx
first_name=xxxxxxxxxx
mc_fee=0.74

address_country_code=US
address_name=xxxxxxxxxx
notify_version=2.9
custom=11
payer_status=unverified
business=xxxxxxxxxx@mysite.com
address_country=United States
address_city=xxxxxxxxxx
quantity=1
verify_sign=AiPC9BjkCyDFQXbSkoZcgqH3hpacADv1CkHIOzo0KxRXyF2ihQ4mcB0a

payer_email=xxxxxxxxxx
txn_id=7VS675029S402735C

payment_type=instant
last_name=xxxxxxxxxx
address_state=TX
receiver_email=xxxxxxxxxx
payment_fee=0.74

receiver_id=L8ME2KBYBXW2S
txn_type=web_accept
item_name=xxxxxxxxxx
mc_currency=USD
item_number=
residence_country=US
receipt_id=1952-8478-1360-1838

handling_amount=0.00
transaction_subject=11
payment_gross=15.00

When I look at the order in Admin, It shows as pending and when I click on it, I see this in the status: PayPal IPN Invalid [Completed]

There is also a big red X next to the customer notified box.

In my IPN settings in Paypal, I've tried having no URL, mysite.com/ext/modules/payment/paypal_ipn/ipn.php and mysite.com/includes/modules/payment/paypal_ipn.php None of them seem to make a difference.

Can anyone please help me?? TIA

#4071 satish

  • Community Member
  • 5,315 posts
  • Real Name:Satish Mantri
  • Gender:Male
  • Location:Nagpur(India)

Posted 05 April 2010, 07:19

View PostJenica77, on 04 April 2010, 23:29, said:

I have been searching this thread for four hours, I hope someone can help me out!! I installed 2.3.4.7 which appears to me to be the last english version. I've been testing it and here's what I'm getting:

Orders do show up in Admin
Payment does show up in Paypal, I get normal confirmation email from Paypal

I never get a confirmation email (as the customer or the shop owner)
I get error emails from Paypal:


When I look at the order in Admin, It shows as pending and when I click on it, I see this in the status: PayPal IPN Invalid [Completed]

There is also a big red X next to the customer notified box.

In my IPN settings in Paypal, I've tried having no URL, mysite.com/ext/modules/payment/paypal_ipn/ipn.php and mysite.com/includes/modules/payment/paypal_ipn.php None of them seem to make a difference.

Can anyone please help me?? TIA


There is an IPN file in this Module.
It is to process the backend IPN post.
The code of that files feels that there is something wrong in the order placed and the IPN recd so it results in invalid IPN.

You need to debug that file.

Satish
Ask for osCommerce value addon suggestion tips for your site.
Check My About US For who am I and what My company does.


#4072 Jenica77

  • Community Member
  • 39 posts
  • Real Name:Jenica

Posted 06 April 2010, 21:41

View Postsatish, on 05 April 2010, 07:19, said:

There is an IPN file in this Module.
It is to process the backend IPN post.
The code of that files feels that there is something wrong in the order placed and the IPN recd so it results in invalid IPN.

You need to debug that file.

Satish

OK, well I haven't changed anything in the ipn.php file that came with the package so I'm not too cure where to start. I do have two e-mail addresses associated with my paypal account. The business one and a personal one. I made the business one the primary. I saw that someone earlier was having some issue with having multiple email addresses so I'm not sure if I need to do anything different.

Should I post the code from the ipn.php file here? Like I said, its the standard one that came with the package 2.3.4.7

#4073 drillsar

  • Community Member
  • 222 posts
  • Real Name:thomas mccaffery

Posted 10 April 2010, 16:56

anyone get the paypal ipn to work with MVS contribution?

#4074 nedragdnuos

  • Community Member
  • 31 posts
  • Real Name:nedragdnuos

Posted 24 April 2010, 17:50

Hi everyone,

Ive just spent the last two hours redinbg each page here but I cant seem to find any reference to my problem.

I have just password protected my Admin folder, and now the order email is not being sent. As soon as I remove password protection from my admin folder then the order emails suddenly work again. Has anyone encountered this problem, and have you found a solution.

Any help would be greatly appreciated.

Regards!

#4075 nedragdnuos

  • Community Member
  • 31 posts
  • Real Name:nedragdnuos

Posted 24 April 2010, 23:58

Hi everyone again, please disregard that last post, the password on my admin dosnt seem to interfere with the update.

I have just tested with the sandbox and it seems the paypal customer emails are going out, but the status is not being updated in admin and I am not receiving the update email, just payment received, but only for the rest of the world. Now the strange this is that sandbox test Australian customer works correctly and updates properly, very strange considering my hosting is in the USA.

I should also note the my configuration has not been touched at all and none of the files have been modified in any way.

Is it possible that paypal is having some issues etc? Im kinda lost as its strange to have the module work perfectly one moment then the next its playing up for no reason...

Again, sorry for my ramblings, I hope they make sense. Any help would be appreciated.

Cheers!

#4076 nedragdnuos

  • Community Member
  • 31 posts
  • Real Name:nedragdnuos

Posted 25 April 2010, 08:19

Hi everyone, in reference to my last post, I have just received 4 very strange emails from my store (I think?) with the following content:

Subject: PayPal IPN Invalid Process

$_POST:


$_GET:

Thats it, thast all thats in the email and this is now 5-6 hours after paypal payment has been received but no update on admin side from various sales.. this is now starting to worry me, absolutley no changes whatsoever have been made to any files with normal sales going through and now all of a sudden this module, or maybe paypal itself is playing up within the last 24 hours...

If anyone has encountered this problem, could they please reply, any help, again, is greatly appreciated.

Cheers!

#4077 sarafina

  • Community Member
  • 108 posts
  • Real Name:Sandrine

Posted 25 April 2010, 18:34

I installed this for my store. Version 2.3.4.6 and when I did that, it tells me to go to admin and enable 'Paypal IPN' but that option isn't there.

None of the files required me to modify admin either. I am using V2.2 RC2 and I see this contribution is for MS2. IS that the problem?

Anybody with an RC2 store can you tell me what module version you use?
Contributions installed: Purchase without Account / STS/ All Products/ Header Tags Controller

#4078 sarafina

  • Community Member
  • 108 posts
  • Real Name:Sandrine

Posted 25 April 2010, 21:38

^NVM I do have it.

Everytime I go to checkout I don't have an option to purchase without using paypal. It says log in or create account. I have already checked and I have enable purchase without paypal under paypal settings. Any clue what is going on?
Contributions installed: Purchase without Account / STS/ All Products/ Header Tags Controller

#4079 sarafina

  • Community Member
  • 108 posts
  • Real Name:Sandrine

Posted 25 April 2010, 22:22

Also when I am in sandbox I get following error: Paypal does not allow your country of residence to ship to the country you wish to.

Any clue on how I can fix this? I am only using CANADA/U.S. addresses..

Edited by sarafina, 25 April 2010, 22:22.

Contributions installed: Purchase without Account / STS/ All Products/ Header Tags Controller

#4080 sservat

  • Community Member
  • 14 posts
  • Real Name:Sebastian
  • Gender:Male
  • Location:Sydney, Australia

Posted 27 April 2010, 01:09

Hi,

I recently installed an IPN module and I'm having a weird problem.

Logged in with my PayPal Sandbox account, I check-out a product in my store, but it redirects to PayPal's login screen with NO ORDER DETAILS. (e.g. https://www.paypal.com/au/cgi-bin/webscr <- no extra GET parameters

If I then hit "back" and check-out again, once again it redirects to PayPal's login screen, but this time with ORDER DETAILS. (e.g. https://www.paypal.com/au/cgi-bin/webscr <- with session parameters)

Everything else here after works fine.

Anyone knows what's going on behind the scene? I've been on this problem for days!

I'll be happy to test anything,

THANKS!

Seb. :thumbsup: