Why Are Some Orders Missing From the BALANCE_TRANSACTION Table?
Question
Why are some orders missing from or delayed in the BALANCE_TRANSACTION table?
Environment
Connector: Shopify
Answer
Fivetran uses payout IDs to retrieve BALANCE_TRANSACTION records. However, the Shopify API only returns PAYOUT records after the associated payout is updated.
Shopify may update payouts several days after the related order is processed. As a result, ORDER records may sync before their corresponding BALANCE_TRANSACTION records become available.
The date column in the PAYOUT table indicates when the payout is scheduled or issued. It does not indicate when the payout data becomes available through the Shopify API. You should not use the date column to determine when related BALANCE_TRANSACTION records are expected to appear in your destination.