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

[rmshii]

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.