Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sourav_Nandi
Contributor
Contributor

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

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?

Labels (1)
1 Reply
Xiaodi_Shi
Employee
Employee

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