Page MenuHomePhabricator

Handle Gravy giving us wrong or inconsistent paypal trxn ID
Closed, ResolvedPublic

Description

When we get the gravy paypal rows the txn_id they have for Paypal is not the one stored when the donor initiates the payment - causing it not to ingress to CiviCRM @Cstone thinks this may be is a bug at Gravy's end but we can handle in in our Audit / Reconciliation code with a bit of duct tape.

contribution_extra.gateway gravy
gateway_txn_id 08486c38-54e0-4afa-acc2-8b1218234ef9
"backend_txn_id":"43P37729ES2101736" - this one from the reconciliation file
contribution tracking ID 243715804

*original paypal txn ID * "4XY584180P080392D

Contact ID https://civicrm.wikimedia.org/civicrm/contact/view?reset=1&cid=69566112

Event Timeline

Change #1234142 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Take what we can get

https://gerrit.wikimedia.org/r/1234142

Change #1234142 merged by Eileen:

[wikimedia/fundraising/crm@master] Take what we can get

https://gerrit.wikimedia.org/r/1234142

Change #1234153 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Fix transactionDetail to store

https://gerrit.wikimedia.org/r/1234153

Change #1234153 merged by Eileen:

[wikimedia/fundraising/crm@master] Fix transactionDetail to store

https://gerrit.wikimedia.org/r/1234153

OK - that worked - it has a transaction now!! Imported from the PayPal reconciliation report.

In terms of backfill - we will get these sorted as we run the back fill on the missing gravy chargebacks in https://phabricator.wikimedia.org/T405404 - we have PayPal reconcilliation reports going back to 2014 but obv not backfilling that far...

In terms of volume - looks like there are 3 of these from 25 Jan - but many days have 0. Maybe some hundreds? There were quite a few missing Gravy Adyen transactions back when I was focussing on Adyen but I think the PayPal ones are less

After deploying the fix for this I re-processed Dec & Jan paypal reconciliation files - looks like we rescued 182 gravy paypal donations - I *think* I had already rescued the chargebacks from this time but they might make up some of the rescued

Missing transactions found in logs: 182

Oddly I thought I had run all the files from Dec & Jan and that 182 would be the total retrievable gravy-missing - but I'm running files I thought I had run and they are resolving more. I will eventually have run them all a lot so they will all be in. I did create a separate issue to look at maybe not ignoring paypal / adyen IPNs when they relate to gravy transactions because they seem to be more reliable IPNS