Review refunds and disputes - Creatora

{
  orders(status: { equals: [refunded, disputed] }) {
    id status closedOn amountNetCharge amountNetRevenue amountNetProfit
    refund { refundedOn amount isPartial isTotal }
    dispute { disputedOn isWon fee }
    student { email }
    offerSnapshot { name }
  }
}

{
  "data": {
    "orders": [
      {
        "id": "55555555-5555-4555-8555-555555555555",
        "status": "refunded",
        "closedOn": 1788224400000,
        "amountNetCharge": 80.0,
        "amountNetRevenue": 60.0,
        "amountNetProfit": 57.0,
        "refund": {
          "refundedOn": 1788307200000,
          "amount": 20.0,
          "isPartial": true,
          "isTotal": false
        },
        "dispute": null,
        "student": {
          "email": "student@example.com"
        },
        "offerSnapshot": {
          "name": "Drawing Essentials"
        }
      }
    ]
  }
}

{
  orders(status: { equals: [refunded, disputed] }) {
    id status closedOn amountNetCharge amountNetRevenue amountNetProfit
    refund { refundedOn amount isPartial isTotal }
    dispute { disputedOn isWon fee }
    student { email }
    offerSnapshot { name }
  }
}

{
  "data": {
    "orders": [
      {
        "id": "55555555-5555-4555-8555-555555555555",
        "status": "refunded",
        "closedOn": 1788224400000,
        "amountNetCharge": 80.0,
        "amountNetRevenue": 60.0,
        "amountNetProfit": 57.0,
        "refund": {
          "refundedOn": 1788307200000,
          "amount": 20.0,
          "isPartial": true,
          "isTotal": false
        },
        "dispute": null,
        "student": {
          "email": "student@example.com"
        },
        "offerSnapshot": {
          "name": "Drawing Essentials"
        }
      }
    ]
  }
}

Review Orders currently refunded or disputed, including the refund amount or dispute outcome and the revenue retained.

Request

{
  orders(status: { equals: [refunded, disputed] }) {
    id status closedOn amountNetCharge amountNetRevenue amountNetProfit
    refund { refundedOn amount isPartial isTotal }
    dispute { disputedOn isWon fee }
    student { email }
    offerSnapshot { name }
  }
}

{
  "data": {
    "orders": [
      {
        "id": "55555555-5555-4555-8555-555555555555",
        "status": "refunded",
        "closedOn": 1788224400000,
        "amountNetCharge": 80.0,
        "amountNetRevenue": 60.0,
        "amountNetProfit": 57.0,
        "refund": {
          "refundedOn": 1788307200000,
          "amount": 20.0,
          "isPartial": true,
          "isTotal": false
        },
        "dispute": null,
        "student": {
          "email": "student@example.com"
        },
        "offerSnapshot": {
          "name": "Drawing Essentials"
        }
      }
    ]
  }
}

Use the result

const rows = response.data.orders.map(order => ({
  orderId: order.id, customer: order.student?.email ?? null,
  offer: order.offerSnapshot.name, status: order.status,
  eventDate: order.refund?.refundedOn ?? order.dispute?.disputedOn ?? null,
  originalCharge: order.amountNetCharge, refundedAmount: order.refund?.amount ?? null,
  disputeWon: order.dispute?.isWon ?? null,
  retainedRevenue: order.amountNetRevenue, profitAfterFees: order.amountNetProfit
})).sort((a, b) => (b.eventDate ?? 0) - (a.eventDate ?? 0));

The request has no list limit and returns each Order’s current state. Filter by eventDate for the refund or dispute period; closedOn is the original purchase completion date. A full financial-event history or payment reconciliation requires the provider’s records.