/* Custom shortcode to display active auctions (without future and past ones), usage [number_of_active_auctions] Code should be copy pasted to your child theme functions.php file. */ add_shortcode('number_of_active_auctions', 'number_of_active_auctions_function'); function number_of_active_auctions_function( ) { global $woocommerce; $meta_query = $woocommerce->query->get_meta_query(); $args = array( 'post_type' => 'product', 'post_status' => 'publish', 'ignore_sticky_posts' => 1, 'meta_query' => array( 'relation' => 'AND', // don't include past auctions 'past_auctions' => array( 'meta_key' => '_auction_closed', 'meta_compare' => 'NOT EXISTS'), // don't include future auctions 'future_auctions' => array( 'meta_key' => '_auction_started', 'meta_compare' => 'EXISTS') ), 'tax_query' => array(array('taxonomy' => 'product_type' , 'field' => 'slug', 'terms' => 'auction')) ); $products = new WP_Query( $args ); echo "Number of active auctions: ".$products->found_posts; wp_reset_postdata(); }