{"id":23397,"date":"2023-10-16T16:08:53","date_gmt":"2023-10-16T16:08:53","guid":{"rendered":"https:\/\/ithemelandco.com\/?p=23397"},"modified":"2025-10-16T11:59:44","modified_gmt":"2025-10-16T11:59:44","slug":"woocommerce-order-status-report","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/blog\/woocommerce-order-status-report\/","title":{"rendered":"How to get order status report in WooCommerce?"},"content":{"rendered":"\n<p>In WooCommerce, customers&#8217; orders are categorized in different statuses to inform the store managers about the status of ordered products. These statuses have different names, such as completed, processing, on hold, etc. By reviewing the order status report in WooCommerce, the manager of the online store can manage the status of the orders professionally.<\/p>\n\n\n\n<p>One of the weaknesses of the WooCommerce system is its reporting section, which gives limited possibilities to online store owners. For this reason, most store managers use the WooCommerce report plugins. This type of plugins provides online store managers with a useful and comprehensive tool to receive all types of WooCommerce reports very quickly.<\/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>In this post, we describe how to get the order status report in WooCommerce with three methods:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span style=\"text-decoration: underline\"><a href=\"#method-1\" data-type=\"internal\" data-id=\"#method-1\">Get order status report with WooCommerce analytics.<\/a><\/span><\/li>\n\n\n\n<li><span style=\"text-decoration: underline\"><a href=\"#method-2\" data-type=\"internal\" data-id=\"#method-2\">Use SQL to generate WooCommerce order status reports.<\/a><\/span><\/li>\n\n\n\n<li><span style=\"text-decoration: underline\"><a href=\"#method-3\" data-type=\"internal\" data-id=\"#method-3\">Generate order status reports using the WooCommerce report plugin.<\/a><\/span><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">What is the WooCommerce order status?<\/h2>\n\n\n\n<p>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>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>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>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 class=\"wp-block-heading\" id=\"method-1\">Get order status report by WooCommerce analytics<\/h2>\n\n\n\n<p>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><\/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><\/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><\/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><\/figure>\n\n\n\n<p>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 class=\"wp-block-heading\" id=\"method-2\">Use SQL to generate WooCommerce status report<\/h2>\n\n\n\n<p>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>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>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><\/figure>\n\n\n\n<p>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><\/figure>\n\n\n\n<p>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>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 class=\"wp-block-heading\" id=\"method-3\">Generating order status report in the WooCommerce reports plugin&nbsp;<\/h2>\n\n\n\n<p>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>To use the WooCommerce reports plugin for generating order status reports, first, you need to <a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/install-plugin\/\" data-type=\"link\" data-id=\"https:\/\/ithemelandco.com\/blog\/docs\/woocommerce-report\/install-plugin\/\" target=\"_blank\" rel=\"noreferrer noopener\">download and install<\/a> it on your WordPress website.&nbsp;<\/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-4a33225c 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-4f39da6d 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\" 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\" 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>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><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Generate order status reports&nbsp;<\/h3>\n\n\n\n<p>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>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>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>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>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><\/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>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>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><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">WooCommerce order status change report<\/h4>\n\n\n\n<p>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><\/figure>\n\n\n\n<p>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><\/figure>\n\n\n\n<p>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>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>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><\/figure>\n\n\n\n<p>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>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><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Extra features of WooCommerce report plugin<\/h2>\n\n\n\n<p>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>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>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>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><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Export WooCommerce order status report&nbsp;<\/h3>\n\n\n\n<p>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><\/figure>\n\n\n\n<p>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-4a33225c 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-4f39da6d 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\" 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\" 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>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>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>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>The WooCommerce order status report is a very useful tool that helps online store managers find out about the status of their orders. By evaluating the data of this report, managers can be informed about the status of product delivery and the stage where the customer&#8217;s order is. This data allows the managers of online stores to gain customers&#8217; trust and ultimately help them to return and repeat their purchases.<\/p>\n\n\n\n<p>WooCommerce reports plugin, with the possibility of creating different types of order status, reports with just one click and providing more features such as filtering and exporting reports, is the best plugin that simply allows store owners to track the order status.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In WooCommerce, customers&#8217; orders are categorized in different statuses to inform the store managers about the status of ordered products. These statuses have different names, such as completed, processing, on hold, etc. By reviewing the order status report in WooCommerce, the manager of the online store can manage the status of the orders professionally. One [&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":"In WooCommerce, customers&#8217; orders are categorized in different statuses to inform the store managers about the status of ordered products. These statuses have different names, such as completed, processing, on hold, etc. By reviewing the order status report in WooCommerce, the manager of the online store can manage the status of the orders professionally. One [&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":2,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/23397\/revisions"}],"predecessor-version":[{"id":48996,"href":"https:\/\/ithemelandco.com\/blog\/wp-json\/wp\/v2\/posts\/23397\/revisions\/48996"}],"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}]}}