Also, RECURRING GLOBALCOLLECT 8974545132-5 from December 3rd, 2017 came from a banner on the Initial List tab of
en6C 2017: Mobile/iPad banners with confusing frequency toggle:

B1718_120218_en6C_ipd_p1_lg_frm_cnt.no-LP.rcc

We just got the complaint from the donor today: should the initial round of proactive cancellations have caught this one?

The email lists and transaction lists for both GC and PayPal have been generated and are in the tmp folder on frdev.

@CCogdill_WMF we are ready to go to cancel the paypal transactions with the email list on frdev. When would you be able to send out the email?

I don't think I have time to get these out today and I think it's DS policy not to send these on Fridays. Would Monday work? @MBeat33 if you feel like this needs to happen today, let's see if @MNoorWMF can help.

@XenoRyet what are the filenames?

Thanks. Having the cancellations & refunds done soon after the emails are sent is best for donor experience, so it's contingent on @MNoorWMF & @XenoRyet having similar availability. I will ping both in IRC to see, but Monday is fine if all players don't have bandwidth today.

@MBeat33 @MNoorWMF @CCogdill_WMF I can do the paypal cancellations & refunds.

Thank you, @mepps and @MNoorWMF

We got the remainders list from William at PayPal and are canceling the last 24 stragglers manually.

Thanks @MBeat33 just saw this.

We are still seeing donors report unintended recurrings from B1718_120218_en6C_ipd_p1_lg_frm_cnt.no-LP.rcc, which was part of the batch processed in T186883: Unintended recurring: pull list and help automate refunds. Can we add that banner to this batch of Ingenico recurring cancel-&-refunds, to catch any more that we might have missed? PayPal is less urgent cause we get a year to refund them, but Ingenico is nearing the end of the refund time limit.

@XenoRyet can you update your query for globalcollect? And can you see how many donors in paypal would be affected?

@MBeat33 When you look at those donors still affected by this banner, were any of their charges refunded?

@mepps I'm not sure how to query all donations from that banner to spot-check. All I know is it was in the list for the first round of proactive cancel/refunds, and we're seeing donors who used it report unintended recurrings that have been neither canceled nor refunded. If you know the query, please paste in and I can spot check to see if any from that banner have been proactively canceled/refunded.

@MBeat33 yeah @XenoRyet can do the query, I was more curious what you were seeing with the donors reporting.

Ah, yes, the donors who are reaching out are ones where the donations need to be refunded as well as canceled, so I think the first refund script did not include them, @mepps

@MBeat33 Got it, I just wanted to make sure one or the other process didn't fail. It sounds like they just weren't included in the original query.

I've added B1718_120218_en6C_ipd_p1_lg_frm_cnt.no-LP.rcc to the current batch and rerun the queries for GC. Updated files are on frdev.

Change 435052 had a related patch set uploaded (by XenoRyet; owner: XenoRyet):
[wikimedia/fundraising/crm@master] Unintended Recur Part 3

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

@CCogdill_WMF @MBeat33 I believe I'm more or less set to do the GC cancellations and refunds. Do I need to wait for an email to get sent to donors, or should I just go ahead and run it?

Thank you @XenoRyet It's good if the email follows not too long after the cancel/refunds. @CCogdill_WMF would you or @MNoorWMF have bandwidth for a GC email tomorrow? Tuesday as a plan B is not terrible.

Sure. Can we set a time to start so we know when to expect the email?

Le jeu. 24 mai 2018 à 14:57, MBeat33 <no-reply@phabricator.wikimedia.org> a
écrit :

MBeat33 added a comment.

Thank you @XenoRyet https://phabricator.wikimedia.org/p/XenoRyet/ It's
good if the email follows not too long after the cancel/refunds.
@CCogdill_WMF https://phabricator.wikimedia.org/p/CCogdill_WMF/ would
you or @MNoorWMF https://phabricator.wikimedia.org/p/MNoorWMF/ have
bandwidth for a GC email tomorrow? Tuesday as a plan B is not terrible.

*TASK DETAIL*
https://phabricator.wikimedia.org/T192958

*EMAIL PREFERENCES*
https://phabricator.wikimedia.org/settings/panel/emailpreferences/

*To: *XenoRyet, MBeat33

*Cc: *gerritbot, MNoorWMF, mepps, CCogdill_WMF, XenoRyet, Aklapper,
krobinson, Ppena, MBeat33, Versusxo, Majesticalreaper22, Giuliamocci,
Adrian1985, Cpaulf30, Baloch007, Darkminds3113, Bsandipan, Lordiis,
Adik2382, Th3d3v1ls, Ramalepe, Liugev6, Lewizho99, Maathavan, DStrine

Change 435052 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Unintended Recur Part 3

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

Tomorrow would technically violate our No Friday Deploy policy, but it's such a tiny and safe deploy that I'm happy to do it anyway. Tuesday would be fine as well if that works better for folks. Tomorrow after 10:30ish Pacific or anytime on Tuesday would work for me.

Cool, want to say tomorrow 11am pst for the cancel & refunds, and the emails as close as possible after the scripts finish?

Works for me.

@MBeat33 @CCogdill_WMF Just confirming we're good to go on this in about an hour at 11:00 pacific?

Good from DS-land, @XenoRyet - do you know the # of donors this time around? Thanks

@MBeat33 Looks like about 641 donors in this round.

Great, that's not a crazy number, @XenoRyet thanks

Change 435195 had a related patch set uploaded (by XenoRyet; owner: XenoRyet):
[wikimedia/fundraising/crm@deployment] Unintended Recur Part 3

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

Change 435195 merged by jenkins-bot:
[wikimedia/fundraising/crm@deployment] Unintended Recur Part 3

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

Cancellations and refunds have been done, everything ran as expected.

@XenoRyet awesome news, thank you!

@MBeat33 Is that just for globalcollect?

We haven't seen any from Paypal, @mepps but would need some sample transactions to know for sure.

RECURRING GLOBALCOLLECT 6018183811-4 is one from the November/October batch of cancel/refunds where the final donation remains but the earlier ones (including the first) are refunded.