[Resolved] Need help to display individual product from each subcategory in View Loop

[Author]

Posts

[manishB-2]

Hi Support team,
I need a help to make a View display target results.

I want to display individual products from each subcategory in a toolset view loop based on the current Product primary category. So Main idea is "I have two Primary Product Categories and each category has more than 5 Subcategories and all products attached to subcategories and not to primary categories. So we can also consider that somewhere indirectly these products are connected with the Primary category too. So In my Single Product page, I have added "similar products View" that displays 5 to 6 Products in the same primary category in which current product is displayed. But the condition is, I want to display similar products only one Product from each subcategory." For better understanding. Please check the video below and also a screenshot of a diagram, that will show you what I am talking about.

hidden link

[Minesh]

Hello. Thank you for contacting the Toolset support.

I review the video you shared and I understand that you want to display only one product belongs to your each sub-category.

if you can share problem URL and access details, Once I review your current setup, I will be able to guide you in the right direction.

*** 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 have set the next reply to private which means only you and I have access to it.

[Minesh]

Can you please check now: hidden link

i've created the following views:
=> hidden link
- This is the taxonomy view to query the taxonomy product_cat

=> hidden link
- This is the product view to display only one product belongs to specific child term

Within the "Similar Products" section of your elementor template:
=> hidden link
I've added the view "tax-view-single-product-similar".

I've added the following code to "Custom Code" section offered by Toolset:
=> hidden link

add_filter( 'wpv_filter_taxonomy_query', 'func_filter_by_parent_tax_term', 999, 4 );
function func_filter_by_parent_tax_term($tax_query_settings, $view_settings, $view_id) {
  global $post;
  
    if($view_id == 6683){
           
      $terms = wp_get_object_terms( $post->ID,'product_cat');
     
       foreach($terms as $k=>$v):
      		$parent = $v->parent;
      $child_terms = get_terms( 'product_cat', array( 'parent' => $parent, 'orderby' => 'slug', 'hide_empty' => true,'exclude'=>array($v->term_id),'fields'=>'ids' ) );   
      
      endforeach;

      $tax_query_settings['include'] =$child_terms;
      }
    return $tax_query_settings;
}

I can see its working as expected. Can you please confirm and let me know your feedback.

[manishB-2]

Hi, I am sorry to bother you again Minesh,
But there was a misunderstanding of mine. My boss actually had asked a different query rule and displaying the similar products.

And correct Process to display the similar products is that, each subcategory has a list of Products Custom ids which are saved in a custom field called "product-id" and What my boss wants is

I have displayed the Excel file that includes the product IDs connected with Each Category. So Basically we want to first add a query filter which will be the "Current Category of the page where view is displayed" and after that, I need to check all connected Product IDs with the current Category and once the system finds available Product IDs then it will pull only 1 Product from each product ID And display them as similar products, For example, there are 12 Product IDs for that category then 12 Products will be displayed as Similar Products. I have explained all these details in the video. So please watch it and please, please help me to make it work. Its really important feature.

hidden link

All Credentials for access are still the same. you can access the site.

New threads created by Minesh and linked to this one are listed below:

https://toolset.com/forums/topic/split-need-help-to-display-individual-product-from-each-subcategory-in-view-loop-get-product-id-from-term-custom-fields/

[Minesh]

That is totally new requirement. I'll split the ticket with your latest requirement as the solution I shared may help other users.

We will continue with your new requirement with the following ticket:
=> https://toolset.com/forums/topic/split-need-help-to-display-individual-product-from-each-subcategory-in-view-loop-get-product-id-from-term-custom-fields/

Feel free to close this ticket.

[Minesh]

Please feel free to mark resolve this ticket as well 🙂

[manishB-2]

My issue is resolved now. Thank you!