What Is the Shopify Detailed Sales Report?
The Shopify Detailed Sales Report puts sales, customer, product, tax, and fulfillment data for each order into a single row-level dataset. Instead of opening one report for what sold, another for who bought it, and a third for tax and delivery, you read the whole order on one line: order name, email, financial status, transaction and fulfillment dates, product and SKU, discounts, the full tax breakdown, and both billing and shipping addresses.
The report works at the line-item grain, so one row represents one product line within an order. An order with three products shows as three rows, and its order-level values like Total Sales and Shipping repeat across those rows. That grain is worth understanding before you total anything, and it is what separates this report from an order-summary view.
Merchants reach for this report when they need the complete picture behind a transaction, not an aggregate. It is the report to use when a question spans several data types at once, such as which vendor's items shipped late, or whether a discount code landed on the right products.
Learn more: How to Get Detailed Sales Reports for Shopify Stores walks through building a detailed sales report yourself, field by field.
Which Fields Are Included in the Shopify Detailed Sales Report?
The fields let you trace an order end to end, from who placed it and what they paid to where it shipped and how it was taxed.
You can customize the pre-made report by adding, removing, or rearranging columns so it matches the way you review orders.
Important Insights You Can Find in This Report
Why is an order paid but still not fulfilled?
Read Financial Status next to Fulfillment Status and Fulfillment Date on the same rows. An order marked paid with no fulfillment date is revenue you have collected but not yet shipped. One or two is routine, but if the same pattern clusters around a particular Product Vendor or SKU, it points to a stock or supplier bottleneck rather than a one-off delay. Filter to those rows and check whether the holdup traces back to a single source.
Which discount codes are landing on the wrong products?
Because Discount Code 1 and Discount sit on the same row as Product Name and Sub Total, you can see exactly which product each code discounted, not just that a code was used somewhere on the order. Look for a code repeatedly applied to already low-priced lines, or stacked on items you never meant to promote. That tells you a promotion is quietly reducing the value of lines that did not need help.
Do billing and shipping locations disagree on the same order?
Both address blocks appear on one line, so you can compare Billing Country against Shipping Country without joining two reports. Orders where they differ are worth a second look for tax accuracy, since the Tax 1 to Tax 5 breakdown should reflect the delivery destination, and for fraud screening on higher-value orders. Isolate the mismatched rows and confirm the tax components applied match where the order actually shipped.
THE ANALYST'S READ: The Signal Most Merchants Miss
The most common mistake with this report is summing the wrong columns. Since the grain is one row per product line, order-level fields like Total Sales, Shipping, and Tax repeat on every line of a multi-item order. Add up the Total Sales column directly and you will overstate revenue, because a three-line order counts its order total three times.
The fields that are safe to sum down the column are the line-level ones: Net Quantity, and line values like Sub Total and Discount. The order-level fields should be counted once per order, using Order Name or Order ID as the grouping key. Before you trust any total from this report, pull a single known order, confirm its lines reconcile to its actual order total, and only then aggregate. This grain trap is specific to a combined line-level export and would not appear on an already-aggregated report.
Learn more: Shopify Sales Reports Explained covers how a sales report differs from an order report and which metric belongs where.
How Can You Automate the Shopify Detailed Sales Report?
Open the pre-made Detailed Sales Report in Report Pundit and the columns are already set, so you can save it as is or adjust the fields first. Once it looks right, schedule it to run and email itself daily, weekly, or monthly, and add your team, VA, or accountant as recipients on the same schedule.
For delivery, you can download it as Excel, CSV, or PDF, or push it straight to Google Sheets or Google Drive so the data lands where you already work without a manual export.
Frequently Asked Questions
How is the Shopify Detailed Sales Report different from the Shopify Order Report?
The Order Report is an order-grain operational view for working and tracking orders. The Detailed Sales Report is line-level and pulls sales, customer, product, tax, and fulfillment fields together on each row, so it is built for analyzing the detail behind transactions rather than processing them.
Why does the same order appear on more than one row?
Because the report is at the line-item level. Each product line in an order gets its own row, and order-level values like Total Sales and Shipping repeat across those rows. Group by Order Name or Order ID when you need to roll lines back up to the order.
Does the report show billing and shipping addresses separately?
Yes. It includes a full billing address block and a full shipping address block on the same row, so you can compare where an order was billed against where it was delivered without combining reports.
What do the Tax 1 to Tax 5 columns represent?
They itemize each individual tax component applied to an order, with a title and an amount for each. This is useful where multiple taxes stack, such as state plus county, since you see each one by name instead of a single combined tax figure.
Can I focus the report on a single vendor, product, or status?
Yes. Apply a filter to narrow it to one Product Vendor, product, financial status, or fulfillment status, so you study just the slice you care about instead of the full order history.
Does Total Sales already include tax, shipping, and discounts?
Total Sales is the order's final figure after discounts, returns, tax, and shipping are accounted for. Sub Total, by contrast, is the line value before shipping and tax, which is why the two columns will not match.