Orders API not returning all records within date range

Retired Boards Appdev Graphql Basics And Troubleshooting
1

We work with multiple stores to pull orders in specific statuses based off of last updated date.

On multiple occasions, we have noted several orders missing when they should have returned in the response. On each occasion there has only been one page of results, and orders updated either before and/or after the missing order do appear.

If we do the same API call now the orders appear, but they did not at runtime and I’m not clear on why.

Examples below:

Time call made: 2022-06-08T14:06:52Z
API Call: GET https://{{domain}}.myshopify.com/admin/api/2022-01/orders.json?limit=250&updated_at_min=2022-06-07T16:05:32+00:00&updated_at_max=2022-06-08T14:05:33+00:00&fulfillment_status=unshipped&financial_status=paid&order=created_at%20asc

X-Request-Id: 4fae5992-655d-437a-a54c-d4b7d78cbda4

Missing order Id’s: 4285775347796, 4285777051732, 4285785702484, 4286092902484, 4286094475348, 4286095327316, 4286095654996, 4286096441428, 4286100504660, 4286100865108, 4286101094484

Time call made: 2022-06-08T11:01:27Z

API Call: GET https://{{domain}}.myshopify.com/admin/api/2022-01/orders.json?limit=250&updated_at_min=2022-06-07T21:03:04+00:00&updated_at_max=2022-06-08T11:00:11+00:00&fulfillment_status=unshipped,partial&financial_status=paid&order=created_at%20asc

X-Request-Id: 7988c5e9-81f8-448d-b35b-4f59a0100e7a

Missing order Id’s: 4285416898603, 4285475356715, 4285497802795, 4285585555499, 4285678223403, 4285678452779, 4285679140907, 4285679435819

Time call made: 2022-06-07T21:04:19Z

API Call: GET https://{{domain}}.myshopify.com/admin/api/2022-01/orders.json?limit=250&updated_at_min=2022-06-07T20:02:43+00:00&updated_at_max=2022-06-07T21:03:04+00:00&fulfillment_status=unshipped,partial&financial_status=paid&order=created_at%20asc

X-Request-Id: 89ebcb57-caaa-4f33-b654-6def5e335ed9

Missing order Id: 4285155803179

Time call made: 2022-06-08T13:02:57Z

API Call: GET https://{{domain}}.myshopify.com/admin/api/2022-01/orders.json?limit=250&updated_at_min=2022-06-08T12:01:15+00:00&updated_at_max=2022-06-08T13:01:44+00:00&fulfillment_status=unshipped,partial&financial_status=paid&order=created_at%20asc

X-Request-Id: dfca4810-a029-4f1e-94b4-b21ffc88e2f9

Missing order Id: 4285806805035

2

Is there anyone that can help with this?

We have had even more occurrences of customers reporting this. All of them occurred between 6/7-6/8.
We reported this via the partner portal but the only response we got was saying to include status=all, which goes against our acceptance criteria and would not solve the issue. The orders were open at the time the original API call was made, and should’ve been returned in the API.

Another example below:

Order Id missing at time of API call: 4241010720848

Date/Time expected: 2022-06-08T09:46:00-07:00
Request:
2022-06-08T17:00:09Z
https://{{domain}}.myshopify.com/admin/api/2022-01/orders.json?limit=250&updated_at_min=2022-06-08T16:29:59+00:00&updated_at_max=2022-06-08T16:58:55+00:00&fulfillment_status=unshipped,partial&financial_status=pending,paid&order=created_at%20asc
Response:
{“orders”:}
X-Request-ID: f324b1bb-07e3-4083-a36f-ed4e2c3ed48a