How to View Sales Report by Country for Past Orders

The plugin adds two new columns to the WooCommerce Analytics database — one for the billing country code and one for the shipping country code. For new orders placed after the plugin is installed, these columns are automatically populated.

For existing orders placed before the plugin was installed, you must re-import the historical analytics data so that country information is backfilled for all past sales.

Re-Import WooCommerce Analytics Historical Data

Follow these steps to import historical data and enable country reporting for past orders:

• In your WordPress admin, navigate to Analytics → Settings.
• Find theImport Historical Datasection at the bottom of the Analytics Settings page.
• This ensures that all existing orders are re-processed, not just new ones. Without unchecking this, previously imported orders will be skipped and their country data will not be updated.
• Click the Import button and follow the on-screen progress until the import completes. Depending on the number of orders in your store, this may take several minutes.
• Make sure to uncheck the “Skip previously imported customers and orders” checkbox before clicking Import. If this remains checked, existing orders will not be updated with country data.

After the Import

Once the import is complete, navigate to Analytics → Sales by Country. The report will now include billing and shipping country data for all orders — both historical and new. You can use the country filter, date range, and billing/shipping toggle to analyse your full sales history by country.

For more information about importing historical data in WooCommerce Analytics, refer to the WooCommerce Analytics documentation →