Related products by respective subcategory

Hi,

you need to modify related.php template file.
PATH: your-theme/woocommerce/single-product/related.php

Change $args to,

$args = apply_filters( 'woocommerce_related_products_args', array(
		'post_type' => 'product',
		'ignore_sticky_posts' => 1,
		'no_found_rows' => 1,
		'posts_per_page' => $posts_per_page,
		'orderby' => $orderby,
		'post__not_in' => array( $product->id ),
		'tax_query' => array(
			array(
				'taxonomy' => 'product_cat',
				'field' => 'id',
				'terms' => $cats_array
			),
		)
) );

where $cats_array is,

$cats_array = array(0);
// Get product categories
$terms = wp_get_post_terms( $product->id, 'product_cat' );

//Select only the category which doesn't have any children
if( sizeof( $terms ) ){
	foreach ( $terms as $term ) {
		$children = get_term_children( $term->term_id, 'product_cat' );
		if ( !sizeof( $children ) )
			$cats_array[] = $term->term_id;
	}
}

and remove/comment,

$related = $product->get_related( $posts_per_page );
if ( sizeof( $related ) == 0 ) return;

Hi Mohan,

I have same issue and you gave the snippet what I look for. It is very important for me, because my parent category has more than a few hundred products while sub-category has almost 10 products. So I have to use sub-category related products.

But, I applied your snippet but now it doesn’t show any related products.

By the way, I found the related.php at different path;
wp-content/plugins/woocommerce/templates/single-product/related.php

I use latest WC.
Could you advise me, please?

Best Regards

Hi,
When I remove ;
if( sizeof( $terms ) ){ line,
It works properly.
Regards

The original related.php is at:
wp-content/plugins/woocommerce/templates/single-product/related.php
and its best not to modify it because any edits will be overwritten by WooCommerce updates.

Instead, put the modified version at:
wp-content/themes/your-theme/woocommerce/single-product/related.php
as Mohan said because it should be safe from updates here. The file at this location should override the plugin version.

Thanks Iorro for your advise.

Hi Mohan

Many thanks for responding. I’ve located the file and found two of the elements you mention. But I can’t work out $cats_array. Am I missing something obvious? Sorry relatively new at this! Here’s all the code in the related file

<?php
/**
* Related Products
*
* @author WooThemes
* @package WooCommerce/Templates
* @version 1.6.4
*/

if ( ! defined( ‘ABSPATH’ ) ) {
exit; // Exit if accessed directly
}

global $product, $woocommerce_loop;

if ( empty( $product ) || ! $product->exists() ) {
return;
}

$related = $product->get_related( $posts_per_page );

if ( sizeof( $related ) == 0 ) return;

$args = apply_filters( ‘woocommerce_related_products_args’, array(
‘post_type’ => ‘product’,
‘ignore_sticky_posts’ => 1,
‘no_found_rows’ => 1,
‘posts_per_page’ => $posts_per_page,
‘orderby’ => $orderby,
‘post__in’ => $related,
‘post__not_in’ => array( $product->id )
) );

$products = new WP_Query( $args );

$woocommerce_loop[‘columns’] = $columns;

if ( $products->have_posts() ) : ?>

<div class=”related products”>

<h2><?php _e( ‘Related Products’, ‘woocommerce’ ); ?></h2>

<?php woocommerce_product_loop_start(); ?>

<?php while ( $products->have_posts() ) : $products->the_post(); ?>

<?php wc_get_template_part( ‘content’, ‘product’ ); ?>

<?php endwhile; // end of the loop. ?>

<?php woocommerce_product_loop_end(); ?>

</div>

<?php endif;

wp_reset_postdata();

It’s OK, managed to get this working. I put the $cats_array above where the commented out $related was. Works a treat. Thank you so much, you’ve saved hours of trying to figure this out Mohan!

(And thanks lorro for the tip on where to save the file)