Query Orders by Fulfillment Status

I would like a list of all my orders in a certain status. More specifically, I just need a count of all the orders in where Fulfillment Status = “Unfulfilled”. How would I create a query to do either?

1 Like

Curious about this as well.

Hi @matt_dataautomation & @garrett!
We do have it on our radar to add this.
I will try to get a better ETA and let you know as soon as I have an update.
Thanks!

1 Like

query {
orders(fulfillment_status: “pending”) {
data {
edges {
node {
id
legacy_id
order_number
shop_name
fulfillment_status
order_date
profile
required_ship_date
shipping_lines {
carrier
method
price
}
shipments{warehouse_id}
shipping_address {
first_name
last_name
address1
address2
city
state
state_code
zip
country
}
tags
line_items(first: 2) {
edges {
node {
id
sku
quantity
product_name
fulfillment_status
quantity_allocated
backorder_quantity
barcode
}
cursor
}
}
shipments {
id
order_id
user_id
warehouse_id
address {
name
address1
address2
city
state
country
zip
}
shipped_off_shiphero
dropshipment
}
returns {
id
reason
status
}
}
}
}
}
}

query for get a list of orders based on status.

2 Likes

Is there an update on this? Looking to implement a similar query.

1 Like

Any updates on this?

Hi @madhupatel @marvinpackrabbitusa @bbarrett
I apologize for the delay with this. I will raise the priority and ask if we can expedite this.
Thanks again for the patience!
Tom

Hi @madhupatel @marvinpackrabbitusa @bbarrett

We are currently going inside the code freeze period. This means that we won’t be touching the code unless it’s extremely necessary to avoid potential disruptions in this last part of the year.

So Feature Requests will be resumed at the beginning of 2021 (this one included)
I will raise priority so this one gets tackled first by then.
I apologize for the inconvenience and thanks for the patience again!
Tom

Hi @madhupatel @marvinpackrabbitusa @bbarrett @matt_dataautomation @garrett

We apologize for the delay about this, but in case it helps, now you should be able to filter orders using “unfulfilled” as a status now

Example:

query {
  orders(fulfillment_status: "unfulfilled") {
    request_id
    complexity
    data(first: 100) {
      edges {
        node {
          id
          legacy_id
          order_number
          partner_order_id
          shop_name
          fulfillment_status
        }
      }
    }
  }
}

Thanks again for the patience while we implemented this!
Tom

1 Like

Hi @tomasw, is it possible to use logical operators on queries? I need to get orders with fulfillment_status NOT “pending”? is this possible? thanks

Hi @apopelka
Welcome to our community!
Unfortunately is not possible to use logical operators, right now the only way is to use the unfulfilled or to filter for specific statuses

Hi Team,

I know this topic is a little old, but I just wanted to chime in to see if it is possible to query multiple fulfillment statuses at once. I’m tracking orders over several statuses and would love the option of being able to submit one query that pulls orders for all of them at once.

i.e. fulfillment_status: “pending”,“fulfilled”,“wholesale”, etc.

Thank you!

Logan