Looking for a Low Stock Alert App With Variant-Level Control + Forecasting (Replacing MerchBees)

Hey Shopify Community!

We’re looking for a replacement for MerchBees, which recently changed how it handles low-stock alerts. Our business needs very specific features to help us manage inventory cleanly and avoid stockouts without overstocking.

Here’s what we’re looking for:

Set low-stock thresholds at the variant product level.
No tagging required. We need to pick specific variants/products for tracking without adding or managing tags.
Alerts via email, ideally with an attached CSV or Excel report.
Dashboard view showing red/yellow/green status for inventory health at a glance.
– Ability to exclude certain products by variant from low-stock alerts.
Affordable—we’re a small team, so cost is a factor.
– Bonus: If there’s forecasting (in the same app or a separate one), that’s a big plus—especially if it uses past sales to help us plan production intelligently.

The goal is to maintain enough inventory to keep production flowing, without sitting on too much excess.

If you’ve used an app or have a recommendation that fits this, we’d love to hear from you!

Thank you!

Hey, for now I don’t know what theme you are using but a lot of themes have come with this feature to show inventory status on the variant level.

You can actually set a threshold in the settings below which the status will show a different color mostly red and above it the message with green and also when it’s near to threshold then in yellow. This is what I have seen on some.

I don’t know of apps but I am pretty there are out there. I can help to set this up with you with code.

So basically I can code all the setup displaying the messages with the different colors. It will be on the variant level and also we can choose to not include specific variants with their variants ID’s.

I am not sure on that notifying with the mail thing but I can research it up. And i don’t think I can come up with forecasting, honestly I don’t even understand it properly.

Can you like explain that a little more in detail? Other than that I can pretty much come up with that inventory status thing.

But I am definite there are apps and since this is not a very advanced feature you might probably find free resource for this.

Please reach out via personal links below for a convenient conversation and collaboration.

Best

Shadab

We are on a modified Venture version 8.0.0 theme. It’s currently unsupported by Shopify and does not have those features you describe. I started with it in 2019 when it was a supported and free theme from Shopiy.

Hi @JohnSmith2

Ciara here from Better Reports :waving_hand:

It doesn’t look like you’ve found a solution just yet to your low stock inventory project, so I thought I’d jump in, seeing as you requested app suggestions.

In Better Reports, we can create a report that shows inventory levels for variants with the ability to filter out variants/products you don’t want to see.

Some merchants even add a filter to show variants with less than X amount of available quantity.

Depending on your needs, you could schedule this report to run hourly/daily/monthly to an email or Google Sheets.

We won’t be able to color code by red/yellow/green, but we can try to color code on a scale using one color or sort/order to make identifying low stock variants easier.

We can also use past sales data to provide forecasting estimates specific to your needs. For example, quantity sold in the last 30/60 days etc.

This will not work at $299 month. We would be open to around $35 to $50 a month for this type of service. I still can’t believe how much apps want when they see a store is shopify plus. I wish we had never switched to it.

Okay. Well as I mentioned before I can try setting this up with code for you with a one time fee rather than a monthly fee like apps would.

The backlog is, I won’t be able to provide the forecasting feature, just the inventory thing.

Best

Shadab

Hey @JohnSmith2 ,

Mete from Merchbees. Could you let us know which change affected your store? We’d love to help.

You can also reach us via live chat to discuss the matter.

Best,

Mete

Have you tried mechanic?

https://apps.shopify.com/mechanic

Similar to the flow app for automations. Also Flow (by Shopify) can send Auto reports.

Hey, I think we might have the right solution for you.

Our App Logistified (https://apps.shopify.com/logistified) offers pretty much all you mentioned.

We offer:

  • Low stock thresholds on product variant level
  • You can prepare/ pick variants to focus on based on 34 filters that range from tags to sku. So you can build your specialized requirements to only see the products-variants you need.
  • We provide a customizable daily email report that which variants need attention
  • We provide a dashboard that monitors inventory health and on top shows other usful KPIs such as inventory value, days on hand and many more
  • We also provide inventory forecasting based on your complete past sales history individually for every variant
    • On top you can customize the data each model should be based on to also consider seasonal effects.

We have a free trial of 14 days that we can extend on demand. Afterwards we will charge 12$/month or 120$/year with no hidden charges.

Fell free to reach out in case you need additional information.

Hope this helps you to grow your business.

Best Regards,

Nicola