OpenCart Community

Currently when you search for a product number no results are returned unless youclick the "search by product number"; Is there a way that i can make it so that when a regular search is run the product number is also searched?

There is no enhanced module (ready made) I recall. You should start looking at search logic and add the other column into search functionlity.

Glycosan wrote:Currently when you search for a product number no results are returned unless youclick the "search by product number"; Is there a way that i can make it so that when a regular search is run the product number is also searched?

If you mean product model, Glycosan, this can be done fairly easily - see this post/thread:
http://forum.opencart.com/viewtopic.php?t=14380#p72054

...I put my product refs in the 'model' field, and it works well for me.

Good find Moggin. That looks about right.

Thank you problem resolved.

Thanks for advice, it helped.

I would like to ask for another thing ( i have asked before, but no one answer). I am using czech language, and this searching does not work for diacritics. If the name of product is for example "pásová pila", it will not find it.

I try to change the name for example to "pasova pila" and everything was ok, searching was succes. So the problem is in DIACRITICS. Any ideas???

Thank you so much

I found, that the name and description of product is saved using entities - for example "okružní pila" is saved like "okružní pila" and so on.. I have to probably change the encoding during the saving to database..

But I have no clue where to change this, does someone no..?? Thank you

Does anyone know, in what file it is saving to the database??? Maybe it is the solution to change the way of saving.. Thank u

Cheers kedgetech, Glycosan - glad to help

vojtech25, unfortunately I know almost nothing about MySQL and character sets. I just found this page by chance, on Opencart member webaccent's site (ran it through the google translator)
http://web-accent.com/ru/stati/kodirovk ... poisk.html - Character set in MySQL, or why can't I search) If you can understand it, maybe it will help you? It sounds like character set may be the problem.

If any Czech users are reading this, please lend vojtech25 a hand...

vojtech25, in catalog\model\catalog\product.php you have to replace all occurences of strtolower(*) call to mb_strtolower(*, 'UTF-8').

This has nothing to do with sql or web page encoding setting.

Great! Thank you very much, it helped pretty nice