Why Are Some Refunded or Cancelled Shopify Orders Missing From the Destination?
We sync refunded and canceled orders to different tables based on the reason:
- Out-of-stock refunds appear in the
ORDER_ADJUSTMENTtable, not in theORDER_LINE_REFUNDtable. - Canceled orders appear in the
ORDER_LINE_REFUNDtable, not in theORDER_ADJUSTMENTtable.