Creating custom daily low stock query for Flow app excluding dropship items

Topic summary

A user is building a Flow automation to generate daily inventory summaries for products with stock below 20 units. The challenge is excluding dropship/made-to-order items that don’t track inventory, as these keep appearing in the reports.

Current filter criteria:

  • Status: active
  • Total inventory: <20

Proposed solutions:

  • Flow doesn’t support direct querying by inventory tracking status
  • Use Liquid code conditions to filter out non-tracked inventory products in the output
  • Alternative approach: Tag all non-inventory-tracked products (e.g., “not_tracking_no”) and add a tag-based exclusion filter to the Flow

The discussion includes screenshots showing the current Flow configuration but remains unresolved regarding the optimal implementation method.

Summarized with AI on November 6. AI used: claude-sonnet-4-5-20250929.

Hi! I need help creating a custom daily stock Flow, with inventory summary of products less than 20 pieces. The issue I’m running into is that we have some dropship items on our websites that are made to order, where we don’t track inventory, but they keep showing up in my daily summary.

Does anyone know how to filter only “tracked” inventory?

Right now I have:

“status:active and inventory_total:<20”

Thank you!

Shay

You can’t query by that field. Instead, you would need to write some conditions in your liquid to only output the products that don’t track inventory.

You could alternatively tag the products that don’t track inventory and add a filter like “tag_not:no_tracking”

1 Like