Incorrect results on order query with date range

Code_Black_Belt
Shopify Partner
136 1 9

Hello,

we are getting incorrect orders querying the Order API with date boundaries.

We use the parameters created_at_min and created_at_max from https://help.shopify.com/api/reference/order#index to filter orders within a date range but we get orders outside that date range.

A simple example query is

/admin/orders.json?status=any&limit=250&page=5&fields=created_at&created_at_min=2015-12-31T19:00:00-04:00&created_at_max=2016-11-25T23:30:00-04:00

what gets as response:

{"orders":[{"created_at":"2015-07-20T13:54:00-04:00"}]}

If you don't see anything obviously wrong with the query, I can forward all the details privately, which I did not include to protect merchant's privacy.

Kind regards,
  Mike
  Code Black Belt

 

0 Likes
Ron11
Tourist
26 0 1

Hi Milke,

We can fix this for you add me on S.K.Y.P.E I.D:  cis(DOT)ron

 

Regards,

Ron Anderson

 

0 Likes
Code_Black_Belt
Shopify Partner
136 1 9

Hello Ron,

this is Mike from Code Black Belt.

Thanks for your kind offer but this seems to be an issue with the Shopify API, it only happens for some particular stores, so I will wait for an answer from the Shopify team.

Thanks anyway.

Regards,
  Mike
  Code Black Belt

 

0 Likes
stevenmunoz
New Member
2 0 0

Hello!

Did you get this solved? I'm facing the same issue

0 Likes