Paypal Express payment shows unprocessed but paid in Paypal

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
dandersonMLT
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 95
Joined: Sun Oct 04, 2015 5:45 pm

Paypal Express payment shows unprocessed but paid in Paypal

Post by dandersonMLT » Mon Nov 14, 2016 6:06 am

We received an order that was paid with Paypal Express.
The order payment shows "Unprocessed" in AbleCommerce, but Paypal shows the order as "Paid"

Why would this happen?

Thanks,
Dave

nadeem
Captain (CAPT)
Captain (CAPT)
Posts: 258
Joined: Tue Jul 31, 2012 7:23 pm

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by nadeem » Wed Nov 16, 2016 1:38 am

This might be happening due to the IPN failure. Can you check the error log to see if there is any error in the log?

dandersonMLT
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 95
Joined: Sun Oct 04, 2015 5:45 pm

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by dandersonMLT » Wed Nov 16, 2016 3:06 am

I only see a few paypal warnings or errors such as this:

"Error in PayPal GetExpressCheckout. User ID detected in PayPal response: UID11098657, Customer User ID: 11098699 "

"An error has occured at http://www.websitename.com/PayPalExpres ... NYMQJCPRLL
Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown."



They are seldom though. And there are far less than the number of paypal orders marked as unprocessed.
I don't see anything specifically with IPN in the error logs, unless they would be in a different log file. I looked in paypal.log as well, but I don't see anything in there indicating an error either.

Thanks,
Dave

nadeem
Captain (CAPT)
Captain (CAPT)
Posts: 258
Joined: Tue Jul 31, 2012 7:23 pm

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by nadeem » Thu Nov 17, 2016 12:27 am

Another theory is, some times notifications fail if the server is down. You can see the notifications history at PayPal IPN history page. There is drop-down with delivery status of Failed, Sent, Disabled, Retrying Queued so IPN can be in either status.

The PayPal has automatic notification resend mechanism. If it re-sends notifications a bunch of times and it keeps failing they could put them on a much longer queue. PayPal will resend those when server is up again within 4 days and the number of re-send requests less than 15.

dandersonMLT
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 95
Joined: Sun Oct 04, 2015 5:45 pm

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by dandersonMLT » Fri Nov 18, 2016 5:34 am

Response from Paypal:

"The IPNs aren’t failing; sent you full validated response of one; shows the status as ‘completed’ which the payment should have been updated on the order side of able. You can try and do what he says but I highly doubt that’s the issue. It’s a programmatic matter when we’re sending the response back; improper updating the order."

Any other ideas?

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by Katie » Fri Nov 18, 2016 7:10 am

I've worked on issues like this before, and the problem ended up being the firewall. If the code was broken, then we would see every transaction fail plus a whole lot of customers complaining. I've literally spent weeks of my time on trying to resolve these random issues with Paypal. We never could track it down to the code, so there might be some other issue.

It's nearly impossible to solve random issues because we need to be able to reproduce an issue in order to fix it. BTW, the last time I've seen the error "User ID detected in PayPal response" was back in 2008 with a different version.

What is the exact version of AbleCommerce you are using? A better error message would also be helpful, and trying to understand why there are two different User ID's. Sometimes, you can look at the Page Views record for the user for some hints as to how they went through the checkout process.
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

dandersonMLT
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 95
Joined: Sun Oct 04, 2015 5:45 pm

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by dandersonMLT » Fri Nov 18, 2016 7:44 am

AbleCommerce Gold R10

dandersonMLT
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 95
Joined: Sun Oct 04, 2015 5:45 pm

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by dandersonMLT » Wed Nov 30, 2016 4:36 am

Any updates based on version Gold R10?

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by Katie » Wed Nov 30, 2016 6:20 am

Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

dandersonMLT
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 95
Joined: Sun Oct 04, 2015 5:45 pm

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by dandersonMLT » Wed Nov 30, 2016 10:25 am

So we should have the most up to date PayPal code.
Any other ideas of how to work around or fix these issues?

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by Katie » Wed Nov 30, 2016 10:37 am

Yes, please see my post from Fri Nov 18, 2016.

You have to first identify the issue which means you need to get some full error messages and be able to reproduce the issue.

In my experience, if it is random and only happens on occasion (not for every PP order), then it is not the code but some underlying issue with the server whether it be network, firewall or something else.

Thanks,
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

dandersonMLT
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 95
Joined: Sun Oct 04, 2015 5:45 pm

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by dandersonMLT » Thu Dec 01, 2016 5:11 am

Where can I obtain the full error messages?
Firewall seems unlikely since it works many times and only fails occasionally.

Paypal is willing to help where they can, but they aren't seeing anything on their side.
If you can point me in a direction of where to get the "Full" error messages I'll be glad to provide them.

If there is a higher level support ticket that we can open, even paid, the customer might be willing to do that as well.

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by Katie » Thu Dec 01, 2016 9:02 am

Hi,

You can view the full error message by going to the Help > Error Log page, or you can open the \app_data\logs\app.log file.

If you would like to open a support ticket, we can explain the details of paid support.

https://www.ablecommerce.com/helpdesk.aspx

You can't necessarily rule out the firewall. I've seen clients who are blocking inbound traffic and Paypal uses different servers to send the IPN. However, in your case, the error message makes me think this is a different issue.

Thanks,
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

dandersonMLT
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 95
Joined: Sun Oct 04, 2015 5:45 pm

Re: Paypal Express payment shows unprocessed but paid in Paypal

Post by dandersonMLT » Thu Dec 01, 2016 9:29 am

Thanks for your help. I have created a ticket at the link provided.

Post Reply