Best Approach for Canonical Products in Solr

[Former Member]

Hello,

We have a requirement where we need to fetch some grouped products in the search results. We are using product variant relationship but OOTB, we display the first variant. Here we would like to display the aggregate of all the variants, like with price range etc.

To achieve this, we are thinking of indexing the aggregate attributes(like price range etc) as a new solr document and then retrieve it at query time. The problem here though is we cannot facilitate this aggregate product to have all the fields in it that is mandatory for every other variant to get pulled up by the default solr query. So we are looking to achieve this with a sub-query, to pull out the associated aggregate documents from the main query result and append them to the main query result.

We also thought about having a the aggregate attributes indexed against each variant, but that would significantly increase every document field count and that wont be accepted by the client.

Please let us know if there are any other way to do this, keeping performance in consideration

Thanks in advance!!