[Resolved] Split: Need help to display individual product from each subcategory in View Loop – get product ID from term custom fields

[Author]

Posts

[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.

[Minesh]

Hello. Thank you for contacting the Toolset support.

As I can see the product IDs are attach to the specific term and you are having it on excel sheet.

To attach the product IDs to term - you will require to create a term custom field (numeric type) and set this field to have multiple instances (repeating field) and you can then add your product IDs to as per the excel sheet to your term when you edit your term.

Can you please do that and get back to me.

[manishB-2]

Okay, I have added the custom field in terms with Repeated options. and also added all the IDs in each subcategory. But as you had mentioned in above comment to add numeric value, so that will not work for some IDs because some IDs are having Dash(-) characters so numeric field will give an error.

Please check the site now and help me to make it work.

[Minesh]

Ok - so you can change that field to text field instead of numeric field. Once you done, please let me know.

[manishB-2]

I have already done that. Added text field and also added all ids to all sub categories. You check in there.

[Minesh]

Great.

Can you please check now: hidden link

I've added the following filter to "Custom Code" section offered by Toolset:

function func_products_attach_to_term( $query_args ,$view_settings, $view_id ) {
    global $post;
     
    if ( $view_id == 6685 ) {
      
      // getting current term info attached to post
      $terms = wp_get_object_terms( $post->ID,'product_cat');
       $include_ids = array();
      
      // getting product IDs attached to term & search and get related post belongs to product ID
       foreach($terms as $k=>$v):
      		$product_ids =  get_term_meta($v->term_id,'wpcf-term_ids');
      			foreach($product_ids as $x=>$y):
      			
      			$args = array('post_type'   => 'product',
   					 		   's'          => $y,
    							'post_status' => 'publish',
                                 'orderby'        => 'rand'
							);
				$result = new WP_Query($args);
                
                // adding one product out of found products
                $include_ids[] = $result->posts[0]->ID;
      		endforeach;
       endforeach;
      
      if(empty($include_ids)){
        $include_ids = array(0);
      }
       // passing product IDs  
       $query_args['post__in'] = $include_ids;   
    }
    return $query_args;
}
add_filter( 'wpv_filter_query', 'func_products_attach_to_term', 10, 3);

Can you please confirm it works as expected and mark resolve both the tickets. 🙂

[Minesh]

Can you please confirm that the solution I shared help you to resolve your issue.

[manishB-2]

My issue is resolved now. Thank you!