Shopify SQL templates

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.

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.

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.

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.