Extract data from Shopify

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

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.

Order Items Sales

Aggregates orders, and combines order line details with various order-related information to calculate sales metrics such as gross sales, net sales, and total sales for Shopify order items.

Order Items Adjustmens

Creates an order adjustment summary by combining data from Shopify's order adjustments, refunds, orders, and customers. It provides details such as order information, refund amounts, customer names, and customer types. The query also distinguishes between first-time and returning customers based on order numbers.

Order Items Refunds

Aggregates order refund data from Shopify, linking it with customer, order, product, and variant details to provide a comprehensive view of refunds. It includes information such as refund amounts, customer details, product titles, and order statuses. Additionally, it categorizes customers as either first-time or returning based on their order history.

Order Master

Consolidates sales, refunds, and adjustments from Shopify into a unified view by combining data from sales, refund, and adjustment sources. It includes additional fields to indicate whether a record represents a sale, refund, or adjustment and provides detailed order information such as customer details, product information, and financial status. The template uses union operations to merge data from different sources into a single dataset.

View all Shopify templates