Related products on product page

-- HikaShop version -- : 4.6.0
-- Joomla version -- : 4.1.5
-- PHP version -- : 7.4

Hi there!

I wanna ask for some trick to solve my needs:
I successfully set up to show some random items on my product's page, but I'm unable to set it up to get these not randomly but maybe much more related to the actual item "automatically" - as there are thousands of items in the shop imported, setting up manually every item's related products is not an option.

I thought on based on the product's page product name maybe stripping long product names to separate words, and run on these a LIKE SQL query, but any idea/alternatives is appreciated.

Thanks in advance,
PePe

nicolas wrote: Hi,

I don't see a way to do that with just the options available by default.
What you could do is develop a small plugin implementing the onBeforeProductListingLoad event to add conditions to the MySQL query loading the products when on the product details page:
www.hikashop.com/support/documentation/6...reProductListingLoad
So if you have PHP knowledge, you can do that.
This plugin would be a good basis as it uses the same event:
www.hikashop.com/marketplace/product/222...-product-plugin.html

<?php
class plgHikashopRelatedproductsbyname extends JPlugin
{
	function plgHikashopRelatedproductsbyname(&$subject, $config){
		parent::__construct($subject, $config);
	}

	function onBeforeProductListingLoad(&$filters){
		// STOP IF IT'S NOT THE PRODUCT VIEW
		if ((hikaInput::get()->getCmd('ctrl')) != 'product'){return;}
		
		// FOR LOADING THE CURRENT PRODUCT'S NAME
		$class = hikashop_get('class.product');
		$product_id = (int)hikashop_getCID('product_id');
		$product = $class->get($product_id);
		
		// SPLITTING CURRENT PRODUCT'S NAME INTO AN ARRAY WHICH IS MORE THAN 5 CHAR LONG TO BE MORE "RELATED"
		$words = array_filter(preg_split("/[\s,]+/", $product->product_name), function($val){
			return strlen($val) >5 ; 
		});

		// IF THERE'S NO DATA IN WORDS, STOP FILTERING
		if(!empty($words)) {

		// ADDING THE FILTER
		$filters[]='(b.product_name LIKE "%'.implode('%") OR (b.product_name LIKE "%', $words).'%")';
		}
		
	}
}