Stock update

[AlexM]

Hi,

I have:

Ingredients (Ingredient | Stock)

Recipes (Product | Ingredient I Used Qty) 

Products 

Ordered Products ( Order | Product)

Orders ( Ordered Product | Qty)

Problem:

I need to update the Ingredient stock every time a product is added to an order or when an order is canceled.

Ideally with actions only and not automation.

I am thinking at looping with actions but can't see through it on how I would achieve it.

Thanks!

[Elvic]

Why don’t you simply create another virtual column in Ingredients which will calculate your stock less active order quantities?