Single Country View – Orders & Products

When you filter the report to a single country, two additional report tables are displayed below the main summary: the Orders table and the Best-Selling Products by Country table. These tables give you detailed insight into every order and every product sold in that country for the selected date range.

Drilling into a single country — 39 second walkthrough.

How to Activate the Single Country View

Go to Analytics → Sales by Country.
Use the Country filter to select exactly one country (e.g., India).
The Orders table and the Best-Selling Products by Country table will automatically appear below the main summary.

These two tables only appear when exactly one country is selected in the filter. When multiple countries are selected or no country filter is applied, only the main aggregated country table is shown.

The Orders table shows per-order detail, so it requires the manage_woocommerce capability — an Administrator or Shop manager. A user who can view reports but is not a shop manager sees the main table and the product breakdown, but not the Orders table.

Orders Table

The Orders table shows every individual order from the selected country within the chosen date range. Each row represents one order with the following columns:

Column	Description
Date	The date the order was placed.
Order #	The WooCommerce order number, displayed as a clickable link to the order detail page.
Status	The current order status, with a status indicator dot. Only statuses that count toward your reports appear here — see the note below.
Customer	The customer name associated with the order. A guest order shows the name entered at checkout.
Customer Type	Whether the customer is New (first order) or Returning. This is WooCommerce’s own store-wide classification — it counts the customer’s orders across your whole store, not just within the selected country or period.
Product(s)	The product(s) included in the order. If more than one product, a +N more indicator is shown.
Items Sold	Total number of individual items in the order.
Coupon(s)	Any coupon codes applied to the order, or “-” if none were used.
Net Sales	Revenue for the order after discounts, with tax and shipping taken out. The same definition as Net Sales in the main country table.
Attribution	The sales attribution channel for the order (e.g., Web admin, Direct). Populated by WooCommerce Order Attribution; orders placed before that feature was enabled show no channel.

Which orders appear. The table lists the same orders the main report counts — anything in a status you have excluded under Analytics → Settings → Excluded statuses is left out. On a default store that means pending, cancelled, failed, trashed and fully refunded orders do not appear. See How the Numbers Are Calculated.

Refunds. A partially refunded order still appears as one row, and its Net Sales is reduced by the refunded amount — which is why an order’s figure here can be lower than the amount originally charged. Refunds are never listed as rows of their own.

Best-Selling Products by Country Table

The Best-Selling Products by Country table shows a product-level breakdown for the selected country and date range. Each row represents one product with the following columns:

Column	Description
Product Name	The product name, displayed as a clickable link to the product in WooCommerce.
Country	The country the product was sold to (matches the selected country filter).
Qty Sold	Total quantity of this product sold across all orders in the date range.
Total Sales	Product revenue at list price — quantity × price, before discounts, and excluding tax and shipping.
Net Sales	Product revenue after discounts, excluding tax and shipping.
Orders	Number of distinct orders that included this product.
Avg Price	Average selling price — Total Sales divided by Qty Sold.

"Total Sales" means something different in this table than in the main country table. Here it is product revenue before discounts, with no tax and no shipping — it is a product figure, not an order figure. In the main country table, Total Sales is the whole order total, after discounts and including tax and shipping. The two will not add up to each other, and that is expected. Net Sales, by contrast, means the same thing in both.

Row limits

Both tables are capped so that a country with a very large order history does not stall the report.

Table	Rows returned
Orders	Up to 100 orders, most recent first.
Best-Selling Products by Country	Up to 500 products, in the sorted order you have selected.

If a country has more orders than the limit in your chosen range, narrow the date range to see the rest. The main country table’s totals are not affected by these limits — they always aggregate every matching order.

Both the Orders and Best-Selling Products tables can be downloaded as CSV independently using the Download button in the top-right of each table. The export contains the rows currently shown, so the same limits apply.

Troubleshooting

Problem	What to check
The two tables do not appear	Exactly one country must be selected. With two or more, or none, only the main table shows.
The Orders table is missing but the product table is there	The Orders table needs `manage_woocommerce`. Check the user’s role.
The order totals here do not add up to the main table	Expected. The Orders table’s Net Sales excludes tax and shipping, while the main table’s Total Sales includes them, and the product table’s Total Sales is a different measure again. See the warning above.
An order I know exists is not listed	It is probably in an excluded status, outside the date range, or beyond the 100-row limit. It may also be recorded under the other address type — try the billing/shipping toggle.
The Attribution column is empty	WooCommerce Order Attribution was not active when those orders were placed. It cannot be backfilled.
Customer Type looks wrong for this country	It is a store-wide classification. A customer whose first order with you was from another country counts as Returning here, even on their first order from this one.