Page MenuHomePhabricator
Create Task
Maniphest T412174

Check Braintree venmo refunds and disputes from audit
Open, Needs TriagePublic
Actions

Description

So we are getting the files:

settlement_batch_report_refund_2024-09-26.json
settlement_batch_report_dispute_2024-09-04.json

  • I think we are processing the refunds, confirm that
  • I don't think we are doing anything for the disputes/chargebacks, if so add that

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Add flag to output to single filewikimedia/fundraising/SmashPigmaster+127 -45
Add handling for raw refund filewikimedia/fundraising/SmashPigmaster+238 -2
Add handling for raw files (if they exist)wikimedia/fundraising/SmashPigmaster+355 -5
Allow start & end date instead of hours as optionswikimedia/fundraising/SmashPigmaster+17 -5
Useful additional fields plus graphQL fixwikimedia/fundraising/SmashPigmaster+36 -2
Add ability to pass in alternate date-typeswikimedia/fundraising/SmashPigmaster+23 -1
Add ability to output raw files to Braintree maintenance, add statusHistorywikimedia/fundraising/SmashPigmaster+20 -2
Output transactions in disputes braintree filewikimedia/fundraising/SmashPigmaster+6 -1
Customize query in gerrit

Event Timeline

Cstone created this task.Dec 10 2025, 3:59 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 10 2025, 3:59 AM
Eileenmcnaughton subscribed.Dec 10 2025, 5:26 AM

OK some data on what that dispute stuff means

https://chatgpt.com/share/6939047e-d750-800a-8fe4-596d6bbc1a8e

Eileenmcnaughton added projects: Wikimedia-Fundraising-CiviCRM, FR-WMF-Audit.Dec 14 2025, 2:54 AM
gerritbot added a comment.Dec 14 2025, 2:54 AM

Change #1217846 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Output transactions in disputes braintree file

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

gerritbot added a project: Patch-For-Review.Dec 14 2025, 2:54 AM
gerritbot added a comment.Tue, Dec 16, 7:40 PM

Change #1217846 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Output transactions in disputes braintree file

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

AKanji-WMF moved this task from Triage to Current Sprint on the Fundraising-Backlog board.Tue, Dec 16, 8:18 PM
Maintenance_bot removed a project: Patch-For-Review.Tue, Dec 16, 8:30 PM
AKanji-WMF added projects: Fundraising Sprint: Yabba Dabba Stew, fr-current-sprint.Tue, Dec 16, 8:37 PM
Eileenmcnaughton added a comment.Thu, Dec 18, 3:14 AM

OK - so the raw now gives better info

{
  "cursor": "WkdsemNIVjBaVjh6YWpocU1uZDJOWE42ZVhkdE16bGo7MjAyNS0xMi0xNlQyMDoyMTo1M1o",
  "node": {
    "id": "ZGlzcHV0ZV8zajhqMnd2NXN6eXdtMzlj",
    "legacyId": "3j8j2wv5szywm39c",
    "type": "CHARGEBACK",
    "caseNumber": "xxxxxx",
    "createdAt": "2025-12-16T20:21:53.000000Z",
    "referenceNumber": null,
    "receivedDate": "2025-12-16",
    "status": "OPEN",
    "transaction": {
      "purchaseOrderNumber": null,
      "id": "dHJhbnNhY3Rpb25fZzEwem04NmI",
      "orderId": "240578023.1",
      "createdAt": "2025-11-25T18:11:09.000000Z",
      "paymentMethodSnapshot": {
        "username": "xxxxxx",
        "venmoUserId": "xxxxxx"
      }
    },
    "amountDisputed": {
      "value": "50.00",
      "currencyCode": "USD"
    },
    "amountWon": {
      "value": "0.00",
      "currencyCode": "USD"
    }
  }
}
,
{
  "cursor": "WkdsemNIVjBaVjlqZVdNMWQyWjBhbXQwY2pocU5IZG07MjAyNS0xMi0xNVQyMDoyNjoyNVo",
  "node": {
    "id": "ZGlzcHV0ZV9jeWM1d2Z0amt0cjhqNHdm",
    "legacyId": "cyc5wftjktr8j4wf",
    "type": "CHARGEBACK",
    "caseNumber": "yyy",
    "createdAt": "2025-12-15T20:26:25.000000Z",
    "referenceNumber": null,
    "receivedDate": "2025-12-15",
    "status": "ACCEPTED",
    "transaction": {
      "purchaseOrderNumber": null,
      "id": "dHJhbnNhY3Rpb25fbWVrYzgwc3Q",
      "orderId": "241838567.1",
      "createdAt": "2025-12-09T20:56:47.000000Z",
      "paymentMethodSnapshot": {
        "username": "XYZ",
        "venmoUserId": "ZZZ"
      }
    },
    "amountDisputed": {
      "value": "68.70",
      "currencyCode": "USD"
    },
    "amountWon": {
      "value": "0.00",
      "currencyCode": "USD"
    }
  }
}

But most of it didn't bubble up

[
  {
    "contribution_tracking_id": "",
    "invoice_id": null,
    "payment_method": "venmo",
    "gross": "0.00",
    "currency": "USD",
    "email": null,
    "phone": null,
    "first_name": "LMN",
    "last_name": null,
    "gateway_txn_id": "ZGlzcHV0ZV8zajhqMnd2NXN6eXdtMzlj",
    "date": "2025-12-16",
    "type": "chargeback"
  },
  {
    "contribution_tracking_id": "",
    "invoice_id": null,
    "payment_method": "venmo",
    "gross": "0.00",
    "currency": "USD",
    "email": null,
    "phone": null,
    "first_name": "QRF",
    "last_name": null,
    "gateway_txn_id": "ZGlzcHV0ZV9jeWM1d2Z0amt0cjhqNHdm",
    "date": "2025-12-15",
    "type": "chargeback"
  },
]

Note that one is Open and one is Accepted - we probably want to filter out the ones that aren't accepted? Not sure the range of statuses

gerritbot added a comment.Mon, Dec 22, 11:14 PM

Change #1220404 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Add ability to output raw files to Braintree maintenance, add statusHistory

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

Eileenmcnaughton moved this task from Backlog to Doing on the Fundraising Sprint: Yabba Dabba Stew board.Mon, Dec 22, 11:14 PM
gerritbot added a project: Patch-For-Review.Mon, Dec 22, 11:14 PM
Eileenmcnaughton claimed this task.Mon, Dec 22, 11:14 PM
Cstone closed this task as Declined.Mon, Dec 22, 11:19 PM

Due to how they settle, looks like we don't need fees for now

Cstone reopened this task as Open.Mon, Dec 22, 11:19 PM

whoops wrong task

gerritbot added a comment.Mon, Dec 22, 11:31 PM

Change #1220407 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Add ability to pass in alternate date-types

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

gerritbot added a comment.Tue, Dec 23, 5:02 AM

Change #1220404 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add ability to output raw files to Braintree maintenance, add statusHistory

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

gerritbot added a comment.Tue, Dec 23, 5:02 AM

Change #1220407 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add ability to pass in alternate date-types

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

Maintenance_bot removed a project: Patch-For-Review.Tue, Dec 23, 5:30 AM
gerritbot added a comment.Tue, Dec 23, 8:06 PM

Change #1220649 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Allow start & end date instead of hours as options

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

gerritbot added a project: Patch-For-Review.Tue, Dec 23, 8:06 PM
gerritbot added a comment.Wed, Dec 24, 2:09 AM

Change #1220660 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Useful additional fields plus graphQL fix

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

gerritbot added a comment.Wed, Dec 24, 2:26 AM

Change #1220662 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Add handling for raw files (if they exist)

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

gerritbot added a comment.Thu, Jan 1, 11:46 PM

Change #1220660 abandoned by Eileen:

[wikimedia/fundraising/SmashPig@master] Useful additional fields plus graphQL fix

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

gerritbot added a comment.Fri, Jan 2, 3:01 AM

Change #1222527 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Add handling for raw refund file

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

gerritbot added a comment.Fri, Jan 2, 4:18 AM

Change #1222530 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Add flag to output to single file

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

gerritbot added a comment.Mon, Jan 5, 6:01 PM

Change #1220649 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Allow start & end date instead of hours as options

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

gerritbot added a comment.Mon, Jan 5, 7:09 PM

Change #1220662 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add handling for raw files (if they exist)

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

gerritbot added a comment.Mon, Jan 5, 7:10 PM

Change #1222527 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add handling for raw refund file

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

gerritbot added a comment.Mon, Jan 5, 10:55 PM

Change #1222530 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add flag to output to single file

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

Maintenance_bot removed a project: Patch-For-Review.Mon, Jan 5, 11:30 PM
Eileenmcnaughton moved this task from Doing to Pending Deployment on the Fundraising Sprint: Yabba Dabba Stew board.Tue, Jan 13, 2:15 AM
AKanji-WMF edited projects, added Fundraising Sprint: A 2026; removed Fundraising Sprint: Yabba Dabba Stew.Tue, Jan 13, 9:32 PM
AKanji-WMF moved this task from Backlog to Pending Deployment on the Fundraising Sprint: A 2026 board.
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits