[go: up one dir, main page]

Page MenuHomePhabricator

dLocal is sending invalid 0000@dlocal.com donor emails in IPNs
Closed, ResolvedPublic

Description

TLDR: There are a ton of dLocal India donors who have not received their thank-you emails because we've tried to send them to the email address dLocal sent us back in IPNs, which is not the same as the initial email the donor submitted when donating, and instead, a made-up @dlocal.com email address.

Samples:

  • 207408608
  • 204255729
  • 191464698
  • 191474462
  • 191461548

Full:
@krobinson mentioned that a donor enquired why they never received their thank you email. After scanning the weblogs, I found 210878546 and 210878580 related to that donor, and I can see that we sent over the donor's Gmail email address as part of the payment transaction, but then later on dLocal sent us back a new email address in the follow-up IPNs. The email follows a convention of firstname_lastname0000@dlocal.com, and it appears that we're then using this email address to send the thank you email to, which is failing as it doesn't exist.

When grepping the logs from today, I see hundreds of affected donations. To see them, hop on to frlog1002 and run:
grep '"status":"PAID"' --color=always /var/log/remote/payments-listener-dlocal | grep --color=always '"country":"IN"' | grep --color=always 0000@dlocal.com

Update:
This seems to be specific to recurring UPI subscriptions and does not affect one-time UPI payments.

Event Timeline

jgleeson renamed this task from dLocal sending is invalid 0000@dlocal.com donor emails in IPNs to dLocal is sending invalid 0000@dlocal.com donor emails in IPNs.Aug 6 2024, 4:23 PM

I made the group 0000@dlocal.com email addresses for easier searching in searchkit

For added context, this also means that donors are still receiving follow up fundraising emails, despite making a donation, as the scan will not be looping them out of sends.

India email 2 is not for a while, but I recommend holding off until we have the correct email addresses in Civi.

If they are UPI/PayTM and need to be notified of the switch to Razorpay, this would also impact that outreach email.

XenoRyet triaged this task as High priority.Aug 6 2024, 7:49 PM

To add on to what @krobinson said:

  • There are 71 one time donors that have been affected by this
  • Any new recurring since July 31 will also not have the right email in civi (61 so far)

We should be able to get their emails from the logs

The big number (3028) are from older recurrings, we have their old email addresses in the civicrm log tables and will able to change them back.

Change #1060189 had a related patch set uploaded (by Cstone; author: Cstone):

[wikimedia/fundraising/crm@master] WIP: Reset dlocal emails to before 0000@dlocal issue

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

Plan for now:

  • run the upgrader and patch above to fix the recurring emails
  • figure out a script to grab the other emails from the logs
  • resend tys for recurrings
  • unhold all the bounced 0000@ addresses

From dLocal - This issue as been fixed and the donor's email are now generated correctly. We are working to get the list of all impacted donor, and will be sent shortly.

Change #1060189 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Reset dlocal emails to before 0000@dlocal issue

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

the update got ran with the civi upgrade, email addresses are reset to what they were before for the recurrings and they have been unholded

Hi @Cstone I am unable to find any of the sample CID listed in Civi. Can you please check? Ty.

XenoRyet set Final Story Points to 4.