Send email on changing line item field value

Question

I have a custom list field on the product line item type, which is for the ability to set seperate shipping statuses for each product in one order.

When the store admin updates this list field on a line item, the site will need to send out an email to the customer.

Is there a nice way to make this happen?

Answer 1

There are three approaches I can think of.

1. Use a hook to alter the update function to send an email out based on your conditions.
2. Add JS to handle the change via a custom AJAX call.
3. Create a cron job that monitors changes in the database and emails out messages when changes are picked up.

The first two options are your best and from those, depending on skill level, I would choose one.