[Resolved] Filter Products base on Custom User Fields on Archive Product Page (WooCommerce)

[Author]

Posts

[bambiM]

I created a custom user field called Web Category ( checkbox ), and what I want is to show the products base on the product category and the "Web Category" user field.

Ex.
Current Logged-in User has selected the "Art" checkbox then the Views will filter the product list to only show the Art Product Category.

=== This was Resolved (https://toolset.com/forums/topic/filter-products-base-on-custom-user-fields/) but I would like to know if it is possible that we could do the same functionality on the Archive Page (Product)?

Thanks

[Minesh]

Hello. Thank you for contacting the Toolset support.

Well - can you please share access details so I can check and see if we can apply the same thing on archive page.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I would additionally need your permission to de- and re-activate Plugins and the Theme, and to change configurations on the site. This is also a reason the backup is really important. If you agree to this, please use the form fields I have enabled below to provide temporary access details (wp-admin and FTP).

I have set the next reply to private which means only you and I have access to it.

[Minesh]

Well - I do not see you setup product archive yet as I do not see any archive:
=> hidden link

Can you please setup your product archive first on your site - please check the following Doc that will help you to understand how you can create the post type archive:
=> https://toolset.com/documentation/user-guides/creating-wordpress-custom-post-archives/

[bambiM]

Hi Minesh,

Done adding the product archive views.

Thanks

[Minesh]

Well - I've added the following code to Toolset's custom code section:

function func_filter_archive_by_category($query) {
  global $current_user;
  if (!is_admin() and is_post_type_archive('product') ) {
    $cat_slugs = array();
    
   $cats = get_user_meta($current_user->ID,'wpcf-web-category');
  if(isset($cats[0])){
   		foreach((array)$cats[0] as $k=>$v):
      		$cat_slugs[] = $v[0]; 
   		endforeach;
  } 
    
  	$taxquery = array(
        array(
            'taxonomy' => 'product_cat',
            'field' => 'slug',
            'terms' => $cat_slugs,
            'operator'=> 'IN'
        )
    );

    $query->set( 'tax_query', $taxquery );
  }
}
add_action( 'pre_get_posts', 'func_filter_archive_by_category');

=> hidden link

I can see the archive is respecting the category terms you selected:
=> hidden link

More info:
=> https://toolset.com/documentation/adding-custom-code/using-toolset-to-add-custom-code/

Can you please confirm - it works at your end as well 🙂

[bambiM]

Hi Minesh,

Could you also do this on the Product Category Archive (Taxonomy)?.

Thanks

[Minesh]

Would you mind to create a new ticket and assign it to me and feel free to close this ticket.