When we fetch orders through the REST Admin API endpoint /admin/api/2025-10/orders.json for the period from September 1, 2025 to September 30, 2025, the API returns a total of 59 orders. However, when we export the orders to an Excel file for the same date range, we get 61 orders.i have crossed checked my parameters and everything is correct.
Hi @Jay_White
Is it possible those other 2 orders are draft orders? That would exclude them from the normal orders API, but they may be included from the UI.
Have you identified which orders from the web export are different from the API retrieved ones?
Hey @Jay_White 
- just confirming, is the discrepancy happening when you use the native Shopify export functionality like this or with a third party exporter app/integration?
And is the behaviour occurring with our GraphQL API as well if you use that instead of the REST API? Just wanted to narrow things down as our REST API is considered a “legacy” API: About REST Admin API versioning
Happy to help even if it is only happening with REST, but did want to suggest GraphQL as a possible workaround. Hope to hear from you soon!
@Dylan We are simply fetching all the orders by mentioning the status => Any and the orders which are missing are given below in screenshots
@Alan_G we haven’t tried the GraphQL API, currently we are using the About REST Admin API versioning .
file has 61 orders and debugging the API shows 59, the two which are present in files but not in debugging are
-
6119852769498
-
6119986168026
Thanks for confirming @Jay_White and sharing those Order IDs. I’ll see if I can look into this. Sending you a DM, just to confirm some info and then I’ll loop back here with a public response just in case we can help anyone else who might be seeing this issue once we’re able to confirm expected behaviour.