Hide specific products on woocommerce when ACF true/false is true in a product

Question

I have created a custom field true/false, and I want when true is selected in a product not to be displayed in the eshop. I want to insert the code inside the functions.php

example

if ( in_array( 'subscriber', (array) $user->roles ) || !is_user_logged_in()  ) {

$postid = get_the_ID();
$prd_only_for_Customers = get_field('prd_clients', $postid); // The ACF true/false field }

Can anyone help ?

Answer 1

As Howard said your question is incomplete but you can use the following method to set product hidden.

You can use pre_get_posts hook in your functions.php. Since Woocommerce 3 the products visibility is now handled by the 'product_visibility' custom taxonomy for the terms 'exclude-from-catalog' and 'exclude-from-search'… See this thread or this one too.

So you should use instead the WC_Product CRUD setter methods set_catalog_visibility() this way:

function get_post_ids_by_meta_key_and_value($key, $value) {
    global $wpdb;

    $meta = $wpdb->get_results("SELECT post_id FROM `".$wpdb->postmeta."` WHERE meta_key='".$wpdb->escape($key)."' AND meta_value='".$wpdb->escape($value)."'");

    $post_ids = [];
    foreach( $meta as $m ) {
        $post_ids[] = $m->post_id;
    }

    return $post_ids;
}


add_action('pre_get_posts', function( $query ){
    if ( $query->is_main_query() && is_woocommerce() && !is_user_logged_in() ) {
        $product_ids = get_post_ids_by_meta_key_and_value('prd_clients', 1);
        foreach($product_ids as $id){
            // Get an instance of the product
            $product = wc_get_product($id);
            // Change the product visibility
            $product->set_catalog_visibility('hidden');
            // Save and sync the product visibility
            $product->save();
        }
    }
});

This code isn't tested, let me know if it worked or you faced any problem.