Limit Product Search Suggestion to Product 'Selection' only?

Help for integrating the Laravel package
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
ocytacus
Posts: 9
Joined: 19 Sep 2016, 07:43

Re: Limit Product Search Suggestion to Product 'Selection' o

Post by ocytacus » 19 Sep 2016, 16:25

aimeos wrote:Yes, it is. I assume you haven't added any configuration to your config/shop.php file that includes an "index" part?
The only thing I tried to fix the problem is this:

Code: Select all

'mshop' => [
		'index' => [
			'manager' => [
				'attribute' => [
					'standard' => [
						'search' => [
							'mysql' =>
								'SELECT mpro."id"
								FROM "mshop_product" AS mpro
								:joins
								WHERE :cond
								GROUP BY mpro."id" /*-orderby*/, :order /*orderby-*/
								/*-orderby*/ ORDER BY :order /*orderby-*/
								LIMIT :size OFFSET :start'
						]
					]
				],
			],
		],
]
But it didn't help.

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Limit Product Search Suggestion to Product 'Selection' o

Post by aimeos » 20 Sep 2016, 13:25

It took us some time to figure out what the problem was.
If you save an article of a selection product in the expert mode admin interface, the product is added to the index regardless of being associated to a category. This is fixed in the dev-master branch of the Aimeos core now.

You should run "composer update" and delete all entries in the "mshop_index_text" table. Then, start the index rebuild with "./artisan aimeos:jobs index/rebuild". If you now save articles that should be part of a selection product and containing a text of type "name", than they shouldn't be indexed any more.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

ocytacus
Posts: 9
Joined: 19 Sep 2016, 07:43

Re: Limit Product Search Suggestion to Product 'Selection' o

Post by ocytacus » 20 Sep 2016, 15:16

Thanks for your help. The latest Aimeos-core dev update really solved the issue.

My search suggestion is working properly now :D

Post Reply