How to add a product tag based on a product metafield value

Hello,

I am looking for help with some automated product tagging.

We are using product metafields to capture price status for collection management. Values are either Full Price or Markdown. We use these values to group products into collections to run promotions against. The values are populated through an integration with our ERP. When our product team updates a products’ price status in the ERP, the Metafield value is updated in Shopify

Long story short, an app needs a product tag (Yotpo rewards & loyalty) and can’t check if a product is in a collection or not for discount eligibility. It would need product ID’s, Product Tags or Product type. The automation I am looking to set up would check if the products metafield value is Full Price or Markdown and either add a tag if the value is Full Price and there is not already a Full Price tag or remove the Full Price tag if the value is Markdown.

We have approx 20,000 products in the store.

Is this possible with flow?

I’m not sure that there is a suitable trigger for that use case currently…there aren’t yet events for metafield updates, for example.