Client histories wrong

Hi @ravanh,

Thanks for reaching out about this. That does sound unusual, especially if the customer purchase counts changed after the store migration.

WooCommerce calculates the “Customer history” data based on the orders linked to a customer account or billing email, so if something changed during the migration, such as user IDs, order associations, or duplicated data, it could affect the counts being shown.

To help narrow this down, could you let us know:

1. Was the site migrated to a new domain, server, or both?
2. Did you use a migration plugin or restore from a backup?
3. Have you already tried a conflict test by temporarily disabling all plugins except WooCommerce and switching to a default theme like Twenty Twenty-Four to see if the counts change?
4. Are the affected orders linked to registered customer accounts, guest orders, or both?

Also, please share your WooCommerce System Status Report so we can take a closer look: https://woocommerce.com/document/understanding-the-woocommerce-system-status-report/

You can paste it via https://pastebin.com or https://quickforget.com and share the link here.

Hi @ravanh,

Thanks for sharing those additional details and the System Status Report. The fact that only 922 out of 1430 orders are appearing in the Orders admin page is definitely a strong clue here, especially combined with the incorrect customer history calculations.

From what you described, it does sound possible that the manual order import during the migration may have caused inconsistencies between the WooCommerce order tables and the lookup tables WooCommerce uses for customer statistics and order history.

I also noticed from your report that HPOS is enabled on the site. Since HPOS stores orders in dedicated WooCommerce tables, partial imports or mismatched sync data can sometimes lead to symptoms like:

• Incorrect customer order counts
• Wrong average or total spent values
• Guest orders not being linked correctly
• Missing orders in the admin Orders list

To start narrowing this down further, could you please check the following:

1. Go to WooCommerce → Status → Tools
2. Run these tools one at a time:
   • Regenerate the product lookup tables
   • Recount terms
   • Clear analytics cache
3. Then check under: WooCommerce → Settings → Advanced → Features

Please temporarily disable HPOS compatibility mode if enabled, save changes, then re-enable it and allow WooCommerce to resync the order data.

4. Also, can you confirm:
   • Were the manually imported orders imported directly into the database, or through a plugin/tool?
   • Do the “missing” orders still exist in the wp_wc_orders table and wp_posts table, or only one of them?

Since the issue persists even in Health Check troubleshooting mode, this is looking less like a plugin conflict and more like a data synchronization or migration inconsistency.

Let us know what you find after the above checks and we’ll continue from there.