Loading...

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 article
    Adding 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 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, which this connection doesn't request today.
  • Protected customer data
    Reading 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 offset
    Filters 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 currency
    Sales metrics are returned in the currency the order was placed in, with no conversion applied.