Home » Forums » Ubercart » Support

Status not changing after IPN validates

Submitted by stompeers on Mon, 11/26/2007 - 17:11
stompeers

Posts: 76
 Joined: 09/19/2007
Bug FinderGetting busy with the Ubercode.

Hello,

I've been reading through the forum posts for the last hour or so, but can't quite narrow down a solution to this problem:

I'm currently using UC Alpha 7e with Paypal WPP, and order status' are not updating after the IPN goes through most of the time. Most of them say 'Pending' and a few say 'Payment Received'. The amount of the order doesn't seem to have an effect. Watchdog says that the IPN was received and was valid on both types.

I did notice that the ones that have a status of 'Pending' have an additional admin comment that says 'Order created through website.', while the ones with status 'Payment Received' only have a single comment that says something like:

$___ USD captured successfully through PayPal.
Address: Address and postal code matched
CVV2: Match

Any ideas as to why the status isn't changing? What might I do to be able to fix it?

Thanks!
Chris
permalink #1 Mon, 11/26/2007 - 18:39
torgosPizza

Posts: 1293
 Joined: 08/14/2007
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.

A couple posts for you to read through, perhaps to glean some ideas. This is not a new issue - I have seen it with PayPal WPS and had to make modifications.

http://www.ubercart.org/forum/support/1718/credit_cards_being_charged_or...

http://www.ubercart.org/issue/1540/file_download_and_paypal_not_calling_...

--

"Pain don't hurt." - Dalton

Mike Nelson's RiffTrax! www.rifftrax.com

permalink #2 Thu, 11/29/2007 - 13:31
stompeers

Posts: 76
 Joined: 09/19/2007
Bug FinderGetting busy with the Ubercode.

Thanks for the links, I had seen those but suspect my problem is more fundamental, though I could be wrong.

I took a look through the us_payment_paypal_ipn table to see if I could see any patterns, and here they are:

All orders that are successfully marked "Payment Complete" have txn_type 'express_checkout', and they also have something set for 'receiver_email'. All others, which are kept in 'pending' status, have a txn_type of 'web_accept' and have nothing set for 'receiver_email'.

So it looks like the IPN must be going through, but it isn't triggering some of the code in uc_paypal.module. Any thoughts on what might be going on here?

The big problem with this is that even if a transaction is declined, it's still keeping the status as 'pending', so the manager has to manually go through all the orders to check the comments and set the status manually.

Thanks!
Chris

permalink #3 Thu, 11/29/2007 - 13:44
stompeers

Posts: 76
 Joined: 09/19/2007
Bug FinderGetting busy with the Ubercode.

Let me add a little more detail that is confusing to me:

I have a transaction that went through successfully according to PayPal, and the order has the following comments:

Order Comments:
11/28/2007
8:54:33 AM	7		Payment received	-

Admin Comments:
11/28/2007
8:54:17 AM	7	9.99 USD captured successfully through PayPal.
                        Address: Nothing matched; transaction declined
CVV2: Match

This seems odd. The status under the order comments says "Payment received", but the current status of the order is "Pending" and according to PayPal, payment on the order has gone through.

What I need here is for the status to accurately reflect the state of the order. Also, I would like to know why in the admin comments in this example it says the transaction was declined, though it is clear that at some point the transaction went through?

Thanks!
Chris

permalink #4 Thu, 11/29/2007 - 14:01
torgosPizza

Posts: 1293
 Joined: 08/14/2007
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.

Do you have a Workflow-ng condition setup to update the order status?

Also that address issue might be the one in the other thread, about the address being overridden? Or is that just a WPS thing? (I don't use WPP so I can't help too much, I'm afraid).

--

"Pain don't hurt." - Dalton

Mike Nelson's RiffTrax! www.rifftrax.com

permalink #5 Thu, 11/29/2007 - 14:07
stompeers

Posts: 76
 Joined: 09/19/2007
Bug FinderGetting busy with the Ubercode.

In order to use Workflow NG, you need to upgrade to the latest version of UC, right? I'm currently on 7e.

permalink #6 Thu, 11/29/2007 - 16:20
torgosPizza

Posts: 1293
 Joined: 08/14/2007
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.

Could be wrong, but I think that's the first version that utilizes WF-ng? Either way you might want to upgrade anyway. The latest version probably has a lot of minor tweaks, additions and bug fixes that will make your life easier! Smiling

--

"Pain don't hurt." - Dalton

Mike Nelson's RiffTrax! www.rifftrax.com

permalink #7 Thu, 11/29/2007 - 18:17
stompeers

Posts: 76
 Joined: 09/19/2007
Bug FinderGetting busy with the Ubercode.

Thanks for your help, Torgos, I updated UC, did the rounding fix and added the checkout workflow. So far, it seems to be working well.