What is the Order lines report?

The Order Lines report in the REPORTiT – Advanced Reporting for WooCommerce plugin provides the most detailed breakdown of your sales transactions available. Unlike the standard Orders report, which summarizes each transaction into a single row, this report breaks down every item within each order, displaying each product as a separate line item. 

This gives you unparalleled visibility into exactly which products are selling, their specific categories, SKUs, quantities, and individual prices, along with a full breakdown of associated shipping costs, taxes, and discounts applied at the item level. It is the ultimate tool for detailed product performance analysis and reconciling individual transactions.

Generating the Order Lines Report

To create this detailed report, navigate to Revenue > Order Lines.

Once there, follow these steps to refine your data:

1. Set the Date and Time filter to define the period you wish to analyze.

Read More: How to Use the Date Filter and Compare Performance Across Time Periods?

2. Apply additional filters to drill down into specific data segments:

• Customer name: Find all transactions for a specific person.
• Product name/ SKU: Filter by a specific item or its unique identifier.
• Status: View orders with a specific status (e.g., Completed, Processing).
• Order total: Analyze orders based on their total value.
• Order item counts: Filter by the number of items in an order.
• Country/State/ City: Isolate sales from specific geographic locations.
• Order ID: Look up a specific order by its unique number.
• Coupon Code: See the performance of a specific promotion.
• Discount: View orders based on the discount amount applied.
• Tax code: Isolate transactions based on their tax rules.
• Shipping: Filter by shipping method or cost.
• Category/Attribute/Tags: Narrow down results by product characteristics.

Understanding Your Order Lines Report

The generated report is organized into three main interactive sections for comprehensive analysis.

1. The Customizable Performance Overview

This section provides a high-level summary of the filtered data. You can select which key metrics to display from an available list, which typically includes:

• Orders: The total number of orders.
• Gross Sales: Total revenue before any deductions.
• Total Refunds: The total amount refunded.
• Discounts: The total value of all discounts applied.
• Net Sales: The final revenue after refunds and discounts.
• Shipping: The total revenue collected from shipping costs.
• Taxes: The total amount of sales tax collected.
• Total Sales: The final grand total.
• Average Items Per Order: The mean number of items per transaction.
• Average Order Gross: The mean revenue per order before deductions.
• Average Order Net: The mean revenue per order after deductions.

Click on any of these overview metrics to plot its data trend in the dynamic chart below.

2. The Interactive Visualization Chart

This chart provides a graphical representation of your selected metric.

Adjust the time interval to Weekly, Monthly, or Quarterly views.

Switch between Line graphs for trends or Bar charts for comparisons.

3. The Detailed Order Lines Data Table

This is the core of the report, offering an itemized list of every product sold.

Key Columns Include: 

• Order & Transaction Details:

• Date, Order ID, Status: The timestamp, unique identifier, and current state of the order.
• Customer, Customer Type: The purchaser’s name and their segment (e.g., New, Returning).
• Payment Method: The gateway used for the transaction.

• Product & Line Item Details:

• Products/SKU, Category/Variation: The item name, its unique stock code, category, and specific attributes.
• Quantity, Rate, Product Amount: The number of units sold, individual price, and total line value.

• Financial Metrics:

• Gross Sales, Net Sales, Total Sales: Revenue before deductions, after refunds/discounts, and the final total.
• Discounts, Tax, Refund, Shipping: The itemized breakdown of all financial adjustments and fees.

• Analytics & Customer Data:

• Items Sold, Attribution: Total units moved and the marketing source that generated the order.
• Billing/Shipping Details: The complete customer-provided address information for invoicing and delivery.

This table is fully customizable. You can show or hide columns, adjust the number of line items per page, and use the search function to find a specific product, order, or customer.

Finally, you can download the entire report for offline analysis in formats like CSV or Excel.

Read More: How to Export Reports for Further Analysis?