Shopify
Orders, customers and line items from your Shopify store.
The Shopify connector reads orders (with their customer and line item details) from a single Shopify store and brings them into the sheet. Each connection corresponds to one store, the .myshopify.com domain you authorize when you connect.
One row per order, or per article: if your report includes a Line Item field (Line item ID, Line item title, Line item name, SKU, Product ID or Variant ID), each row represents one article of the order instead of the whole order, so an order with 3 different products produces 3 rows. Sales metrics (Total sales, Tax, Discounts, etc.) stay at the order level: they repeat identically on every row of the same order rather than being split across its articles, since Shopify itself does not provide a way to allocate an order's total across its lines.
Protected customer data: reading the customer's email requires the app to have "Protected customer data access" approved in Shopify's Partner/Dev Dashboard. On a development store this takes effect as soon as the request is saved, no review needed; installing the app on a real merchant's store requires Shopify's formal review first.
Order history window: by default Shopify only returns orders from the last 60 days, regardless of the date range set in the report. Reading older orders requires Shopify's read_all_orders scope, not requested on this connection today.
Required permissions
read_orders: Needed to read order, customer and line item data for your reports (by default, only the last 60 days of orders - see Limits).read_products: Needed to resolve the product and variant details referenced by order line items.read_customers: Needed to read the customer fields (name, email, country, city) linked to orders.read_inventory: Requested for future inventory-level reporting; the current set of metrics and dimensions doesn't use it yet.
Available metrics
| Metric | Period | Aggregation | Note |
|---|---|---|---|
| Orders | Always 1 on every row; sum it to count orders in the report (counts each order once even if expanded into several rows). | ||
| Ordered quantity | The quantity of the specific article when the report is expanded per article; the order's total quantity across all its articles otherwise. | ||
| Gross sales | Approximation: Shopify's API doesn't expose gross sales directly, so it's calculated as net sales plus discounts (reconstructing the pre-discount subtotal). Order-level value: repeats identically on every row of the same order if the report is expanded per article (see Overview above). | ||
| Discounts | Order-level value: repeats identically on every row of the same order if the report is expanded per article (see Overview above). | ||
| Net sales | Order-level value: repeats identically on every row of the same order if the report is expanded per article (see Overview above). | ||
| Shipping | Order-level value: repeats identically on every row of the same order if the report is expanded per article (see Overview above). | ||
| Tax | Order-level value: repeats identically on every row of the same order if the report is expanded per article (see Overview above). | ||
| Total sales | Order-level value: repeats identically on every row of the same order if the report is expanded per article (see Overview above). |
Available dimensions
| Dimension | Note |
|---|---|
| Order ID | |
| Order name | |
| Order created at | |
| Order created at (date) | |
| Order financial status | |
| Order fulfillment status | Shows "unfulfilled" when Shopify returns no status. |
| Order currency code | |
| Order email | The order's contact email. Usually the same as Customer email, but can differ for manually edited orders. |
| Order tags | |
| Order channel | |
| Order cancelled at | Empty if the order was never cancelled. |
| Order closed at | Empty if the order is still open. |
| Order note | |
| Order confirmed | True or false. |
| Order discount code | Comma-separated if more than one code was applied. |
| Order shipping city | |
| Order shipping province | |
| Order shipping country | |
| Order billing city | |
| Order billing province | |
| Order billing country | |
| Customer ID | Empty when the order has no linked customer (guest checkout or a manually created order). |
| Customer email | The email on the customer's own profile, not the order's contact email (see Order email). Empty when the order has no linked customer. |
| Customer first name | Empty when the order has no linked customer. |
| Customer last name | Empty when the order has no linked customer. |
| Customer country | From the customer's default address. Empty when the order has no linked customer or no default address. |
| Customer city | From the customer's default address. Empty when the order has no linked customer or no default address. |
| Line item ID | Adding this field expands the report to one row per article instead of per order - see the Overview above. |
| Line item title | Adding this field expands the report to one row per article instead of per order - see the Overview above. |
| Line item name | Adding this field expands the report to one row per article instead of per order - see the Overview above. |
| SKU | Adding this field expands the report to one row per article instead of per order - see the Overview above. Empty for line items without an SKU. |
| Product ID | Adding this field expands the report to one row per article instead of per order - see the Overview above. Empty for custom line items not tied to a catalog product. |
| Variant ID | Adding this field expands the report to one row per article instead of per order - see the Overview above. |
| Shop name | The store's .myshopify.com domain. The same value on every row. |
Known limits
- One row per order, or per articleAdding any Line Item field (Line item ID, Line item title, Line item name, SKU, Product ID or Variant ID) expands the report to one row per article of the order instead of one row per order. Sales metrics stay at the order level and repeat identically across the articles of the same order.
- 60-day order history by defaultShopify only returns orders from the last 60 days, regardless of the date range set in the report. Reading older orders requires Shopify's read_all_orders scope, which this connection doesn't request today.
- Protected customer dataReading the customer's email requires the app to have "Protected customer data access" approved for the store in Shopify's Partner/Dev Dashboard. On a development store this takes effect right after saving the request, no review needed; a real merchant's store requires Shopify's formal review first.
- Filters, sorting, limit and offsetFilters and sort order are set from the report form, same as other connectors. Limit and offset have no field in the form: set them by typing a number directly into the corresponding cell of the report's configuration column.
- Values in the store's own currencySales metrics are returned in the currency the order was placed in, with no conversion applied.