Magento 2

By default when you enter sku reference in quick bar search of Magento 2 , It displays all the product whose sku is having prefix of entered sku , By example if you enter ‘BHSHIRT-F‘ for searching specific proudtc which have this reference as value , you will get more tahn one for example ‘ BHSHIRT-FX1 and BHSHIRT-FX2‘ .

Why ?

Now in Magento 2 we have in database catalogsearch_fulltext_scope1 and catalogsearch_fulltext_scope2 , is related to how many scope you have , let’s imagine you have 2 store one for English and other for Arabic , the system create 2 scope . And stock the map of search inside this tables , but how ? Yeah let’s go and see the structure of table ,this table have 3 columns entity_id and atrribute_id and data_index :

entity_id : id of entity or product that mapped with this infos

atrribute_id : id of attribute related to attribute set of product by default title and short description and description attribute used in map