WooCommerce Custom Reports: An Ultimate Guide
Many businesses utilize WooCommerce to build e-commerce platforms on their WordPress websites. One of the reasons for the growth is its adaptability, making it an excellent choice for large and small organizations. Creating WooCommerce custom reports to track critical data is an essential part of establishing a scalable website.
The WooCommerce reporting services require a strong comprehension of how to use by administrators. By data analysis, these reports offer essential insight into the store’s performance.
Therefore, we have put the article WooCommerce Custom Reports: An Ultimate Guide to help you guys figure it out. In this article, you will have an in-depth understanding of the WooCommerce reports, and we will share the necessary steps to generate reports for WooCommerce that you can apply when establishing your online store.
Types of WooCommerce Reports
Default and Custom reports are the two primary types of reports that WooCommerce may create.
Default Reports
Default WooCommerce reporting provides generic data based on the overall success of your e-commerce store. You may see them right away on WooCommerce’s admin site’s Reports tab.
You can browse four different sorts of default reports:
Orders: This report calculates your product’s gross and net sales volume. You may also examine which things are the most popular or profitable. This data can also be sorted and filtered according to certain dates, goods, or categories.
Customers: The Consumer report can provide you with critical data if you have customer accounts. This will display the number of new sign-ups for a specific time period. On your website, you may also make a comparison of the number of visitors to the number of repeat clients.
Stock: This report presents an overview of your store’s inventories, indicating which commodities are in and out of stock.
Taxes: The taxes report reveals how much revenue was earned from your store in terms of sales and state taxes. You could also look up the applicable state tax codes.
Customized Reports
Because the Webmaster chooses which metrics are included, WooCommerce custom reports have a huge amount of customized, in-depth details. This enables you to construct one-of-a-kind analysis conclusions depending on the precise facts you wish to categorize and measure.
Data analysis for the following items can be included in custom reports:
Shipping: Compare the amount you pay for shipping to the amount consumers pay for shipment.
Coupons: Examine the most popular coupons and the amounts saved and received as a result of these offers.
Category Report: The sales and performance parameters for each product category are separated in this report.
Country and State Report: You can create a report with information regarding performance for certain states or countries to which you deliver.
Tax and Refund Report: For accounting reasons, get example computations of crucial tax and refund details.
Daily, Monthly, and Yearly Summary: View detailed reports depending on pre-determined timelines.
Sold and Unsold Products: Show the difference between the total cost of sold and unsold products.
Top Rated Products: If your website has a rating element, you can take a look at a summary of the results in this report.
To create WooCommerce custom reports, you will need to use plugins to gather, store, and arrange the information you will need for your research.
How to Create a WooCommerce Custom Report
1. Creating a WooCommerce Custom Report by Using Code
We will need to add the WC Admin Report class from the start. The class-wc-admin-report.php file, which is displayed on the first line in the code following, can be used to accomplish this.
In WooCommerce Reports, we will also need to build a “Sales By Country” page underneath the “Orders” section. We will utilize the woocommerce_admin_reports filter to do this, as can be seen here.
<?php
include_once(WC()->plugin_path().'/includes/admin/reports/class-wc-admin-report.php');
add_filter( 'woocommerce_admin_reports', 'my_custom_woocommerce_admin_reports', 10, 1 );
function my_custom_woocommerce_admin_reports( $reports ) {
$sales_by_country = array(
'sales_by_country' => array(
'title' => 'Sales By Country',
'description' => '',
'hide_title' => true,
'callback' => 'sales_by_country_callback',
),
);
// This can be: orders, customers, stock, or taxes, based on where we want to insert our new reports page
$reports['orders']['reports'] = array_merge( $reports['orders']['reports'], $sales_by_country);
return $reports;
}
?>
$reports is an array that contains the tabs and their pages, as you can recognize in the source code. Essentially, we are placing our page into that array. You can modify the ‘orders’ section to any of the other available tabs, such as customers, stock, or taxes, or build your own.
Next, we are moving to our callback function where we create an instance of the WC_Report_Sales_By_Country
class which we are going to create a bit later and we are calling it is output_report()
method which displays the date filter and the table report in our case.
Next, we move to our callback function, where we make an example of the WC_Report_Sales_By_Country
class, which we will construct later, and call it is output_report()
method, which in our case displays the date filter and the table report.
<?php
function sales_by_country_callback() {
$report = new WC_Report_Sales_By_Country();
$report->output_report();
}
?>
Now let’s get down to business. We will lengthen the WC_Admin_Report
class and modify the following two methods: get_main_chart()
– query all finished orders for the provided date period, sort them by nation, and present the number of orders and earnings. output_report()
– alter the standard date range. The rest of the overridable methods, such as the export button, may be located here.
WooCommerce displays reports for the previous month by default, however, we want to modify that to the current month. When we do not have a tailored range selected, we can achieve this by altering the $current_range
to ‘month’. Last_month, year, 7day, and month are some of the other options.
We verify order data with $query_data in get_main_chart()
, where we supply the names of the field we need to include, its category (post_data, meta, order_item, order_item_meta), function (SUM, COUNT, or empty), and the name is how we will refer to that column.
We are querying _billing_country
, as you can see from the code.
<?php
class WC_Report_Sales_By_Country extends WC_Admin_Report {
/**
* Output the report.
*/
public function output_report() {
$ranges = array(
'year' => __( 'Year', 'woocommerce' ),
'last_month' => __( 'Last month', 'woocommerce' ),
'month' => __( 'This month', 'woocommerce' ),
);
$current_range = ! empty( $_GET['range'] ) ? sanitize_text_field( $_GET['range'] ) : 'month';
if ( ! in_array( $current_range, array( 'custom', 'year', 'last_month', '7day' ) ) ) {
$current_range = 'month';
}
$this->check_current_range_nonce( $current_range );
$this->calculate_current_range( $current_range );
$hide_sidebar = true;
include( WC()->plugin_path() . '/includes/admin/views/html-report-by-date.php' );
}
/**
* Get the main chart.
*/
public function get_main_chart() {
global $wpdb;
$query_data = array(
'ID' => array(
'type' => 'post_data',
'function' => 'COUNT',
'name' => 'total_orders',
'distinct' => true,
),
'_billing_country' => array(
'type' => 'meta',
'function' => '',
'name' => 'country'
),
'_order_total' => array(
'type' => 'meta',
'function' => 'SUM',
'name' => 'order_total'
),
);
$sales_by_country_orders = $this->get_order_report_data( array(
'data' => $query_data,
'query_type' => 'get_results',
'group_by' => 'country',
'filter_range' => true,
'order_types' => wc_get_order_types( 'sales-reports' ),
'order_status' => array( 'completed' ),
'parent_order_status' => false,
) );
?>
<table class="widefat">
<thead>
<tr>
<th><strong>Country</strong></th>
<th><strong>Number Of Orders</strong></th>
<th><strong>Sales</strong></th>
</tr>
</thead>
<tbody>
<?php foreach( $sales_by_country_orders as $order ) {
?>
<tr>
<td><?php echo WC()->countries->countries[$order->country]; ?></td>
<td><?php echo $order->total_orders; ?></td>
<td><?php echo wc_price($order->order_total); ?></td>
</tr>
<?php } ?>
</tbody>
</table>
<?php
}
}
?>
2. Creating a WooCommerce Custom Report by Using a Plugin
Establishing a Custom Report with Product Sales Report Pro
Step 1: Filtering of Order
The order term (choose from 10 pre-set ranges or make a new range), the status (choose from 7 alternatives), specific fields (pick from 8 equations and specify the value), and the user’s role are all available on the Order Filtering section.
Step 2: Filtering of Products
Select items, restrict by tags, constrain by fields, include or omit products depending on different statuses, including delivery, and include refunds using the Product Filtering section.
Step 3: Sorting and Gathering
Group by and sort by options are available on the Grouping and Sorting section. None, order, or order line item can be used to group items. Sorting options include ID, SKU, name, amount, and gross sales.
Step 4: Report Sections
The Report Fields option allows you to customize which fields appear on the report. It includes the default fields, which you can remove or add as needed. The names that appear on the report could also be changed. I’d like to see a drag-and-drop option so they can be simply reconfigured.
Step 5: Formatting and Exhibiting
You can restrict the number of items to exhibit on the Display and Format section, include the title, header, totals, and quantities, and set the format (from five options) and file name. Some of these areas are constantly changing.
Step 6: Advanced Settings
Set a time limit for how long the report can operate, deactivate object caching, allow bug mode, and contribute your own CSS to the Advanced tab.
4 WooCommerce Custom Reports Plugins
1. Product Sales Report for WooCommerce
Product Sales Report for WooCommerce is a fantastic and easy-to-use alternative. It has over 9,000 active installs and is suitable with WordPress 3.5 or above. Website owners can utilize the Product Sales Report to immediately summarize individual goods or categories depending on date ranges and sales status. These reports are available in XLSX, XLS, and HTML formats, making them simple to download, share, and transmit.
Outstanding features:
- Creating and distributing reports with a single click – see or export your reports with a single click
- Filtering by date range, either using the built-in presets or entering your own start and finish dates
- Sorting by order status - include or exclude transactions resting on their status
- Product-specific reporting - reports for the entire store, broken down by item or by a group of items
- Showing all versions for a product as a single line item by grouping them together
Price: The cost of this add-on ranges from $30 for a single site to $449 for unlimited subscriptions
2. Advanced Reporting for WooCommerce
Another plugin option is Advanced Reporting for WooCommerce, which provides custom sales reports with just a few simple clicks. This extension is compatible with WordPress 3.0 and up, and it has over 1,000 active installations. This is an all-in-one software that offers a variety of report alternatives. It also works with a Support Ticket System add-on to keep track of customer troubleshooting like refunds, swaps, and replacements. Users can read overviews and select specific reports by navigating via the plugin.
Outstanding features:
- The plugin is aligned with Phoeniixx’s Support Ticket System plugin
- The Total Summary, Orders Placed Today, and Total Earnings are displayed
- Displays the most popular products and categories
- The Top Customers list is presented
- The Top Billing Country and the Top States are shown
Price: The free version of this WooCommerce custom reporting plugin is accessible, however, the premium version costs $39 per site.
3. Advanced WooCommerce Reporting
Advanced WooCommerce Reporting is a flexible, user-friendly framework for creating nearly any type of custom report. It works with WordPress 4.0 and higher, and there are over 4,300 active installs. There is a standard license and an extended license available for a single website.
Outstanding features:
- Grasping all of the data easily rapidly via visual reports
- Possessing a search function for finding specific data points or things
- All reports are available in a variety of formats for download
- Automatic email summaries can be sent out for all reports
- Numerous Informative Summarize Reports on a Powerful Dashboard
Price: This plugin costs $39 and comes with a variety of add-ons for specialized features like cross tab reports and more product selections
4. Advanced WooCommerce Reports
Another wonderful low-cost choice is Make Web Better’sAdvanced WooCommerce Reports. This plugin is compatible with the most recent version of WordPress and allows for up to 25 sites to be licensed. This plugin also includes a mobile version that allows you to keep track of important data while on the go.
Outstanding features:
- Providing an overview of crucial data via the summary section
- Allow choosing the kind of info to include in the report for a tabular summary
- Make Your Own Reports
- Reports should be sent via email.
- Reports are shown graphically.
Price: The plugin costs as little as $18 for a single site or as much as $329 for 25 sites per year
Final words
Finally, we hope that our post WooCommerce Custom Reports: An Ultimate Guide has been helpful in improving your online business process. More than that, we would like to share our business tips as well as possible remedies, so you can see that running an internet business is not too difficult, and you may explore a wide choice of shop page extensions like WooCommerce to solve your website’s problem.
In addition, the only way to establish a strong e-commerce business is to have control over the data you need to make informed decisions. Without reliable data, it is practically difficult to ascertain efficient sales and business plans - yet default reports can not provide nearly enough. We sincerely hope that this article has aided your online business in some way. Furthermore, we hope that you will be able to choose the best path to follow in the post.