Shopify Flow Help Please

Shopify Apps
1

Hello, Shopify Community!

I’m seeking assistance with a Shopify Flow workflow I’ve created. I’ve been working with a Shopify Support Advisor, Ron, and he recommended posting here to get some expert help.

My goal is to create a single daily or weekly email report that lists all products from a specific collection that have an inventory level below 10 units.

Here’s my current situation:

Workflow Name: Send Daily Christmas Under 10 Email

Trigger: The trigger is correctly set up to check for inventory levels.

The Challenge: I need to add a condition to this workflow to filter the report so it only includes products from my “Christmas” collection (which has ID: 280120230044). The products in this collection all have an SKU that starts with “XM”.

I tried using a condition based on the product collection, but I keep getting a “condition was false” error, or the report includes all products under 10 units instead of just the ones from the specified collection.

Could an experienced Flow user or developer please help me find the correct condition to use? I’ve attached screenshots of my current workflow below.

Thank you so much for your help!

2

Hard to tell without seeing the screenshots.
Maybe forum engine hid them?

I’d approach it with 2 flows:
First runs on “Product variant inventory quantity changed”. Check the inventory level and SKU, if matches – assign product tag.

Second flow runs on schedule, daily, uses “Get product data” to retrieve a list of products tagged by the first flow and feeds it into “Send internal email”.
Then, removes tag from those products using Loop.

3

This is a great example of why reporting via Flow gets hard fast.

Quick question (I’m validating an idea):
Would you prefer a simple “scheduled email report” tool where you can pick:

  • a collection (or SKU prefix like XM)
  • an inventory threshold (e.g. < 10)
    and then receive a weekly/daily CSV + a simple PDF by email,
    without having to maintain multiple Flows and tags?

If yes, which format would you want most: CSV, PDF, or both?