Back to Community
Home / Community / Plugin → Woocommerce

Troubleshooting Common WooCommerce Order and Report Display Issues

27 threads Sep 7, 2025 Plugin → Woocommerce

Content

Many WooCommerce store owners encounter problems where orders or sales data don't appear correctly in the admin dashboard or analytics reports. This can be a frustrating experience, especially when it impacts your ability to manage inventory, fulfill purchases, or analyze business performance. Based on common community reports, this guide outlines the most frequent causes and their solutions.

Why Do These Display Issues Happen?

Orders and reports can fail to display properly for several reasons. The most common culprits are cached data, database synchronization problems (especially related to the new High-Performance Order Storage (HPOS)), incomplete site migrations, or conflicts with other plugins or themes.

Common Solutions for Missing or Incorrect Orders and Reports

1. Clear Your Analytics Cache

If your reports show outdated information, like including deleted orders or missing recent sales, the analytics cache is often to blame. WooCommerce caches this data for performance. To refresh it:

  1. Navigate to WooCommerce > Status > Tools.
  2. Find and click the "Clear analytics cache" button.
  3. After clearing, check if your reports now show accurate data.

2. Rebuild Your Analytics Data

If clearing the cache doesn't work, a more thorough rebuild may be necessary. This re-imports all historical order data into the analytics tables.

  1. Go to WooCommerce > Status > Tools.
  2. Click the "Regenerate shop stats data" or similar tool. This process may take a while for stores with many orders.

3. Troubleshoot High-Performance Order Storage (HPOS) Sync

The transition to HPOS is a major source of sync issues. If your order sync is stuck or failing, try these steps:

  • Check for Error Logs: Go to WooCommerce > Status > Logs and look for error messages related to order sync. Errors often point to specific data corruption in old orders (e.g., invalid dates for `cancelled` orders) that is halting the process.
  • Disable Conflicting Plugins: Temporarily deactivate all plugins except WooCommerce. If the sync completes, reactivate them one-by-one to identify the conflict. Pay special attention to other plugins that manage orders, invoices, or exports.
  • Review System Status: Ensure your site meets all requirements for HPOS. You can find this report at WooCommerce > Status.

4. Verify Your Migration Was Complete

After moving a site, missing orders often result from an incomplete database migration. Ensure that all WooCommerce tables (especially custom order tables if using HPOS and the traditional `wp_posts` and `wp_postmeta` tables) were successfully copied to the new server. A single missing table can cause orders to be invisible.

5. Check for Plugin and Theme Conflicts

A conflict is likely if the problem only affects one admin user or specific order statuses (like "draft").

  1. Switch your theme to a default WordPress theme like Twenty Twenty-Four.
  2. Deactivate all plugins except WooCommerce.
  3. If the issue is resolved, reactivate your plugins one by one to identify the source of the conflict.

6. Investigate Browser and User-Specific Issues

If some users can see data while others cannot, the problem might be local.

  • Clear your browser's cache and cookies.
  • Try accessing the orders page using an incognito or private browser window.
  • Confirm that your user role has the correct permissions to view orders.
  • Check the Screen Options tab in the top right corner of the Orders screen to ensure all columns (like "Items") are set to be visible.

When to Seek Further Help

If these steps do not resolve your issue, the problem may be highly specific. Before seeking help from your theme or plugin developers, gather the following information from your site:

  • System Status Report: Found under WooCommerce > Status. This provides a detailed overview of your environment.
  • Error Logs: Check under WooCommerce > Status > Logs for any relevant `fatal-errors` or other log files.
  • Screenshots: Capture what you see, especially any error messages.

Providing this information will help others diagnose complex issues more effectively.

Related Support Threads Support