Searching for a product from different sources

Elastic Stack Elasticsearch
1

We are working on a project which aggregates product information from
different sources. So title of the product can vary from merchant to
merchant.

For example let's say

Merchant A has a product called "Staedtler ergosoft 157 SB24 Coloured
Pencils Box 24"
Same product exists on Merchant B as "Staedtler 157 SB24 ergosoft
Pencils 24-Box"

As you can see there are some words missing and some of the words are
in different places.

I was wondering what is the best way to define the schema which will
return these two products when user searches for "Staedtler SB24 24
box"

Thanks

--

2

Optimus wrote:

We are working on a project which aggregates product information
from different sources. So title of the product can vary from
merchant to merchant.

For example let's say

Merchant A has a product called "Staedtler ergosoft 157 SB24 Coloured
Pencils Box 24"
Same product exists on Merchant B as "Staedtler 157 SB24 ergosoft
Pencils 24-Box"

As you can see there are some words missing and some of the words are
in different places.

I was wondering what is the best way to define the schema which will
return these two products when user searches for "Staedtler SB24 24
box"

You can actually accomplish this with the mapping ES defines for
you. See if the attached is helpful.

-Drew

--