How to decrease the quantity of a catalog item after each Request is being submitted?

[sreeshsurendran]

The requirement is to reduce the stock by the number of quantity of requested.

For example,

there's iPhone 15 catalog item and I order 1 quantity of it. The backend value of stock for this catalog item is 14. Now, after the REQ is submitted, the stock number should come down to 13

[Vishal Birajdar]

Hi @sreeshsurendran 

Can you let us know In which table "Stock" field resides ? in a stockroom Table ?

[sreeshsurendran]

Hi @Vishal Birajdar  : I was thinking if we could create a read-only variable with the catalog item and reduce the number from the variable

[Vishal Birajdar]

Hi @sreeshsurendran 

but there should be source of truth from database where we will store number of stocked item know.