# Ecommerce data model with ES

**URL:** <https://discuss.elastic.co/t/ecommerce-data-model-with-es/201158>\
**Category:** Elasticsearch\
**Created:** [September 26, 2019, 6:58am UTC](https://discuss.elastic.co/t/ecommerce-data-model-with-es/201158 "2019-09-26T06:58:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![svbhayani](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@svbhayani](https://discuss.elastic.co/u/svbhayani)\
**Post date:** [September 26, 2019, 6:58am UTC](https://discuss.elastic.co/t/ecommerce-data-model-with-es/201158/1 "2019-09-26T06:58:59Z")

</div>

Hello ,

I want to create a schema design in ES to support below business model

- I have Hundreds of thousands of articles ~1000K
- Each article may have different prices/offers like Samsumg S10 can have different 50 or more prices - priceA - 500$ , priceB - 550$ and so on
- Each article can be attached to different categories (we have nearly 12K categories)

Question - I want to implement search for article and in response i need only those articles which has given valid price/offer and all the categories attached to it .  
Ex - if I search "cover" it should return me all the articles matched with this search term and all the categories attached for valid offer which is priceA (if price available).

Thanks in Advacne

---

<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:** [October 24, 2019, 7:04am UTC](https://discuss.elastic.co/t/ecommerce-data-model-with-es/201158/2 "2019-10-24T07:04:26Z")

</div>

Closed on October 24, 2019, 7:04am UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.