Want to Update Array of Array Object Value in Mongo

[Ashesh Khatri]

{
"_id": ObjectId(),
"sku": "V4696-DR-V33",
"options": [
    {
        "sku": "8903689984338",
        "stores": [
            {
                "code": "AND1",
                "zipcode": "110070",
                "inventory": -1000
            },
            {
                "code": "AND2",
                "zipcode": "201010",
                "inventory": -1000
            },
            {
                "code": "AND3",
                "zipcode": "411001",
                "inventory": -1000
            },
            {
                "code": "AND4",
                "zipcode": " 700020",
                "inventory": -1000
            },
            {
                "code": "",
                "zipcode": "110015",
                "inventory": -1000
            }
        ],
        "price": 2199,
        "_id": ObjectId(),
        "size": "14"
    },
    {
        "sku": "1742564789",
        "stores": [
            {
                "code": "AND5",
                "zipcode": "110070",
                "inventory": -1000
            },
            {
                "code": "AND6",
                "zipcode": "201010",
                "inventory": -1000
            },
            {
                "code": "AND7",
                "zipcode": "411001",
                "inventory": -1000
            },
            {
                "code": "AND8",
                "zipcode": " 700020",
                "inventory": -1000
            },
            {
                "code": "",
                "zipcode": "110015",
                "inventory": -1000
            }
        ],
        "price": 2199,
        "_id": ObjectId(),
        "size": "14"
    },

]
}

    {
    "_id": ObjectId(),
    "sku": "V4696-DR-V33",
    "options": [
        {
            "sku": "8903689984338",
            "stores": [
                {
                    "code": "AND1",
                    "zipcode": "110070",
                    "inventory": -1000
                },
                {
                    "code": "AND2",
                    "zipcode": "201010",
                    "inventory": -1000
                },
                {
                    "code": "AND3",
                    "zipcode": "411001",
                    "inventory": -1000
                },
                {
                    "code": "AND4",
                    "zipcode": " 700020",
                    "inventory": -1000
                },
                {
                    "code": "",
                    "zipcode": "110015",
                    "inventory": -1000
                }
            ],
            "price": 2199,
            "_id": ObjectId(),
            "size": "14"
        },
        {
            "sku": "1742564789",
            "stores": [
                {
                    "code": "AND5",
                    "zipcode": "110070",
                    "inventory": -1000
                },
                {
                    "code": "AND6",
                    "zipcode": "201010",
                    "inventory": -1000
                },
                {
                    "code": "AND7",
                    "zipcode": "411001",
                    "inventory": -1000
                },
                {
                    "code": "AND8",
                    "zipcode": " 700020",
                    "inventory": -1000
                },
                {
                    "code": "",
                    "zipcode": "110015",
                    "inventory": -1000
                }
            ],
            "price": 2199,
            "_id": ObjectId(),
            "size": "14"
        },

    ]
    }

I want to update each inventory value. I want query in mongo query or any python script to update whole document with nested value. Can I use $unwind method for resolve this issue ??? I want Mongo query related to this issue? Kindly Reply this issue ?? I am very Stuck with This Issue

[Valeri Karpov]

It's really difficult to do this with an aggregation framework query or an update. If it were up to me I'd just batch-load documents and make the updates manually.