I need to filter all products with no SKU set. Using -sku:* isn’t working properly and fails to return some products that have variants with a null SKU. Running the following queries produces no results: x-request-id: 271998b6-518d-4df8-b292-881578105614-1783992234 { products(query:"-sku:*", …

Hey @DavidT - thanks for your patience while I dug into this further. I’ve confirmed that products(query: "-sku:*") returns products where none of the variants has an SKU. It won’t return a product containing a mix of variants with and without SKUs, which explains the result for the product you sha…

Those exact variants have since been updated to include a SKU, so you won’t be able to reproduce on that store unfortunately.

Hey @DavidT - thanks for reaching out I did some digging and tested the same products(query: "-sku:*") query using Admin GraphQL API version 2026-07 on my test store, but I wasn’t able to reproduce the empty result. My query returned matching products, and the nested variants included SKU values re…

Well the issue is it works for most products, but for those few I shared it wasn’t. I included the request IDs and everything hoping you could look into exactly why. But we’ve since fixed the issue for the store owner and they have set a SKU now on all variants, so you won’t be able to reproduce it …

Thanks, that is indeed the scenario that was present. I would like to see documentation of this limitation as well as knowing if this applies to other text fields as well or just SKUs.

I guess what is confusing is if sku:* returns products where any variant has a SKU, then I expect the negation to do the exact opposite. But instead it returns products where all variants have no SKU, rather than if only some have no sku. The logical negation of NOT ANY (none) should be SOME (at le…

Thanks for the response here @DavidT . I see where you’re coming from as well. I’m doing some more digging here and looking into more clear documentation as well. I’ll follow up when I have more to share.

Product query sku filter not working properly

GraphQL Admin API Troubleshooting

DavidT July 14, 2026, 1:33am 2

Is it related to this issue? productVariants's sku search prefix bug

Topic		Replies	Views
productVariants SKU search returning incorrect results GraphQL Admin API Troubleshooting general-gql-troubles	3	78	September 11, 2026
productVariants's sku search prefix bug GraphQL Admin API Troubleshooting general-gql-troubles	3	229	February 7, 2025
Issue with "query" parameter in Product Variant GraphQL Query – Works for Some Shops, But Not Others GraphQL Admin API Troubleshooting general-gql-troubles	6	141	April 18, 2025
SKU based search in Predictive Search API Shopify App Store dev-stores	6	251	August 11, 2025
Strange behavior(bug) with barcode filter on productVariants GraphQL Admin API Troubleshooting general-gql-troubles	2	86	February 13, 2025

Product query sku filter not working properly

Related topics