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

[Wes-Dev-Shopify]

Hey folks - thanks for the report.

This looks to be the same underlying issue as another thread we’re already tracking, so I’m going to close this one and keep everything together over there:

Order metafield in query through shopifyql not found anymore

Hi everyone, I’m reaching out to see if anyone else is experiencing issues with ShopifyQL via the Admin API since last week. We have a Power Query implementation that retrieves sales data grouped by custom order metafields. This setup has been working reliably for a couple of months, but as of last week, it started throwing an error. Api version is 2026-04 The Issue: When executing a ShopifyQL query via the API, the system returns: Metafield Column Not Found: Metafield 'order.metafields.custo…

Short version: it’s an unintentional side effect of a recent change to how third party apps are scoped when they query metafields, which is why your product metafield returns “not found” through shopifyqlQuery but still works in admin reporting. We’re working on a fix, and I’ll post updates in that thread as soon as I have them.

Thanks!