Post by Glycosan » Wed Aug 11, 2010 12:21 am

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?

Newbie

Posts

Joined
Tue Aug 10, 2010 12:42 am

Post by kedgetech » Wed Aug 11, 2010 5:58 am

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

User avatar
Active Member

Posts

Joined
Mon Mar 22, 2010 5:20 pm
Location - USA, Australia, India

Post by Moggin » Wed Aug 11, 2010 6:45 am

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.

Active Member

Posts

Joined
Wed May 05, 2010 4:56 am

Post by kedgetech » Wed Aug 11, 2010 7:24 am

Good find Moggin. That looks about right.

User avatar
Active Member

Posts

Joined
Mon Mar 22, 2010 5:20 pm
Location - USA, Australia, India

Post by Glycosan » Wed Aug 11, 2010 11:15 pm

Thank you problem resolved.

Newbie

Posts

Joined
Tue Aug 10, 2010 12:42 am

Post by vojtech25 » Thu Aug 12, 2010 12:41 am

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

______________________________________________________
http://www.vojtechzahorsky.com


New member

Posts

Joined
Tue Jan 19, 2010 7:18 pm

Post by vojtech25 » Thu Aug 12, 2010 4:03 am

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

______________________________________________________
http://www.vojtechzahorsky.com


New member

Posts

Joined
Tue Jan 19, 2010 7:18 pm

Post by vojtech25 » Fri Aug 13, 2010 3:22 pm

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

______________________________________________________
http://www.vojtechzahorsky.com


New member

Posts

Joined
Tue Jan 19, 2010 7:18 pm

Post by Moggin » Sat Aug 14, 2010 7:01 am

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...

Active Member

Posts

Joined
Wed May 05, 2010 4:56 am

Post by mayhemer » Tue Mar 15, 2011 10:13 pm

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.

Newbie

Posts

Joined
Tue Mar 15, 2011 10:10 pm

Post by vojtech25 » Wed Mar 16, 2011 2:40 am

Great! Thank you very much, it helped pretty nice :)

______________________________________________________
http://www.vojtechzahorsky.com


New member

Posts

Joined
Tue Jan 19, 2010 7:18 pm
Who is online

Users browsing this forum: Google [Bot] and 155 guests