Schedule Product Collection Changes by Metafield Date

This scheduled trigger runs once per day at midnight. It initiates the workflow that checks all products in your "Coming Soon" collection for publish dates matching the current date. The daily timing ensures products launch at the start of their scheduled day. The schedule is pre-configured but can be adjusted if you prefer a different time (like early morning before your store opens).

This step retrieves products from a Shopify collection, limited to 100 products per run. You need to configure the collection_id during setup—this should be the ID of your "Coming Soon" collection (or whatever collection holds your pre-launch products).

To find your collection ID, go to Products > Collections in Shopify admin, click on your "Coming Soon" collection, and look at the URL which will show a number like "123456789012"—that's your collection ID.

This filter checks if {{shopify.0.id}} is not empty, meaning at least one product exists in the collection. If products exist, the workflow proceeds to loop through them. If the collection is empty, the workflow stops here without error. This safety check prevents the loop from attempting to iterate over an empty array.

This loop step iterates through each product in the {{shopify}} array returned from the collection. For every product, the loop executes the subsequent metafield retrieval, date checking, and collection movement steps using {{loop.id}} as the product identifier. The loop continues until all products in the collection have been checked.

This step retrieves a specific metafield from each product using {{loop.id}} as the product identifier. The metafield is configured with namespace "custom" and key "publish_date"—this is the standard metafield created when you add a custom date field to products in Shopify admin. The metafield value (the date) is returned as {{shopify_1.value}} in format "YYYY-MM-DD".

Setup requirement: You must create this metafield definition in your Shopify store first (Settings > Custom Data > Products > Add definition) with type "Date" before using this workflow.

This filter checks two conditions:
(1) {{shopify_1.value}} is not empty (the product has a publish date set), AND
(2) {{shopify_1.value}} equals today's date ({{now | date: "%Y-%m-%d"}}).

Both conditions must be true for the workflow to proceed with moving the product. If the publish date is in the future, past, or missing, the workflow skips that product and moves to the next one in the loop.

This transform step maps the data needed to delete the metafield into a structured format:
product_id ({{loop.id}}),
namespace ("custom"), and
key ("publish_date").

This output is passed to a custom code step that uses Shopify's GraphQL API to delete the metafield. Clearing the metafield after moving the product ensures the workflow won't try to move the same product again on subsequent daily runs.

Custom code:
const Mesa = require('vendor/Mesa.js');
const Transform = require('vendor/Transform.js');
const ShopifyGraphql = require('vendor/ShopifyGraphql.js');
module.exports = new class {
script = (payload, context) => {
const output = Transform.convert(context, payload);

const mutation = `mutation MetafieldsDelete($metafields: [MetafieldIdentifierInput!]!) {
metafieldsDelete(metafields: $metafields) {
deletedMetafields {
key
namespace
ownerId
}
userErrors {
field
message
}
}
}`;

const response = ShopifyGraphql.send(
mutation,
{
metafields: [
{
ownerId: `gid://shopify/Product/${output.product_id}`,
namespace: `${output.namespace}`,
key: `${output.key}`,
},
],
},
null
);

Mesa.output.next(response);
}
}

This step searches for a custom collection with the title "Coming Soon" and returns the first match (limit 1). The collection ID is stored as {{shopify_2.0.id}} for use in the next step.

If your pre-launch collection has a different name, update the query.title field to match your actual collection name.

This step finds the collect (the Shopify term for collection membership) that connects {{loop.id}} (the product) to {{shopify_2.0.id}} (the "Coming Soon" collection). The collect ID is returned as {{shopify_3.0.id}}.

In Shopify's system, products aren't directly "in" collections—instead, "collect" records create the relationship between products and collections, so you must delete the collect to remove a product from a collection.

This step deletes the collect using {{shopify_3.0.id}}, which removes the product ({{loop.id}}) from the "Coming Soon" collection. After this step executes, the product no longer appears in the "Coming Soon" collection on your storefront. The product itself isn't deleted—only its membership in that specific collection is removed.

This step creates a collect that links {{loop.id}} (the product) to a destination collection.

Critical setup: You need to configure the collection_id in the body to specify which collection receives the product. Find your "New Arrivals" (or equivalent) collection ID using the same method as step 2—go to Products > Collections, click on "New Arrivals," and get the ID from the URL. Enter this ID in the step configuration. After this step, the product appears in your "New Arrivals" collection.