Why are some orders missing in REST API calls based on date and fulfillment status?

[Vinatha]

Hi,

I'm using REST API call ( to fetch one of our merchants who has a shopify store) based on date and fulfillment status , however randomly few orders are getting missed .

I have seen a thread on change in date timestamp from UTC offset to ISO8601 and still the orders are getting missed.

Here are the API calls I have used:

/admin/api/2020-04/orders.json?financial_status=paid&status=open&fulfillment_status=unshipped&updated_at_min=2022-03-02T12:40:36-0600&limit=75

changed to

/admin/api/2020-04/orders.json?financial_status=paid&status=open&fulfillment_status=unshipped&updated_at_min=2022-03-02T18:35:37.000Z&updated_at_max=2022-03-02T18:50:39.046Z&limit=250

[cartcoders]

You can follow these steps >> https://stackoverflow.com/questions/70259708/can-retrieve-some-orders-but-not-all-using-shopify-rest...

If you still facing the issue, We can help you to fix the issue. 

Contact Shopify Expert at - contact@cartcoders.com

[Hamill289]

---

@cartcoders wrote:

You can follow these steps >> https://stackoverflow.com/questions/70259708/can-retrieve-some-orders-but-not-all-using-shopify-rest...Toys r us credit card

If you still facing the issue, We can help you to fix the issue. 

Contact Shopify Expert at - contact@cartcoders.com

---

Yes, that is correct. I can get N orders from one API call, but I need to do an additional N API calls to get more information that is specific to a single order. Thank you for the link. I will try to come up with a more workable solution than what is posted above.

[Hamill289]

---

@Vinatha wrote:

Hi,

I'm using REST API call ( to fetch one of our merchants who has a shopify store) based on date and fulfillment status , however randomly few orders are getting missed .

I have seen a thread on change in date timestamp from UTC offset to ISO8601 and still the orders are getting missed.   Toys r us credit card

Here are the API calls I have used:

/admin/api/2020-04/orders.json?financial_status=paid&status=open&fulfillment_status=unshipped&updated_at_min=2022-03-02T12:40:36-0600&limit=75

changed to

/admin/api/2020-04/orders.json?financial_status=paid&status=open&fulfillment_status=unshipped&updated_at_min=2022-03-02T18:35:37.000Z&updated_at_max=2022-03-02T18:50:39.046Z&limit=250

---

Yes, that is correct. I can get N orders from one API call, but I need to do an additional N API calls to get more information that is specific to a single order. Thank you for the link. I will try to come up with a more workable solution than what is posted above.