Some orders are missing Shopify Order API

[zack-schulfler]

Hello,

I am trying to build dashboards for our Logistics team. Basically, What I am trying to do is I try to fetching the data using Shopify Order API and show with graph how many Orders are delay to fulfilled.  I just found out one thing when I am using Shopify Order API. Some of the orders are missing when I try to get the data from API.

First, I try to get total orders in specific date and I got 69.

https://Shopify_token/admin/api/2020-10/orders/count.json?created_at_min=2020-11-25&created_at_max=2020-11-26&status=any

Then, I try to fetch all the orders from Nov 25 using this.

https://Shopify_token/admin/api/2020-10/orders.json?status=any&created_at_min=2020-11-25&created_at_max=2020-11-26&fields=tags,created_at,fulfillment_status,id&limit=250

Then, I got only 68 orders. I try to look at Shopify Admin and fetching the data it also show 69. One order is missing and it created date is also Nov 25. 

Why that order is missing? Any suggestion on API usage?

[Jivan_Suhagiya]

Hi,
try this one

https://Shopify_token/admin/api/2020-10/orders.json?status=any&created_at_min=2020-11-25&created_at_max=2020-11-26&fields=tags,created_at,fulfillment_status,id&limit=250&status=any

[zack-schulfler]

Hi @Jivan_Suhagiya  

status=any is already included at the end of the api. But we still missing one order from api return.

do you have any idea on that?

[Jivan_Suhagiya]

oh sorry,
can you please check which order is missing? and check json data of that order

[zack-schulfler]

@Jivan_Suhagiya  , yes

we check json for that missing order and also Shopify admin panel as well. We found that order and also that order created_at is Nov 25 as well. But it is missing in above api. 

I have no idea why that is happening. Do you think can we trust SHopify admin api? 

[Jivan_Suhagiya]

yes, API is stable
can you please ping me on skype for quick chat?
I would like you to test some parameters 

[Jivan_Suhagiya]

are you able to get that order by id?
like 

https://Shopify_token/admin/api/2020-10/orders/order_id.json

[zack-schulfler]

@Jivan_Suhagiya  Yes. I can get that order with specific id. Also look at the created_at and it show Nov 25.  But missing that order when I call api with date range. 

[zack-schulfler]

 any update for this one?

[kk8]

Hi, i am encounter the same issue as @zack-schulfler , i have executed the admin api "admin/api/2021-04/orders/count.json?financial_status=paid&fulfillment_status=unshipped&created_at_min=2021-07-13T10:00:00+08:00" to retrieve  the no of orders which return me 5 orders. However, when i execute "/admin/api/2021-04/orders.json?financial_status=paid&fulfillment_status=unshipped&created_at_min=2021-07-13T10:00:00+08:00", i only manage to get 2 orders.

I found that if i use my created_at_min=2021-07-13T02:00:00+08:00, i manage to get the 5 transactions, anyone can advise. Thanks in advance 

[mayoub]

Rest API ignores timezone. If you want to have a timezone, you have to process the time manually (or through your code) before you request from the server.

I.e change 2021-01-01T10:00:00+05:00 to 2021-01-01T05:00:00.

[ilong54]

My software pulls every order year to date can't be timezone. Misses one or two orders clearly in date range no reason why that I can see for the specific missing orders. Any suggestions?

[abubakarhb]

Hi ,
To me it just seems like the admin api is not stably reliable, if this little issue cannot be attended to then there will be trust issue with shopify.

Note that i am also encountering this right now. i have not found result yet from shopify and this is sad to have not respond positively or negatively to clear the mind of the customer from any doubt.