We have hit this issue in the past and were told that there was a bug in the Orders API when using specific parameters that caused orders to not appear, we were also told that this was fixed. Potentially there is a new issue somewhere. (previously reported issue shown here https://community.shopify.com/c/shopify-apis-and-sdks/orders-api-not-returning-all-records-within-da...
We have noticed missing orders when they should have returned in the response. If we do the same API call now the orders appear, but they did not at runtime. This is a customer's store, so we have obfuscated data.
Example below:
Time of API Call: 2022-11-30T22:31:23Z
Call Made: GET https://{{domain}}.myshopify.com/admin/api/2022-04/orders.json?limit=250&updated_at_min=2022-11-30T21:59:05+00:00&updated_at_max=2022-11-30T22:29:56+00:00&fulfillment_status=unshipped&financial_status=paid&order=created_at%20asc
X-Request-ID: b2e57a76-b6a1-4cd6-a6bb-f5e10c982949
Response: { "orders": [] }
2 Orders are missing from this call, shown below. Both are in the appropriate statuses, and have an updated date within the query time we called. This call was made on 12/9 and both orders were returned, with no apparent changes made to the orders.
{
"order": {
"id": 4762836172957,
"cancel_reason": null,
"cancelled_at": null,
"closed_at": null,
"confirmed": true,
"created_at": "2022-11-30T16:59:24-05:00",
"currency": "USD",
"customer_locale": "en-US",
"device_id": null,
"discount_codes": [],
"estimated_taxes": false,
"financial_status": "paid",
"fulfillment_status": null,
"gateway": "paypal",
"location_id": null,
"name": "SH#2905",
"note": null,
"note_attributes": [],
"number": 1905,
"order_number": 2905,
"presentment_currency": "USD",
"processed_at": "2022-11-30T16:59:19-05:00",
"processing_method": "express",
"source_name": "web",
"source_url": null,
"taxes_included": false,
"test": false,
"total_weight": 880,
"updated_at": "2022-11-30T16:59:27-05:00",
"user_id": null,
"discount_applications": [],
"fulfillments": [],
"line_items": [
{
"id": 11657481093277,
"fulfillable_quantity": 10,
"fulfillment_service": "manual",
"fulfillment_status": null,
"gift_card": false,
"grams": 88,
"product_exists": true,
"product_id": 5965296271517,
"properties": [],
"quantity": 10,
"requires_shipping": true,
"taxable": true,
"variant_id": 37727475859613,
"variant_inventory_management": "shopify",
"tax_lines": [],
"duties": [],
"discount_allocations": []
}
]
}
}
{
"order": {
"id": 4762847379613,
"cancel_reason": null,
"cancelled_at": null,
"closed_at": null,
"confirmed": true,
"created_at": "2022-11-30T17:15:40-05:00",
"currency": "USD",
"customer_locale": "en-US",
"device_id": null,
"discount_codes": [],
"estimated_taxes": false,
"financial_status": "paid",
"fulfillment_status": null,
"gateway": "paypal",
"location_id": null,
"name": "SH#2906",
"note": null,
"note_attributes": [],
"number": 1906,
"order_number": 2906,
"presentment_currency": "USD",
"processed_at": "2022-11-30T17:15:36-05:00",
"processing_method": "express",
"source_name": "web",
"source_url": null,
"taxes_included": false,
"test": false,
"total_weight": 88,
"updated_at": "2022-11-30T17:15:44-05:00",
"user_id": null,
"discount_applications": [],
"fulfillments": [],
"line_items": [
{
"id": 11657503342749,
"fulfillable_quantity": 1,
"fulfillment_service": "manual",
"fulfillment_status": null,
"gift_card": false,
"grams": 88,
"product_exists": true,
"product_id": 5965296271517,
"properties": [],
"quantity": 1,
"requires_shipping": true,
"taxable": true,
"variant_id": 37727475859613,
"variant_inventory_management": "shopify",
"tax_lines": [],
"duties": [],
"discount_allocations": []
}
]
}
}
