Need an Expert to Assist me in creating a complex workflow

I have a workflow that assigns a metafield with an ‘expiry date’ for variants for products that were added. The expiry date will be set to 7 days from now. this is so that i can create a collection, or a search function where users can filter by what has been added the last week. I now need a workflow that will then delete the date from the metafield after the expiry date is met. AI had suggested me to take this route since tags aren’t ideal for me as i’m using them for something else.

This can be a paid gig if necessary.

For information

  • Metafield namespace & keys

custom.new_arrival_expiry (date style)
custom.new_arrivals_expiry_timestamp (integer style for unix formatting)

Once all is set up, I would then create a metafields search filter as follows to get the list of variants/products created in the last 7 days

Filter Name: “New Arrivals”.

  • Type: Metafield.
  • Metafield: custom.new_arrival_expiry (if i use the date metafield)
  • Condition: exists.

of course, any better alternatives are appreciated

It’s pretty simple, actually.

After your action “Assign product metafield” you add a Flow action “Wait for 7 days” and then action “remove product metafield”

Kinda like this: