Page MenuHomePhabricator

recent Gravy donations not in Civi
Open, MediumPublic

Description

The first is a PayPal donation from October 18th that was manually captured on November 6th. Manually settling PayPal's at Gravy is a new workflow.

9629b124-2829-4139-8842-21a7ff1946eb
cid=24645612
ZD #176575

The second is a new recurring card donation from yesterday, November 12th. @KHancock99 noted that happened this around the same time as a slowdown mentioned by Dallas in Slack.

80892609-9caf-4a3c-8d5b-a2f1c62a8ba4
ZD #1773036
multiple email addresses

I've added these to the Transactions Log in the Gravy tracker, and can manually import to Civi if needed.

Event Timeline

MBeat33 updated the task description. (Show Details)

80892609-9caf-4a3c-8d5b-a2f1c62a8ba4 seems to have been imported to Civi over the weekend.

The ID for the PayPal one exists in a Gravy audit file that's marked as completed, so I'm not sure why that didn't get sent to Civi. I'll do a quick dive into what gets parsed out of that file.

OK, I see, we only have the authorization_succeeded, not the capture_succeeded for the PayPal one. So we should ask Gravy why it didn't get into an audit file on 11/6 or 11/7. Should be OK to insert it manually, just making sure you add the gateway field and the invoice ID. Of course it would be nicer to have that automatically populated from the trxn ID where you're already adding it...

Thanks @Ejegg for noting in the Gravy Tracker that PayPal 9629b124-2829-4139-8842-21a7ff1946eb only appeared in Gravy's all_transactions report as authorization_succeeded, never as capture_succeeded (despite showing status Captured at the console). Hopefully they can clarify that.

I just added it to Civi and sent the TY email.

XenoRyet triaged this task as Medium priority.Nov 18 2025, 8:24 PM
XenoRyet moved this task from Triage to Chaos Crew Backlog on the Fundraising-Backlog board.

Notes from the gravy call: it seems like their all transactions report for a particular day only includes donations with a creation date of that day, not donations updated on that day. So with their current logic we would have to re-run transaction reports for previous days in order to pick up something that captures later. They also say they send a webhook for this capture, though - let's see why we didn't record the capture from that webhook.

Per thread in Slack, a recent inadvertent manual settle at Adyen reached Civi the next day, thanks to recent work by @Eileenmcnaughton

The 'nightly audit file ingestion' item is still open at the Gravy Tracker, but apart from the PayPal Resolution Center stuff T405404: Handle Gravy Paypal Chargebacks and Refunds from the resolution center we're not seeing many missing transactions. Will monitor and resolve this Task if nothing else fails to reach Civi.

@MBeat33 - just for clarification -we are parsing these out of the Adyen audit files, not the gravy files so no direct link with the Gravy tracker task

I'm running the audit parser on paypal fields now to check the gaps there - I can see some missing transactions so just making sure the cope copes with them