---
title: "The Queryful query language · Reporting for Shopify"
description: "Every Queryful report is a short query you can read. See the language with real examples: sales by product, orders with line item properties, month over month."
url: https://queryful.app/query-language
locale: en
---

At launch

# A query language you can read.

Every Queryful report is a short query. Autocomplete suggests fields as you type, and inline validation flags a mistake before you run it. The examples below show the shape of the language.

[Join the waitlist](#waitlist)

Coming soon to the Shopify App Store

## Top products last month

```
FROM sales
  SHOW net_sales, orders
  GROUP BY product
  DURING last_month
  ORDER BY net_sales DESC
  LIMIT 20
```

## Net sales by sales channel, against the month before

```
FROM sales
  SHOW net_sales
  GROUP BY sales_channel
  DURING last_month
  COMPARE TO previous_period
```

## Paid orders this week, with line item properties

```
FROM orders
  SHOW order_name, created_at, total_price, line_item_properties
  WHERE financial_status = 'paid'
  DURING last_7_days
```

## Discount codes by net sales this quarter

```
FROM sales
  SHOW net_sales, discounts
  GROUP BY discount_code
  DURING this_quarter
  ORDER BY net_sales DESC
```

## Shopify's reports and Queryful

|   | ShopifyQL | queryful. |
| --- | --- | --- |
| Shape | FROM, SHOW, GROUP BY, DURING | FROM, SHOW, GROUP BY, DURING |
| Row-level order fields | No | Yes |
| Runs on | Shopify's analytics | Queryful's copy of your data |
| Email the result on a schedule | No | Yes |

## Built for reports

### Short

A report is a few lines, not a page of SQL.

### Documented

The reference is published with the docs at launch.

### Autocomplete

Field names and keywords as you type.

### Validation

Mistakes flagged before you run the query.

FAQ

## Frequently asked questions

### Is it SQL?

It reads like SQL but is shorter, and built for reports: FROM a dataset, SHOW figures, GROUP BY, DURING a period.

### Is it like ShopifyQL?

Similar in shape. It runs on Queryful's copy of your data, so it can report on row-level order fields that ShopifyQL can't.

### Where is the reference?

Published with the docs at launch.

### Are these field names final?

They show the shape of the language. The full list of fields is in the reference at launch.

## Explore more

[Custom reports](https://queryful.app/shopify-custom-reports) [Sales reports](https://queryful.app/shopify-sales-reports) [Order export](https://queryful.app/shopify-order-export) [Scheduled reports](https://queryful.app/shopify-scheduled-reports) [AI reports](https://queryful.app/shopify-ai-reports) [Finance reports Coming soon](https://queryful.app/shopify-finance-reports) [Sales tax by jurisdiction Coming soon](https://queryful.app/shopify-sales-tax-report) [Inventory reports Coming soon](https://queryful.app/shopify-inventory-reports) [Customer reports Coming soon](https://queryful.app/shopify-customer-reports) [Multi-store reporting Coming soon](https://queryful.app/shopify-multi-store-reporting) [Better Reports alternative](https://queryful.app/better-reports-alternative) [Report Pundit alternative](https://queryful.app/report-pundit-alternative) [Data Export IO alternative](https://queryful.app/data-export-alternative) [Shopify's reports vs Queryful](https://queryful.app/shopify-reports-vs-queryful)

## Queryful is coming soon.

Leave your email and we'll tell you when Queryful is on the Shopify App Store.

 

Company 

Email address

 Join the waitlist

 I agree to the [privacy policy](https://queryful.app/privacy-policy).

One email when Queryful is listed. Unsubscribe any time.
