Page MenuHomePhabricator

email addresses in Adyen donor name fields
Closed, ResolvedPublic

Description

There are about 1470 recurring Adyen donors whose Civi name fields are just their email addresses. There may be more than one cause to this, but the great majority seem to be donors whose Contact Source = Silverpop + a banner name, so it may be related to how recurring Adyen donations merge into existing RML CIDs?

We did not hear much from donors about this after the end of year recurring Thank You email send, but this Task is a request to look at the process to see if it can be improved to avoid future requests from donors. I found the list by searching for 'recurring Adyen past 30 days + name %@'. Spot checking the list, they all look like Apple Pay donors.

Some RML examples:
cid=58356055
cid=47018312
cid=44572974
cid=42110835

Some examples from non-RML cids:
cid=58392130
cid=53038546
cid=44466383

Also, @SHust did some research at IBM and cid=58392130 does show an RML source there (but not in Civi), so maybe there is a related issue with RML signups migrating to Civi.

Event Timeline

XenoRyet triaged this task as Medium priority.Feb 14 2023, 7:19 PM

From Michael: probably not needed until we get closer to end of year.

Looked into this a little bit, seems like some bug going on. One of the ones did have the donor name on the donation but it's NULL in the civicrm_contact db (which causes the email to show up as the name). Working on trying to replicate it locally.

So the one I found just lately was a GPay recurring. It didn't get a token from the front end for some reason, so the initial donations message from payments-wiki was bumped to the damaged queue for being recurring with no token.
Then we got a RecurringContract IPN for it (which DID have the token) but that was discarded because we only use those for iDEAL.
Finally we got an entry for it in the audit, ran the TokenizeRecurringJob on it, and sent that to the donations queue. It was entered into the database with an email address but no name attached.

For GPay and Apple Pay, since we get a full name field from Google or Apple, we don't send any name info to Adyen. So their IPNs and their audit files don't have that data.

Possible fix:

  • When a donation is recurring but we don't get the token on the front end, send it to the pending queue rather than donations.
  • Expand the RecurringContractJob to handle non-iDEAL donations, as long as they have a pending message.

I was looking at CZK contribs for this month and 18 one-time donations got this error too. Samples:

CIDDate ReceivedtransactionInvoiceRecurring ?Adyen?Source = Silverpop?
595772352023-05-05 09:32:12HS3V5S6T8ZT3MKG2175872417.1NY Apple MCY
595284782023-05-02 09:14:36TT3BD394CBK4K472175804065.1NY Apple MCY
595571342023-05-10 16:32:24SNJ9DJQG3VLQ4V42175915870.1NY Apple MCY
595923252023-05-07 17:58:41M4LZ8M7ZSS7WTM42175888024.1NY Apple MCY
595981982023-05-09 14:10:25DVDR7CDV7KFJ8X62175904777.1NY Apple MCY
595955752023-05-08 14:01:06DCZS8BLVC95CKMG2175891212.1NY Apple VisaY
595163502023-05-02 10:07:44LDWTLFZQW4H6SP42175804253.1NY Apple MCY
595483362023-05-07 12:04:03BCRZHFXT4969BV62175887189.1NY Apple MCY

Recent breadcrumbs:

177712621.1 cid=33533171 is a one-time ApplePay donation from Jul 13, with email address but no name and a Silverpop/RML contact source. Donor name is visible at Adyen console.

177711243.1 cid=55847508 is a one-time ApplePay donation from Jul 12, with email address but no name and a Silverpop/RML contact source. Donor name is visible at Adyen console.

cid=49363433 187546189.1 ApplePay Visa onetime Aug 3rd

cid=32204570 187547205.1 ApplePay Visa onetime Aug 3rd

MBeat33 renamed this task from email addresses in Adyen recurring donor name fields to email addresses in Adyen donor name fields.Aug 7 2023, 1:51 PM

Thanks for all the data @MBeat33 I think this something where the donor gets added to civi first through RML. When there is no name in civi the email address is shown. Then when the donor makes an actual donation we aren't updating the name in civi for some reason.

@MBeat33 just to confirm @Cstone's theory, I checked on 187546189.1 and found that we did actually collect names and send them to the queue from paymentswiki.

So I'll review how we update the donor info when adding a contribution to an existing donor, and change it to include adding a name when the existing record just has an email.

Change 959334 had a related patch set uploaded (by Ejegg; author: Ejegg):

[wikimedia/fundraising/crm@master] Test for adding missing name to matched contact

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

Change 959334 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Add missing name to matched contact

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

XenoRyet set Final Story Points to 2.