Refunded and/or Cancelled Orders Are Missing From Shopify Tables

Shopify handles refunded and/or cancelled orders as follows:

• If a Shopify order is refunded due to being out of stock, the order appears in the ORDER_ADJUSTMENT table but not in the ORDER_LINE_REFUND table.
• If an order is cancelled, it appears in the ORDER_LINE_REFUND table but not in the ORDER_ADJUSTMENT table.

No Action Required

This behavior is expected and is the default functionality of the Shopify app. You don't need to take any action.