`operations/discontinued-flow.md`

30 lines
---
id: discontinued-flow
type: operations
tags: [discontinued, disco, filemaker, archive, substitutes, join-key]
aliases: ["disco flow", "date discontinued", "archive flow"]
sources: [sources/discontinued-flow.md]
updated: 2026-07-17
---
# Discontinued (disco) flow

**Summary:** FileMaker Date Discontinued → Shopify archive → dw_unified disco_items; join on the DASHED SKU, not the Shopify Handle. Vendor-confirmed disco auto-processes; ambiguous replies queue for Steve.

## Facts
- Pipeline: FileMaker `Date Discontinued` → Shopify archive → dw_unified
  `disco_items` registry. <!-- src: discontinued-flow -->
- **Join on the DASHED SKU** (`comboskuwithdash = dw_sku`), NOT the sparse
  Shopify Handle. <!-- src: discontinued-flow -->
- 2026-07-07 run archived 2,227 of ~28,888 disco records (0 errors) + generated
  customer letters. <!-- src: discontinued-flow -->
- Vendor-reply path (discontinued-agent): a vendor that EXPLICITLY says a product
  is discontinued → stamp FileMaker discontinued + close the open sample order so
  the >10-day follow-up stops. Ambiguous/sensitive replies (no sample,
  backordered, relationship-ended, brand-attribution, legal) are QUEUED for
  Steve, never auto-written. <!-- src: discontinued-flow -->
- Substitutes: substitutefinder returns nearest ACTIVE/STAGED/DRAFT only —
  ARCHIVED and deleted products are NEVER shown as substitutes. <!-- src: discontinued-flow -->

## Related
- [[catalog-gates]] · [[store-and-data-truth]] (unified-first).