A sales report is a powerful tool that helps store managers make crucial decisions by analyzing data and evaluating their progress to reach their goals. Sales report in WooCommerce is also important for deciding the marketing strategies to encourage customers to buy more from your shop or determining which products should be supplied to satisfy customers.
In this article, we introduce three practical methods to get sales reports in WooCommerce with and without plugins.
How to check your sales report in WooCommerce without the plugin?
Generating the sales report for WooCommerce is one of the most popular reports used by store managers to analyze their store performance. However, there is a slight difference between getting sales reports in the new and old versions of WooCommerce. Let’s see how.
WooCommerce sales analysis in the WooCommerce reports
Sales analysis for WooCommerce in the WooCommerce reports is generated by going to the address below:
WordPress Dashboard > WooCommerce > Reports
By opening the reports tab, you can see four categories for receiving WooCommerce reports, including orders, customers, stock, and taxes. If you select Orders on top of the page, you can find below sales reports as subcategories:
Sales report by date
This report displays the total number of orders based on the specified date range.
You can choose one of the default date ranges, which are:
- Last month
- This month
- Last 7 days
Or specify a customized date range in the Custom date. For example, you can set one day to get WooCommerce’s daily sales report.
As you may notice, a guide panel on the screen’s left helps you match the colors in the chart with the data in this panel. For example, light blue is gross sales, while dark blue is the net sales.
Sales report by product
If you want to generate a WooCommerce daily report for products, you can click on this tab and choose one of the date ranges as we described in the previous report.
For example, if you choose the last 7 days, the sales report by product is like the below:
Some options on the left panel allow you to review WooCommerce sales analysis about Top sellers, Top freebies, Top earners, etc.
It is also possible to find the product you want to see its sales report in the Product Search field.
Sales report by category
In this tab, you can first choose some categories in the Select Category field of the left panel:
Then, by clicking on the Show button and choosing the date range, you can get sales reports of those categories in WooCommerce, as illustrated below:
Get sales report in WooCommerce Analytics
The store managers who are using the new version of WooCommerce have access to the sales reports by going to the address below:
WordPress Dashboard > WooCommerce > Analytics > Orders
By going to the Orders tab, you can find the below options for filtering the WooCommerce sales statistics:
Date range: You can set a custom date range in this field.
Show: There are two options in this tab:
- All orders: All orders placed in the specified date range are listed in the sales report.
- Advanced filters: You can limit the orders by adding as many filters as you need after choosing these options.
The filtering options are limited to the below items:
- Order Status
- Coupon codes
- Customer type
- Tax rates
When all desired filters are set, you can get the sales report for WooCommerce by clicking on the Filter button.
In this report, a list of orders is provided by date, and you can find some other information in the table, including:
- Order Status
- Customer Type
Generating WooCommerce sales reports in old and new versions has many limitations and is not useful for store managers needing specific and detailed information. For better WooCommerce sales analysis, you need a powerful tool like the WooCommerce report plugin with flexible options for filtering and generating sales reports.
How to use SQL query to get sales report for WooCommerce
It is also possible to run different SQL queries to receive WooCommerce sales statistics. Here we provide you a SQL query for generating a sales report of all products in your shop:
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 wp_woocommerce_order_items as it_woocommerce_order_items LEFT JOIN wp_posts as it_posts ON it_posts.ID=it_woocommerce_order_items.order_id LEFT JOIN wp_woocommerce_order_itemmeta as woocommerce_order_itemmeta ON woocommerce_order_itemmeta.order_item_id = it_woocommerce_order_items.order_item_id LEFT JOIN wp_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 wp_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 wp_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 wp_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' 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' GROUP BY it_woocommerce_order_items.order_item_id ORDER BY order_id DESC
If you run this query, a WooCommerce daily order report is generated, listing the data in the below columns:
- Order id
- Order date
- product name
- Product rate
- Order item
- Order status
- Order amount
- Net amount
As you may notice, running SQL queries is time-consuming, and you need special knowledge about writing codes and working with WordPress databases. If you are looking for a more convenient and flexible way to get sales reports in WooCommerce, we recommend you use the WooCommerce report plugin. Continue reading to find out how easy sales analysis is for WooCommerce with this plugin.
How to generate WooCommerce daily sales report by WooCommerce report plugin?
The WooCommerce report plugin has a user-friendly interface with many customization options for filtering and generating the sales report and providing required data for WooCommerce sales analysis in the specified date range.
To get sales report in WooCommerce by using this plugin, you need to follow the below steps:
- After installation of the WooCommerce report plugin, go to the WordPress dashboard and click on iT Woo Report to see the plugin dashboard.
- On the left panel, find the Order tab and click on the All Order option as shown below:
- In the new page just appeared, click on the Search icon to see the Search form.
- There are a lot of fields in the Search form that you can customize to filter the sales report based on your needs, including:
- Date From, Date To: By getting help from the built-in calendar in these fields, you can limit the report to a specified date range.
- Order Id: Limit the report to a specific order
- Customer: You can fetch reports just for specific customer(s)
- Category: In this case, the plugin display the orders that including products in specific category(s)
- Product: Limit the report to a specific product(s)
- Status: You can choose an order status to see the list of orders with that status in the sales report.
- Country: If you need to fetch all of report from specific country choose your country here
- State: If you need to fetch all of report from specific state choose your state here
- Variations: You can use the items in this field to check the sales report related to any product variations.
- Variation only: If you mark this item, the plugin only generates the sales report of variation products.
- Postcode: If you set postcode, the plugin display the orders with current postcode
- Email: You are able to fetch orders with specific billing email
- Order by: If you want to sort your report based on any data, you can choose one of the items in this list.
- Coupon code: If you want to fetch orders that including specific coupon code set this field
- Show order item details: By marking this item, you can see order item details in the sales report, like the ordered products, their qty, etc.
Coupon used only: If you mark this option, the list of orders that use coupons will be listed in the report.
After editing the filter options you need, the report will be generated by clicking on the Search icon.
In this report, you will find a list of orders in a table, along with other useful information in the below columns:
- Phone no
- Payment method
- Coupon code
- Shipping Amt.
- Invoice Actions
There is also a summary report at the bottom of the table, showing the below information to you:
- Product count
- Product Amount
- Product Discount
- Net Amount
There are also extra options available on the top of the table for customizing the report as below:
By using this box, you can search for a specific name to filter the sales report based on it.
This is an ideal option when you want to customize the columns in your report. By marking/un-marking the items in this list, you can set which columns to be displayed in the table.
Export WooCommerce daily sales report
Exporting sales reports is one of the most amazing features of the WooCommerce report plugin. This plugin allows you to export the sales report with just one click on the Download icon and choose one of the below formats:
It is also possible to print the report directly by choosing the Print option.
What is a sales report?
A sales report is a table or chart showing an online store’s daily, weekly, or monthly sales. WooCommerce sales analysis allows managers to make more informed decisions to achieve their goals. The wooCommerce order report plugin is usually used to get WooCommerce daily order reports, which allows the sales manager to collect more detailed data about their store performance. This report usually includes data about sales results, such as the amount of each order, the quantity of ordered products, the total number of orders, and customer data, such as their name, country, etc.
Why are sales reports important?
Sales reports are very important for online store managers because they help them evaluate their through reaching their goals. With WooCommerce sales analysis, managers can determine better ways to improve sales in the short or long term. They can also decide which marketing strategies will help them sell more products to their customers.
Why should you need to keep track of WooCommerce sales reports?
The WooCommerce sales report analyzes an e-commerce store sale over a specific period. The data analysis of this report helps businesses review their sales strategy and other efforts to grow.
Managers of online stores find it important to evaluate sales reports for the following reasons:
- Make better decisions by monitoring the performance of their online store.
- Quickly identify problems using sales data before they get out of hand.
- Identify potential customers worth greeting.
- Determining the type of consumers who order their products or services.
- Providing a more accurate insight into their sales performance.
With the help of WooCommerce sales reports, evaluating the strengths and weaknesses of your online store may become easier than ever. WooCommerce sales analysis helps to create a more effective plan to reach your final goals. We hope that the methods we have reviewed in this post on how to get WooCommerce sales reports have helped you gain a deeper insight into this topic.
If you want to receive an accurate and detailed sales report that provides you with a simple user interface without the need for coding, we recommend using the WooCommerce report plugin. In addition to providing sales reports, this plugin allows you to receive more than 50 reports with one click. In addition, it comes with wonderful features such as forecasting sales and comparing it with actual sales, as well as automatic e-mail of regular reports.