Get All Fulfilled Orders - GraphQL

Technical Q&A
1

Hello all,

I am using GraphQL with the Admin API to query for products.

When I do something like this:

orders(first: 50, query: “fulfillment_status:unfulfilled”)

I correctly get all unfulfilled orders.
But when I do this:

orders(first: 50, query: “fulfillment_status:fulfilled”)

I get nothing. I have fulfilled orders. the displayFulfilledStatus property is FULFILLED.
There is no error about fulfilled not being valid. The API documentation states fulfilled is valid. In fact, it is even the example query the documentation shares.
But it just isn’t working.

Has anyone experienced this, hopefully with a resolution?

Thank you.

2

Experiencing same issue, no solution yet.

3

A couple ways to do this:

Get fulfillments

{
  fulfillmentOrders(first: 250, sortKey: UPDATED_AT, reverse: true) {
    edges {
      node {
        id
        createdAt
        orderId
        order {
          displayFulfillmentStatus
        }
      }
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}

Or, just get fulfilled orders. The problem with this is you can’t sort by the fulfillment date. You can only sort by the order create date or update date:

{
  orders(first:250
    query: "fulfillment_status:'fulfilled'"
    sortKey: UPDATED_AT
    reverse: true
  ) {
    edges {
      node {
        id
        createdAt
        displayFulfillmentStatus
        fulfillments(first:50) {
          createdAt
        }
      }
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}