Sending triggered email on Collection update?

Ask the community
, , ,
1

Hello guys. Hope you can point me in the right direction here, as I am just getting started familiar with Wix and corvid.

What I want to do:
I want site visitors (not members or customers) to be able to subscribe for “Out of Stock” product, in order to receive automatic email notification as soon as product is back in stock.

My current situation:

  1. On the WIX Store product page, I have added a “Subscribe” button. This button appears only when the viewed product is “Out of Stock”.
  2. By clicking on the “Subscribe” button, the site visitor (not a member or customer - just a visitor) is prompted with a lightbox requiring inputting email address of the visitor.
  3. If email address is provided, and visitor clicks on “Submit” button in light box - the record (product._id, and provided email address) is added into my “Subscribe” collection. This collection simply keeps track of who (email addresses) subscribed for “Out of Stock” products.
    All this works fine. The question is how to the implement next step

Question:
Is there a way, to trigger automated email notification (or send email somehow from back-end?) to email addresses in “Subscribe” collection, as soon as Product is back in stock (inStock is flagged true in Product details in Stores/Products collection)?

Really appreciate your help and advise on this.

Thank you, and have a great day.

2

To continue on my question:

To intercept WIX Stores/Products collection updates, I have a feeling I need to use afterUpdate() hook of the collection?

But, when I look at WIX Stores/Products available hooks, I do not see there afterUpdate() hook (there are other hooks, but no this one)?

Maybe I am missing something or approaching this problem from a wrong direction?