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

[Shaytopalovic]

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

[paul_n]

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"