Page MenuHomePhabricator

Civi: enable search by merchant reference # for failed donations
Open, Needs TriagePublic

Description

Donors send many error reference #s to DR that we're unable to locate at the PSP consoles. The Civi logs may contain information that enables us to recommend specific actions to these donors to help them donate.

From a conversation in Slack about this, @jgleeson summarized what we'd like as:

"..something similar to what we do for the damaged queue and show all the data with filterable fields, allowing you to look up any data relating to the contribution tracking ID provided by donors. This would provide you with basic information, including the URL parameters they visited with, and, in some cases, their OS and browser versions, which could serve as a starting point for certain queries."

In the example of 234064733.1, the logs pointed to the IPDenyList as a cause of rejection, so if possible it would be great to have fraud scores among the info that's searchable.

Event Timeline

Logs are tricky, but we could look at contribution tracking and pending rows for starters

AKanji-WMF moved this task from Triage to Next on the Fundraising-Backlog board.

Team discussing a consolidated report view with different table data from contribution tracking i.e. failed, damaged on a single page

@Eileenmcnaughton flags this Autocomplete which may be helpful in addressing this

Logs are tricky, but we could look at contribution tracking and pending rows for starters

@Ejegg we could put a UI on @Eileenmcnaughton's recent TransactionLog to help Michael on this one.

jgleeson renamed this task from Civi: enable log search by merchant reference # for failed donations to Civi: enable search by merchant reference # for failed donations.Oct 9 2025, 12:13 PM

fr-tech talked a bit about making a Payment attempt table this week which would help expose this data in civi