JSONAPI Word excerpt is not found

[rvhelp2]

Hello everyone,

I am having trouble with the search function in my Aimeos shop. When I search for the word “kralle” or “krallen”, no results are found even though I have a product called “Befestigungskrallen”. However, when I search for “Befestigungskrallen”, the product is found. Is there a way to configure the search to also consider similar words or partial matches? We also have products called ‘Profilbretter’. If I search for ‘Profil’ here, these will be found.”

[aimeos]

All indexes (DB fulltext, ElasticSearch, Solr, etc.) are prefix-based indexes which means they only find words which begins with the input string and therefore, you won't find any words where the input string is in the middle or the end. DB LIKE searches can't use any index and therefore, they are very slow the more texts must be searched through.

There are two options:
1.) Add words you want to find too as hidden product texts (e.g. "kralle")
2.) Use the "Standard" index text manager which only uses a LIKE search (slow!)

For the second option, the configuration in mshop.php would be:

Code: Select all

'index' => [
	'manager' => [
		'text' => [
			'name' => 'Standard' // slow to unusable depending on the amount of texts!!!
		]
	]
]