Skip to main content

ShopifyQL in the Shopify admin

All merchants have access to the ShopifyQL code editor directly in the Shopify admin. Navigate to Analytics and select New exploration, or open an existing report and click on the editor to expand it and edit the code.

ShopifyQL code editor in the Shopify admin showing a query and results visualization

Anchor to Code editor featuresCode editor features

The code editor provides an interactive environment for writing and testing ShopifyQL queries:

  • Syntax highlighting and autocompletion: The editor recognizes ShopifyQL syntax and suggests table names, column names, and keywords as you type.
  • Schema exploration: Browse available tables and columns to understand what data you can query.
  • Real-time query validation: The editor validates your query syntax before execution and highlights errors.
  • Visualization preview: See your results rendered as tables, charts, or other visualizations directly in the admin.

Anchor to Natural language queries with SidekickNatural language queries with Sidekick

The analytics query editor integrates with Sidekick and understands natural language, making advanced reporting accessible to everyone. Create and customize analytics reports by asking questions like "What was the best converting traffic source in September?" and Sidekick builds reports for you instantly.

Refine your queries with follow-up questions like "How many repeat versus new customers for each traffic source?" that build on your conversation history for more sophisticated insights. Sidekick remembers your conversation, so you can reference previous chats to dive deeper.

You can still write ShopifyQL directly, but you can also start with plain language and learn query building through practical examples. Sidekick translates your questions into ShopifyQL with business-friendly explanations of what each report measures.

Anchor to Writing queriesWriting queries

Enter your ShopifyQL query in the code editor. The editor executes queries when you click Run or press the keyboard shortcut.

ShopifyQL query

FROM sales
SHOW total_sales, orders
GROUP BY day
SINCE last_week
ORDER BY day DESC

Anchor to Saving and sharing reportsSaving and sharing reports

After you've written a query, you can save it as a custom report. Saved reports appear in your Reports list and can be:

  • Scheduled for regular email delivery.
  • Shared with other staff members who have analytics access.
  • Exported to CSV for external analysis.

Anchor to Learn moreLearn more

For detailed information about using the code editor, see ShopifyQL editor in the Shopify Help Center.

ShopifyQL syntax reference

Complete reference for all ShopifyQL keywords, operators, and functions.

Was this page helpful?