How can I get notified when a product is published?

[sizweWB]

Hi,

We'd like to get notified when a product is published, is there a flow to do this? Currently there is a flow that notifies when a product is created, but we want to get notified when it's published because sometimes these situations don't happen on the same day.

If possible please write down the formula so I can add it into the "custom query" field.

Thanks in advance

Sizwe

[paul_n]

I don't think a query with "Get product data" would solve this fully, because there isn't a field to query by publication date (this may be because a product can have more than one publication). You could get products that were recently updated (there is a query already in the UI for that) and then check if the publication date is recent using liquid in the notification action. Assuming you only want to check the online store publication you could check `{{ product.publishedAt }}`

[sizweWB · Accepted solution]

Thanks Paul and Niyeepo for the efforts.

However I managed to find a solution by creating 2 flows with different triggers and slightly different conditions on each, see below flows;

FLOW 1:

Product Created > Check if...Status equals "Active" > Send notification

FLOW 2:

Product Status Updated > Check if...Old Status is equal to "Draft" AND Status is equal to "Active" > Send notification

Quite basic but it gets the job done.

Thanks again for the assistance guys

Sizwe