Is_price_reduced query not working on products

GraphQL Admin API Troubleshooting
1

The is_price_reduced query parameter on the products query isn’t working. It doesn’t seem like the match is working at all.

For example (query),

{
  products(first: 2 query:"is_price_reduced:true") {
    nodes {
      id
      variants(first: 5) {
        nodes {
          price
          compareAtPrice
        }
      }
    }
  }
}

Results:

{
  "data": {
    "products": {
      "nodes": [
        {
          "id": "gid://shopify/Product/4288600637512",
          "variants": {
            "nodes": [
              {
                "price": "4.83",
                "compareAtPrice": "4.83"
              }
            ]
          }
        },
        {
          "id": "gid://shopify/Product/4288600703048",
          "variants": {
            "nodes": [
              {
                "price": "3.08",
                "compareAtPrice": "3.08"
              }
            ]
          }
        }
      ]
    }
  },
  "extensions": {
    "cost": {
      "requestedQueryCost": 8,
      "actualQueryCost": 6,
      "throttleStatus": {
        "maximumAvailable": 2000,
        "currentlyAvailable": 1994,
        "restoreRate": 100
      }
    },
    "search": [
      {
        "path": [
          "products"
        ],
        "query": "is_price_reduced:true",
        "parsed": {
          "field": "is_price_reduced",
          "match_all": "true"
        }
      }
    ]
  }
}

One would think that these products should not be returned, since their price is the same as the compare at price?

Anyone have luck with this query?

2

Hi Ozzy,

When I run the same query, I am seeing products where price < compare at price, which is expected:

2294×740 77.7 KB

Did you test this in the GraphiQL app?