How to Get WooCommerce Sales by Country Report (2 Easy Methods)

For online stores that sell products internationally, understanding where customers come from is essential for making better business decisions. A WooCommerce sales by country report helps store owners analyze their revenue across different countries and identify which markets generate the most orders.

By reviewing sales data by country, store managers can discover valuable insights such as which countries have the highest demand, where marketing campaigns perform better, and which regions may require improved shipping or pricing strategies. These insights are especially important for businesses planning to expand their international presence.

WooCommerce stores collect geographic information such as the customer’s billing country whenever an order is placed. This data can be used to generate a sales by country report that shows how many orders were placed from each country and how much revenue was generated.

There are multiple ways to generate this report. Some store managers prefer using WooCommerce MySQL queries to retrieve raw data directly from the database, while others use reporting plugins that provide ready-to-use dashboards and advanced filters.In this guide, we will show you two practical methods to generate a WooCommerce sales by country report. The first method uses a SQL query to retrieve the report directly from the WooCommerce database. The second method uses REPORTiT as a WooCommerce reporting plugin that allows you to generate advanced country-based reports quickly and easily.

What is sales by country report?

The sales by country report includes a list of all countries that customers ordered from there with useful information like number of orders, total orders, quantity of sold products, etc. This report allows the store owners to see the overall sales performance of their stores for each country. 

Use SQL code to get sales by country report in WooCommerce

Running SQL queries is one of the best methods for generating different types of reports in WooCommerce. To run a query, you need to use a database management system like PhpMyAdmin and log into your WordPress database by using the username and password set for it.

We recommend you use this method only if you are an expert in code writing and you have already worked with WordPress database management systems.

It is also important to get a backup from your site before running the query to use it in case of any problem.

By having the above-mentioned consideration in mind, you can insert the below query in the MYSQL tab to get sales by country report in WooCommerce:

SELECT SUM(it_postmeta1.meta_value) AS 'total_amount' ,it_postmeta2.meta_value AS 'billing_country' ,Count(*) AS 'order_count' 

FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID 

WHERE it_posts.post_type = 'shop_order' AND it_postmeta1.meta_key = '_order_total' AND it_postmeta2.meta_key = '_billing_country' it_posts.post_status IN ('wc-completed') 

GROUP BY it_postmeta2.meta_value Order By total_amount DESC

By running this query, you can receive a report with the most important columns required for sales by country report, including:

• Total amount: Total amount of orders spent in the country.
• Billing country: The billing country of orders.
• Order count: Number of orders placed in the country.

Although using SQL code is useful for store managers who need specific information about their sales, generating reports with a lot of details is really complicated. So, if you have a big ecommerce store and you need to analyze different types of sales by country report, your ultimate solution is using the WooCommerce report plugin.

Let’s see how this plugin can help you to generate customized reports quickly and easily.

Use the WooCommerce report plugin to get sales by country report in WooCommerce

WooCommerce report plugin is one of the best WooCommerce reporting tools you can generate more than 50 types of sales reports with one click or download them as CSV, XLS, or PDF files.

In the following, we review the various methods of getting sales by country reports in the WooCommerce report plugin:

Step 1: Install and activate the plugin

The first step for generating a country sales report in the WooCommerce report plugin is to download and install it on your WordPress website. By activating the plugin, you can see the IT Woo Report option in the WordPress dashboard. You need to click on it to see the main page of the plugin.

Step 2: Get WooCommerce sales by country report

On the main page of the WooCommerce report plugin, all available reports are listed in the left panel, and to make finding your required report easier, they are divided into some categories like orders, products, etc.

Now, let’s see which one can help you to get sales by country report.

Get WooCommerce order sales by country report 

The most common sales by country report is get report based on all orders placed in each country. By generating this report, store managers can compare the total sales of their online store in each country to get deep insight into their business performance.

To generate this report in our plugin, you need to:

• Go to Order > Order / Country report.
• Open the filter form by pressing the Search icon.
• Set a date range in the form.
• Press the Search button to get the sales by country report. 

As illustrated below, this report is a list of all countries that your online store received orders in, along with the below columns:

• Number of items sold: The total quantity of products ordered by customers in each country. 
• Net sale: Total amount of orders placed in each country. 
• Coupon: Total amount of discounts in each country. 
• Shipping: Total amount of shipping in each country. 
• Refunds: Total amount of refunded orders in each country.
• Final sale amount: The final sale amount is calculated automatically by the sum of Net sale and shipping and discount amounts.

There is also a summary report at the bottom of the table that gives you brief information about the total number of sold items, total net sale amount, total shipping, discount, and refund amounts, as well as the total final sale amount.

Get WooCommerce product sales by country report

One of the most information about online shops that store managers need to analyze is the popularity of products in each country. They need this information to supply the demands of their customers in the destination market.

To get product sales by country report in the WooCommerce report plugin, you can easily go to the Cross tab option and choose Product/Country report.

If you want to see all the information about this report, set a date range in the Filter Form and press the Search button to see a list of products in the table with their total sales amount in each country reported in separate columns of the table.

However, if you need a customized report, it is possible to filter the report based on the below options available in the filter form:

• Category: To observe the sales of specific categories in different countries 
• Status: To see the total product sales report in each country based on specific order status like processing or completed.
• Product: To track the sales of specific products of your online store in different countries. 
• Country: To analyze the total sales of products in a specific country.

Generate WooCommerce country per month sales report 

A monthly sales report per country is another useful report informing store managers about the total sales of each month in different countries. By analyzing this report, store owners can recognize which country had the most sales in each month.

To get monthly sales report by country in our plugin, go to the Cross Tab and choose Country/Month report.

Then, set a date range in the Filter Form and generate the report by pressing the Search button.

As shown below, you can see the list of all countries with their total sales in each month in separate columns of the table:

There are also two options in the filter form allowing you to customize the results displayed in the report as below:

• Country: To observe the monthly sales report of one specific country
• Status: To get the sales monthly report by country based on specific order status.

Extra Feature of WooCommerce report plugin

In addition to generating various types of sales reports, there are some helpful tools in the WooCommerce report plugin that allow store managers to customize the table, download reports or automate sending reports to their emails.

Here, we review some of these tools.

Select report columns

Select report column is a tool designed above the report table, helping you to customize the report columns table. 

By opening the list of Select Column fields, you are able to mark/unmark the columns you want to see in the report table. 

Export sales by country reports to CSV, Excel, or PDF

Downloading country sales reports is one of the most important requirements of store managers. In this plugin, there is a Download icon on the top of the report tables, allowing the user to export the report to different formats like Excel, CSV, and PDF.

It is also a Print Option for printing the report directly from the plugin.

Why do store managers need sales reports by country?

Online store managers use sales by country reports in WooCommerce to quickly have an insight into the sales performance of their business in all locations and geographic regions. When used as part of good business practices in financial planning and analysis (FP&A), the manager can improve the revenue, as well as identify any potential problem resulting in poor performance of the business. The comprehensive analysis of this report can also help managers take the required action on time and make smart decisions for developing their business effectively. 

Conclusion

Analyzing WooCommerce sales by country is an important step for store owners who want to understand their international market performance. By reviewing where orders come from and how much revenue each country generates, store managers can make better decisions about marketing strategies, product availability, shipping policies, and pricing.

Although it is possible to generate a sales by country report using WooCommerce MySQL queries, this method requires technical knowledge and direct access to the website database. It may also be difficult to customize or analyze complex reports using SQL alone.

For most WooCommerce store owners, using a dedicated reporting plugin like REPORTiT is a much simpler and more flexible solution. The REPORTiT plugin allows users to generate country-based sales reports instantly, apply filters, export reports to different formats, and analyze sales trends without writing any code.

With the right reporting tools, WooCommerce store managers can gain deeper insights into their global sales performance and make data-driven decisions to grow their online business.