[{"_id":"65df172ab30ae9e46faf8c30","productItem":{"_id":"63db7504857b18c809dcc59a","name":"Shelf","group":"Furniture"},"amount":950,"date":"2024-02-28T00:00:00.000Z"},{"_id":"65df1737b30ae9e46faf8c39","productItem":{"_id":"63db7504857b18c809dcc59a","name":"Shelf","group":"Furniture"},"amount":500,"date":"2024-02-20T00:00:00.000Z"},{"_id":"65df1759b30ae9e46faf8c3e","productItem":{"_id":"63bbbad10cad70daae6b9ec8","name":"Chair","group":"Furniture"},"amount":10000,"date":"2024-01-27T00:00:00.000Z"},{"_id":"65df1777b30ae9e46faf8c43","productItem":{"_id":"63bbbb3b0cad70daae6b9edc","name":"Wooder chair","group":"Furniture"},"amount":1500,"date":"2024-02-27T00:00:00.000Z"},{"_id":"65df1785b30ae9e46faf8c48","productItem":{"_id":"63bbbb3b0cad70daae6b9edc","name":"Wooden chair","group":"Furniture"},"amount":3250,"date":"2024-04-17T00:00:00.000Z"}]

db.collection.aggregate([{"$group":{_id:{"productItem":"$productItem._id"},stock:{$push:"$$ROOT"}}},{"$project":{_id:"$_id.productItem",stock:"$stock",orders:[{"_id":"63c5035aaeb7f60e8e71fb8b","store":"63bbbb7b0cad70daae6b9ef6","pickingdate":"2023-01-30T10:52:44.000Z","deliverydate":"2023-01-31T10:52:44.000Z","products":[{"_id":"63c50394aeb7f60e8e71fb9d","productItem":"63bbbb3b0cad70daae6b9edc","amount":350},{"_id":"63c50394aeb7f60e8e71fb9e","productItem":"63bbbb3b0cad70daae6b9edc","amount":200},{"_id":"63d240169e5affab8243b630","productItem":"63bbbb3b0cad70daae6b9edc","amount":250}]},{"_id":"63e3993485a6f921498d62be","store":"63bbbb870cad70daae6b9efa","pickingdate":"2023-02-08T12:43:25.265Z","deliverydate":"2023-02-08T12:43:25.265Z","products":[{"_id":"63e3993485a6f921498d62bb","productItem":"63bbbb350cad70daae6b9ed8","amount":0},{"_id":"63e3993485a6f921498d62bc","productItem":"63bbbb000cad70daae6b9ed0","amount":0}]},{"_id":"63eb8606c11f03d7dd1ac6e8","store":"63bbbb660cad70daae6b9eee","pickingdate":"2023-02-11T13:00:31.000Z","deliverydate":"2023-02-11T13:00:31.000Z","products":[]},{"_id":"63d781d1afb570e9084adedd","store":"63bbbb7b0cad70daae6b9ef6","pickingdate":"2023-01-29T08:37:07.000Z","deliverydate":"2023-01-30T08:37:07.784Z","products":[{"_id":"63d781d1afb570e9084adeda","productItem":"63bbbb350cad70daae6b9ed8","amount":0},{"_id":"63d781d1afb570e9084adedb","productItem":"63bbbb3b0cad70daae6b9edc","amount":0}]},{"_id":"63da6e6a9b234012ba12f856","store":"63bbbb7b0cad70daae6b9ef6","pickingdate":"2023-02-01T13:51:20.077Z","deliverydate":"2023-02-01T13:51:20.077Z","products":[]},{"_id":"6408c4765c28184294cdbe8c","store":"6408786e5061404ca8aa706a","pickingdate":"2023-03-09T00:00:00.000Z","deliverydate":"2023-03-10T00:00:00.000Z","products":[{"_id":"6408c4765c28184294cdbe86","productItem":"63bbbb3b0cad70daae6b9edc","amount":65},{"_id":"6408c4765c28184294cdbe87","productItem":"6408782f5061404ca8aa6fca","amount":352},{"_id":"6408c4765c28184294cdbe88","productItem":"63db7504857b18c809dcc59a","amount":66}]},{"_id":"6408c4775c28184294cdbedf","store":"63bbbb870cad70daae6b9efa","pickingdate":"2023-03-12T00:00:00.000Z","deliverydate":"2023-03-12T00:00:00.000Z","products":[{"_id":"6408c4775c28184294cdbedb","productItem":"63bbbb350cad70daae6b9ed8","amount":7},{"_id":"6408c4775c28184294cdbedc","productItem":"63bbbb000cad70daae6b9ed0","amount":543},{"_id":"6408c4775c28184294cdbedd","productItem":"63bbbb3b0cad70daae6b9edc","amount":543}]},{"_id":"6408c4755c28184294cdbe14","store":"63bbbb610cad70daae6b9eea","pickingdate":"2023-03-07T00:00:00.000Z","deliverydate":"2023-03-11T00:00:00.000Z","products":[{"_id":"6408c4755c28184294cdbe0f","productItem":"63bbbb000cad70daae6b9ed0","amount":30},{"_id":"6408c4755c28184294cdbe10","productItem":"63db75ba857b18c809dcc611","amount":150},{"_id":"6465f005c8ce319aec89eaf2","productItem":"63bbbb3b0cad70daae6b9edc","amount":150}]},{"_id":"6475f3aef10517949a564b90","store":"641989dbd22513c63a2b3d9d","pickingdate":"2023-05-30T13:00:44.928Z","deliverydate":"2023-05-30T13:00:44.928Z","products":[]},{"_id":"646cac842791e02d418d5d4d","store":"646cac5d2791e02d418d5c6c","pickingdate":"2023-05-23T12:06:00.663Z","deliverydate":"2023-05-23T12:06:00.663Z","products":[{"_id":"646cac842791e02d418d5d40","productItem":"63bbbad10cad70daae6b9ec8","amount":100},{"_id":"646cac842791e02d418d5d41","productItem":"63bbbad10cad70daae6b9ec8","amount":100},{"_id":"646cac842791e02d418d5d42","productItem":"63bbbad10cad70daae6b9ec8","amount":100},{"_id":"646cac842791e02d418d5d43","productItem":"63bbbad10cad70daae6b9ec8","amount":100},{"_id":"646cac842791e02d418d5d44","productItem":"63bbbad10cad70daae6b9ec8","amount":100},{"_id":"646cac842791e02d418d5d45","productItem":"63bbbad10cad70daae6b9ec8","amount":100},{"_id":"646cac842791e02d418d5d46","productItem":"63bbbad10cad70daae6b9ec8","amount":100},{"_id":"646cac842791e02d418d5d47","productItem":"63bbbad10cad70daae6b9ec8","amount":100},{"_id":"646cac842791e02d418d5d48","productItem":"63bbbb3b0cad70daae6b9edc","amount":100},{"_id":"646cac842791e02d418d5d49","productItem":"63bbbad10cad70daae6b9ec8","amount":100},{"_id":"646cac842791e02d418d5d4a","productItem":"63bbbad10cad70daae6b9ec8","amount":100},{"_id":"646cac842791e02d418d5d4b","productItem":"63bbbad10cad70daae6b9ec8","amount":100}]},{"_id":"6465f1232576ace89acb5610","store":"63bbbb610cad70daae6b9eea","pickingdate":"2023-03-07T10:33:59.000Z","deliverydate":"2023-03-08T10:33:59.000Z","products":[{"_id":"6465f1232576ace89acb560e","productItem":"64198afed22513c63a2b4370","amount":55},{"_id":"6465f1342576ace89acb5681","productItem":"63db75a6857b18c809dcc60c","amount":150}]},{"_id":"6475f6736c29eba3e1a9a96f","store":"641989e2d22513c63a2b3e83","pickingdate":"2023-05-30T13:11:28.448Z","deliverydate":"2023-05-30T13:11:28.448Z","products":[{"_id":"6475f6736c29eba3e1a9a96d","productItem":"64198afed22513c63a2b437f","amount":0}]}],total:{$reduce:{"input":"$stock","initialValue":0,"in":{"$add":["$$value","$$this.amount"]}}}}},{"$project":{_id:"$_id",stock:"$stock",totalInStock:"$total",soldTotal:{$reduce:{input:"$orders",initialValue:0,in:{$add:["$$value",{$reduce:{input:"$$this.products",initialValue:0,in:{$add:["$$value",{$cond:[{$eq:["$$this.productItem","$_id"]},"$$this.amount",0]}]}}}]}}}}}])