Page MenuHomePhabricator

Adyen audit files + missing manual settles Dec 2024
Closed, ResolvedPublic

Description

Lindsay noticed that the donor in cid=29072714's donation settled at Adyen on 12/6 but never reached Civi.

merchant ref 224397787.1
PSP ref BZSBH975C68KGX62

Could we re-run the audit file for 12/6 to get this and any other laggards to Civi?

Another missing manual settle is PSP ref CTGQMKPDF8JCG969, merchant ref 227043722.1 from December 20th.

We also have two missing from Dec 27th and will add to this Task if the weekly audit does not import them to Civi.

Event Timeline

MBeat33 renamed this task from December 6th Adyen audit file check to Adyen audit files + missing manual settles Dec 2024.Jan 2 2025, 5:11 PM
MBeat33 updated the task description. (Show Details)

Another manual settle not in Civi:

merchant ref: 227750668.1
payment reference JFF95KM783RQM8F6 / V4F2TZF28J7KZQ25
Zendesk #1612455
manually settled December 27th, not in Civi January 6

XenoRyet triaged this task as High priority.Jan 6 2025, 8:48 PM

Change #1109114 had a related patch set uploaded (by Damilare Adedoyin; author: Damilare Adedoyin):

[wikimedia/fundraising/SmashPig@master] Map 'visadebit_applepay' payment method to allow successful audit imports.

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

@MBeat33 Thanks for putting this forward, I've ran the job to import the transaction 227750668.1. This wasn't automatically imported because of the time between the payment attempt and the settlement date. I see the transaction with order_id 224397787.1 has also been imported automatically.

Also looks like Adyen introduced this new PaymentMethod variant called "visadebit_applepay" but failed to publish it on the docs. Our audit import job fails on these transactions as it isn't one of the recognised methods we have specified. I've added it in the linked patch and should allow importing of some missing transactions when deployed.

Change #1109114 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Map 'visadebit_applepay' payment method to allow successful audit imports.

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

Thank you so much, @Damilare. I will mention to our Adyen rep that them adding methods without publishing them causes issues for us, maybe they can improve that on their end.

227750668.1 reached Civi, thank you.

@Damilare re "This wasn't automatically imported because of the time between the payment attempt and the settlement date." - is there a limit to how much time we have to manual settle before a donation won't be imported?

Jake at Adyen said that the best way to pick up when new PaymentMethod variants are added is to receive alerts from the "New from payment partners" category of alerts:

Screenshot 2025-01-28 at 12.22.49 PM.png (1×2 px, 321 KB)

He also said they would keep the docs up to date, but it's clear they missed this one.

Thanks @MBeat33 for following up with Adyen. Given the docs still hasn't been updated with the visadebit_applepay payment method, seems like the notification settings could be the safest option. However, I just checked my account on Adyen's console, but can't seem to find the setting in the picture you shared. Perhaps I don't have the required privileges for that, if that's the case, please can you set in such a way that FRTech gets a notification email when the payment method list is updated? Thanks.

Re: "is there a limit to how much time we have to manual settle before a donation won't be imported?" Currently we have this limit to 12 days, I believe this is to ensure the audit imports perform optimally. If the transaction is more than 12 days old, you can alert us so we increase the limit for that run to cover for the manually settled transaction.

Many thanks @Damilare for the info re the 12 day manual settlement timeframe, I'll share that with the DR team. And thanks for the option to revise the limit to capture as needed, that should be a rare case.

Thanks also for subscribing via the console to the Adyen alerts (Slack convo). I'll definitely let Jake know the documentation is still not up to date.

XenoRyet set Final Story Points to 4.