In this post, we have provided a step-by-step guide about generating WooCommerce sales reports by product category with both methods.<\/p>\n\n\n\n
What is a sales report by product category?<\/h2>\n\n\n\n
Sales report by category provides comprehensive information about the orders placed in an online store related to one or more product categories separately. Generally, this report lists the product categories in a table. It reports other information like the number of orders, the number of products, the total sales amount, and others related to those categories in different table columns.<\/p>\n\n\n\n
By analyzing the data of this report, you will be able to check information such as sales amount, sales quantity, sales price, and total sales amount, making it easier to manage to supply products and improve customer loyalty by identifying top-selling products.<\/p>\n\n\n\n
Now let\u2019s see how you can get WooCommerce product category sales reports with and without a plugin.<\/p>\n\n\n\n
Get product category sales reports programmatically <\/h2>\n\n\n\n
One of the easiest methods to generate sales reports by product category is running an SQL query in phpMyAdmin. The phpMyAdmin makes it easy to have access to the WordPress database and run queries to generate WooCommerce sales reports. <\/p>\n\n\n\n
In the following, you can find a PHP code to get product category sales report programmatically in WooCommerce.<\/p>\n\n\n\n
SELECT IF ( (woocommerce_order_itemmeta.meta_key = '_fee_amount'), 1, 0) AS fee, DATE_FORMAT(it_posts.post_date,'%m\/%d\/%Y') AS order_date, it_woocommerce_order_items.order_id AS order_id, it_woocommerce_order_items.order_item_name AS product_name, it_woocommerce_order_items.order_item_id AS order_item_id, woocommerce_order_itemmeta.meta_value AS woocommerce_order_itemmeta_meta_value, (it_woocommerce_order_itemmeta2.meta_value\/it_woocommerce_order_itemmeta3.meta_value) AS sold_rate, IF ( (woocommerce_order_itemmeta.meta_key = '_fee_amount'), woocommerce_order_itemmeta.meta_value , (it_woocommerce_order_itemmeta4.meta_value\/it_woocommerce_order_itemmeta3.meta_value))AS product_rate, IF ( (woocommerce_order_itemmeta.meta_key = '_fee_amount'), woocommerce_order_itemmeta.meta_value , (it_woocommerce_order_itemmeta4.meta_value))AS item_amount, (it_woocommerce_order_itemmeta2.meta_value) AS item_net_amount, (it_woocommerce_order_itemmeta4.meta_value - it_woocommerce_order_itemmeta2.meta_value) AS item_discount, it_woocommerce_order_itemmeta2.meta_value AS total_price, count(it_woocommerce_order_items.order_item_id) AS product_quentity, woocommerce_order_itemmeta.meta_value AS product_id, woocommerce_order_itemmeta_var.meta_value AS variation_id ,it_woocommerce_order_itemmeta3.meta_value AS 'product_quantity' ,it_posts.post_status AS post_status ,it_posts.post_status AS order_status FROM gbQDaFZ_12_woocommerce_order_items as it_woocommerce_order_items LEFT JOIN gbQDaFZ_12_posts as it_posts ON it_posts.ID=it_woocommerce_order_items.order_id LEFT JOIN gbQDaFZ_12_woocommerce_order_itemmeta as woocommerce_order_itemmeta ON woocommerce_order_itemmeta.order_item_id = it_woocommerce_order_items.order_item_id LEFT JOIN gbQDaFZ_12_woocommerce_order_itemmeta as woocommerce_order_itemmeta_var ON woocommerce_order_itemmeta_var.order_item_id = it_woocommerce_order_items.order_item_id LEFT JOIN gbQDaFZ_12_woocommerce_order_itemmeta as it_woocommerce_order_itemmeta2 ON it_woocommerce_order_itemmeta2.order_item_id = it_woocommerce_order_items.order_item_id LEFT JOIN gbQDaFZ_12_woocommerce_order_itemmeta as it_woocommerce_order_itemmeta3 ON it_woocommerce_order_itemmeta3.order_item_id = it_woocommerce_order_items.order_item_id LEFT JOIN gbQDaFZ_12_woocommerce_order_itemmeta as it_woocommerce_order_itemmeta4 ON it_woocommerce_order_itemmeta4.order_item_id = it_woocommerce_order_items.order_item_id AND it_woocommerce_order_itemmeta4.meta_key='_line_subtotal' LEFT JOIN gbQDaFZ_12_term_relationships as it_term_relationships ON it_term_relationships.object_id = woocommerce_order_itemmeta.meta_value LEFT JOIN gbQDaFZ_12_term_taxonomy as term_taxonomy ON term_taxonomy.term_taxonomy_id = it_term_relationships.term_taxonomy_id Where ((woocommerce_order_itemmeta.meta_key = '_product_id' AND it_woocommerce_order_itemmeta3.meta_key='_qty') OR (woocommerce_order_itemmeta.meta_key = '_fee_amount')) AND woocommerce_order_itemmeta_var.meta_key = '_variation_id' AND it_woocommerce_order_itemmeta2.meta_key='_line_total' AND DATE(it_posts.post_date) BETWEEN STR_TO_DATE('2023-02-01', '%Y-%m-%d') and STR_TO_DATE('2024-02-14', '%Y-%m-%d') AND term_taxonomy.taxonomy LIKE('product_cat') AND term_taxonomy.term_id IN (33,25) AND it_posts.post_status IN ('wc-processing','wc-on-hold','wc-completed') AND it_posts.post_parent = '' GROUP BY it_woocommerce_order_items.order_item_id ORDER BY order_id DESC<\/code><\/pre>\n\n\n\nTo customize this code and instruct it to show the information you need related to specific categories, you can easily replace the Category IDs<\/strong> in the line illustrated below:<\/p>\n\n\n\n![\"PHP](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/php-code-product-category-sales-report.jpg\")
<\/a><\/figure>\n\n\n\nThen, after running the query, you will see a report listing the following information in different columns of the table:<\/p>\n\n\n\n
\n- Order Date<\/li>\n\n\n\n
- Order ID<\/li>\n\n\n\n
- Product Name<\/li>\n\n\n\n
- Order item ID<\/li>\n\n\n\n
- Sold Rate<\/li>\n\n\n\n
- Product Rate<\/li>\n\n\n\n
- Item Amount<\/li>\n\n\n\n
- Item Net Amount<\/li>\n\n\n\n
- Item Discount<\/li>\n\n\n\n
- Total Price<\/li>\n\n\n\n
- Product Quantity<\/li>\n<\/ul>\n\n\n\n
![\"result](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/result-php-code-product-category-sales-report.jpg\")
<\/a><\/figure>\n\n\n\nHow to run SQL code in PHPmyadmin?<\/h4>\n\n\n\n
You need to run this SQL query with phpMyAdmin by following the below instructions:<\/p>\n\n\n\n
\n- Log in to phpMyAdmin to access the database. <\/li>\n\n\n\n
- Click on the database name of your WordPress website in the left column.<\/li>\n\n\n\n
- Select the SQL<\/strong> tab on the top of the screen.<\/li>\n\n\n\n
- Look for the database name again above the text field, and confirm this is the correct database you intend to run a query on.<\/li>\n<\/ul>\n\n\n\n
![\"run](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/sql-code.png\")
<\/a><\/figure>\n\n\n\n\n- Write or paste the query in the text field.<\/li>\n\n\n\n
- Press the GO<\/strong> button.<\/li>\n\n\n\n
- Some queries will require a second confirmation to run.<\/li>\n<\/ul>\n\n\n\n
Caution<\/em><\/strong>: <\/strong>If running SQL queries, you may change or add data to your database. So, it makes sense to back up your WordPress database before running the code.<\/p>\n\n\n\nIf you have no experience in working with PHPMyAdmin, please ask an expert to do this task and run the SQL query or use the WooCommerce report plugin instead. This plugin helps you to generate any type of sales report without coding. <\/p>\n\n\n\n
<\/div>\n\n\n\nUse the WooCommerce report plugin to get sales report by product category <\/h2>\n\n\n\n
The WooCommerce report plugin<\/span><\/a> is a great tool for generating more than 50 WooCommerce sales reports quickly and easily. It has some default options for creating different sales report with one click and provides a lot of useful features for filtering, customizing and even exporting the generated reports.<\/p>\n\n\n\nWe prepared a step-by-step guide to show you how easy is to get a WooCommerce sale report by product category with this plugin.<\/p>\n\n\n\n
Step 1: Install WooCommerce report plugin<\/h3>\n\n\n\n
Like other WooCommerce plugins, you need to download and install the .Zip file of the WooCommerce report plugin on your WordPress website. <\/p>\n\n\n\n
You can find a comprehensive guide about installation and activation of the plugin, here<\/a><\/span>.<\/p>\n\n\n\n\n\n\nREPORTiT – Advanced WooCommerce Reporting<\/p>\n\n\n\n
The easy way to get WooCommerce product category sales report<\/p>\n\n\n\n
\nBuy Plugin<\/a><\/div>\n\n\n\nFree Version<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n\n![\"REPORTiT](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2025\/10\/reportit-banner.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\nAfter activation, the iT Woo Report<\/strong> menu will be added to your WordPress dashboard which leads you to the main page of the WooCommerce report plugin.<\/p>\n\n\n\n![\"select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/select-it-woo-report-section.png\")
<\/a><\/figure>\n\n\n\nStep 2: Get WooCommerce product category sales report<\/h3>\n\n\n\n
On the main page of the plugin, you have access to the preset reports in the left panel. To get the category sales report WooCommerce, you need to navigate to the below address: <\/p>\n\n\n\n
Orders > All orders<\/strong><\/p>\n\n\n\n![\"select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/select-all-orders-section.jpg\")
<\/a><\/figure>\n\n\n\nOn the \u201cAll Orders\u201d<\/strong> page, there is a Search<\/strong> icon designed to let you open the Filter Form<\/strong> and use it for filtering the report based on your needs.<\/p>\n\n\n\nTo get a purchase report by product category, first, you need to set a date range in the Date From<\/strong> and Date To<\/strong> fields.<\/p>\n\n\n\nThen, locate the Category<\/strong> field and select one or more categories from the list to receive the reports related to them:<\/p>\n\n\n\n![\"set](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/set-order-date-range.png\")
<\/a><\/figure>\n\n\n\nFor example, to generate WooCommerce product category sales report for Accessories<\/strong> in the last year, we set the fields in the Filter Form as below:<\/p>\n\n\n\n\n- Date From<\/strong>: 2023-02-01<\/li>\n\n\n\n
- Date To<\/strong>: 2024-02-01<\/li>\n\n\n\n
- Category<\/strong>: Accessories<\/li>\n<\/ul>\n\n\n\n
![\"select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/select-accessories-category.png\")
<\/a><\/figure>\n\n\n\nBy pressing the Search<\/strong> button, the plugin will create the report like the below:<\/p>\n\n\n\n![\"result](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/result-orders-report.png\")
<\/a><\/figure>\n\n\n\nIn the category sales report WooCommerce, you can find all the information you need in the separate columns of the table, including:<\/p>\n\n\n\n
\n- Order ID, Order Status, Order Date<\/li>\n\n\n\n
- Name, Last Name, Email, Customer, Phone No.<\/li>\n\n\n\n
- Sate, Country<\/li>\n\n\n\n
- Payment Method<\/li>\n\n\n\n
- Category, Products, Variation<\/li>\n\n\n\n
- Ordered Quantity<\/li>\n\n\n\n
- Product Amount, Product Discount, Net Amount, Shipping Amount<\/li>\n\n\n\n
- Invoice Action<\/li>\n\n\n\n
- SKU<\/li>\n\n\n\n
- Rate<\/li>\n\n\n\n
- Coupon Code<\/li>\n<\/ul>\n\n\n\n
You can also review a Summary<\/strong> report displaying the Total Order Count<\/strong>, Total Product Count<\/strong>, Total Quantity<\/strong>, Product Amount<\/strong>, Discount Amount,<\/strong> and Net Amount<\/strong> of the Category you have filtered in the Search<\/strong> form.<\/p>\n\n\n\n![\"result](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/result-summary-report.png\")
<\/a><\/figure>\n\n\n\nExtra features of sales report by product category<\/h3>\n\n\n\n
The wooCommerce report plugin comes with extra features enabling you to search, customize, or export the report very fast and smoothly.<\/p>\n\n\n\n
Continue reading to get familiar with these amazing features in the WooCommerce sale report by product category.<\/p>\n\n\n\n
Customize the table columns of the purchase report by product category<\/h4>\n\n\n\n
One of the advantages of the WooCommerce report plugin is the ability to customize the columns of the table report. After generating a category sales report WooCommerce, you can open the dropdown list of Select Columns<\/strong> designed above the table and mark the columns you need.<\/p>\n\n\n\n![\"Customize](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/customize-table-columns.png\")
<\/a><\/figure>\n\n\n\nFor example, we marked some columns as illustrated in the above picture and the result looks like below:<\/p>\n\n\n\n![\"result](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/result-customize-table-columns.png\")
<\/a><\/figure>\n\n\n\nExport sales report by product category<\/h4>\n\n\n\n
If you want to export WooCommerce sale report by product category, you can simply click on the Download<\/strong> icon on top of the table and choose one of the file formats including:<\/p>\n\n\n\n\n- Excel<\/li>\n\n\n\n
- CSV<\/li>\n\n\n\n
- PDF<\/li>\n<\/ul>\n\n\n\n
![\"Export](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/export-sales-report-.png\")
<\/a><\/figure>\n\n\n\nIt is also possible to have a hard copy of the report by selecting the Print<\/strong> option in the list.<\/p>\n\n\n\nSearch in the purchase report by product category<\/h4>\n\n\n\n
To help store managers review their preferred information in the WooCommerce product category sales report, we designed a Search<\/strong> box on the top of the table. You can search any value like User name<\/strong>, Email<\/strong>, Order ID<\/strong>, Country<\/strong>, etc. to see the related report in the table.<\/p>\n\n\n\nFor example, if you want to see which categories have been ordered by Horton<\/strong>, type Horton<\/strong> in the Search<\/strong> box:<\/p>\n\n\n\n![\"Search](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2024\/02\/search-purchase-report.png\")
<\/a><\/figure>\n\n\n\nSo, the Plugin will filter the report and show the related information in the table as illustrated above.<\/p>\n\n\n\n
\n\n\nREPORTiT – Advanced WooCommerce Reporting<\/p>\n\n\n\n
The easy way to get WooCommerce product category sales report<\/p>\n\n\n\n