Goal progress showing wrong total

Hi Greg,

First off, that’s a really sweet implementation of Give. Well done!

Can you clarify a few things for me first:

1. Where the payments Test Payment?
2. Where they offline donations?
3. I’m a little confused on what the progress should actually be. Without those two transactions, what SHOULD the goal be? And what is it now?

Let me know. Thanks!

Thanks for the kind words and fast response, Matt.

1. The deleted transaction were live, not test. They were PayPal payments that were abandoned while pending (I’m guessing the donors bailed on the PayPal payment page). I wanted to remove the transactions so they wouldn’t be reflected in the total. In hindsight, it would probably have been better to mark them as abandoned.
2. They were PayPal donations. We started the campaign with PayPal and Stripe gateways active, but have since disabled PayPal and are going exclusively with Stripe. Offline payment is not active.
3. The goal progress should show $5,300, which is the actual amount raised to date. It currently shows $5,164.

Cheers

#3 is what I’m not following. Why should the goal show $5,300? It would seem there are multiple problems if your deleted Pending payments and the amount went down.

Perhaps the goal was reflecting those two payments and it shouldn’t have done that in the first place, which would mean the $5,164 is accurate. Or, when you deleted the pending payments the goal went down and in your reports it actually shows that the total COmpleted donations is $5,300 but the goal is incorrect.

That amount of detail will help isolate where the issue is in the code. Thanks for your help in narrowing that down.

OK, so I manually added up the transaction amounts and they match the report, so we know that number is correct (currently $5,475). But the goal progress on the donate page only shows $5,339. So it seems your second theory is correct.

Here’s the weird part: I can’t reconcile the variant between the two totals ($136). The two deleted transactions totaled $110, so you would think that would be the difference. All donations so far are divisible by 5 or 10, so how the heck do we get a number like 5,339? Weird.

I think we’ll need to access the site if possible to dig in deeper. Can you email me at [email protected] with WordPress and FTP credentials?

Hey Greg,

I don’t have a fix for you yet, but here’s the work-around. Goal progress is stored in the database as post meta. You can navigate in your database to wp_postmeta then find the table _give_form_earnings. Change that field to the appropriate amount and you’ll be on track again.

We’ll be digging into why the postmeta didn’t update correctly on delete. Thanks for the heads up!

Perfect. Awesome support, as always.