Advanced flow and email automations

Ask Me Anything Q&A Emailsegmentationwebinarquestions

Topic summary

A merchant is seeking to automate two inventory and order management workflows using Shopify Flow:

1. Customer notifications:

  • Back-in-stock alerts
  • Price drop reminders for specific products

2. Daily vendor purchase order reports:

  • For businesses with 100+ daily orders working with multiple B2B suppliers
  • Needs unfulfilled orders grouped by vendor and SKU
  • Special requirement for fashion: when any size is ordered, must purchase complete size runs (S, M, L, XL, XXL) based on highest quantity needed across all sizes

Available solutions:

  • Back-in-stock notifications are possible using Flow’s “Product variant inventory quantity changed” trigger
  • Price drop alerts lack a native trigger currently
  • Daily vendor reports can be built using “Scheduled time” trigger + “Get order data” + “Send internal email” actions
  • The complex size-run purchasing logic requires custom code via Flow’s “Run code” action or working with a Shopify Partner/developer
  • Alternative: explore specialized inventory management apps

The discussion remains open as the merchant evaluates these technical options.

Summarized with AI on October 30. AI used: claude-sonnet-4-5-20250929.
1

Hello everyone, is there a way to natively create with Shopify Flow:

  1. notify me when back in stock + remind me when price drops for a certain product(s)
  2. For merchants, who have 100+ daily orders, and collaborate with many vendors (suppliers) on B2B level,
    this email flow would be quite handy: We want daily email report of unfulfilled and unsent products, grouped by Vendors (suppliers) and then by SKU-s.

Example: we need to know for which items we need to create purchase orders for today and call our suppliers.
Also, for women’s fashion - If a customer orders, let’s say 1 Green Jacket XL, we need to purchase from our suppliers one whole serie of that Green Jacket (One serie is 1 S, 1 M, 1 L, 1XL, 1 XXL)

So, let’s say my today’s order list is like this:

2 S, 5M, 4 L, 0 XL, 7 XXL

What we want to know is how big is our purchase order
( from example, it has to be 7 series: 7 S, 7M, 7L, 7XL, 7XXL) if we don’t include current stock.

Is there a way to create such a daily email report and automatize it?

Thanks!

2

Hi there!

Thanks for your detailed questions about automating inventory and order management with Shopify Flow. Let me address each of your questions:

1) Back in stock notifications + price drop alerts:

2) Daily vendor/supplier reports for unfulfilled orders

This is potentially achievable with Shopify Flow using a combination of:

The specific grouping by vendors and SKUs you described (especially the series purchasing logic for fashion items) would likely require custom code. You could:

  • Use a “Run code” action in Flow to organize the data as needed
  • Work with a Shopify Partner who can help implement this custom logic
  • Explore inventory management apps that might offer similar functionality

For your specific series purchasing scenario (needing to order complete size runs based on the highest quantity needed), you’d definitely benefit from working with a developer or partner who can create a custom solution tailored to your business rules.

Hope this helps point you in the right direction! Let me know if you have any other questions.

  • Clare