Page MenuHomePhabricator

Donation shows in Adyen but not in Civi - NL
Closed, ResolvedPublic

Description

Donation successful in Adyen but not found in Civi. Thank page was seen by tester. PSP reference number VQL7RPCTHS7WTM42. I am unable to provide donor email address due to privacy. Since donation in not in Civi unable to provide CID. To get the email address of the donor, you can check in Adyen using the PSP reference number provided.

Event Timeline

@RKumar_WMF Hi Rakhi, Please follow this task concerning this issue. https://phabricator.wikimedia.org/T313092. A known problem is being worked on that MAY be related to this. It involves someone testing and using %% in the test string that may be impacting imports. FRTech is investigating: I think someone had some test links and left %% as a placeholder for 'fill in language code here' but then never replaced it with 'en' or 'nl' or the like

@EMartin where are you getting the links to send to testers?

There were two failed donations early this morning, both iDEAL donations from folks with wikimedia email addresses and both not imported due to bad language codes. I see that the full code sent was '%%isolang%%'.

The %%isolang%% is standard code we use in our email donation links. That triggers the personalization that pulls in the specific contact's native language. I checked the email links and they are coded correctly. Not sure what would be causing the break in code.

@nisrael So when you send the email via Acoustic, Acoustic will replace %%isolang%% with the donor's language. When you manually copy a link to send to a tester outside of Acoustic, you need to manually replace that with e.g. 'en' or 'es' to make sure the donation gets into CiviCRM.

@Ejegg Hi Elliott, we are confused as to why the donations we ran yesterday are not in Civi. Are you saying we shouldn't copy links? Is this being worked on? Or is this the state of thing from here on?

@Ejegg Also, if we refund this transaction VQL7RPCTHS7WTM42, will the refund also not be reflected in Civi?

It's fine to copy links, but if copying *from Acoustic* be sure to replace the "%%isolang%%" bit with "en" or "es" or whatever language code makes sense.

Context: Acoustic uses placeholders that it replaces with what it knows about the recipient like their name, and in this case the language.

@EMartin if you copy links directly from an email template, you need to edit them by hand so they will be valid. When Acoustic sends an email from a template, it replaces a lot of tokens with data from the donor's record. One of those tokens is in the link.

If you see any %%blah%% in the link, please replace it with appropriate data before sending it out to a tester. For example, language=%%isolang%% should be replace with language=en (or language=es, etc).

@EMartin regarding the refund, if the parent transaction did not make it to Civi, neither will the refund.

Noting this here for posterity.
Ok so why didn't the parent transaction make it to Civi in the example Rakhi posted (not pulled from acoustic or was it?)
10:31 AM <greg-g> greg
Based on the logs (from elliot's comment at https://phabricator.wikimedia.org/T313826#8105569): because it was using an incomplete/broken url. If the url has "%%isolang%%" in it things will fail. No real user should be presented with such an url.

Could you please review transaction PSP reference number 121585092.1? This transaction was settled manually but it never made to Civi.

@RKumar_WMF manually settled Adyen donations would come in on the next audit file. It looks like they are sending those to us weekly these days, and we got the last one on Jul 29th. So if it's not in that one, it will probably come in on Aug 5.

Ejegg claimed this task.
Ejegg moved this task from Triage to Current Sprint on the Fundraising-Backlog board.
Ejegg moved this task from Backlog to Done on the Fundraising Sprint Machine Unlearning board.

The manually settled transaction was supposed to come in the recent audit file on Aug 5 but is not yet found in Civi.
PSP Adyen reference #: 122781361.1