Add transaction id to partner payout dashboard export

Shopify App Store
1

Hi, the shopify partner payout export has no transaction ids.
The shopify partner api only gives us transaction id. Our finance team has no way of reconciling the two.

Is there a way we can reconcile the data between the api and the export ?
If not, will it be possible to add transaction id to shopify partner export?

1 Like
2

I used the partner api appEvents to do this.here is my script code

 const queryAppEvents = `
  query appEvents(
  $from: DateTime
  $to: DateTime
  $first: Int = 100
  $after: String,
  $appId: ID = "gid://partners/App/xxxxxxx"
) {
  app(id: $appId) {
    name
    events(
      first: $first
      after: $after
      occurredAtMin: $from
      occurredAtMax: $to
    ) {
      edges {
        cursor
        node {
          occurredAt
          shop { id myshopifyDomain }
          type
          ... on RelationshipInstalled { type }
          ... on RelationshipUninstalled { type reason description }
          ... on RelationshipReactivated { type }
          ... on RelationshipDeactivated { type }
          ... on SubscriptionChargeAccepted {
            type
            charge {
              amount { amount currencyCode }
              billingOn
            }
          }
          ... on SubscriptionChargeActivated {
            type
            charge {
              amount { amount currencyCode }
              billingOn
            }
          }```
3

+1 for this. Would be good to have a reliable way to uniquely identify each row/transaction in the CSV.