Alert Slack When a Scheduled Supplier Feed File Is Missing or Stale

6 min setup
No coding required
Runs automatically

Inventory and price syncs from a supplier's FTP feed fail quietly when the supplier stops uploading. This workflow checks the feed every morning and alerts Slack when the file is missing or hasn't been updated, before stock levels drift.

schedule icon
Every morning at 6am
Read the supplier's feed file on the FTP server
Continue if the feed is missing or unchanged
slack logo icon
Alert your team in Slack

How it works

6 steps to know the day your supplier feed stops updating

schedule icon

Every morning at 6am

App connector: Schedule • Time to complete: 1 minute

Runs once a day, before your feed import runs.

Read the supplier's feed file on the FTP server

App connector: FTP • Time to complete: 1 minute

Read the rows of the feed CSV from the supplier's FTP or SFTP folder. No rows means the file is missing or empty.

Get yesterday's snapshot of the feed

App connector: Data • Time to complete: 1 minute

Find the saved record for this feed: yesterday's row count and a fingerprint of its first and last rows.

Save today's snapshot of the feed

App connector: Data • Time to complete: 1 minute

Save today's row count and fingerprint, so tomorrow's run can compare against it.

Continue if the feed is missing or unchanged

App connector: Filter • Time to complete: 1 minute

Continue when no rows came back, or today's row count and fingerprint match yesterday's exactly, which means the supplier didn't upload a new file.

slack logo icon

Alert your team in Slack

App connector: Slack • Time to complete: 1 minute

Post which feed is missing or unchanged, its row count, and the supplier contact to follow up with.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to know the day your supplier feed stops updating

Get setup in 6 minutes.

Use this template →

FAQs

How does it know the file is stale?

It saves the feed's row count and a fingerprint of its first and last rows each day. If tomorrow's file is identical, the supplier most likely didn't upload a new one.

Can I check several suppliers?

Make a copy per supplier feed, or loop over a list of file paths.

Does it stop my import?

No. Pair it with a check in the import workflow if a stale file should skip the import.

Personalize this template

Customize this workflow even further:

Set custom delays
Schedule actions to trigger after a set time period, such as sending follow-up emails 3 days after an event.
Chain multiple actions
Connect several steps together in one workflow, like tagging data, updating records, and notifying your team simultaneously.
Store data in tables
Save order details, customer preferences, or custom metrics in your own database for reference and reporting.
Deploy AI agents for smart decisions
Let AI agents evaluate complex scenarios and choose the right action path based on your defined rules.

You're in good company

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

know the day your supplier feed stops updating

6 min setup • Fully supported if you need help