Multilanguage search

[istilah]

1.54 store and I am using 3 languages.
I noticed a lot of visitors tried to search a product in the wrong language, and use the foreign name/keyword for a product on the search page for another language.
Trying not to miss out sales, I would like the searchfunction to crawl all languages.

Right now I am using a quick and dirty way to achive this:

in /includes/modules/pages/advanced_search_results/header_php.php

$where_str = " WHERE (p.products_status = 1
AND p.products_id = pd.products_id
AND pd.language_id = :languagesID
AND p.products_id = p2c.products_id
AND p2c.categories_id = c.categories_id ";

I just removed the whole line with the language ID.

As I said quick and dirty, this has a drawback that it shows some products 3 times. If so, only the last product of the 3 shown can be put in the cart. The previous 2 can not be put in the cart, even Zencart says it does.

Anyone would have a idea how to change this code to search all languages, as it does now, but to clean up the results to show every product only once?

Any help appreciated.
Greetings,
Ronald

[bramf]

Did you find a solution for your multi language search issue. I experience the same and missing new orders because of it.
tips would be appreciated