How to customize product search to search additional field in product database ?

Hi,

I am working on a search feature where in I have to search product based on custom attribute added in product table. I have checked the code and found that the product search works based on website search and frontend search grid. I tried to append the query condtion in product repository query builder but it does not work. Can anyone provide pointers ?

Thanks,

Jeetendra Gawas

Topic

[ypetrovParticipant]

Hello, Jeetendra Gawas
To add new column to index, you should tart from:
1) described new column at website_search.yml
2) data should be added to index on re-indexation, create listener to do it, example

More detail can be found at documentation

Hope this information will help you. If not please provide more information what part doesn’t works, applying filter, save data to index or..

[jeetendra_gawas1Participant]

Hi Ypetrov,

Thanks for your reply. I will try the steps mentioned above to make my search thing work. Actually what I am trying to do is, I have added a new field in product table named vendor which is a string and it will store the vendor name in db. When i search from front end on product listing i want to be able to search by this new field as well. Right now the default search works based on sku,porduct title, and description fields. I want to force the search to match new field.

Thanks,

Jeetendra Gawas

[ypetrovParticipant]

so you should include this field to ‘all_text’

PHP

$event->addField($product->getId(), 'vendor', $product->getVendor()->getTitle(), true);

1	$event->addField($product->getId(), 'vendor', $product->getVendor()->getTitle(), true);

just take a look at product listener

[Author]

Replies