Query for only variants with truthy SKUs

[shakervalley]

Hi, is it possible to constrain a product variants query to just those with a truthy value for SKU?

At the moment I’m passing a wildcard (“queryString”: “sku:*”). But I get quite a few variants with empty strings as the SKU.

I’d also be curious if empty string is the default value for new variants?

Thank you!

`
query($numResults:Int!, $cursor:String, $queryString: String)
{
  productVariants(first: $numResults, after: $cursor, query: $queryString) {
    nodes{
      sku
      title
      inventoryQuantity
      inventoryItem{
        inventoryLevels(first: 5){
          nodes{
            quantities(names:"available") {
              quantity
            }
            location{
              name
              id
            }
          }
        }
      }
    }
    pageInfo{
      hasPreviousPage
      hasNextPage
      startCursor
      endCursor
    }
  }
}
`

[Eric-HAN]

Hi， there

You could refer to this https://shopify.dev/docs/api/usage/search-syntax

For your question I’d also be curious if empty string is the default value for new variants? I think empty is the default value.

you could modify you query value to this: “queryString”: “-sku:""”

See the result pic below;