WP SITES

You can add a custom column like this which includes products based on all statuses.

add_filter('manage_edit-product_cat_columns', 'custom_product_cat_columns');
function custom_product_cat_columns($columns) {
    $columns['custom_count'] = __('All', 'woocommerce');
    unset($columns['count']); // Remove default count column
    return $columns;
}

add_filter('manage_product_cat_custom_column', 'custom_product_cat_column_content', 10, 3);
function custom_product_cat_column_content($content, $column, $term_id) {
    if ($column === 'custom_count') {
        $statuses = ['publish', 'draft', 'pending'];
        $count = 0;

        foreach ($statuses as $status) {
            $query = new WP_Query([
                'post_type' => 'product',
                'post_status' => $status,
                'tax_query' => [
                    [
                        'taxonomy' => 'product_cat',
                        'field' => 'term_id',
                        'terms' => $term_id,
                    ]
                ],
                'fields' => 'ids',
                'posts_per_page' => -1,
            ]);

            $count += $query->found_posts;
        }

        // Link to filtered products by term ID
        $term = get_term($term_id, 'product_cat');
        $url = admin_url('edit.php?post_type=product&product_cat=' . $term->slug);
        $content = '<a href="' . esc_url($url) . '">' . intval($count) . '</a>';
    }
    return $content;
}

$category_ids = array(4, 7, 10); // Replace with your desired category IDs

    foreach ( $category_ids as $cat_id ) {
        $args = array(
            'post_type'      => 'post',
            'posts_per_page' => 1,
            'orderby'        => 'date',
            'order'          => 'DESC',
            'cat'            => $cat_id,
        );

        $query = new WP_Query( $args );

        if ( $query->have_posts() ) {
            while ( $query->have_posts() ) {
                $query->the_post();
                echo '<h3>Category: ' . get_cat_name( $cat_id ) . '</h3>';
                echo '<h2><a href="' . get_permalink() . '">' . get_the_title() . '</a></h2>';
            }
            wp_reset_postdata();
        }
    }

Try this in functions.php and see what it gets.

add_action('wp_footer', 'dump_full_pricing_for_current_product');
function dump_full_pricing_for_current_product() {
	if ( ! is_product() || ! current_user_can('administrator') ) return;

	global $product, $woocommerce;

	if ( $product && $product->is_type( 'variable' ) ) {
		$variations = $product->get_available_variations();

		echo '<pre>';
		foreach ( $variations as $variation_data ) {
			$variation = wc_get_product( $variation_data['variation_id'] );

			$price_excl_tax = wc_get_price_excluding_tax( $variation );
			$price_incl_tax = wc_get_price_including_tax( $variation );

			// Simulated shipping cost placeholder (actual shipping can't be calculated without full cart + address)
			$shipping_cost = 'Depends on shipping method & address';

			// Simulated fees placeholder (fees are usually added via custom plugins or in cart context)
			$fees = 'Depends on cart-level conditions';

			$data = [
				'variation_id'   => $variation->get_id(),
				'attributes'     => $variation->get_attributes(),
				'regular_price'  => $variation->get_regular_price(),
				'sale_price'     => $variation->get_sale_price(),
				'price'          => $variation->get_price(),
				'price_excl_tax' => wc_price( $price_excl_tax ),
				'price_incl_tax' => wc_price( $price_incl_tax ),
				'simulated_shipping' => $shipping_cost,
				'simulated_fees'     => $fees,
			];

			var_dump( $data );
		}
		echo '</pre>';
	}
}

Use a child theme https://ww.wp.xz.cn/plugins/create-block-theme/

There’s a cost of goods extension for this also https://woocommerce.com/document/cost-of-goods-sold/