PayPal IPN Payments being received but product purchased not showing

[lviper]

I just wanted to say I have a customer that is having this problem as well. And again, nothing was changed. Now I did log in to his paypal account and went to IPN history and I see the last order queued.

This order he got an email from paypal that he received money but the order is not in zencart. The IPN history shows the transaction but the ipn is queued.

So is this queued ipn a problem at paypal, or did it try and could not send it waiting to try again later? I checked the link to the ipn_main_handler.php and it is valid and responding.

I'm going to send an email to paypal support and will post their answer here.

[DrByte]

Well, this now seems to be "normal" with the email confirmation arriving some 4 hours after the order has been placed. I guess it's a bottleneck somewhere between PayPal and Zen Cart ...

W

The bottleneck is in PayPal's servers. Sometimes they get backlogged in processing the notifications.

You can avoid that delay problem by using Express Checkout instead of IPN/Website Payments Standard.

[distanceDemon]

Thanks for that Dr Byte, I'll investigate making the change.
W

[rubbermike]

Just a comment on my own experiences - A while back it seemed to take anything up to an hour for the order to appear on my site, so don't panic too quickly.

Had the same problem this morning with one payment received but no order details, found that if you go to your Paypal account>Profile>Instant payment notifications, you can tick and resend the offending IPN which in my case created the order. Not a fix to the actual problem, but may save that embarassing phone call to your customer....

[Sharni]

This happened to me the first time about 6 months ago. I refunded the customer and asked her to order again, and the same thing happened. I thought it was zen-cart as my installation was only a couple of months along.

However, now I know it is now with PayPal, because eventually orders came through, though one that I did as a test never actually did.

Yesterday when I logged into PayPal they had a notice at the top saying something like this "Please excuse our virtual dust while we do renovations, some aspects of PayPal will not work".

So now I am sitting with payments from customers from late last evening and still no order confirmation and no clue what to ship to them. I am going to give it another couple of hours and then issue refunds, TURN OFF PAYPAL, and then go to authorize.net payments only. This kind of thing is not acceptable. I have paid a small fortune in PayPal fees, I expect the service to work.

So there is NOTHING WRONG WITH ZENCART. This is ALL PAYPAL!!!

Sharni

[SilverKop]

How can you do a test order through paypal?

[DrByte]

How can you do a test order through paypal?

Simply do a normal order, and use PayPal's refund option (from your PayPal transaction details page) to refund the transaction. It'll refund the money and the fees fully.

[SilverKop]

Simply do a normal order, and use PayPal's refund option (from your PayPal transaction details page) to refund the transaction. It'll refund the money and the fees fully.

Many thanks, that worked a treat and system working fine.

My customer had problems and I only received payment details and not order details but this was done on the 19th August. Paypal's fault

[miffy22]

Hi Dr. Byte,

I'm having exactly the same problem that the thread starter has. I'm having no luck solving this issue. Basically, while testing my entire check out process, I performed a real transaction, and got payment confirmation from Paypal. However, no order is showing on my zen cart, neither did I get an email with the order details. Below is the Paypal debug log, could you help me to identify where the problem might be, thank you so much for your assistance!!
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2010-07-16 08:55:26
-------------------
(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers:
Array
(
[0] => Content-Type: text/namevalue
[1] => X-VPS-Timeout: 45
[2] => X-VPS-VIT-Client-Type: PHP/cURL
[3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart(tm) - PayPal/NVP
[4] => X-VPS-VIT-Integration-Version: 1.3.9b
)


Request Parameters: {SetExpressCheckout}
Array
(
[AMT] => 51.30
[ITEMAMT] => 51.30
[LOCALECODE] => CA
[PAYMENTACTION] => Sale
[ALLOWNOTE] => 1
[LANDINGPAGE] => Billing
[REQCONFIRMSHIPPING] => 1
[RETURNURL] => http://artonbeads.net/ipn_main_handler.php?type=ec
[CANCELURL] => http://artonbeads.net/index.php?main...mp;ec_cancel=1
[PAGESTYLE] => Primary
[METHOD] => SetExpressCheckout
[CURRENCYCODE] => CAD
[USER] => order_api1.artonbeads.net
[PWD] => ****************
[VERSION] => 60.0
[SIGNATURE] => ****************************************************6IFR
)


Response:
Array
(
[] =>
[CURL_ERRORS] => (7) Failed to connect to 66.211.168.126: Permission denied
)

(7) Failed to connect to 66.211.168.126: Permission denied
Array
(
[url] => https://api-3t.paypal.com/nvp
[http_code] => 0
[header_size] => 0
[request_size] => 0
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0
[namelookup_time] => 3.3E-05
[connect_time] => 0
[pretransfer_time] => 0
[size_upload] => 0
[size_download] => 0
[speed_download] => 0
[speed_upload] => 0
[download_content_length] => 0
[upload_content_length] => 0
[starttransfer_time] => 0
[redirect_time] => 0
)


SetExpressCheckout, Elapsed: 11ms -- Failed
(7) Failed to connect to 66.211.168.126: Permission denied
Array
(
[url] => https://api-3t.paypal.com/nvp
[http_code] => 0
[header_size] => 0
[request_size] => 0
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0
[namelookup_time] => 3.3E-05
[connect_time] => 0
[pretransfer_time] => 0
[size_upload] => 0
[size_download] => 0
[speed_download] => 0
[speed_upload] => 0
[download_content_length] => 0
[upload_content_length] => 0
[starttransfer_time] => 0
[redirect_time] => 0
)

[DrByte]

(7) Failed to connect to 66.211.168.126: Permission denied

That's an error message reported by CURL when your server attempted to use CURL to connect to the PayPal server to submit a transaction-related request.
Only your hosting company can sort out the problems causing CURL not to connect properly. Your hosting company's server administrator should be able to resolve the permission problems preventing CURL from working. They've probably got overly limiting restrictions configured on the server, preventing it from being able to do the communication required for advanced operations such as ecommerce.