Orders API not returning orders until a later date

VCIH
Shopify Partner
8 0 2

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": []
}
]
}
}

Reply 1 (1)

ShopifyDevSup
Shopify Staff
1326 218 460

Hi @VCIH . If you believe this is still an ongoing issue we would recommend in this case opening a ticket directly with our Partner Support team directly and please include detail of the affected store(s) and as many recent X-request-id values you may have. You can reference this post in your communication with Partner Support also.https://help.shopify.com/en/questions/partners#/contact Thanks. 

Developer Support @ Shopify
- Was this reply helpful? Click Like to let us know!
- Was your question answered? Mark it as an Accepted Solution
- To learn more visit Shopify.dev or the Shopify Web Design and Development Blog