Search results, with custom fields data and alias, instead of product name

-- url of the page with the problem -- : www.nails21.com/en/search
-- HikaShop version -- : 2.6.4

Hi,

In our site ( www.nails21.com/en/search ) if we search products, with English Language Selected (it only happens when english is selected), the search results appears with some products, with the title value of a custom field or from the alias field, instead of the name of the product.

We have a local version, and "debugged" it, but the behaviour doesn't happen in localhost..

Does this seems familiar to you?

Try to search "Advance" word when on English language, and the results will be something like the attachment.
When it should be only the Product Name that should appear and not 'soft-color-chrome' that's the alias but the 'Convert colors into chrome/mirror' name.

Thanks,
AllBS

Hi Nicolas,

thanks for the quick reply.

But i think i didn't explained the situation quite well.

So, our hikashop products search plugin is configured to search in these fields "product_name,product_description".

And after debug, the following query is executed:

SELECT DISTINCT a.product_id AS id, a.product_name, a.product_alias, a.product_canonical, a.product_created AS created ,
a.product_description, "1" AS browsernav, a.product_type, a.product_parent_id, b.category_id as category_id
FROM q5sod_hikashop_product AS a
INNER JOIN q5sod_hikashop_product_category AS b ON a.product_parent_id=b.product_id OR a.product_id=b.product_id
WHERE a.product_published=1 AND (a.product_access = 'all' OR a.product_access LIKE '%,9,%')
AND b.category_id IN (2,67,68,69,......)
AND ((((a.product_name LIKE '%advance%'))) OR (((a.product_description LIKE '%advance%'))) OR (((a.product_code LIKE '%advance%'))))
GROUP BY (a.product_id) ORDER BY a.product_modified DESC

Then on hikashop products plugin, this code is executed:
$row->title=$row->product_name;

But somehow, on the live site the "title" on the search page has that 'soft-color-chrome' when the product name is "SOFT MIRROR POWDER / COLOR CHROME".
We don't know where that "alias" comes from.. and it's not even the alias of that specific product that's "soft-mirror-powder-color-chrome".

It's a very strange issue.

We even thought it could be because of Falang, but after analysis it doesn't seem to be..

What could this be? Do you need access to our backoffice to check it out?

Thanks.

Best regards,
AllBS

Hi Nicolas,

once again, great help you pointed to the right direction.

The solution was to take the entire final else:

if($item->reference_field=='product_name'){
	$row->product_name=$item->value;
	break;
}elseif($item->reference_field=='product_description'){
	$row->product_description=$item->value;
	break;
} //else{
//	$row->product_name=$item->value;
//}
//break;

Hi Nicolas,

Tried that way, but still the problem persists..

I didn't had the time to analise this deeply, but the solution i found works for now apparently.

If you come up with the right solution, it would be greatly appreciated

Thanks,
Best Regards,
AllBS

We have been able to replicate the same issue when products have custom fields. It returns the alias instead of the title. We have modified the code per @allbs suggestion and it seems to work fine. I didn't understand why it is necessary to keep this last line in.

The other MAIN problem with using Falang along with Hikashop, that Falang search gives result scanning all translated fields - not only those listed in Hikashop Product Search plugin.

That's fine now, thanks.

However, we still have to opt out the last 'else', as it was suggested by 'allbs':

if($item->reference_field=='product_name'){
	$row->product_name=$item->value;
	break;
}elseif($item->reference_field=='product_description'){
	$row->product_description=$item->value;
	break;
}//else{
	//$row->product_name=$item->value;
//}

Furthermore;
When the result comes from Falang's translated field, the path is different.

www.studio-general.hu/index.php/hu/compo...op/sound-devices-688
while without translation /i.e. there is no translated field or original language is active/:
www.studio-general.hu/index.php/en/categories/sound-devices-688

It should be the same, because category-related modules should be loaded in both cases.