How does Shopify grab refund records when the Stripe account is shut down?

[EstherL97]

Stripe's account is now closed. Shopify can't refund directly. We need to refund manually on stripe's website, but Stripe's refund doesn't capture the refund history back to the Shopify background.Is there a docking API that our technical team can use to crawl Stripe refund records on Shopify?

[Greg_Kujawa]

This should be doable with the GraphQL API endpoint. I assume that Stripe would be the payment gateway name. While I don't believe you can query just those orders with that specific payment gateway name, you can iterate through the orders and only handle those that match. Here's an example GraphQL API request below, where I'm pulling the first 5 orders and retrieving those details.

Hope this helps!

{
  orders(first: 5) {
    edges {
      node {
        name
        id
        customer {
          id
          displayName
        }
        createdAt
        updatedAt
        displayFinancialStatus
        totalPriceSet {
          presentmentMoney {
            amount
            currencyCode
          }
        }
        totalDiscountsSet {
          presentmentMoney {
            amount
            currencyCode
          }
        }
        totalRefundedSet {
          presentmentMoney {
            amount
            currencyCode
          }
        }
        transactions {
          id
          kind
          status
          createdAt
          amountSet {
            presentmentMoney {
              amount
              currencyCode
            }
          }
          gateway
          authorizationCode
        }
      }
    }
  }
}