Missing Refund Quantity in orders Table in Latest Version – Shopify Stitch Integration

Sourav_Nandi — Mon, 30 Jun 2025 06:22:20 GMT

Hi,
In the previous version of the Shopify integration via Stitch, the orders table included a column for refund quantity. In the latest version, that column seems to be missing.

I noticed that the order_refunds table now has refund-related data.

Can we use the refund_quantity (or similar) from order_refunds as a reliable replacement?

Re: Missing Refund Quantity in orders Table in Latest Version – Shopify Stitch Integration

Xiaodi_Shi — Thu, 18 Sep 2025 06:00:10 GMT

Hello @Sourav_Nandi
A signficant caveat, the refunds field will not be available under Orders. Due to Shopify's API rate limits, requesting too much data in a single API call throws an error. Instead, the Order_Refunds table captures all of the refunds details and should be replicated.

Some good news, minor version 3.1 was released and the fulfillments and lineitems fields, along with a few others, are now available under the Orders table. You will need to go into the integration settings and select them.
Best regards

Sabrina

topic Re: Missing Refund Quantity in orders Table in Latest Version – Shopify Stitch Integration in Stitch

Missing Refund Quantity in orders Table in Latest Version – Shopify Stitch Integration

Re: Missing Refund Quantity in orders Table in Latest Version – Shopify Stitch Integration