Combining master item and item pricing from other sources

Hi All,

Im new to elasticsearch and currently wanna do implementation, but dunno how to integrate it, i have already 100.000++ inventory item description etc but i dont have the pricing yet, i need to pull the pricing from another sources API like multiple supplier etc.

My question how do i combine both sources and create new index etc?
Is it like when i have 10 items with id 1 - 10, than i get the pricing source 1-10 after that creating new index with item_price maybe that have ID and price or how to do it? Since usually im using RDBMS to do things like this join etc.

Thanks for your help :slight_smile: