Differentiate Between Fulfilled and unFulfilled Refunds With No_Restock

Technical Q&A
1

Hello -

I need to differentiate refunds from refunded fulfilled items and refunded unfulfilled items.

Shopify allows to refund both (and optionally to restock) but from the Order endpoint how do I know if the refunded item was fulfilled or unfulfilled with value no_restock ?

Any other way I can differentiate the two?

1 Like
2

Hello @YPD , Have you find a way to differentiate it? I’m also having hard-time identifying if refunded item is fulfilled or not.

3

Hi @tyuzu , did you get any workarround for this? Thanks!

4

@mdou , Unfortunately, I couldn’t find a workaround for it, so I gave up(that time) and changed my process flow instead.

5

@tyuzu not exactly i found but you can differentiate with using the graphql.json api. In graphql api check nonFulfillableQuantity , currentQuantity & unfulfilledQuantity parameter.

6

Thanks @tyuzu . That’s exactly what I have tried (change my workflow).

@YPD using GraphQL API with nonFulfillableQuantity, currentQuantity and unfulfilledQuantity does not help differenciating when a refund line comes from a fulfilled or unfulfilled product (when the order is at least, partially fulfilled). Imagine having an order with only 1 product but quantity 2 with only 1 fulfillment order (one location). If you fulfill only one unit, the order status then changes to partially fulfilled. THen you refund both units (one fulfilled and the order unfulfilled) with NO restock. Using GraphQL (and API REST) there is no difference in these 2 refunds. They are exactly the same, but in my case business process in my ERP are completely different. Someone from Shopify dev team should answer that (do you know how can I post a change proposal or a ticket?).

7

Hello @mdou ,

If you just need the qty of refunded fulfilled item and refunded not fulfilled item. you can use this instead:

// GRAPHQL
lineItems("first":250){
"nodes"{
"quantity",
"unfulfilledQuantity",
"nonFulfillableQuantity",
"refundableQuantity",
}
}

const totalQty: number = node.quantity;
const totalCancelled: number = node.nonFulfillableQuantity; // unfulfilled items that are refunded/cancelled items
const totalUnfulfilled: number = node.unfulfilledQuantity;
const totalFulfilled: number = totalQty - (totalCancelled + Math.max(0, totalUnfulfilled));
const totalRefundedable: number = node.refundableQuantity ?? 0;
const totalRefunded: number = totalQty - totalRefundedable; // unfulfilled/fulfilled items that are refunded
const totalRefundedFulfilled: number = totalRefunded - totalCancelled; // fulfilled item that are refunded