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"}},{$unwind:"$bags",},{$lookup:{from:"sellers",localField:"bags.sellerId",foreignField:"sellerId",as:"sellers"},},{$unwind:"$sellers"},{"$project":{_id:0,"clothId":1,"sellerId":"$sellers.sellerId","bagId":1,"bags.source":1,"sellers.firstName":1,"sellers.lastName":1,"brand":1}}])

Result