graphQL orders search not working

GraphQL Admin API Troubleshooting
1

Query Orders later than 14th feb 2025

Has results earlier

"data": {
    "orders": {
      "nodes": [
        {
          "name": "#1002",
          "email": "sdsadasd@mail.com",
          "id": "gid://shopify/Order/#####",
          "createdAt": "2024-09-16T11:41:21Z",

Below is the parsed query, so thats all good

"search": [
      {
        "path": [
          "orders"
        ],
        "query": "fulfillment_status:'fulfilled' created_at:>'2024-02-14T15:23:00Z'",
        "parsed": {
          "and": [
            {
              "field": "created_at",
              "range_gt": "2024-02-14T15:23:00+00:00"
            },
            {
              "field": "fulfillment_status",
              "match_phrase": "fulfilled"
            }
          ]
        }
      }
    ]

API Latest 2025/01 and also 2025/04

Works as expected on products search, But totally ignores the date when doing orders search.

I started with updated_at. but then changed to created_at after experiencing this issue and thinking maybe not all orders have an update_at date.

an easy query to replicate:

{
	orders(first:5, sortKey:ID, query:"fulfillment_status:'fulfilled' created_at:>'2024-02-14T15:23:00Z'") {
		nodes{
      name
      id
      createdAt
    }
	}
}
2

Thanks for flagging this - are you still seeing this issue? I believe we did make recent changes to how updated_at works. Also can you rely on created_at if you’re still seeing this issue?

1 Like
4

HI

Just realised my issue. my date on search was for 2024. Got that coders blindness turned on and never read it as saying 2024.

And just always read as 2025 :smiley: Sorry