{"id":4432,"date":"2025-11-26T12:28:00","date_gmt":"2025-11-26T12:28:00","guid":{"rendered":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/?p=4432"},"modified":"2025-11-26T14:09:54","modified_gmt":"2025-11-26T14:09:54","slug":"order-lines-report","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/order-lines-report\/","title":{"rendered":"What is the Order lines report?"},"content":{"rendered":"\n<p>The Order Lines report in the <a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-report\/?utm_source=kb&amp;utm_content=order-report\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>REPORTiT &#8211; Advanced Reporting for WooCommerce plugin<\/strong><\/a> 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.&nbsp;<\/p>\n\n\n\n<p>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.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Generating the Order Lines Report<\/h2>\n\n\n\n<p>To create this detailed report, navigate to <strong>Revenue &gt; Order Lines<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-1-open-order-line-report.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"222\" height=\"285\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-1-open-order-line-report.png\" alt=\"Open Order line report\" class=\"wp-image-4437\"\/><\/a><\/figure>\n\n\n\n<p>Once there, follow these steps to refine your data:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Set the <strong>Date and Time<\/strong> filter to define the period you wish to analyze.<\/li>\n<\/ol>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Read More:<\/strong> <a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/use-date-filter-to-compare-performance\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use the Date Filter and Compare Performance Across Time Periods?<\/a><\/p>\n<\/blockquote>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>Apply additional filters to drill down into specific data segments:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Customer name<\/strong>: Find all transactions for a specific person.<\/li>\n\n\n\n<li><strong>Product name\/ SKU<\/strong>: Filter by a specific item or its unique identifier.<\/li>\n\n\n\n<li><strong>Status<\/strong>: View orders with a specific status (e.g., Completed, Processing).<\/li>\n\n\n\n<li><strong>Order total<\/strong>: Analyze orders based on their total value.<\/li>\n\n\n\n<li><strong>Order item counts<\/strong>: Filter by the number of items in an order.<\/li>\n\n\n\n<li><strong>Country\/State\/ City<\/strong>: Isolate sales from specific geographic locations.<\/li>\n\n\n\n<li><strong>Order ID<\/strong>: Look up a specific order by its unique number.<\/li>\n\n\n\n<li><strong>Coupon Code<\/strong>: See the performance of a specific promotion.<\/li>\n\n\n\n<li><strong>Discount<\/strong>: View orders based on the discount amount applied.<\/li>\n\n\n\n<li><strong>Tax code<\/strong>: Isolate transactions based on their tax rules.<\/li>\n\n\n\n<li><strong>Shipping<\/strong>: Filter by shipping method or cost.<\/li>\n\n\n\n<li><strong>Category\/Attribute\/Tags<\/strong>: Narrow down results by product characteristics.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-2-filter-by-order-total.png\"><img decoding=\"async\" width=\"413\" height=\"267\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-2-filter-by-order-total.png\" alt=\"Filter order line report by order total option\" class=\"wp-image-4438\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Understanding Your Order Lines Report<\/h3>\n\n\n\n<p>The generated report is organized into three main interactive sections for comprehensive analysis.<\/p>\n\n\n\n<p><strong>1. The Customizable Performance Overview<\/strong><\/p>\n\n\n\n<p>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:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Orders<\/strong>: The total number of orders.<\/li>\n\n\n\n<li><strong>Gross Sales<\/strong>: Total revenue before any deductions.<\/li>\n\n\n\n<li><strong>Total Refunds<\/strong>: The total amount refunded.<\/li>\n\n\n\n<li><strong>Discounts<\/strong>: The total value of all discounts applied.<\/li>\n\n\n\n<li><strong>Net Sales:<\/strong> The final revenue after refunds and discounts.<\/li>\n\n\n\n<li><strong>Shipping<\/strong>: The total revenue collected from shipping costs.<\/li>\n\n\n\n<li><strong>Taxes<\/strong>: The total amount of sales tax collected.<\/li>\n\n\n\n<li><strong>Total Sales<\/strong>: The final grand total.<\/li>\n\n\n\n<li><strong>Average Items Per Order<\/strong>: The mean number of items per transaction.<\/li>\n\n\n\n<li><strong>Average Order Gross<\/strong>: The mean revenue per order before deductions.<\/li>\n\n\n\n<li><strong>Average Order Net<\/strong>: The mean revenue per order after deductions.<\/li>\n<\/ul>\n\n\n\n<p>Click on any of these overview metrics to plot its data trend in the dynamic chart below.<\/p>\n\n\n\n<p><strong>2. The Interactive Visualization Chart<\/strong><\/p>\n\n\n\n<p>This chart provides a graphical representation of your selected metric.<\/p>\n\n\n\n<p>Adjust the time interval to <strong>Weekly, Monthly, or Quarterly<\/strong> views.<\/p>\n\n\n\n<p>Switch between <strong>Line graphs<\/strong> for trends or <strong>Bar charts<\/strong> for comparisons.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-3-order-line-metrics-chart.png\"><img decoding=\"async\" width=\"1682\" height=\"616\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-3-order-line-metrics-chart.png\" alt=\"order line overview chart\" class=\"wp-image-4439\" srcset=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-3-order-line-metrics-chart.png 1682w, https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-3-order-line-metrics-chart-1536x563.png 1536w\" sizes=\"(max-width: 1682px) 100vw, 1682px\" \/><\/a><\/figure>\n\n\n\n<p><strong>3. The Detailed Order Lines Data Table<\/strong><\/p>\n\n\n\n<p>This is the core of the report, offering an itemized list of every product sold.<\/p>\n\n\n\n<p><strong>Key Columns Include:&nbsp;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Order &amp; Transaction Details:<\/strong><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Date, Order ID, Status:<\/strong> The timestamp, unique identifier, and current state of the order.<\/li>\n\n\n\n<li><strong>Customer, Customer Type: <\/strong>The purchaser&#8217;s name and their segment (e.g., New, Returning).<\/li>\n\n\n\n<li><strong>Payment Method:<\/strong> The gateway used for the transaction.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Product &amp; Line Item Details:<\/strong><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Products\/SKU, Category\/Variation:<\/strong> The item name, its unique stock code, category, and specific attributes.<\/li>\n\n\n\n<li><strong>Quantity, Rate, Product Amount:<\/strong> The number of units sold, individual price, and total line value.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Financial Metrics:<\/strong><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Gross Sales, Net Sales, Total Sales:<\/strong> Revenue before deductions, after refunds\/discounts, and the final total.<\/li>\n\n\n\n<li><strong>Discounts, Tax, Refund, Shipping:<\/strong> The itemized breakdown of all financial adjustments and fees.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Analytics &amp; Customer Data:<\/strong><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Items Sold, Attribution:<\/strong> Total units moved and the marketing source that generated the order.<\/li>\n\n\n\n<li><strong>Billing\/Shipping Details:<\/strong> The complete customer-provided address information for invoicing and delivery.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-4-orderline-data-table.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1662\" height=\"493\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-4-orderline-data-table.png\" alt=\"Order line data table\" class=\"wp-image-4440\" srcset=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-4-orderline-data-table.png 1662w, https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2025\/11\/9-4-orderline-data-table-1536x456.png 1536w\" sizes=\"(max-width: 1662px) 100vw, 1662px\" \/><\/a><\/figure>\n\n\n\n<p>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.<\/p>\n\n\n\n<p>Finally, you can download the entire report for offline analysis in formats like CSV or Excel.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Read More:<\/strong> <a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/export-reports\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Export Reports for Further Analysis?<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Order Lines report in the REPORTiT &#8211; 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.&nbsp; This gives [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4432","post","type-post","status-publish","format-standard","hentry","category-plugin-usage"],"_links":{"self":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/posts\/4432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/comments?post=4432"}],"version-history":[{"count":3,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/posts\/4432\/revisions"}],"predecessor-version":[{"id":4728,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/posts\/4432\/revisions\/4728"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/media?parent=4432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/categories?post=4432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/tags?post=4432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}