Some orders are missing Shopify Order API

zack-schulfler
Tourist
14 0 1

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?

Replies 10 (10)
Jivan_Suhagiya
Shopify Partner
515 74 113

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
If helpful then please Like and Accept Solution.
Email: suhagiyajivan1992@gmail.com
Skype: jivan.suhagiya
First kind of Checkout Reminder APP: https://apps.shopify.com/checkout-reminder
zack-schulfler
Tourist
14 0 1

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
Shopify Partner
515 74 113

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

If helpful then please Like and Accept Solution.
Email: suhagiyajivan1992@gmail.com
Skype: jivan.suhagiya
First kind of Checkout Reminder APP: https://apps.shopify.com/checkout-reminder
zack-schulfler
Tourist
14 0 1

@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
Shopify Partner
515 74 113

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

If helpful then please Like and Accept Solution.
Email: suhagiyajivan1992@gmail.com
Skype: jivan.suhagiya
First kind of Checkout Reminder APP: https://apps.shopify.com/checkout-reminder
Jivan_Suhagiya
Shopify Partner
515 74 113

are you able to get that order by id?
like 

https://Shopify_token/admin/api/2020-10/orders/order_id.json
If helpful then please Like and Accept Solution.
Email: suhagiyajivan1992@gmail.com
Skype: jivan.suhagiya
First kind of Checkout Reminder APP: https://apps.shopify.com/checkout-reminder
zack-schulfler
Tourist
14 0 1

@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
Tourist
14 0 1

 any update for this one?

kk8
New Member
2 0 2

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
Tourist
7 0 1

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.