[Skip to main content](#vessel-content)

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

##

- **[allbs](/forum/user/40031-allbs "View allbs's Profile")**
- [![allbs's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40031-allbs "View allbs's Profile") Topic Author
- [ Offline](/forum/user/40031-allbs)

Less More

- Posts: 59
- Thank you received: 2
-
-

9 years 7 months ago [\#265849](#265849) by [allbs](/forum/user/40031-allbs "View allbs's Profile")  *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#265849 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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")* was created by *[allbs](/forum/user/40031-allbs "View allbs's Profile")*

-- url of the page with the problem -- : [ www.nails21.com/en/search](http://www.nails21.com/en/search)
-- HikaShop version -- : 2.6.4

Hi,

In our site ([ www.nails21.com/en/search](http://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
[ ![ScreenShot2017-03-26at23.36.30.png](/forum/attachment/37249) ](/forum/attachment/37249 "...at23.36.30.png")

- [ ![ScreenShot2017-03-26at23.36.30.png](/forum/attachment/37249) ](/forum/attachment/37249 "...at23.36.30.png") [ ](/forum/attachment/37249?download=1 "...at23.36.30.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

9 years 7 months ago [\#265876](#265876) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#265876 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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,

Edit the "HikaShop Products search plugin in the Joomla plugins manager.
There, you'll find a setting to choose which column of the product data should be used for the search.
If you only want to search on the product name, then only have the product_name column in that setting and that will do it.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[allbs](/forum/user/40031-allbs "View allbs's Profile")**
- [![allbs's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40031-allbs "View allbs's Profile") Topic Author
- [ Offline](/forum/user/40031-allbs)

Less More

- Posts: 59
- Thank you received: 2
-
-

9 years 7 months ago [\#265929](#265929) by [allbs](/forum/user/40031-allbs "View allbs's Profile")  Replied by *[allbs](/forum/user/40031-allbs "View allbs's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#265929 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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-&gt;title=$row-&gt;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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

9 years 7 months ago [\#265943](#265943) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#265943 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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,

It's easy to check if it comes from your translations or not.
Disable the Falang system plugin via the Joomla plugins manager and try the search again.
If the product name appears correctly with Falang deactivated, then it means that the text you see comes from the translation of the product name that you have in Falang.

Looking at the code of the plugin, I might actually have an idea.
Try changing the code: Code:

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

to: Code:

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

and it might help prevent that.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[allbs](/forum/user/40031-allbs "View allbs's Profile")**
- [![allbs's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40031-allbs "View allbs's Profile") Topic Author
- [ Offline](/forum/user/40031-allbs)

Less More

- Posts: 59
- Thank you received: 2
-
-

9 years 7 months ago -  9 years 7 months ago [\#266035](#266035) by [allbs](/forum/user/40031-allbs "View allbs's Profile")  Replied by *[allbs](/forum/user/40031-allbs "View allbs's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#266035 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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,

once again, great help ![:)](/media/kunena/emoticons/3.png ":)") you pointed to the right direction.

The solution was to take the entire final else: Code:

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

Because we have more than just the product_name and product_description translated. In fact it was the product_alias field, that was showing in the translated Product Title (the last translated field).

Now it shows fine the name of the products ![:)](/media/kunena/emoticons/3.png ":)")

Thank you very much.

Regards,
AllBS

Last edit: 9 years 7 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile"). Reason: [code] is nice

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

9 years 7 months ago [\#266048](#266048) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#266048 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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,

Then try like that: Code:

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

we need to keep the line $row-&gt;product_name=$item-&gt;value; as we want to have the matching value replacing the product name on the listing when a match is found on something else than the product_name and that the product_name itself doesn't match.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[allbs](/forum/user/40031-allbs "View allbs's Profile")**
- [![allbs's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40031-allbs "View allbs's Profile") Topic Author
- [ Offline](/forum/user/40031-allbs)

Less More

- Posts: 59
- Thank you received: 2
-
-

9 years 7 months ago [\#266217](#266217) by [allbs](/forum/user/40031-allbs "View allbs's Profile")  Replied by *[allbs](/forum/user/40031-allbs "View allbs's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#266217 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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,

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 ![:)](/media/kunena/emoticons/3.png ":)")

Thanks,
Best Regards,
AllBS

The following user(s) said Thank You: [jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

9 years 7 months ago [\#266225](#266225) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#266225 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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,

Then we would need a FTP and backend access to be able to look at the problem because we're not able to reproduce the problem.
Could you provide that along with a link to this thread via our contact form ?
[ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")**
- [![jameswadsworth's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")
- [ Offline](/forum/user/556-jameswadsworth)

Less More

- Posts: 274
- Thank you received: 5
-
-
-
- [](http://www.deanimaconsulting.com)
-

8 years 10 months ago [\#285882](#285882) by [jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")  Replied by *[jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#285882 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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")*

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.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

8 years 10 months ago [\#285888](#285888) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#285888 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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,

That's because if you remove it, when you search for some text which is in a custom field but not in the product name, you won't see the searched text anywhere on the results listing. So your customers won't understand why the product matched.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[janos](/forum/user/33148-janos "View janos's Profile")**
- [![janos's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33148-janos "View janos's Profile")
- [ Offline](/forum/user/33148-janos)

Less More

- Posts: 38
- Thank you received: 0
-
-

8 years 5 months ago [\#293422](#293422) by [janos](/forum/user/33148-janos "View janos's Profile")  Replied by *[janos](/forum/user/33148-janos "View janos's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#293422 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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")*

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.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

8 years 5 months ago [\#293441](#293441) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#293441 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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,

That's not a general problem but actually a bug that no one reported so far.
Thank you for reporting it. I've added a patch for it.
Download again the install package on our website and install it on yours and you'll get the patch to handle that properly.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[janos](/forum/user/33148-janos "View janos's Profile")**
- [![janos's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33148-janos "View janos's Profile")
- [ Offline](/forum/user/33148-janos)

Less More

- Posts: 38
- Thank you received: 0
-
-

8 years 5 months ago [\#293474](#293474) by [janos](/forum/user/33148-janos "View janos's Profile")  Replied by *[janos](/forum/user/33148-janos "View janos's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#293474 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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")*

That's fine now, thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[janos](/forum/user/33148-janos "View janos's Profile")**
- [![janos's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33148-janos "View janos's Profile")
- [ Offline](/forum/user/33148-janos)

Less More

- Posts: 38
- Thank you received: 0
-
-

8 years 5 months ago -  8 years 5 months ago [\#293564](#293564) by [janos](/forum/user/33148-janos "View janos's Profile")  Replied by *[janos](/forum/user/33148-janos "View janos's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#293564 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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")*

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

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

Otherwise, not the product name but some translated other field e.g. product description will be loaded into the forst row as 'product name'.

Last edit: 8 years 5 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile"). Reason: [code] tag is nice !!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[janos](/forum/user/33148-janos "View janos's Profile")**
- [![janos's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33148-janos "View janos's Profile")
- [ Offline](/forum/user/33148-janos)

Less More

- Posts: 38
- Thank you received: 0
-
-

8 years 5 months ago [\#293640](#293640) by [janos](/forum/user/33148-janos "View janos's Profile")  Replied by *[janos](/forum/user/33148-janos "View janos's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#293640 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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")*

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](https://www.studio-general.hu/index.php/hu/component/hikashop/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](https://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.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

8 years 5 months ago [\#293669](#293669) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Search results, with custom fields data and alias, instead of product name](/forum/45-filters-search/889534-search-results-with-custom-fields-data-and-alias-instead-of-product-name#293669 "-- 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 &quot;debugged&quot; it, but the behaviour doesn't happen in localhost..  Does this seems familiar to you?  Try to search &quot;Advance&quot; 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,

Wouldn't that mean that you have different canonical URLs for different languages for the product ?
In that case, you need to check the canonical URLs that you set in the product.

Otherwise, that would mean that you've created a menu item for the English language to display the categories listing of HikaShop and restricted it to the English language and didn't create a similar menu item for Hungarian. In that case, without a menu item, the search plugin can't use the menu item's alias and instead falls back to "component/hikashop" in order to not generate an error when you click on the link.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4OTUzNC1zZWFyY2gtcmVzdWx0cy13aXRoLWN1c3RvbS1maWVsZHMtZGF0YS1hbmQtYWxpYXMtaW5zdGVhZC1vZi1wcm9kdWN0LW5hbWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.102 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
