Our Partner & Developer boards on the community are moving to a brand new home: the .dev community forums! While you can still access past discussions here, for all your future app and storefront building questions, head over to the new forums.

Orders API not returning some orders even though it matches the criteria

Orders API not returning some orders even though it matches the criteria

rmshii
Shopify Partner
1 0 0

Hello, last month we received complains from our client that some of their orders are not in our system. Upon checking it turns out it is really not part of the return orders from API. I've go through all of the pages and still not in there although the order matches the criteria.

 

Here is the endpoint:

admin/api/2022-07/orders.json?status=open&fulfillment_status=unfulfilled&financial_status=paid&created_at_min=2022-03-11T14:17:40&limit=250

I've checked next page like this:

admin/api/2022-07/orders.json?limit=250&page_info=eyJkaXJlY3Rpb24iOiJuZXh0IiwiZmluYW5jaWFsX3N0YXR1cyI6InBhaWQiLCJmdWxmaWxsbWVudF9zdGF0dXMiOiJ1bmZ1bGZpbGxlZCIsInN0YXR1cyI6Im9wZW4iLCJjcmVhdGVkX2F0X21pbiI6IjIwMjItMDMtMTEgMTQ6MTc6NDAgVVRDIiwibGFzdF9pZCI6NDI3ODQ1NzgyNzUxMCwibGFzdF92YWx1ZSI6MTY0NzE0NjM2ODAwMH0&rel=next

 

And this example order is not included.

Name: #KR749882
ID: 4544791412918

I've tried to check the details of this order; admin/api/2022-07/orders/4544791412918.json and here are the details:

"id": 4544791412918,
"admin_graphql_api_id": "gid://shopify/Order/4544791412918",
"closed_at": null,
"confirmed": true,
"created_at": "2022-08-30T12:22:33+10:00",
"financial_status": "paid",
"fulfillment_status": null,
 
Thank you so much in advance for the help.
Replies 0 (0)