Using ShopifyQL

ShopifyQL, or Shopify Query Language, is Shopify's query language built for commerce. Query languages are used to request and retrieve data from databases. Your store's data is stored in database tables, structured in defined columns and rows. Columns define the type of information they contain, such as sales, and rows specify the actual value of the data type, such as $2,450 USD in sales.

To retrieve your data in a meaningful format, a query must be submitted to the database. A query is a question that asks for specific data as an answer, made of keywords and their corresponding parameters. The combination of several keywords with specific parameters builds your query. After you build your query, you can run it and receive a report.

You can use the ShopifyQL query editor with Shopify Analytics to explore your own business's database and retrieve the data that gives you a more in-depth understanding of your business.

Image of the ShopifyQL panel, displaying a valid query with correct syntax.

In this section