Send an internal email that lists all products or variants where the metafield "inventory timestamp" contains today's date.
Name: inventory timestamp
Namespace and key: custom.inventory_timestamp
Could anyone help with the snippet that would go in the "Message" section when building the email step in Flow?
I'd also love creative suggestions for trigger. For now I'm trying to use the app "Timed Actions" but I have no idea whether it will work. (why can't time/date be a Flow trigger???)
Flow has a Scheduled time trigger in Beta right now. Like this trigger you are using, what you'll realize is that without an event trigger there is no data to use in the workflow, so you need a way to get the the data. As part of the beta, we are adding a way to query products, for example. The main issue for this use case is that metafields can't be used in queries yet, so the beta won't work for you (especially if you have to go through all products).
An alternative way to solve this would be for you to use the Product added to store trigger. And then build your workflow to look for the metafield and do whatever. They go into the admin, select up to 50 products at a time, and click "More Actions > Run Flow Automation" and choose that workflow.
thx Paul, that's great to know.
so am I correct in assuming that there is no way to say :
search for and list all products containing today's date in the inventory_timestamp metafield
in html or liquid code?
The HTML or Liquid part isn't the problem. The problem is that you need a way to get all products with that metafield, which right now would require getting all products in your store every time. If you have more than a hundred or so products, that won't be viable. If the products had some other field that you could filter on, it might be possible.
Make the shift from discounts to donations, and witness your business not only thrive fina...By Holly Dec 4, 2023
On our Shopify Expert Marketplace, you can find many trusted third party developers and fr...By Arno Nov 27, 2023
You've downloaded the Search & Discovery app from the Shopify App store, and as you're ...By Skye Nov 8, 2023