Commit 6f1024fb69 for woocommerce

commit 6f1024fb697e3e10558fc588c2e02d42873fb31e
Author: Albert Juhé Lluveras <contact@albertjuhe.com>
Date:   Mon Feb 9 21:13:02 2026 +0100

    Analytics stock totals: include private products (#63197)

    * Analytics stock totals: include private products

    * Add changelog file

    * Update second check

diff --git a/plugins/woocommerce/changelog/fix-analytics-private b/plugins/woocommerce/changelog/fix-analytics-private
new file mode 100644
index 0000000000..1b445fe813
--- /dev/null
+++ b/plugins/woocommerce/changelog/fix-analytics-private
@@ -0,0 +1,5 @@
+Significance: patch
+Type: fix
+Comment: Analytics stock totals: include private products
+
+
diff --git a/plugins/woocommerce/src/Admin/API/Reports/Stock/Stats/DataStore.php b/plugins/woocommerce/src/Admin/API/Reports/Stock/Stats/DataStore.php
index 98ada71f9c..4cf29ab5f0 100644
--- a/plugins/woocommerce/src/Admin/API/Reports/Stock/Stats/DataStore.php
+++ b/plugins/woocommerce/src/Admin/API/Reports/Stock/Stats/DataStore.php
@@ -80,7 +80,7 @@ class DataStore extends ReportsDataStore implements DataStoreInterface {
 				LEFT JOIN {$wpdb->wc_product_meta_lookup} wc_product_meta_lookup ON posts.ID = wc_product_meta_lookup.product_id
 				LEFT JOIN {$wpdb->postmeta} low_stock_amount_meta ON posts.ID = low_stock_amount_meta.post_id AND low_stock_amount_meta.meta_key = '_low_stock_amount'
 				WHERE posts.post_type IN ( 'product', 'product_variation' )
-				AND posts.post_status = 'publish'
+				AND posts.post_status IN ( 'publish', 'private' )
 				AND wc_product_meta_lookup.stock_quantity IS NOT NULL
 				AND wc_product_meta_lookup.stock_status = 'instock'
 				AND (
@@ -120,7 +120,7 @@ class DataStore extends ReportsDataStore implements DataStoreInterface {
 				SELECT count( DISTINCT posts.ID ) FROM {$wpdb->posts} posts
 				LEFT JOIN {$wpdb->wc_product_meta_lookup} wc_product_meta_lookup ON posts.ID = wc_product_meta_lookup.product_id
 				WHERE posts.post_type IN ( 'product', 'product_variation' )
-				AND posts.post_status = 'publish'
+				AND posts.post_status IN ( 'publish', 'private' )
 				AND wc_product_meta_lookup.stock_status = %s
 				",
 				$status