{"id":23397,"date":"2023-10-16T16:08:53","date_gmt":"2023-10-16T16:08:53","guid":{"rendered":"https:\/\/ithemelandco.com\/?p=23397"},"modified":"2026-06-08T12:58:21","modified_gmt":"2026-06-08T12:58:21","slug":"woocommerce-order-status-report","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/blog\/woocommerce-order-status-report\/","title":{"rendered":"How to Get WooCommerce Order Status Reports With 3 Easy Methods"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Tracking order statuses is one of the most important parts of managing a WooCommerce store. Every order can have a different status, such as pending payment, processing, completed, on hold, canceled, refunded, or failed. If you do not review these statuses regularly, it becomes harder to understand order progress, detect fulfillment problems, and manage customer requests on time.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">WooCommerce includes basic order analytics and status filters, but they are not always enough when you need a clear order status report, a full WooCommerce order status list, or a faster way to analyze orders by date, amount, and status changes.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How to get order status report in WooCommerce?\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/CyL_wsC3MFM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In this tutorial, we\u2019ll show you how to get WooCommerce order status reports using WooCommerce Analytics, SQL queries, and<a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-report\/?utm_source=blog&amp;utm_content=order-status-reports\" target=\"_blank\" rel=\"noreferrer noopener\"> REPORTiT \u2013 Advanced Reporting For WooCommerce<\/a>. You\u2019ll learn how to check order statuses, review status changes, and generate practical reports that help you manage WooCommerce orders more professionally.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Order statuses can reveal issues that affect revenue, fulfilment, and customer experience. <a href=\"https:\/\/ithemelandco.com\/blog\/complete-woo-reporting-guide\/?utm_source=blog&amp;utm_content=order-status-reports\" target=\"_blank\" rel=\"noreferrer noopener\">Advanced WooCommerce reporting guide<\/a> shows how the main report types work together.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is the WooCommerce order status?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Each order in WooCommerce has a unique status to help the store managers identify the progression of orders through the purchase and fulfillment process. This feature is only visible for WordPress admin and includes different identifiers to let store owners manage their workflow effectively.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The WooCommerce order statuses are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Pending payment<\/strong>: When customers place the order but have not paid them yet.<\/li>\n\n\n\n<li><strong>Failed<\/strong>: If customers face issues in the payment processing.<\/li>\n\n\n\n<li><strong>Processing<\/strong>: When orders are received and inventory is reduced, though steps still remain for the order to be fulfilled.<\/li>\n\n\n\n<li><strong>Completed<\/strong>: When payment has been received and all steps in the fulfillment process are complete.<\/li>\n\n\n\n<li><strong>On hold<\/strong>: The customers have placed orders but store owners must approve the payment.<\/li>\n\n\n\n<li><strong>Canceled<\/strong>: When customers cancel their orders, and the inventory stock will be increased to what it was before the order was placed.<\/li>\n\n\n\n<li><strong>Refunded<\/strong>: When store owners refund the order payment to the customers.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Getting the order status report in WooCommerce allows store managers to efficiently track the order statuses which is crucial for ensuring a smooth operation and improving customer satisfaction.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Continue reading to learn how to get a WooCommerce order status report in your online store.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 id=\"method-1\" class=\"wp-block-heading\">Get order status report by WooCommerce analytics<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In WooCommerce analytics, there is no order status option to let store managers directly generate this report. However, by following the below instructions, you can get order status report in WooCommerce analytics:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open <strong>Orders<\/strong> report page.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-orders-menu.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"151\" height=\"362\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-orders-menu.png\" alt=\"select orders menu in analytics section WooCommerce\" class=\"wp-image-23399\"\/><\/a><figcaption class=\"wp-element-caption\">Open orders in WC analytics<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set a date range in the first filtering option (1).<\/li>\n\n\n\n<li>Choose <strong>Advanced Filters<\/strong> in the <strong>Show<\/strong> field (2).<\/li>\n\n\n\n<li>Click on <strong>Add a Filter<\/strong> option (3) and select <strong>Order Status<\/strong> from the dropdown list (4).<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-and-show-and-filter-fields.png\"><img decoding=\"async\" width=\"1697\" height=\"610\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-and-show-and-filter-fields.png\" alt=\"set date range and show and filter fields in order status WooCommerce\" class=\"wp-image-23401\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-and-show-and-filter-fields.png 1697w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-and-show-and-filter-fields-500x180.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-and-show-and-filter-fields-1536x552.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-and-show-and-filter-fields-1000x359.png 1000w\" sizes=\"(max-width: 1697px) 100vw, 1697px\" \/><\/a><figcaption class=\"wp-element-caption\">Add filters<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the <strong>Order status<\/strong> filter, you can choose to include\/exclude one of the statuses in the report. It is possible to add as many filters as you need in this part.&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-order-status-field.png\"><img decoding=\"async\" width=\"1675\" height=\"277\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-order-status-field.png\" alt=\"select order status field report in WooCommerce\" class=\"wp-image-23402\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-order-status-field.png 1675w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-order-status-field-500x83.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-order-status-field-1536x254.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-order-status-field-1000x165.png 1000w\" sizes=\"(max-width: 1675px) 100vw, 1675px\" \/><\/a><figcaption class=\"wp-element-caption\">Order status filter<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Finally, by clicking on the <strong>Filter<\/strong> button, the order status report is generated in two views:<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li>The first view is a chart reporting the order statuses based on the date.<\/li>\n\n\n\n<li>The second view is a table, including the below columns:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Order<\/li>\n\n\n\n<li>Status<\/li>\n\n\n\n<li>Customer<\/li>\n\n\n\n<li>Customer Type<\/li>\n\n\n\n<li>Product<\/li>\n\n\n\n<li>Item sold<\/li>\n\n\n\n<li>Coupon<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-report.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1688\" height=\"732\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-report.png\" alt=\"result customization orders report in WooCommerce\" class=\"wp-image-23405\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-report.png 1688w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-report-500x217.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-report-1536x666.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-report-1000x434.png 1000w\" sizes=\"(max-width: 1688px) 100vw, 1688px\" \/><\/a><figcaption class=\"wp-element-caption\">Orders status report by analytics<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Generating order status report in WooCommerce analytics is a time-consuming task for store managers, especially when they want to analyze this report regularly. There is also no option for receiving reports automatically or customizing the table columns of the report. That&#8217;s why we recommend you use the WooCommerce report plugin that allows you to get different types of reports with just one click.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 id=\"method-2\" class=\"wp-block-heading\">Use SQL to generate WooCommerce status report<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Running SQL queries in WordPress database management software like PhpMyAdmin is another method for receiving order status reports in WooCommerce. If you are an expert in coding, you can write a customized code to receive the report, including the required information for analyzing the order statuses.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here, you can find a sample SQL query for getting order status reports in WooCommerce:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT COUNT(postmeta.meta_value) AS 'order_count' ,SUM(postmeta.meta_value) AS 'total_amount' , it_posts.post_status As 'order_status' ,it_posts.post_status As 'StatusID' \nFROM wp_posts as it_posts LEFT JOIN wp_postmeta as postmeta ON postmeta.post_id=it_posts.ID \nWHERE postmeta.meta_key = '_order_total' AND it_posts.post_type='shop_order' \nGroup BY order_status ORDER BY total_amount DESC;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">By running this query in PhpMyAdmin as illustrated below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/sql-code-generate-report-plugin.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1118\" height=\"435\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/sql-code-generate-report-plugin.png\" alt=\"SQL code generate report plugin in WooCommerce\" class=\"wp-image-23406\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/sql-code-generate-report-plugin.png 1118w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/sql-code-generate-report-plugin-500x195.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/sql-code-generate-report-plugin-1000x389.png 1000w\" sizes=\"(max-width: 1118px) 100vw, 1118px\" \/><\/a><figcaption class=\"wp-element-caption\">Orders status report sql query<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You can receive a report with the most essential information in the table columns, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Order count.<\/li>\n\n\n\n<li>Total amount.<\/li>\n\n\n\n<li>Order status.<\/li>\n\n\n\n<li>Status ID.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-sql-code-generate-report-plugin.png\"><img loading=\"lazy\" decoding=\"async\" width=\"589\" height=\"232\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-sql-code-generate-report-plugin.png\" alt=\"result SQL code generate report plugin in WooCommerce\" class=\"wp-image-23407\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-sql-code-generate-report-plugin.png 589w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-sql-code-generate-report-plugin-500x197.png 500w\" sizes=\"(max-width: 589px) 100vw, 589px\" \/><\/a><figcaption class=\"wp-element-caption\">Order status report result<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Although generating reports with SQL queries provides you more flexibility for receiving the information you need, there are many limitations to using this method, such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>An expert must perform writing codes and running queries; otherwise, there is a potential risk of harming your WordPress website.<\/li>\n\n\n\n<li>&nbsp;You need to pay to hire an expert to do this task if you want to prevent any problems in the future.<\/li>\n\n\n\n<li>&nbsp;You have to back up your website before running the SQL queries, which is a very time-consuming task.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">For all these reasons, it makes sense to use the WooCommerce reports plugin for generating Order status reports in your online shop. Continue reading to get familiar with the amazing features of this functional plugin.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 id=\"method-3\" class=\"wp-block-heading\">Generating order status report in the WooCommerce reports plugin&nbsp;<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The <a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-report\/?utm_source=blog&amp;utm_content=order-status-reports\" data-type=\"link\" data-id=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-report\/?utm_source=blog&amp;utm_content=order-status-reports\"><span style=\"text-decoration: underline\">WooCommerce reports plugin<\/span><\/a> is designed with a user-friendly interface, allowing you to generate a wide range of reports with just one click. In all reports, you have access to extra features like filter form, selecting columns, and sorting options for customizing the report based on your needs.<br>Here, we want to show you how easy it is to get order status reports in WooCommerce with this plugin.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Install and activate WooCommerce reports plugin&nbsp;<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To use the WooCommerce reports plugin for generating order status reports, first, you need to download and install it on your WordPress website.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p><strong>Read more:<\/strong> <a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/install-plugin\/?utm_source=blog&amp;utm_content=order-status-reports\" target=\"_blank\" rel=\"noreferrer noopener\">How to install REPORTiT \u2013 Advanced Reporting for WooCommerce plugin?<\/a><\/p><\/blockquote><\/figure>\n\n\n\n<div class=\"wp-block-columns alignwide are-vertically-aligned-center main-cta-cnt has-background is-layout-flex wp-container-core-columns-is-layout-8a83d729 wp-block-columns-is-layout-flex\" style=\"background-color:#3d67ff;padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\">\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-group is-layout-constrained wp-container-core-group-is-layout-5980c20d wp-block-group-is-layout-constrained\" style=\"padding-top:15px\">\n<p class=\"single-cta-heading has-white-color has-text-color has-link-color wp-elements-0991dc6851cfc99e0f24c91f59e458e6 wp-block-paragraph\" style=\"font-size:26px;font-style:normal;font-weight:800\">REPORTiT &#8211; Advanced WooCommerce Reporting<\/p>\n\n\n\n<p class=\"single-cta-desc has-white-color has-text-color has-link-color wp-elements-2da55855711b3e08296187c93da56365 wp-block-paragraph\" style=\"font-size:16px\">The easy way to get order status report in WooCommerce<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button main-cta-button\"><a class=\"wp-block-button__link has-text-color has-background wp-element-button\" href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-report\/?utm_source=blog&amp;utm_content=order-status-reports\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#ffffff;background-color:#0fba5e;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener\">Buy Plugin<\/a><\/div>\n\n\n\n<div class=\"wp-block-button is-style-outline is-style-outline--1\"><a class=\"wp-block-button__link has-white-background-color has-text-color has-background wp-element-button\" href=\"https:\/\/wordpress.org\/plugins\/ithemelandco-woo-report\/\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#3d67ff;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Free Version<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"532\" height=\"355\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner.png\" alt=\"REPORTiT - Advanced WooCommerce Reporting plugin by ithemeland\" class=\"wp-image-48725\" style=\"width:440px;height:auto\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner.png 532w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner-500x335.png 500w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">After activation, you can open the main page of the plugin by clicking on the <strong>iT Woo Report<\/strong> option in the WordPress dashboard.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-it-woo-report-menu.png\"><img loading=\"lazy\" decoding=\"async\" width=\"327\" height=\"105\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-it-woo-report-menu.png\" alt=\"select IT Woo report menu in WooCommerce\" class=\"wp-image-23408\"\/><\/a><figcaption class=\"wp-element-caption\">Open REPORTiT plugin<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Generate order status reports&nbsp;<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">All available reports in this plugin are listed on the left panel and divided into some categories like order, product, customer, etc.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If your purpose is to generate order status reports, you can simply click on the <strong>Order<\/strong> category to see the related reports. In this category, you can generate two reports related to the order statutes, which are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Order Status report.&nbsp;<\/li>\n\n\n\n<li>Status change report.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s review the information you can receive in these reports, briefly.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">WooCommerce order status report<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Order status report informs you about a list of all order statuses on your online store with their count and total amount.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To generate this report, you need to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to <strong>Orders -&gt; Order status<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-order-status-menu.png\"><img loading=\"lazy\" decoding=\"async\" width=\"256\" height=\"468\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-order-status-menu.png\" alt=\"select order status menu in order section\" class=\"wp-image-23409\"\/><\/a><figcaption class=\"wp-element-caption\">go to Order status report<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open the <strong>Search<\/strong> form and set the date range in <strong>Date From <\/strong>and <strong>Date To<\/strong> fields.<\/li>\n\n\n\n<li>Click on the <strong>Search<\/strong> button to get the status report.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">As illustrated in the picture below, the order status report has a simple view with three columns, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Order status<\/strong>: The status of all orders are listed in different colors.<\/li>\n\n\n\n<li><strong>Order count<\/strong>: The number of orders related to each status.<\/li>\n\n\n\n<li><strong>Amount<\/strong>: The total amount of orders in each status.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">At the button of the page, you can observe a summary report that gives you an insight into the number of statuses, the total number of orders, and the total amount of all orders.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-order-status.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1633\" height=\"808\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-order-status.png\" alt=\"set date range order status in filter form\" class=\"wp-image-23410\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-order-status.png 1633w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-order-status-500x247.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-order-status-1536x760.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/set-date-range-order-status-1000x495.png 1000w\" sizes=\"(max-width: 1633px) 100vw, 1633px\" \/><\/a><figcaption class=\"wp-element-caption\">Filter report by date range<\/figcaption><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">WooCommerce order status change report<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Order status change report is useful when you want to track the orders that their statuses have been changed in a specific date range. To get this type of status report in the WooCommerce product table plugin, try to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to <strong>Orders -&gt; Status change<\/strong>.<\/li>\n\n\n\n<li>Open the <strong>Search<\/strong> form and set the date range.<\/li>\n\n\n\n<li>Filter the status you want to see its report (it is optional, if you don\u2019t choose any statutes, the plugin will show all status changes in the report).<\/li>\n\n\n\n<li>Press <strong>Search<\/strong> button.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-status-options-in-filter-form.png\"><img loading=\"lazy\" decoding=\"async\" width=\"393\" height=\"618\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-status-options-in-filter-form.png\" alt=\"select status options in filter form orders\" class=\"wp-image-23412\"\/><\/a><figcaption class=\"wp-element-caption\">Filter report by status<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">By generating this status change report, you can see a table with the below columns:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Order Id<\/strong><\/li>\n\n\n\n<li><strong>Date<\/strong>: The date of receiving the order.<\/li>\n\n\n\n<li><strong>Amount<\/strong>: The total amount of the order.<\/li>\n\n\n\n<li><strong>Change status date<\/strong>: The date that the order status is changed.<\/li>\n\n\n\n<li><strong>Status<\/strong>: The current order status.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-status-report.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1624\" height=\"494\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-status-report.png\" alt=\"result customization orders status report in WooCommerce\" class=\"wp-image-23414\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-status-report.png 1624w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-status-report-500x152.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-status-report-1536x467.png 1536w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/result-customization-orders-status-report-1000x304.png 1000w\" sizes=\"(max-width: 1624px) 100vw, 1624px\" \/><\/a><figcaption class=\"wp-element-caption\">Status change report<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">At the button of the table, you can see a summary report about the total number of statuses and the total amount of orders.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Example 1: Get change order status report in the current month<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Generating WooCommerce change order status report in the current month provides information about the orders that their statuses have been changed in the current month and helps store owners to better understand the progress of orders and manage them.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To receive this report in the WooCommerce report plugin, you just need to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the <strong>Status Change<\/strong> report from the plugin <strong>Dashboard.<\/strong><\/li>\n\n\n\n<li>Open the <strong>Search<\/strong> form and set the <strong>Date from<\/strong> and <strong>Date to<\/strong> fields to show the current month.<\/li>\n\n\n\n<li>Press the <strong>Search<\/strong> button.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/search-orders-date-range.png\"><img loading=\"lazy\" decoding=\"async\" width=\"331\" height=\"327\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/search-orders-date-range.png\" alt=\"Search orders date range in  WooCommerce reports plugin\" class=\"wp-image-28794\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/search-orders-date-range.png 331w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/search-orders-date-range-100x100.png 100w\" sizes=\"(max-width: 331px) 100vw, 331px\" \/><\/a><figcaption class=\"wp-element-caption\">Filter by current month<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">As illustrated in the picture below, the plugin will show you all orders whose statuses are changed this month. You can find useful information like the total amount and the current status of each order in the table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There is also a summary report informing you about the total number of orders with their total amount. In this example, you can find out that the statuses of 4 orders have been changed this month and their total amount was $1095.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/search-orders-date-range-result.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1421\" height=\"477\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/search-orders-date-range-result.png\" alt=\"Search orders date range result in WooCommerce reports plugin\" class=\"wp-image-28795\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/search-orders-date-range-result.png 1421w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/05\/search-orders-date-range-result-500x168.png 500w\" sizes=\"(max-width: 1421px) 100vw, 1421px\" \/><\/a><figcaption class=\"wp-element-caption\">Current month status change report<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Extra features of WooCommerce report plugin<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In the WooCommerce report plugin, we designed many tools and options to facilitate customizing and exporting reports for store managers.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here you can find the most useful extra features provided in this plugin:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Manage reports columns<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Managing reports columns is a helpful feature available in all reports by clicking on the <strong>Select Column<\/strong> option at the top of the report table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this field, you can see a list of all columns in the table and customize the report by marking the checkbox of any columns you want to see in the report.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-columns-options-in-order-status.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1314\" height=\"598\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-columns-options-in-order-status.png\" alt=\"select columns options in order status WooCommerce\" class=\"wp-image-23415\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-columns-options-in-order-status.png 1314w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-columns-options-in-order-status-500x228.png 500w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-columns-options-in-order-status-1000x455.png 1000w\" sizes=\"(max-width: 1314px) 100vw, 1314px\" \/><\/a><figcaption class=\"wp-element-caption\">Manage columns to display<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Export WooCommerce order status report&nbsp;<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Exporting data is one of the most common requirements of store managers. In the WooCommerce reports plugin, you can simply export the report by clicking on the <strong>Download<\/strong> icon at the top of the table in the below formats:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Excel<\/li>\n\n\n\n<li>CSV<\/li>\n\n\n\n<li>PDF<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/export-order-status-report.png\"><img loading=\"lazy\" decoding=\"async\" width=\"210\" height=\"217\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/export-order-status-report.png\" alt=\"export order status report in WooCommerce\" class=\"wp-image-23417\"\/><\/a><figcaption class=\"wp-element-caption\">Export report options<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to have a hard copy of your report, it is also possible to use the <strong>Print<\/strong> option.<\/p>\n\n\n\n<div class=\"wp-block-columns alignwide are-vertically-aligned-center main-cta-cnt has-background is-layout-flex wp-container-core-columns-is-layout-8a83d729 wp-block-columns-is-layout-flex\" style=\"background-color:#3d67ff;padding-top:30px;padding-right:30px;padding-bottom:30px;padding-left:30px\">\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-group is-layout-constrained wp-container-core-group-is-layout-5980c20d wp-block-group-is-layout-constrained\" style=\"padding-top:15px\">\n<p class=\"single-cta-heading has-white-color has-text-color has-link-color wp-elements-0991dc6851cfc99e0f24c91f59e458e6 wp-block-paragraph\" style=\"font-size:26px;font-style:normal;font-weight:800\">REPORTiT &#8211; Advanced WooCommerce Reporting<\/p>\n\n\n\n<p class=\"single-cta-desc has-white-color has-text-color has-link-color wp-elements-2da55855711b3e08296187c93da56365 wp-block-paragraph\" style=\"font-size:16px\">The easy way to get order status report in WooCommerce<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button main-cta-button\"><a class=\"wp-block-button__link has-text-color has-background wp-element-button\" href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-report\/?utm_source=blog&amp;utm_content=order-status-reports\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#ffffff;background-color:#0fba5e;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener\">Buy Plugin<\/a><\/div>\n\n\n\n<div class=\"wp-block-button is-style-outline is-style-outline--2\"><a class=\"wp-block-button__link has-white-background-color has-text-color has-background wp-element-button\" href=\"https:\/\/wordpress.org\/plugins\/ithemelandco-woo-report\/\" style=\"border-style:none;border-width:0px;border-radius:40px;color:#3d67ff;padding-top:10px;padding-right:30px;padding-bottom:10px;padding-left:30px;font-style:normal;font-weight:500\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Free Version<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"532\" height=\"355\" src=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner.png\" alt=\"REPORTiT - Advanced WooCommerce Reporting plugin by ithemeland\" class=\"wp-image-48725\" style=\"width:440px;height:auto\" srcset=\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner.png 532w, https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner-500x335.png 500w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Why analyzing order status report is important?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Reviewing and analyzing WooCommerce order status reports allows online store managers to manage orders and track them professionally. By evaluating the different statuses of orders, WooCommerce store managers have the opportunity to take timely action to change the order status and identify the orders that need to be followed up and changed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The most important benefit of order status report analysis is that managers can identify unpaid or on-hold orders and turn them into completed or paid orders by satisfying the customer.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Order status analysis helps managers track why orders are not being completed and increases the number of completed orders by providing a better shopping experience for customers and eliminating why they abandon their carts.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">WooCommerce order status reports help store owners understand what is happening inside their order management process. By reviewing order statuses, you can see how many orders are completed, pending, processing, refunded, canceled, or failed, and use this information to improve fulfillment, customer support, and sales analysis.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">WooCommerce Analytics can help with basic order filtering, and SQL can be useful for advanced technical users. However, both methods have limitations when you need a faster, cleaner, and more practical reporting workflow.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With <a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-report\/?utm_source=blog&amp;utm_content=order-status-reports\">REPORTiT \u2013 Advanced Reporting For WooCommerce<\/a>, you can generate WooCommerce order status reports, check order status changes, filter reports by date, review totals, and export reports without writing code. This makes it a better solution for store owners, WooCommerce managers, and developers who need accurate order analytics with less manual work.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To review the wider effect of order-status issues, continue with <a href=\"https:\/\/ithemelandco.com\/blog\/complete-woo-reporting-guide\/?utm_source=blog&amp;utm_content=order-status-reports\" target=\"_blank\" rel=\"noreferrer noopener\">this broader overview<\/a>.<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-7387b849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column blog-faq-section is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\">FAQ<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">1. What is a WooCommerce order status report?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A WooCommerce order status report shows orders grouped or filtered by their current status, such as processing, completed, pending payment, refunded, failed, canceled, or on hold. With <strong>REPORTiT<\/strong>, you can generate this report more easily and review order counts, amounts, and status changes from one reporting dashboard.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">2. How do I check order status in WooCommerce?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">You can check order status in WooCommerce from the <strong>Orders<\/strong> section in your WordPress dashboard. You can also use WooCommerce Analytics to filter orders by status. For a more complete reporting workflow, <strong>REPORTiT<\/strong> helps you view order status reports and status change reports with date filters and report summaries.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">3. What is included in a WooCommerce order status list?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A WooCommerce order status list usually includes statuses such as pending payment, processing, completed, on hold, canceled, refunded, and failed. <strong>REPORTiT <\/strong>helps you analyze these statuses in report format so you can see how many orders belong to each status and how much revenue is connected to them.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4. Can WooCommerce Analytics show order status reports?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Yes, WooCommerce Analytics can show order data and allows filtering by order status. However, the process can be limited if you need dedicated order status reports, status change reports, custom columns, or export options. <strong>REPORTiT<\/strong> gives you a more direct way to generate and manage WooCommerce order status reports.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">5. Is WooCommerce status report the same as order status report?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">No. A WooCommerce status report usually refers to technical store information, such as system settings, server details, and plugin data. A WooCommerce order status report focuses on customer orders and their statuses. <strong>REPORTiT<\/strong> is useful when you want to analyze order statuses, not just technical store status.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">6. Can I export WooCommerce order status reports?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Yes. If you use <strong>REPORTiT<\/strong>, you can export WooCommerce order status reports for further analysis, sharing, or record keeping. This is useful when you need reports for store managers, finance teams, or monthly order reviews.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">7. Why are WooCommerce order status reports important?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">WooCommerce order status reports help you track fulfillment, identify delayed orders, review canceled or refunded orders, and understand how orders move through your store. With <strong>REPORTiT<\/strong>, you can analyze these reports faster and make better decisions based on real order data.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Tracking order statuses is one of the most important parts of managing a WooCommerce store. Every order can have a different status, such as pending payment, processing, completed, on hold, canceled, refunded, or failed. If you do not review these statuses regularly, it becomes harder to understand order progress, detect fulfillment problems, and manage customer [&hellip;]<\/p>\n","protected":false},"author":1990,"featured_media":23418,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[50,73],"tags":[],"class_list":["post-23397","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","category-woocommerce"],"featured_image_url":"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/get-order-status-report-500x335.jpg","excerpt_plain":"Tracking order statuses is one of the most important parts of managing a WooCommerce store. Every order can have a different status, such as pending payment, processing, completed, on hold, canceled, refunded, or failed. If you do not review these statuses regularly, it becomes harder to understand order progress, detect fulfillment problems, and manage customer [&hellip;]","_embedded":{"wp:term":[[{"term_id":50,"name":"Tutorials","slug":"tutorials","term_group":0,"term_taxonomy_id":50,"taxonomy":"category","description":"Follow and learn the latest educational articles about WordPress plugins and WooCommerce here","parent":0,"count":256,"filter":"raw"},{"term_id":73,"name":"WooCommerce","slug":"woocommerce","term_group":0,"term_taxonomy_id":73,"taxonomy":"category","description":"Do you use WooCommerce to manage your online store? We suggest you read this category of WooCommerce articles.","parent":50,"count":205,"filter":"raw"}]]},"_links":{"self":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/23397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/users\/1990"}],"replies":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/comments?post=23397"}],"version-history":[{"count":4,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/23397\/revisions"}],"predecessor-version":[{"id":51591,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/23397\/revisions\/51591"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/media\/23418"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/media?parent=23397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/categories?post=23397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/tags?post=23397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}