Needed to reflect donors who opted in but whose payment attempts then failed.
|Resolved||Ejegg||T216293 Send message to opt-in queue on failed payments attempts with opt_in=1|
|Resolved||Ejegg||T217712 Update Silverpop export to include opted in records with no donations|
So I've been struggling all afternoon to get the script tests/test_update.py to run & still think I'm failing after lots of mucking around with what is or isn't installed.
But then I went back to the queries and I started to wonder if this is actually happening already
We build silverpop_export_staging with
WHERE e.email IS NOT NULL AND e.email != '' AND c.is_deleted = 0 AND e.is_primary = 1;
ie no contribution filter
And later on we use no contribution filter on our final export tables
@CCogdill_WMF you're correct, we are not yet creating Civi records for people with failed donations. I'm not sure where those 405,576 people are from, but a whole lot of them have the opt_in field empty. Maybe from the remind me later lists?
There are two code patches for creating records in civi for opt-in/failed donations, and each has their own Phab ticket. The payments-wiki patch (T216293) was just approved yesterday, and the civi patch (T217710) is still in process.