API order fulfillment data

Leviosa
Shopify Partner
13 0 15

Trying to filter fulfilled orders:

When I send this, I correctly get details for only partially filled orders:

/admin/api/2020-10/orders.json?limit=10&fulfillment_status=partial&created_at_min=2023-06-04&created_at_max=2023-06-10

 

When I send this, I get details, but for unfulfilled order (none fulfilled):

/admin/api/2020-10/orders.json?limit=10&fulfillment_status=fulfilled&created_at_min=2023-06-04&created_at_max=2023-06-10

 

When I send this, I get no order details at all, even though plenty of orders have been fully fulfilled during these dates:

/admin/api/2020-10/orders.json?limit=10&fulfillment_status=shipped&created_at_min=2023-06-04&created_at_max=2023-06-10

 

How to filter order details for fulfilled orders only, and then also for fulfilled AND partial orders?

Replies 2 (2)

Liam
Shopify Staff
2731 301 778

Hi Leviosa,

 

To filter order details for fulfilled orders only, you can use the fulfillment_status filter with a value of fulfilled

 

EG: /admin/api/2020-10/orders.json?limit=10&fulfillment_status=fulfilled&created_at_min=2023-06-04&created_at_max=2023-06-10

 

To filter order details for both fulfilled and partially fulfilled orders, you can use the fulfillment_status filter with a value of fulfilled,partial

 

EG: /admin/api/2020-10/orders.json?limit=10&fulfillment_status=fulfilled,partial&created_at_min=2023-06-04&created_at_max=2023-06-10

 

Hope this helps!

Liam | Developer Advocate @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit Shopify.dev or the Shopify Web Design and Development Blog

Leviosa
Shopify Partner
13 0 15

Hi Liam-

Thanks for replying.

We already tried what you suggest - see details in my first note.  While this command line returns proper data - see attached output file 'Partial' (shortened and private data cleared):

 /admin/api/2020-10/orders.json?limit=10&fulfillment_status=fulfilled&created_at_min=2023-06-04&created_at_max=2023-06-10

 

This command line incorrectly returns UNfulfilled orders - see attached output file 'Fulfilled':

 /admin/api/2020-10/orders.json?limit=10&fulfillment_status=fulfilled&created_at_min=2023-06-04&created_at_max=2023-06-10

 

The only difference between the command lines is 'partial' vs. 'fulfilled'.  When 'shipped' is substituted, response is: 

{"orders":[]}