Can I run though all products based on date in a metafield?

Topic summary

A user is seeking to create a Shopify Flow workflow that monitors product synchronization status from an external database. Their products contain a metafield storing the last synchronization date, and they need to be alerted when this date exceeds three months old, indicating potential sync failures.

Key Requirements:

  • Iterate through all products checking a specific metafield value
  • Compare dates to identify products with sync timestamps older than 3 months
  • Trigger notifications when outdated products are detected

Current Status:
The question remains unanswered with only a brief acknowledgment that it might be possible, but no concrete solution has been provided. The discussion is awaiting input from Shopify Flow experts on implementation details.

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

Is it possible to make a Workflow that runs through all products based on a metafield?

Our products are maintained form an external database that synchs its data with Shopify.
We have a metafield that holds the date for the last synchronisation.

Our problem is that our database sometimes have a problem with synching up. I therefore want to create a flow that informs if the the last synchronisation date is over three months old.
Anybody have an idea of how to do that purely in Shopify Flow?

1 Like

I believe it is possible but I am not too sure on how. Maybe some experts can help you with the detailed information on this case