Page MenuHomePhabricator

We need to list of canceled recurrings in India to send to dLocal for them to stop sending pre-notification texts to donors
Closed, ResolvedPublic0 Estimated Story Points

Description

We need to list of canceled recurrings in India to send to dLocal for them to stop sending pre-notification texts to donors.

Requirement details:
Country - India
Currency - INR
Recurring - Yes
Recurring canceled - Yes
Date parameter - 01-April-2023 till date
Must include the token Dlocal returned in the subscription creation.

Event Timeline

@RKumar_WMF we need to determine whether this will be an ongoing workflow, or a one time thing?

Ok this will be for the recurring donors that were created with the monthly flow

This is one-time thing for the subscription created before we moved to On Demand.

Dwisehaupt set the point value for this task to 0.Jul 19 2023, 4:25 PM

I took the list of recurring created between April-June 2023 which is around 2500 subscriptions. I checked a sample size of 100 manually and 98/100 were canceled. We would like review the list of canceled donations so that we can analyse the reasons for cancelations and assess if we need to reach out to these donors to ask them to restart. Also, the pre-notifications are being sent even for canceled recurrings so dLocal team needs tokens dlocal returned in the subscription creation to stop sending pre-notifications.

Requirement details:
Country - India
Currency - INR
Recurring - Yes
Recurring canceled - Yes
Date parameter - 01-April-2023 till date
Canceled by
Must include the token Dlocal returned in the subscription creation.

We can make a searchkit to get a bunch of this info with the opposite parameters of the similar one showing active monthlys

Great. So will you make a new search kit and share with me? Ty.

We worked on building this in a call last week:
https://civicrm.wikimedia.org/civicrm/admin/search#/edit/1287

I updated it to show the token under Recurring Contribution Payment Token: Token