The Shopify connector syncs order, return, and refund data. However, it does not capture product exchanges when they happen within the same order number.

In Shopify, when a product is exchanged (instead of refunded), the replacement item is added as a new line item in the same original order, often with an updated fulfillment status. This behavior is not currently exposed clearly in the Fivetran schema.

Please enhance the Shopify connector to identify and extract exchange activity, including:

• New line items added post-fulfillment (exchanged products)

• Metadata or flags indicating a line item is a replacement for another

• Link between the original returned item and its replacement

• Updated timestamps for when the exchange occurred

• Any price difference adjustments