Managing inventory can be tricky, especially when products are unpublished or in draft mode. If you're in the same boat, this guide is for you.

In this article, we'll walk you through how to use Shopify Flow to send yourself a weekly inventory warning email based on products tagged with a specific keyword like "blank". This is especially useful if you're using a bundles app that keeps your products unpublished or in draft status, which might make traditional inventory workflows harder to implement.

Let’s look at the problem and the solution step-by-step.

📌 The Challenge

A merchant running a graphics apparel business needed a way to:

• Get a weekly inventory report every Monday for their base apparel blanks.

• These blanks are shared across multiple products (e.g., all black sweaters pull from the same “Blank Black Sweater”).

• Due to how their Bundles app works, all related products are unpublished and in draft status.

• Their attempts using loops, product queries, and custom code in Shopify Flow weren’t producing the desired result.

They wanted a simple and reliable way to be notified before stock runs out—ideally before the weekend when reordering might be slower.

✅ The Solution: Use Shopify Flow

You can absolutely achieve this using Shopify Flow by targeting products with a specific tag, like blank, and automating a weekly email with inventory details.

Here’s how to set it up:

Step 1: Add a Schedule Trigger

• In your Shopify Flow workflow, start with the Scheduled Time trigger.

• Set it to run every Monday at 9:00 AM (or whatever time works for your team).

Step 2: Get All Products With the “blank” Tag

• Add a Shopify Admin API Action to get all products that have the tag "blank".

• This tag acts as the identifier for all your shared blank products.

Step 3: Send Internal Inventory Email

• Use a Send Internal Email action.

• Include the relevant inventory info for each product in the message body.

• Here's an example of how your code might look in the message section:

{% for getProductData_item in getProductData %}
 Product:  {{getProductData_item.title}}   {{getProductData_item.totalInventory}}
  {% for variants_item in getProductData_item.variants %}
  {{variants_item.displayName}}    {{variants_item.inventoryQuantity}}
{% endfor %}
{% endfor %}Copy

🔁 Flexibility and Tips

• This method works even if your products are in draft or unpublished, as long as they are tagged correctly and accessible via the API.

• If you ever change your tag naming convention, remember to update the Flow accordingly.

• You can customize the email formatting to match your team’s needs—HTML support is available.

🧠 Final Thoughts

If you’re managing a business where inventory is shared across multiple products (especially common in fashion and print-on-demand), automating your weekly stock alerts can be a lifesaver.

With just a simple tag and a Shopify Flow workflow, you can stay on top of your inventory, avoid stockouts, and save your team from scrambling last-minute.

No need to waste time on complex code or uncertain workarounds—this setup is simple, scalable, and effective.