How to Schedule Collection Updates with Metafield Dates

Time needed: 5 minutes

This workflow automatically moves products between collections based on a scheduled date stored in a metafield. When the date matches today’s date, it removes the product from one collection (e.g., “Coming Soon”) and adds it to another (e.g., “New Arrivals”).

1. Configure Schedule trigger

   Set up a daily schedule trigger to check products for their scheduled move date.

2. Get products from source collection

   Use the Shopify Collection Products step to retrieve products from your source collection (e.g., “Coming Soon”). Set the limit to control how many products to retrieve—by default, it’s 50, but you can increase it up to 8,000 to fetch more products in a single request.
   
   If your collection has more than 8,000 products, you’ll need to implement pagination to get the full list.

3. Filter valid products

   Add a Filter step to check that the collection has at least one product in the source collection by checking that product IDs are not empty.

4. Loop through products

   Set up a Loop to process each product from the filtered collection list.

5. Check product metafield

   Configure a Shopify Product Metafield step to retrieve the “publish_date” metafield from each product’s “custom” namespace.

6. Filter products by date

   Add a Filter to only process products where:
   
   – The metafield value is not empty
   – The metafield date matches today’s date (format: YYYY-MM-DD)
   
   First, add the MESA “Date” variable, then use the formatting options to achieve the required YYYY-MM-DD format.

7. Clear product metafield

   Add a Transform step with the following JavaScript code to remove the publish_date metafield:
   
   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);
  }
}

8. Get source Collection ID

   Retrieve the source Collection ID (e.g., “Coming Soon”) using the Shopify Custom Collections endpoint.

9. Get collection relationship

   Get the Collection ID that links the product to the source collection using the Shopify Collects endpoint.

10. Remove from source collection

    Delete the Shopify Collects relationship to remove the product from the source collection.

11. Add to destination collection

    Create a new Shopify Collect relationship to add the product to the destination collection (e.g., “New Arrivals”).

12. Turn workflow “On”

    Turn the workflow on and run it once to ensure everything is configured correctly before letting it run automatically on the daily schedule.