{"id":24779,"date":"2023-11-22T10:51:13","date_gmt":"2023-11-22T10:51:13","guid":{"rendered":"https:\/\/ithemelandco.com\/?p=24779"},"modified":"2026-03-09T11:11:19","modified_gmt":"2026-03-09T11:11:19","slug":"woocommerce-sales-by-country-report","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/blog\/woocommerce-sales-by-country-report\/","title":{"rendered":"How to Get WooCommerce Sales by Country Report (2 Easy Methods)"},"content":{"rendered":"\n

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<\/strong> helps store owners analyze their revenue across different countries and identify which markets generate the most orders.<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

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<\/strong> that shows how many orders were placed from each country and how much revenue was generated.<\/p>\n\n\n\n

There are multiple ways to generate this report. Some store managers prefer using WooCommerce MySQL queries<\/strong> 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<\/strong>. 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.<\/p>\n\n\n\n

What is sales by country report?<\/h2>\n\n\n\n

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. <\/p>\n\n\n\n

Use SQL code to get sales by country report in WooCommerce<\/h2>\n\n\n\n

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.<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

It is also important to get a backup from your site before running the query to use it in case of any problem.<\/p>\n\n\n\n

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:<\/p>\n\n\n\n

SELECT SUM(it_postmeta1.meta_value) AS 'total_amount' ,it_postmeta2.meta_value AS 'billing_country' ,Count(*) AS 'order_count' \n\nFROM 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 \n\nWHERE 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') \n\nGROUP BY it_postmeta2.meta_value Order By total_amount DESC<\/code><\/pre>\n\n\n\n
By running this query, you can receive a report with the most important columns required for sales by country report, including:<\/p>\n\n\n\n