Shopify Flows Inventory Email

Shopify Plus

Topic summary

A user is trying to set up a Shopify Flow to receive weekly Monday morning emails showing inventory levels for blank apparel items in a specific collection. The challenge involves products that are unpublished and in draft status due to using the “Bundles” app for shared inventory management.

Initial Problem:

  • Standard collection-based filtering in Shopify Flow wasn’t working
  • Previous attempts using “get Product” loops and custom code failed

Solution Provided:
Another user suggested filtering products by tag instead of collection ID:

  • Add a “blank” tag to relevant products
  • Use the query tag:blank in the “get Product” action
  • Display product titles and total inventory using Liquid code

Follow-up Request:
The original poster successfully implemented the basic solution but needed variant-level inventory (to track specific sizes). A code snippet was provided to loop through variants and display individual quantities alongside variant names.

Status: The discussion appears resolved with working code examples shared for both product-level and variant-level inventory reporting.

Summarized with AI on October 29. AI used: claude-sonnet-4-5-20250929.
1

Hey guys,

I’m having some issues with Shopify Flow app. I’ve watched a bunch of videos and talked back and forth with ChatGPT but I think I might need some help with this one.

GOAL: The goal is to have an email every Monday morning with the inventory levels of a specific collection.

Backstory, we have a graphics apparel business where all of our blank apparel is “shared” across products. They all pull from the same “Blank Black Sweater” or “Ladies Fit White Tee” etc. The way we are doing this is by using an app called “Bundles”. This app requires us to leave the entire collection unpublished and all the products in “Draft.” This is what I think might be causing my troubles.

The idea is that every Monday we get an email with all our Blanks and their variants so that if we need to reorder, we can have them before the weekend. Running out of these blanks would be not good.

I’ve tried all sorts of “get Product” with “for each” loops, I’ve tried all sorts of “run code”, and I’ve tried variations of “give me all the info you can for this specific collection ID”. But now I’m looking to the experts.

Is this possible or am I wasting my time? Thank you!

2

Hey @Gbeats94

I just try sending product inventory email by of a specific collection. seems not work when filter products by collection id. but you can try the filter product by tag. I think the requirements can be achieved

Sonya_2025_0-1744879763004.png
Sonya_2025_0-1744879763004.png2465×832 203 KB

below is the code using the message in the email

{% for getProductData_item in getProductData %}
 Product:  {{getProductData_item.title}}   {{getProductData_item.totalInventory}}
{% endfor %}

Hope this helps. Feel free to DM OR Email me if any questions!

3

Thank you so much for your reply! What is the advanced query you used in the “get Product” action? I appreciate your help on this!!

4

FYI

Sonya_2025_0-1744953010511.png
Sonya_2025_0-1744953010511.png2291×766 121 KB

QUERY:

tag:blank

NOTE: Add a tag “blank” to your products that need the inventory warning

5

That’s perfect! It worked. Now how would I get it to show me each variant as well. Right now it’s the product with the combined variant quantity which is great. But what if we are out of a certain size etc. I really appreciate your help on this. For some reason ChatGPT doesn’t write the code in the proper format/ script.

6

Hi @Gbeats94

Pls try below code in your message box

{% 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 %}

Please let me know if it works by giving it a Like or marking it as a solution!