Shopify SQL templates

3 ready-to-run SQL models for Shopify data in your own warehouse. Each one runs as-is against your synced tables, in Weld SQL or dbt.

• Sales Over Time

  Recreates Shopify's "Total sales over time" on Shopify's own event grain, so returns land on the refund date and order edits on the edit date. Returns the full sales equation plus parity variants, the returns detail block, gift-card columns, and location, sales-channel, country and fulfilment dimensions.

  Advanced · 9 required models

• Product Sales Over Time

  The sales equation at line grain - day x store x order x line - read from the agreement event log, so it reconciles to the sales report. Carries COGS and gross profit from Shopify's own cost history.

  Advanced · 12 required models

• Sales by Product

  Recreates Shopify's "Total sales by product": units, orders and revenue for every product, variant and SKU per day, so you can rank top sellers and break the numbers down by product type or vendor.

  Intermediate · 4 required models

Or browse templates for every connector.