Database

db={clothes:[{"bagId":2224,"brandName":"Denim","size":"32","clothId":1244,"color":"green","price":20},{"bagId":2224,"brandName":"Zara","size":"31","clothId":1243,"color":"red","price":90}],bags:[{"sellerId":1234,"bagId":2224,"source":"fedex"}],sellers:[{"sellerId":1234,"firstName":"John","lastName":"doe","fullName":"John Doe","email":"john@yahoo.com","bagId":2224}]}

Query

db.clothes.aggregate([{$match:{clothId:{"$in":[1244,1243]}}},/** convertInto is arrays of sold clothId which I got from Shopify*/{$lookup:{from:"bags",localField:"bagId",foreignField:"bagId",as:"bags"}},{$lookup:{from:"sellers",localField:"bags.sellerId",foreignField:"sellerId",as:"sellers"},},{"$project":{_id:0,"clothId":1,"sellerId":{$first:"$sellers.sellerId"},"bagId":1,"bags":{$first:"$bags"},"sellers":{$first:"$sellers"},"brand":1}}])

Result