Product count discrepancy

Hello @danstaak,

Are you able to take screenshots of each report and post here? That would be extremely helpful in diagnosing any potential issues.

Thank you!

Hi, Links to screenshots below.

I also noticed that there is a duplicated item in the wp_wc_order_product_lookup table under one of the two orders (5719). I don’t know if it’s related or not, but order 5719 only had 1 product in. The other order (5670) also only contained 1 product and the wp_wc_order_product_lookup reflects this correctly. Screenshots of that data are also linked below.

WooCommerce > Orders – https://staakcodepen.s3.amazonaws.com/woo-debug/woo-orders.jpg

Analytics > Orders – https://staakcodepen.s3.amazonaws.com/woo-debug/analytics-orders.jpg

Analytics > Products – https://staakcodepen.s3.amazonaws.com/woo-debug/analytics-products.jpg

Database – https://staakcodepen.s3.amazonaws.com/woo-debug/woo-database.jpg

Thanks!

Thank you for the screenshots @danstaak.

Is the product sold in Order 5719 variable? Has its type been edited recently?

What shows when you click the “+1 more” in the Orders Report?

Thanks!

Yes, the product is a variable one and it does get updated fairly regularly to manage stock levels, etc.

I’ve added another screenshot to show what happens when clicking on the “+1 more”, but it basically shows the same product name twice – https://staakcodepen.s3.amazonaws.com/woo-debug/analytics-orders-hover.jpg

If I hover over the product name, the product ID for all 3 products shows the same (236). This is the URL – /wp-admin/admin.php?page=wc-admin&filter=single_product&products=236&period=custom&compare=previous_year&before=2019-12-03&after=2019-12-02&path=%2Fanalytics%2Fproducts

Screenshot of the page – https://staakcodepen.s3.amazonaws.com/woo-debug/analytics-specifc-product.jpg

Hi @danstaak,

We released a new update for WooCommerce Admin. Please update to it if you have not already, and see if this resolves the issue. If it does not, reply back to this thread and it will re-open ??