Title: Product count discrepancy
Last modified: December 16, 2019

---

# Product count discrepancy

 *  Resolved [danstaak](https://wordpress.org/support/users/danstaak/)
 * (@danstaak)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/product-count-discrepancy/)
 * There are discrepancies between the **Analyitcs > Orders** dashboard and the **
   Analytics > Products** dashboard.
 * It looks like the **Analyitcs > Orders** is correct, whereas the **Analytics 
   > Products** dashboard is getting some extra data from somewhere.
 * For example, my website had 2 orders on the 2nd December. Each order contained
   1 item (2 orders, 2 products).
 * The **Analyitcs > Orders** dashboard reports 2 orders, 2 products.
 * The **Analytics > Products** reports 3 products sold – with one of the orders
   being duplicated.
 * Please help to resolve, thanks!

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [Jeff Stieler](https://wordpress.org/support/users/jeffstieler/)
 * (@jeffstieler)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/product-count-discrepancy/#post-12244309)
 * Hello [@danstaak](https://wordpress.org/support/users/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!
 *  Thread Starter [danstaak](https://wordpress.org/support/users/danstaak/)
 * (@danstaak)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/product-count-discrepancy/#post-12245773)
 * 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](https://staakcodepen.s3.amazonaws.com/woo-debug/woo-orders.jpg)
 * Analytics > Orders – [https://staakcodepen.s3.amazonaws.com/woo-debug/analytics-orders.jpg](https://staakcodepen.s3.amazonaws.com/woo-debug/analytics-orders.jpg)
 * Analytics > Products – [https://staakcodepen.s3.amazonaws.com/woo-debug/analytics-products.jpg](https://staakcodepen.s3.amazonaws.com/woo-debug/analytics-products.jpg)
 * Database – [https://staakcodepen.s3.amazonaws.com/woo-debug/woo-database.jpg](https://staakcodepen.s3.amazonaws.com/woo-debug/woo-database.jpg)
 * Thanks!
 *  [Jeff Stieler](https://wordpress.org/support/users/jeffstieler/)
 * (@jeffstieler)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/product-count-discrepancy/#post-12248164)
 * Thank you for the screenshots [@danstaak](https://wordpress.org/support/users/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!
 *  Thread Starter [danstaak](https://wordpress.org/support/users/danstaak/)
 * (@danstaak)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/product-count-discrepancy/#post-12249829)
 * 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](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](https://staakcodepen.s3.amazonaws.com/woo-debug/analytics-specifc-product.jpg)
 *  [Mike W](https://wordpress.org/support/users/nixiack8/)
 * (@nixiack8)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/product-count-discrepancy/#post-12423838)
 * Hi [@danstaak](https://wordpress.org/support/users/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 🙂

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Product count discrepancy’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/woocommerce-admin_b298d1.svg)
 * [WooCommerce Admin](https://wordpress.org/plugins/woocommerce-admin/)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce-admin/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce-admin/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-admin/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce-admin/reviews/)

 * 5 replies
 * 3 participants
 * Last reply from: [Mike W](https://wordpress.org/support/users/nixiack8/)
 * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/product-count-discrepancy/#post-12423838)
 * Status: resolved