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