How to filter products without images

Correct Answer

You may need to display only products with images in a smart search result web part. To achieve this goal you need to follow these steps:

In the Site Manager –> Development –> System tables -> select Edit for table Ecommerce – SKU and go to the Search fields tab. Among these fields find SKUImagePath and check boxes Tokenized and Searchable. Do not forget to click on the OK button to confirm this change

As always, if some field definition is changed, you need to rebuild the index. Go to the Site Manager – Administration – Smart search and Rebuild the index. You need to make sure that Analyzer for this index is set to Simple.

Now you just need to configure the Search condition property in your smart search result web part. Its value should be: +SKUImagePath:getmetafile