Why are some orders missing when using Admin Order API?

Shopify Discussion
1

Hi Shopify devs,

We found that some orders were created but no webhook was received, so we decided to check all orders which were updated everyday using Admin Order API /admin/api/2021-07/orders.json .

Considering that each request is limited(max is 250) and the orders are ordered by updated_at, we requested many times to get all orders and each time the ‘updated_at_max’ is the minimum updated_at of orders from the last request.

But we found some orders were missing from the API.

For example, some orders are missing when fetch using the same updated_at_max(2021-09-19T12:20:51), such as 4280962810015(in the result of URL2 not in URL 1).

URL 1:https://{shopify_domain}/admin/api/2021-07/orders.json?updated_at_min=2021-09-18T16:15:00&updated_at_max=2021-09-19T12:20:51Z&limit=100&status=any&fields=id,updated_at

Result:

{
    "orders": [
        {
            "id": 4286400561311,
            "updated_at": "2021-09-19T20:18:14+08:00"
        },
        {
            "id": 4286395285663,
            "updated_at": "2021-09-19T20:15:18+08:00"
        },
        {
            "id": 4286384636063,
            "updated_at": "2021-09-19T20:09:26+08:00"
        }
        ........
       ]
}

URL 2:https://{shopify_domain}/admin/api/2021-07/orders.json?updated_at_min=2021-09-19T12:20:00&updated_at_max=2021-09-19T12:20:51Z&limit=100&status=any&fields=id,updated_at

Result:

{
    "orders": [
        {
            "id": 4280962810015,
            "updated_at": "2021-09-19T20:20:45+08:00"
        },
        {
            "id": 4279894376607,
            "updated_at": "2021-09-19T20:20:50+08:00"
        },
        {
            "id": 4278678028447,
            "updated_at": "2021-09-19T20:20:51+08:00"
        },
        {
            "id": 4276576583839,
            "updated_at": "2021-09-19T20:20:47+08:00"
        },
        {
            "id": 4275740704927,
            "updated_at": "2021-09-19T20:20:44+08:00"
        },
        {
            "id": 4272981115039,
            "updated_at": "2021-09-19T20:20:48+08:00"
        },
       .......
    ]
}

It seems that the orders weren’t ordered by updated_at. Can I get all orders by using updated_at_max. If not, how?

Thanks