I have added a custom field to the product and I would like to update its value whenever a new purchase order is confirmed.

Example:

Product.Purchase_Price = 0.00 (Field type is float) When a purchase order is confirmed for this product I would like to update Purchase_Price with the last purchased price.

How can I achieve this with a custom module?

Thank you for your help!