# Searching for a product from different sources

**URL:** <https://discuss.elastic.co/t/searching-for-a-product-from-different-sources/9603>\
**Category:** Elasticsearch\
**Created:** [November 7, 2012, 4:41pm UTC](https://discuss.elastic.co/t/searching-for-a-product-from-different-sources/9603 "2012-11-07T16:41:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Optimus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/optimus/32/2649_2.png) [@Optimus](https://discuss.elastic.co/u/Optimus)\
**Post date:** [November 7, 2012, 4:41pm UTC](https://discuss.elastic.co/t/searching-for-a-product-from-different-sources/9603/1 "2012-11-07T16:41:39Z")

</div>

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

--

---

<div class="post-metadata">

**Author:** ![drewr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/drewr/32/7803_2.png) [@drewr](https://discuss.elastic.co/u/drewr)\
**Post date:** [November 7, 2012, 7:18pm UTC](https://discuss.elastic.co/t/searching-for-a-product-from-different-sources/9603/2 "2012-11-07T19:18:00Z")

</div>

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

--

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 3:05am UTC](https://discuss.elastic.co/t/searching-for-a-product-from-different-sources/9603/3 "2017-07-06T03:05:37Z")

</div>

Closed on July 6, 2017, 3:05am UTC