Difference between fulfilled and unfulfilled refunds

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?

I thought I could use the attribute restock_type - the documentation says:

  • cancel: The items have not yet been fulfilled. The canceled quantity will be added back to the available count. The number of fulfillable units for this line item will decrease.

But I find some refunded orders that were not fulfilled with value no_restock and some fulfilled items with value no_restock.

Any other way I can differentiate the two?

2

In order to research further, the way your orders are fulfilled would be needed.

https://help.shopify.com/en/manual/orders/fulfillment/fulfilling-orders

3

This doesn’t answer my question. Fulfilment objects don’t have any reference to refunded items as far as I’m aware.

4

I’m aware it doesn’t answer your question…, I’m looking for more info to look into it further.

The fulfillment page has multiple links to look at and I’m not going to go through them all.

Which way do you do fulfillment?

5

It does not matter.

I have the same problem. I am fetching an order using REST API so I get a json with refunds having line items. At this point I know what was refunded and if it was restocked but I do not know whether this was for a fulfilled or non-fulfilled part. I tried to use restock_type to determine it so ‘cancel’ would mean it is for non-fulfilled part while ‘return’ this is for fulfilled. However there is a third type ‘no_restock’ that you can get refunding both fulfilled and non-fulfilled item.

So the question is how to determine whether a given refund line item is for fulfilled or non-fulfilled part.

1 Like
6

Hello @breiko , Have you find a way to differentiate it? I’m also having hard-time identifying if refunded item is fulfilled or not on uncheck restock option during refund.

7

Hi @tyuzu , I am having the same problem. There doesn’t seem to be any object in the api to differentiate them. Did you figure this out?

8

No, but since I only need the numbers of the unfulfilled and fulfilled refunded items. I did below to get it.

// 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