Shopify Connector

Start moving your Shopify data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Shopify connector in the Weld documentation

customer

currency

75 more shopify tables

Explore available Shopify data

Browse all the data tables available for the Shopify connector, in our interactive ERD data viewer.

View the Shopify Data Schema

Transform and model Shopify data

Get clean data models from your Shopify data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Shopify

raw.shopify.table1

raw.shopify.table2

Get started with Shopify SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Shopify.

Customer growth by month

Analyzes the growth of customers on a monthly basis using data from the Shopify integration. It selects the month and counts the number of new customers, grouping the results by month. The output is ordered by month.

Monthly sales

Retrieves monthly sales data from a Shopify integration by joining order and order line tables and grouping the results by month. The template uses the date_trunc function to extract the month from the created_at date field and calculates the total sales by multiplying the quantity and price fields.

Top ten products

Retrieves the top ten products based on the quantity sold. It uses an inner join to combine order lines and orders data and groups the results by product title. The template is limited to only display the top ten products based on the count of orders.

Yearly revenue

Retrieve the total sales revenue for each year by joining the order and order line tables and grouping the results by year. The template uses the date_trunc function to extract the year from the created_at column.

Orders with tax, shipping , refunds and discounts

Retrieves detailed information about orders, including tax, shipping, refunds, and discounts, from a Shopify integration. It uses several subqueries to calculate various metrics such as total order line discounts, order level discounts, and line return.

View all Shopify templates