Search for product code

ped · Post by **ped** » 11 Sep 2020, 09:28

Hello,

I am quiet new to aimeos and am working on my first shop project.

I use the TYPO3 Extension version 19.10.7 with php 7.2.29 and TYPO3 9.5.20.

Here is my problem:

In the frontend search I would like to be able to search for Product codes. This only works for some product codes which is very
strange and maybe someone can help me with that.

For example the search for "AB/028-100" finds the product with the code "AB/028-100"

But the search for "AB/010-028" returns no results even though there is a product with said code.

Some codes like "DH-HK" or "DH-HR" are never found.

Any ideas? Thank you!

Post by **aimeos** » 11 Sep 2020, 10:18

The MySQL full text search replaces characters which have a special meaning for full text search like "-", so the input is "DH HK" which isn't found any more. It would be possible to add a second condition for "product.code" here:
https://github.com/aimeos/ai-controller ... #L455-L468

Help for Aimeos