How to get a daily inventory report from Flow App?

[SHFWS]

Hi!

Has anyone figured out how to get Flow to send a "daily report" of inventory. We have it turned on right now, to track inventory quantity changes, but it sends us like 50 emails. I would like to receive one email at the end of everyday, or at the beginning of the day, with a list of products that have less than 48 in stock. 

I have tried the "scheduled to run..." trigger and multiple other things, but can not seem to find one that will only send one email with all products.

Thanks!

[InventoryHero]

I had the same experience as you.

You can try Stockbot; as you can set it up to send daily emails with a list of products that have low stock levels.

With this app properly setup, you will receive only 1 email per day with a list of products that have low stock levels. I hope this helps! 

[Appify_Commerce]

I hope this message finds you well and that your business is thriving. I wanted to reach out to you today to introduce you to our innovative inventory management app, which we believe could greatly benefit your store.

Our app is powered by cutting-edge machine learning technology that allows it to accurately predict inventory trends and forecast future demand. This means that you can rest assured that your store will always be well-stocked and prepared to meet your customers' needs.

In addition, our app will send you timely updates when your stock is running low or when a particular product is performing exceptionally well. This will help you stay on top of your inventory levels and ensure that you never run out of popular products.

We understand that every store owner has unique inventory management needs, which is why we offer a fully customizable solution that can be tailored to your specific requirements. Whether you need to manage a large and complex inventory or a smaller, more streamlined selection of products, our app can help.

Best of all, we are currently offering a free trial period, so you can try our app for yourself and see just how much it can benefit your store. We are confident that once you experience the power of our inventory management app, you will never want to go back to your old way of doing things.

So why wait? Give our app a try today and see how it can transform your business. We look forward to hearing from you soon and helping you take your store to the next level.

Warm regards,

[Appify_Commerce]

https://apps.shopify.com/predictify?surface_intra_position=8&surface_type=partners&surface_version=r...

[Jonathan-HA]

Hey there @SHFWS,

If you're open to using an alternative app, our EZ Exporter app can email you a custom CSV/Excel inventory report as an attachment on a daily schedule.

You can set a custom filter to only include products/variants where the available quantity is less than 48 and they will all be combined in a single CSV or Excel file.

[Report-Pundit]

Hello @SHFWS ,

Report Pundit offers several options to manage inventory reports.

You can schedule the report to run at specific times, choose where to receive the report, and receive a single report at the end of each day.

Additionally, you can use a filter to customize the report and view products that have less than 48 items in stock.

Thanks!

[lpscleay]

I set up a flow that does pretty much this (mine was a weekly email with separate lists for <=8 and 0 stock items):

[BillyBee]

@lpscleay  I'm trying to do this same thing, but filter out for certain SKUs. The flow will basically give a daily inventory report on a couple items but I can't get it working. The Flow statement is  {% if variants_item.sku ==100060 %}, but I don't think I've set the get product data query correctly to pull the right data, sku:100060 isn't working. Any ideas? 

[lpscleay]

I'm no expert on the API, but it seems that 'sku' should work in the 'Get product data' Edit query field:
sku:100060 AND inventory_total:<=8
You shouldn't need to use SKU in the email step because it's already been filtered by SKU in the query (I only use inventoryQuantity in the email to separate into 2 lists).