What Is the Detailed Sales Report?
The Detailed Sales Report brings order, product, customer, payment, tax and fulfillment details into one exportable view. It helps you follow an order from its transaction date through the fulfillment information recorded for it.
Rather than switching between individual orders, review the selected period using identifiers, financial status, discounts, product SKUs, billing and shipping addresses, and tax components. The report includes both order-level and product-related fields; check how totals repeat across rows before summing amounts.
Report Overview
- Report period
- Choose the date range relevant to your review.
- Data included
- Order identifiers, product lines, amounts, returns, taxes, customer addresses, payment information and fulfillment dates/statuses.
- Best for
- Order investigations, sales-detail exports, finance reviews and fulfillment follow-up.
- Export formats
- Excel, CSV, TXT and PDF.
- Automation
- Daily, weekly or monthly scheduled emails and delivery options.
What Can You Learn from Detailed Sales Data?
1. Trace payment and fulfillment progress
Compare Financial Status, Transaction Date, Fulfillment Status (Order), and Fulfillment Date to find orders needing investigation.
Example: A hypothetical order shows a completed transaction but no fulfillment date.
What you can do: Review that order and confirm its operational status.
2. Explain discounted order totals
Review Sub Total, Discount Code 1, Discount, Shipping, Tax and Total Sales together to understand the reported order amounts.
Example: A hypothetical order has a promotion code and a discount amount.
What you can do: Check whether the applied promotion matches the order record.
3. Follow product and variant activity
Use Product Name, Variant SKU, Net Quantity and Product Vendor to identify which items appear in the detailed sales records.
Example: A hypothetical SKU appears repeatedly during a selected week.
What you can do: Inspect the SKU’s orders before making a replenishment decision.
4. Spot address and delivery discrepancies
Compare billing and shipping details with Shipping Title, fulfillment fields and order notes to support customer-service follow-up.
Example: A hypothetical order has a shipping address different from its billing address.
What you can do: Confirm the intended delivery address before taking action.
What Should You Check First in This Report?
Start with the fields that determine how you interpret the detailed rows.
- Financial Status and payment references: establish which transactions need a closer look.
- Total Sales, Discount, Shipping and Tax: read these alongside Sub Total; avoid adding order totals repeatedly across product rows.
- Net Quantity and Variant SKU: check product-level movement without treating net units as inventory on hand.
- Fulfillment Status (Order) and Fulfillment Date: identify orders whose delivery workflow requires follow-up.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing detailed sales for a selected period | Review sales details, discounts and products for the selected period. |
| Following up on order fulfillment details | Inspect order and line fulfillment statuses, dates and notes. |
| Responding to a customer’s order query | Find order IDs, customer contacts, shipping addresses and payment references. |
| Checking sales and payment-related records | Review reported sales, discounts, taxes, payment method and financial status. |
| Reviewing sales by SKU or vendor | Filter or sort product, variant SKU, vendor and net quantity details. |
How to Create This Report in Data Export
Use the premade Detailed Sales Report as the starting point.
- Open Data Export and find the premade Detailed Sales Report.
- Open the report and review its order, item, customer, payment and tax columns.
- Select the date range; adjust fields or add a useful filter, such as financial or fulfillment status.
- Save the report, then export it in the format suited to your workflow.
- If needed, configure a daily, weekly or monthly scheduled delivery to the intended recipients.
Make the Most of This Report
A few practical checks make a wide order-detail export easier to use.
01 / ROW LEVEL
Check repeated totals: A single order may have multiple product rows. Confirm the row structure before totaling order-level amounts.
02 / STATUS
Read both fulfillment fields: Compare order-level and detail-level statuses rather than treating them as identical.
03 / TAX DETAIL
Keep tax components together: Tax 1 through Tax 5 titles and amounts help distinguish separately listed tax components.
04 / SHARING
Limit personal data: Billing, shipping, phone and email fields may be sensitive. Share exports only with people who need them.
Frequently Asked Questions
Does this report show both payment and fulfillment information?
Yes. It includes Financial Status, Payment Method, Payment Reference, Fulfillment Status (Order), Fulfillment Status and Fulfillment Date.
Can I identify the product variant on an order?
Yes. Product Name, Variant SKU, Product Price and Net Quantity are listed in the supplied report fields.
Does the report include customer addresses?
Yes. It includes billing and shipping contact and address fields. Handle exported personal information carefully.
Can I review separate tax components?
Yes. The report includes Tax and up to five numbered tax title/amount field pairs, depending on the underlying order data.
Can the report be exported or delivered automatically?
The supplied knowledge base lists Excel, CSV, TXT and PDF exports, plus scheduled delivery by email and other configured destinations.
