Detailed Sales
Report for Shopify

The full-detail sales export — every line with channel, payment, tax, cost, and margin — built for deep analysis and your data warehouse.

Star

5 from 1,800+ merchants

2,000+ data fields

Trusted by 40,000+ Shopify stores

Updated June 2026

What this report is
The Detailed Sales Report is a comprehensive Shopify report with one row per sale line and every relevant field — product, variant, channel, customer, payment method, discounts, tax, shipping, cost, and margin. Report Pundit provides it as a free pre-built template built for deep analysis and warehousing, with scheduling and exports to Google Sheets, Excel, CSV, BigQuery, or Power BI.
Report type
Comprehensive line-level sales export
Best for
Analysts, finance, BI / data-warehouse pipelines
Refresh
On run or schedule
Setup time
~6 minutes
Tracks
Every sale line with full commercial detail
Export to
Google Sheets, Excel, CSV, PDF, BigQuery, Power BI
Scheduling
Yes
Shopify plan
All plans, including the free Report Pundit plan
Keep up with Shopify reports
We promise we won’t spam you.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Why this report matters

Sometimes you don’t want a summary — you want every row, every field, to slice yourself or pipe into a warehouse. That “kitchen-sink” sales export is the foundation a real analytics stack is built on.

Shopify’s native exports are partial and rigid: limited columns, no cost or margin, no scheduled push to BigQuery or Power BI. Analysts end up gluing CSVs together instead of querying a clean, complete table.

A detailed sales report puts one row per line with the full commercial picture — channel, payment, tax, cost, margin — and can push it on a schedule to your warehouse. It’s the difference between a reporting tool and a data source. Where the Order Report is the operational ledger, this is the analytical feed.

What’s included

Never just a list of column names. Every column gets a plain definition, plus a formula, a worked example, or a heads-up wherever it earns one.

Transaction keys

Order, line, date

Order reference, the specific line item, and the order timestamp — the grain of the table.

Channel & location

Sales channel and the relevant location for each line.

Customer

Customer identifier/email where present, for joining to customer data.

Product & quantity

Product / variant / SKU

Full product identity per line, your join key to catalog and inventory.

Quantity & unit price

Units and price per line.

Formula:  Line gross = Unit price × Quantity

Money & margin

Discounts, net, tax, shipping

The full money build-up per line.

Formula:  Line net = Line gross − Discounts − Returns

Payment method

How the order was paid (card, PayPal, gift card, COD), useful for finance and fee analysis.

Cost & margin

Unit cost and the resulting gross margin, where cost is set in Shopify.

Formula:  Gross margin = Line net − (Unit cost × Quantity)

Heads up:  Cost and margin are blank for any product without a unit cost set in Shopify — set costs to make this column meaningful.

Financial & fulfillment status

Payment and fulfillment state per order, carried onto each line.

Common added columns

Who uses this report

01

Data analyst

Situation
You’re building a sales model in BI.
Look at
The full line-level table piped to BigQuery or Power BI.
Decision
Query and model freely instead of wrangling partial CSV exports.
02

Finance

Situation
You need cost and margin on every line.
Look at
Net, cost, and margin columns across the period.
Decision
Analyze true contribution by product and channel, not just gross revenue.
03

Ops / RevOps

Situation
You feed a central warehouse nightly.
Look at
A scheduled push of the detailed export.
Decision
Treat Shopify as a clean data source feeding the wider stack.
04

Founder / analyst

Situation
You have a one-off deep question.
Look at
The complete table filtered to the slice in question.
Decision
Answer it directly in a sheet without rebuilding from raw orders.

How to read the report

  • Treat it as a data source, not a dashboard. Its value is completeness and grain; the summarizing happens downstream in your sheet or BI tool.
  • Mind the row grain. One row per line means order-level fields repeat across lines — aggregate carefully so you don’t double-count shipping or order totals.
  • Set product costs first. Margin is only as real as your cost data; without unit costs, the margin column is empty.
  • Schedule the push. For a warehouse feed, a daily scheduled export beats manual pulls and keeps the source current.

How to build the report in Report Pundit

Under 5 minutes from install to insight. No code, no SQL.
  1. Open Report Pundit in your Shopify admin and choose Create Report (or the pre-built “Detailed Sales” template).
  2. Set the data source to Sales / Order line items (one row per line).
  3. Add transaction keys: Order, Line, Date, Channel, Location, Customer.
  4. Add product columns: Product, Variant, SKU, Quantity, Unit price.
  5. Add money columns: Discounts, Net, Tax, Shipping, Payment method.
  6. Add Cost and a calculated Gross-margin column (net − cost × qty).
  7. Add Financial status and Fulfillment status.
  8. Set the date range, run, and confirm a known order’s lines reconcile, then Save.
  9. Schedule a daily/weekly push to BigQuery, Power BI, or Google Sheets for your analytics stack.

Customization & filters

The pre-built version covers 90% of merchant needs. For the remaining 10%, common customizations:
  • Add or remove any of 2,000+ fields to fit your schema.
  • Toggle one row per line vs one row per order.
  • Add metafields, tags, and line-item properties for a richer feed.
  • Filter to a channel, location, or product set.
  • Schedule a recurring push to BigQuery or Power BI.

Automate & export

Once the report is set up the way you want it, automation does the rest:
  • Schedules — hourly, daily, weekly, monthly, or custom cron
  • Delivery formats — Excel, CSV, PDF, or push to Google Sheets in real time
  • Group by month or week — trends instead of a static snapshot
  • Destinations — email (multiple recipients), Google Sheets, Google Drive, FTP/SFTP, Looker Studio, BigQuery
  • Conditional alerts — get notified only if a channel's net sales drop more than X% week-over-week

Report Pundit vs Shopify's native Sales by Channel report

Shopify ships a basic version. Here's where it stops — and what Report Pundit adds.
Capability Shopify built-in Report Pundit
One row per line, full field set × (limited columns) ✓ 2,000+ fields
Cost & margin per line × ✓ (with cost set)
Scheduled push to BigQuery / Power BI ×
Payment method per line Limited
Available on every Shopify plan Shopify / Grow plan & up — not on Basic ✓ All plans, incl. free
Scheduled email / Slack delivery × ✓ Daily, weekly, multiple/day
Export to Google Sheets in real time × (manual CSV only) ✓ Live sync
Add custom / calculated columns × (saved custom reports: Advanced/Plus only) ✓ 2,000+ fields
Combine with app data (PayPal, ShipStation…) × ✓ 30+ integrations
Multi-store reporting (Plus) ×

Frequently Asked Questions

How is this different from the Order Report?

The Order Report is an operational ledger for working orders — fulfillment, refunds, staff. The Detailed Sales Report is an analytical feed: maximum fields, one row per line, built to slice or pipe into a warehouse.

Can I push it straight to BigQuery or Power BI?

Yes. Schedule a recurring export to BigQuery, Power BI, or Google Sheets so Shopify acts as a clean, current data source for your analytics stack.

Does it include cost and margin?

Yes, where you’ve set unit cost in Shopify. Margin is calculated per line (net − cost × quantity); it’s blank for products with no cost set.

Report Not Found
Let's create it!
Your request is in! Check out all reports with the button below.
* Error. Please input correct email

Benefits

Granular Product level insights

Granular Product-Level Insights

The report enables users to track the true sales performance of individual products, considering discounts and returns for accurate financial analysis.
Discount analysis icon

Discount Analysis

Understand the impact of discounts on product profitability and overall order value.
Order tracking icon

Order Tracking

Monitor the financial details of orders even if they undergo edits. This helps maintain accurate records and simplifies financial reconciliation processes.

Sales Over Time

Leverage historical data with the Sales Over Time Report. This report covers costs, order details, sales channels, and payment methods, helping you track trends, manage sales tax returns, and assess the effectiveness of each sales channel.

Order Tags and Line Item Properties

A detailed report built to include order tags and line items added to each placed order, along with essential sales and product details for thorough analysis and processing.

Sales by Channel

The Sales by Channel report displays sales data based on the source of each sale. It's a valuable report offering insights into multichannel Shopify selling.

Sales by Checkout Currency

This report displays the breakdown of your sales by customer currency used at the checkout with the total sales value also being displayed in your local currency.

Sales by Device ID

The report displays sales data segmented by device type, such as mobile, desktop, or tablet, allowing merchants to analyze performance based on customer device usage.

Sales by Customer

The Sales by Customer Report provides Shopify merchants with valuable insights into customer purchasing behavior. This report breaks down sales by individual customers, highlighting the most valuable and active customers.

Commission

The Commission Report is the key to rewarding store staff and affiliates for sales they generate. It provides an overview of their sales performance along with calculated commissions share.

Sales by Staff

A report designed for quick analysis of sales attributed to each staff member across all POS locations, with details from gross sales to net sales calculations.

Sales by Variant

Gain detailed insights into each product variant's performance with the Sales by Variant Report. Beyond basic sales data, it shows how each variant impacts your store's success. Use it to fine-tune inventory management and identify popular options, helping you make strategic decisions to boost your bottom line.

Sales by Vendor

The Sales by Vendor report analyzes how each vendor's products contribute to your store's success. By examining sales, purchase costs, and profitability, this report provides insights to make strategic decisions, maximize profits, and optimize inventory management based on vendor performance.

Sales by POS

The report provides detailed sales figures and net product counts, accounting for refunds, at each POS location, offering a clear view of actual sales performance and inventory movement.

Sales by Discount Code

Sales by Discount Code report in Report Pundit provides a detailed analysis of sales generated through specific discount codes over a defined period.

Refund

Report Pundit’s Refund Report records the details of money returned by a Shopify merchant to unsatisfied customers when they return the product/service. These reports help the merchant keep track of the refunds issued, monitor customer satisfaction and have a proper record of financial transactions for filing taxes.

Weekly Sales Pattern

Your true day-of-week rhythm — which days and hours actually sell — so you staff, schedule ads, and send emails when buyers are buying.

Sales by Fulfillment Location

Data reported to analyze sales based on order fulfillment locations for any specified date range, including product quantity sold and corresponding sales value.

Finance Summary

The Finance Summary Report provides an overview of your store’s financial performance by aggregating key revenue, expense, and tax data. This report helps store owners understand their overall profitability, cash flow, and key cost drivers, making it essential for budgeting and financial planning

Sales by Billing Location

The Sales by Billing Location report in Shopify provides a detailed breakdown of sales based on the billing addresses of your customers. This report categorizes sales data of your customer base by country, region, or city.

Order vs Return (Monthly)

A report interpreting monthly returns by comparing the total sales value with the sales value of returned orders, including percentage calculations for both return orders and return value.

Completed Draft Order

This report provides insights into finalized draft orders, displaying detailed information on converted orders, including product details, pricing, and customer data for analysis.

Sales by Collections

The Sales by Collections report provides a detailed view of your product sales, inventory costs, and profitability by collection, helping you see which collections drive revenue and how they resonate with your audience, allowing you to tailor your product strategies accordingly.

Sales by Product

The Sales by Product report offers details about each product’s sales performance over a given time frame. It provides valuable insights into which of your products are and aren’t selling well. These insights will enable you to make informed decisions about inventory management and marketing and improve your business.

Last 30 days Sales Summary

A report that provides a comprehensive overview of sales performance over the past 30 days, including total revenue, order count, average order value, and product-specific sales trends for detailed analysis.

Last 24 Hours Orders

Use the Last 24 Hours Orders report to stay updated on all orders placed within the past day. It provides critical insights into sales trends, customer transactions, and order statuses, allowing you to monitor your store's recent activity and make informed business decisions.

Build and automate your Shopify Reporting

Unlock the full potential of your Shopify store with Report Pundit. Gain access to over 2000 data fields, automate reports, and make data-backed decisions to grow your business.