![\"select](\"https:\/\/ithemelandco.com\/blog\/wp-content\/uploads\/2023\/10\/select-products-menu.png\")
<\/a><\/figure>\n\n\n\nThen, you can find some filtering options on the report page to generate WooCommerce reports by product based on your needs. Let’s review them:<\/p>\n\n\n\n
Filtering options of WooCommerce product sales report<\/h3>\n\n\n\n
There are two options available for filtering WooCommerce product reports on this page:<\/p>\n\n\n\n
Filter by date<\/strong>: This field allows you to choose one of the preset dates to generate the report or specify any date range you want in the Custom<\/strong> tab. There is also an option for comparing the reports of two periods with each other.<\/p>\n\n\n\n Show<\/strong>: In this field, you can set if you want to receive WooCommerce reports by all products or just a single product.<\/p>\n\n\n\n By default, you can get the sales report of all products that were sold in the specified date range.<\/p>\n\n\n\n However, if you choose the single product option, you can search the name of the product in the search box to see its sales performance:<\/p>\n\n\n\n There is also a comparison mode allowing you to choose more than one product to observe and compare their data in the report:<\/p>\n\n\n\n You need to search for multiple products and add their names to the Search<\/strong> box to generate the report:<\/p>\n\n\n\n As you may have noticed, the WooCommerce product report has two views. The first one is a chart, and the second one is a table with different columns.<\/p>\n\n\n\n In the table report, you can find the below information in the columns:<\/p>\n\n\n\n Running SQL queries in database management software like PhpMyAdmin is another method for generating WooCommerce product reports. Here you can find a sample SQL code for getting WooCommerce report by product:<\/p>\n\n\n\n After running this code, you will receive a table containing the below columns:<\/p>\n\n\n\n If you do not have sufficient knowledge about writing SQL codes, we recommend you let an expert do this task for you. It is also important to back up your site database before running any SQL codes in order to prevent encountering problems in your WordPress website.<\/p>\n\n\n\n Although the reports generated in WooCommerce analytics and by SQL can provide useful information for store managers, there are some limitations in filtering and customizing the reports. So, to get more practical reports with various data you may need for analyzing the performance of your online store, using a WooCommerce product sales report plugin is needed. <\/p>\n\n\n\n Continue reading to get familiar with one of the most powerful plugins for generating comprehensive and useful product sales reports.<\/p>\n\n\n\n The WooCommerce report plugin<\/a><\/span> is one of the valuable WooCommerce plugins that you can use to get deep insights into the sales of your products and the performance of your online store. This plugin provides you with WooCommerce product reports that you can download with just one click or email to anyone you want regularly.<\/p>\n\n\n\n It is possible to receive product sales reports in this plugin based on various parameters. To prepare these reports, after installation and activation in your website<\/span><\/a>, you must go to the address below:<\/p>\n\n\n\n WordPress Dashboard > iT Woo report<\/strong><\/p>\n\n\n\n REPORTiT – Advanced WooCommerce Reporting<\/p>\n\n\n\n The easy way to get product sales report in WooCommerce<\/p>\n\n\n\n Then, refer to the Products<\/strong> menu and click on any of the options in this tab, such as Purchase Product, Product by User report, Purchased Product by Customer report, etc.<\/p>\n\n\n\n In this post, we review three important reports related to the sale of products, which are:<\/p>\n\n\n\n Let\u2019s see which information you can get by generating these reports.<\/p>\n\n\n\n In this report, you can find a list of all products sold on the specified date. To get this report, you need to:<\/p>\n\n\n\n In this report, you can find the below information in separate columns:<\/p>\n\n\n\n The WooCommerce sales report plugin will also generate a total amount report at the bottom of the page, informing you about the total product count, total sales qty, and total amount.<\/p>\n\n\n\n If you want to review WooCommerce sales reports for one specific product, you can easily open the Search<\/strong> form and choose your product from the list of Products<\/strong> field.<\/p>\n\n\n\n For example, in the following example, we decided to analyze the WooCommerce sales reports of Caps product in the last 2 years:<\/p>\n\n\n\n So, the plugin reported the Cap<\/strong> sales data in the specified date range including the Sales Quantity, and Sales Amount.<\/p>\n\n\n\n The product sales count for WooCommerce and the Total Amount of Orders were also reported in the summary report.<\/p>\n\n\n\n The purchased variation report is a list of product variations with their sales amount, allowing you to have an insight into the sales performance of variable products. <\/p>\n\n\n\n The steps for generating the report are the same as the previous one. However, the options available in the search form include:<\/p>\n\n\n\n After clicking on the Search<\/strong> button, you can see the purchased variations report as illustrated below:<\/p>\n\n\n\n The columns in the table report are much the same as the purchased product report that we have described before.<\/p>\n\n\n\n The only difference is the information in the total report at the bottom of the page, which is reported as the total variations count, total sales Quantity, and total amount.<\/p>\n\n\n\n There are two methods for receiving product sales report for WooCommerce variation in our plugin:<\/p>\n\n\n\n If you want to analyze the data related to one specific variation, you can easily search it in the Quick Search <\/strong>box.<\/p>\n\n\n\n For example, in the below WooCommerce sales report, we searched for blue variation. So, all data related to the products with Blue<\/strong> variation have been filtered and reported:<\/p>\n\n\n\n The plugin will automatically report the Variation Count<\/strong>, Sales Qty,<\/strong> and Total Amount of Sales<\/strong> related to all blue products in the summary report.<\/p>\n\n\n\n If you want to receive a WooCommerce sales report related to one specific variation, you can follow the below instructions:<\/p>\n\n\n\n Now, you can review WooCommerce sales related to that specific variation in the table.<\/p>\n\n\n\n The summary sales report WooCommerce including Variation count<\/strong>, Total Sales Quantity,<\/strong> and Total sales amount<\/strong> is also available at the bottom of the table.<\/p>\n\n\n\n If you want to analyze information about all products in your online shop, choose this report in the WooCommerce report plugin. To get this report, use the Search<\/strong> form to set the date range and filter the report by Category<\/strong> and Tag<\/strong> if needed.<\/p>\n\n\n\n Then, by pressing the Search <\/strong>button, you can find the below report includes the useful information in separate columns including:<\/p>\n\n\n\n WooCommerce product reports by month are one of the most essential reports that store managers analyze to recognize the sales performance of their online store. <\/p>\n\n\n\n To generate this report, you need to go to the CrossTab<\/strong> and choose the Product\/Month<\/strong> option.<\/p>\n\n\n\n Just same in the previous report, you need to set a date range in the Search<\/strong> form to generate the report.<\/p>\n\n\n\n It is also possible to filter the report by category, order status, and product.<\/p>\n\n\n\n In this report, you will see the list of products with their sales amount in each month.<\/p>\n\n\n\n There is also some other useful information in the report, like:<\/p>\n\n\n\n Despite generating sales reports in the WooCommerce report plugin, some extra features are designed to help store managers easily customize or export the data in their reports, such as:<\/p>\n\n\n\n On the top of the table on the report page, you can find a Select Columns<\/strong> field. This field allows you to mark\/unmark the columns in the report to customize it. <\/p>\n\n\n\n There is a Download<\/strong> icon available for each report, enabling you to export WooCommerce product sales report as one of the below formats:<\/p>\n\n\n\n It is also possible to print the report directly by choosing the Print<\/strong> option.<\/p>\n\n\n\n REPORTiT – Advanced WooCommerce Reporting<\/p>\n\n\n\n The easy way to get product sales report in WooCommerce<\/p>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n\n
SQL code for WooCommerce sales report by product<\/h2>\n\n\n\n
<\/a><\/figure>\n\n\n\nSELECT ANY_VALUE(shop_order.ID) as order_id, ANY_VALUE(it_woocommerce_order_items.order_item_name) AS 'product_name' ,ANY_VALUE(it_woocommerce_order_items.order_item_id) AS order_item_id ,it_woocommerce_order_itemmeta7.meta_value AS product_id ,ANY_VALUE(DATE(shop_order.post_date)) AS post_date ,SUM(woocommerce_order_itemmeta.meta_value) AS 'quantity' ,SUM(it_woocommerce_order_itemmeta6.meta_value) AS 'total_amount' FROM wp_woocommerce_order_items as it_woocommerce_order_items\nLEFT JOIN wp_woocommerce_order_itemmeta as woocommerce_order_itemmeta ON woocommerce_order_itemmeta.order_item_id=it_woocommerce_order_items.order_item_id\nLEFT JOIN wp_woocommerce_order_itemmeta as it_woocommerce_order_itemmeta6 ON it_woocommerce_order_itemmeta6.order_item_id=it_woocommerce_order_items.order_item_id\nLEFT JOIN wp_woocommerce_order_itemmeta as it_woocommerce_order_itemmeta7 ON it_woocommerce_order_itemmeta7.order_item_id=it_woocommerce_order_items.order_item_id\nLEFT JOIN wp_woocommerce_order_itemmeta as it_woocommerce_order_itemmeta11 ON it_woocommerce_order_itemmeta11.order_item_id=it_woocommerce_order_items.order_item_id \nLEFT JOIN wp_posts as shop_order ON shop_order.id=it_woocommerce_order_items.order_id WHERE 1*1 AND woocommerce_order_itemmeta.meta_key = '_qty' AND it_woocommerce_order_itemmeta6.meta_key = '_line_total' AND it_woocommerce_order_itemmeta7.meta_key = '_product_id' AND it_woocommerce_order_itemmeta11.meta_key = '_variation_id' AND it_woocommerce_order_itemmeta11.meta_value = '0' AND (shop_order.post_type = 'shop_order' OR shop_order.post_type = 'shop_order_refund') \nGROUP BY it_woocommerce_order_itemmeta7.meta_value ORDER BY total_amount DESC;<\/code><\/pre>\n\n\n\n<\/a><\/figure>\n\n\n\n\n
Get product sales report from the WooCommerce report plugin <\/h2>\n\n\n\n
<\/figure>\n<\/div>\n<\/div>\n\n\n\n\n
<\/a><\/figure>\n\n\n\nPurchased product sales report for WooCommerce<\/h3>\n\n\n\n
\n
\n
<\/a><\/figure>\n\n\n\n\n
<\/a><\/figure>\n\n\n\nExample 1: How to find product sales data<\/strong><\/h4>\n\n\n\n
<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\nPurchased product variations sale report<\/h3>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n\n
<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\nExample 2: How to get sales by product report for a specific variation<\/strong><\/h4>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\nAll products report<\/h3>\n\n\n\n
<\/a><\/figure>\n\n\n\n\n
<\/a><\/figure>\n\n\n\nMonthly product sales report<\/h3>\n\n\n\n
<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n\n\n\n\n
<\/a><\/figure>\n\n\n\nExtra options of WooCommerce sales report plugin<\/h3>\n\n\n\n
Select columns to customize sales report WooCommerce<\/strong><\/strong> <\/h4>\n\n\n\n
<\/a><\/figure>\n\n\n\nExport WooCommerce sales reports<\/strong><\/strong> <\/h4>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n