How to Auto-Hide Shopify Products When Their Expiry Date Passes

Selling an expired product isn't just embarrassing — for food, cosmetics, and supplements, it can be a genuine compliance risk. The problem is that Shopify doesn't watch your expiry dates for you. This guide shows how to fix that with one metafield and one workflow.

This happens more than you'd think

A food store sells a batch of protein bars with a best-before date of March 15. Someone orders on March 22. The refund, the apologetic email, the one-star review — all preventable, all painful. The merchant knew the date was there in the product metafield. They just didn't have anything watching it.

This isn't a niche scenario. It happens to supplement stores, cosmetics brands, specialty food retailers, event ticket sellers — anyone whose products have a hard date after which they shouldn't be sold. Manual checking works until your catalogue is 50 products deep. After that, things slip through.

The right tool for this job

Shopify doesn't have native expiry date automation. Shopify Flow can't query products by metafield date (that's a known platform limitation — here's the full explanation). The common workaround is a calendar reminder or a spreadsheet you check weekly. Both work until they don't.

DateCue watches your metafield dates every minute. When an expiry date passes, it changes the product status automatically. No code, no Flow triggers, no cron jobs.

Setting up the metafield

If you don't already have an expiry date metafield, set one up in Shopify admin first. Go to Settings → Custom data → Products and add a new metafield definition:

• Name: Expiry Date (or Best Before, Use By — whatever matches your business language)
• Namespace and key: custom.expiry_date
• Type: Date — or Date and time if you need precise timing

Once the definition is saved, you can set the date on individual products through the product editor, via Bulk Editor, or by CSV import. DateCue will pick up whichever products have the metafield populated.

Creating the DateCue workflow

In DateCue, create a new workflow and configure it like this:

The Active status filter is worth explaining. Without it, the workflow would run against every product with the metafield — including ones you've already manually put into draft for other reasons. The filter makes sure DateCue only acts on products that are currently live, so it doesn't interfere with your existing drafts.

Draft vs Archived — which should you use?

The workflow above moves products to Draft, which hides them from your storefront but keeps them editable and recoverable. That's usually the right choice for expiry — the product still exists in your admin, you can view its history, and if you need to reinstate it (say, a new batch arrives), you can publish it again.

If you'd rather have expired products completely off-sale and reflected correctly in sales reports, use Archived instead. Archived products don't appear in the active product list, but they're not deleted — they're moved to a separate view. For regulated industries like food and pharma, archiving can be the cleaner audit trail.

For compliance-heavy use cases, there's a more detailed guide: compliance automation for regulated Shopify products.

Pair it with an early warning

The auto-hide workflow deals with products after they expire. But if you sell food or supplements, you probably want to know before expiry too — either to run a clearance sale or to trigger a reorder.

DateCue lets you run multiple workflows on the same metafield. A second workflow set to "Before the date (14 days)" can add an "expires-soon" tag to feed a clearance collection — or you can set up a staff email alert 30 days before so your buyer has time to reorder.

How quickly does DateCue act?

DateCue checks every minute. So when an expiry date passes, the product will be moved to draft within about a minute. It's not instantaneous to the second, but it's close enough for any practical purpose. No more "sold after expiry" because the product sat live for three days after the date passed.