Excited to share that ShopifyQL is now available as shopifyqlQuery within the Admin API.
Instead of rebuilding Shopify’s entire analytics layer, you can now query our data directly using the same analytics engine that powers Shopify Admin.
What’s new:
Direct access to sales, customer, and product analytics data
Same metrics merchants see in Shopify Admin
No more custom data extraction or modeling required
Who should use this:
Almost every app can benefit. Even if you’re not building an analytics app, showing consistent sales data, customer metrics, or product performance builds merchant trust.
This is great update. I wanted to use but I get the
"message": "Access denied for shopifyqlQuery field. Required access: `read_reports` access scope. Also: Level 2 access to Customer data including name, address, phone, and email fields. Please refer to https://shopify.dev/docs/apps/launch/protected-customer-data.",
message. I already added the “read_reports” in my access scopes. What can be reason behind this?
I did, Shopify shows the scope change and asks for the permission. But it didn’t work. Currently I just built the report with my data. But if this works perfectly, it’ll be a game changer for me and for merchant experience…
does it help the data query at ORANGIZATION level to get the data like “Total sales by sales channel” report?
FROM ORGANIZATION sales
SHOW orders, gross_sales, discounts, returns, net_sales, shipping_charges,
taxes, total_sales
WHERE sales_channel IS NOT NULL
GROUP BY sales_channel WITH TOTALS
SINCE startOfDay(-30d) UNTIL today
ORDER BY total_sales DESC
LIMIT 1000
VISUALIZE total_sales TYPE donut
