Auto-Draft Shopify Products That Are Past Their Sell-By Date

Most stores carry active products that have quietly outlived their intended run: limited edition items, event-specific merchandise, seasonal goods, promotional bundles. They stay live because nobody went back and removed them. Here's how to auto-draft Shopify products past their sell-by date, so the cleanup is built into the product record from the start.

Why does a bloated catalogue hurt your store?

A bloated active catalogue harms your store in several ways. Customers find irrelevant products in search, collections fill with clutter, and out-of-stock "ghost" products linger in navigation. Setting each product's status by hand never scales. The fix: give every time-limited product an end date at creation, and let DateCue enforce it.

Step 1: Create the sell-by metafield

A metafield stores the sell-by date on each product so DateCue knows when to act. In your Shopify admin, open Settings → Custom data → Products and add a new definition. Give it the namespace and key below, set the type to Date, and save. That's the whole setup.

The two values to enter:

• Namespace and key: custom.sell_by_date
• Type: Date

Make it a habit to set this on every time-limited product at creation time. Products without the metafield are ignored by the workflow entirely.

Step 2: The DateCue workflow

Build one workflow that reads custom.sell_by_date and sets the product status to Draft on that date. There's nothing else to wire up: no Flow date conditions, no scripts. DateCue checks due dates every minute, so a product drafts itself the moment its sell-by date arrives. The config is three fields, shown below.

When the sell-by date arrives, DateCue moves the product to Draft. It disappears from collections, search, and the storefront. Your catalogue stays current without anyone manually reviewing it.

Draft or archive: which status should you use?

Use Draft for products you might bring back, and Archived for ones that won't return. A drafted product stays editable in your admin but leaves the storefront, so it's right for restockable limited runs, repeat promotional bundles, or seasonal lines you'll reactivate next year. Shopify's product status guide covers both states.

Use Archived for products that won't come back. Archived products are retained for reporting and order history but are fully retired from the catalogue. Use this for one-time event merchandise, expired promotions, or discontinued lines. See Archive Shopify Products Automatically on Their End Date for the archiving workflow.

How do you get a warning before a product drafts?

Add a second workflow that fires a few days before the sell-by date and emails your team. Use an offset of, say, 3 days, with a send-email action. You get a heads-up before anything disappears from the storefront, so there's time to extend the date or restock. The config sits below.