Shopify Flow Email Notification Setup

Job ID: 39185582

Budget: €30 – €250 EUR

I'm looking for a Shopify Flow expert who can set up a custom email notification system for me. I need to receive an email every morning with the following:

- The first part should list the SKUs I need to order. The criteria for this is based on a meta field in the product that I manually update, called 'Stock Mini'. If the quantity in stock is lower than what is indicated in this field, the SKU should be added to the email. However, if the Meta Field > Product: 'En Commande' is true, then that SKU should not be included (as it means the product is already on order).

- The second part of the email should list the SKUs that are currently on order. If the Meta Field > Product: 'En Commande' is not true, then include this SKU.

The email should be sent via a Custom SMTP server, with the subject line 'Stock Order Alert' and formatted as a Table. with 4 columns: SKU, TITLE, QTY IN STOCK, DISTRIBUTOR NAME, DISTRIBUTOR SKU

Ideal Skills & Experience:
- Extensive experience with Shopify Flow
- Familiarity with setting up email notifications within Shopify
- Proficient in working with meta fields in Shopify
- Experience with Custom SMTP server
- Skills in creating table formatted emails
Related categories: PHP JavaScript HTML Shopify Templates Shopify