Schedule Product Collection Changes by Metafield Date

Automatically update products based on a scheduled date using a custom metafield. This workflow runs daily, checks each product for a specific date metafield, and when that date matches today, it performs a series of updates—such as clearing the metafield, removing the product from one collection (like “Coming Soon”), and adding it to another (like “New Arrivals”).

🔧  Setup is needed:
➕  Create Publish Date Product Metafield
➕  Create Coming Soon Collection
➕  Create New Arrivals Collection
⏰  Adjust Schedule
✏️  Add Collection ID

Follow the steps below to set up this workflow.

Step 1

In Shopify Admin, you will need to create a Publish Date Product Metafield.

Click Settings.

Click Metafields and metaobjects on the left sidebar.

Click Products.

Click Add definition.

For Name, fill in Publish Date.

Click Select type and select Date.

Check that One value is selected. If not, select One value.

Keep the Validations section as is and turn on the Storefront API access.

Click Save.

Click X on the top right corner to exit out of Settings.

Step 2

In Shopify Admin, you will need to create a Coming Soon Collection.

Click Products.

Click Collections.

Click Create collection.

For Title, fill in Coming Soon.

Add whatever you would like for the Description.

In the Collection type section, select Manual.

In the Products section, manually add in any products.

Setup other sections if needed (i.e. “Publishing”, “Image”, etc..).

Click Save.

Step 3

In Shopify Admin, you will also need to create a New Arrivals Collection.

Go back to the Collections page.
Click Create collection.

For Title, fill in New Arrivals.

Add whatever you would like for the Description.

In the Collection type section, select Manual.

Do not add any products in the Products section.

Setup other sections if needed (i.e. “Publishing”, “Image”, etc..).

Click Save.

Step 4

After creating the Publish Date Product Metafield, and Coming Soon and New Arrivals collections, you will need to set up this workflow.

Step 5

In the Schedule trigger, keep it running daily. You can adjust the time when it runs daily or keep it as is.

Step 6

In the Get List of Collections' Products (Coming Soon) step, fill in the Collection ID field from the Coming Soon collection.

To locate your collection ID, go back to the Coming Soon Collection you created in your Shopify Admin.

In your web browser's URL bar, locate your URL. 

https://admin.shopify.com/store/my-store-uuid/collections/287588253384

After /collections, the set of numbers is the collection ID. Using the example URL, the collection ID is 287588253384.

Step 7

At the top or bottom of the workflow, click the Save Changes button to save your changes.

Step 8

At the top or bottom of the page, switch Off to On to turn on your workflow to start automating. Runs will trigger depending on the frequency set in the Schedule trigger (first step).

Back in your Shopify Admin, product(s) in the Coming Soon collection will need their Publish Date Product Metafield set to a future date if available. Otherwise, please leave blank.

✋  Still have questions? We got you. Email us at contact@getmesa.com where our Customer Success team is happy to help!