Write a MongoDB Aggregation Pipelines to find and group products by using compound weighted search index

Job ID: 36402528

Budget: $20 – $35 USD

I am looking for an expert in working with MongoDB Aggregation Pipelines to write a sophisticated search system for products.
My target data set for this project is products, and I will need to use a weighted compound search index to help quickly and efficiently search through the data.
you can use restore provided products.json into the MongoDB Compass and the work on aggregation pipeline in MongoDB Compass aggregation builder.
if we search YYY, this aggregation pipeline should return all related products based on weight assigned to each field.
if product does not have "productVariants" object, should return as separate object.
if product has "productVariants" object, this aggregator should return found product as main object and all other products with same "productVariants -> variantId" as "relatedProduct" object in main product.

PLEASE DON'T BID IF YOU ARE NOT EXPERT
Related categories: NoSQL Couch & Mongo Node.js MongoDB