Limit Number of Products to Add to The Shop

Let’s say you want to limit the number of products that a client can add to his WooCommerce shop… You might want to do to that for various reasons… here is how to do it. Simply place that code in functions.php:

add_action( 'admin_head-post-new.php', 'woo_limit_products_creation' );

function woo_limit_products_creation() {

    global $post_type;
    global $wpdb;

    $products_limit = 50; // Change this value

	if( $post_type === 'product' ) {
		$products_count = $wpdb->get_var( "SELECT count(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'product'" );
		if( $products_count >= $products_limit ) {
			wp_die( sprintf( __("Error. You are not allowed to create more than %s products."), $products_limit) );
		}
	}
	return;
}