Official PayPal IPN Support Thread
#4061
Posted 08 March 2010, 01:36
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
Posted 14 March 2010, 05:39
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
Posted 16 March 2010, 19:24
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
Posted 17 March 2010, 05:00
Jubbarelly, on 16 March 2010, 19:24, said:
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
#4065
Posted 17 March 2010, 18:23
totalnumpty, on 17 March 2010, 05:00, said:
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
Posted 18 March 2010, 05:38
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
#4067
Posted 22 March 2010, 10:30
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
Posted 25 March 2010, 18:31
totalnumpty, on 18 March 2010, 05:38, said:
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
Posted 26 March 2010, 04:40
Jubbarelly, on 25 March 2010, 18:31, said:
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
#4070
Posted 04 April 2010, 23:29
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
$_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
Posted 05 April 2010, 07:19
Jenica77, on 04 April 2010, 23:29, said:
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
Check My About US For who am I and what My company does.
#4072
Posted 06 April 2010, 21:41
satish, on 05 April 2010, 07:19, said:
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
Posted 10 April 2010, 16:56
#4074
Posted 24 April 2010, 17:50
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
Posted 24 April 2010, 23:58
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
Posted 25 April 2010, 08:19
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
Posted 25 April 2010, 18:34
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?
#4078
Posted 25 April 2010, 21:38
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?
#4079
Posted 25 April 2010, 22:22
Any clue on how I can fix this? I am only using CANADA/U.S. addresses..
Edited by sarafina, 25 April 2010, 22:22.
#4080
Posted 27 April 2010, 01:09
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.














