shopifyqlQuery API returns “Metafield Column Not Found” for product metafield that works in Admin Analytics (same query)

GraphQL Admin API Troubleshooting
1

ShopifyQL query (sensitive values anonymized)

FROM sales

SHOW net_items_sold

WHERE product.metafields.related_products.masterSKU IN (

'masterSKU-EXAMPLE-ALPHA',

'masterSKU-EXAMPLE-BETA',

'masterSKU-EXAMPLE-GAMMA',

'masterSKU-EXAMPLE-DELTA',

'masterSKU-EXAMPLE-EPSILON',

'masterSKU-EXAMPLE-ZETA'

)

AND customer_tags NOT CONTAINS ‘exclude’

AND order_tags NOT CONTAINS ‘exclude’

GROUP BY product_variant_sku

WITH TOTALS, PERCENT_CHANGE

SINCE 2026-02-10

UNTIL today

COMPARE TO previous_year

ORDER BY product_variant_sku ASC

LIMIT 1000

VISUALIZE net_items_sold TYPE table

(The six IN (...) values are placeholders; real values are product metafield masterSKU on our store.)

Problem

This query runs successfully in Shopify Admin → Analytics. The same string via shopifyqlQuery returns:

Metafield Column Not Found: Metafield ‘product.metafields.related_products.masterSKU’ not found

Invalid Expression: Field not found

tableData is null; errors are in parseErrors.

What we verified

  • Metafield definition (namespace: related_products, key: masterSKU, ownerType: PRODUCT): analyticsQueryable.eligible: true, analyticsQueryable.enabled: true (via metafieldDefinitions on API 2026-04).

  • App scopes (re-authorized): read_reports, read_products, read_orders, read_customers, plus inventory/locations/write_products.

  • API version: 2026-04 (also reproduced on 2025-10).

2

Hi @Miruna_Andriesei

My ShopifyQL query works perfectly. Would you mind sharing your query statement?

3

@kyle_liu it works for you in graphql with a product metafield?

FROM sales SHOW net_items_sold WHERE product.metafields.related_products.masterSKU IN (‘sku_1’, ‘sku_2’) AND customer_tags NOT CONTAINS ‘exclude-from-sales-analysis’
AND order_tags NOT CONTAINS ‘exclude-from-sales-analysis’ GROUP BY product_variant_sku WITH TOTALS, PERCENT_CHANGE SINCE 2026-02-02 UNTIL today COMPARE TO previous_year ORDER BY product_variant_sku ASC LIMIT 1000 VISUALIZE net_items_sold TYPE table