This question has been flagged

How can I update stock quantities with scheduled actions, I want to set stock to zero automatically after 1 week. Have tried with change quantity and I still can get get it to work.

or Is there any best method to archive it.

Avatar
Discard
Best Answer

Hello Kanda,

I have managed to figure out how this would work, here is the code:

# get all products which are products
products = env["product.product"].search([("type", "=", "product")])

for product in products:
    template = product.product_tmpl_id
    new_quantity = 0
    stock_change = env["stock.change.product.qty"].create(
    [
        {
            "new_quantity": new_quantity,
            "product_id": product.id,
            "product_tmpl_id": template.id
            }
        ]
    )
    stock_change.change_product_qty()

This hasn't been fully tested but seems to work on products which have a product and uses the same algorithm when you click the "Update Quantity" button.

All the best,

Avatar
Discard