> ## Documentation Index > Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt > Use this file to discover all available pages before exploring further. # Items Delisted This Week, Costco SIP > Items flipped from active -> delisted in the last 7 days. Direct shelf-loss; chase reasons within 24h. How to read it, why it matters, and how to act on it. **Metrics type:** [Key Metrics](/nerve-centre/overview#metrics-types-explained) • **Category:** [Marketplace](/nerve-centre/connectors#connectors-by-type) > Items flipped from active -> delisted in the last 7 days. Direct shelf-loss; chase reasons within 24h. ## At a glance > Count of items in the supplier's Costco catalogue that flipped from `active` to `delisted` in the last 7 days. Each delisted item is direct shelf-loss: Costco buyers will not order it on the next PO cycle, the velocity revenue stops, and re-listing requires a new buyer-meeting commitment. Costco's delisting decisions are made at the buyer-team level (each Costco merchandise category has a dedicated buyer who curates the SKU range); the supplier learns about delistings through the Costco item-master sync feed, not through advance notice. This card is the supplier's only systematic early-warning of ranging changes. | | | | -------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | **What it counts** | `COUNT(items WHERE previous_status = active AND current_status = delisted AND status_change_date >= now() - 7d)`. Items moving back from delisted to active in the same 7-day window are not netted; the card surfaces the delist event regardless of subsequent reactivation. | | **Item-master source** | Costco item-master sync (typically a daily file dropped into supplier `/inbox` or a JSON feed via the Costco supplier API). Each row carries `costco_item_number`, `supplier_sku`, `status` (active / pending\_review / delisted / discontinued), `last_status_change`, `delisting_reason_code`. | | **Status definitions** | `active` = on the shelf, accepting POs. `pending_review` = Costco flagged for buyer review, no POs being issued. `delisted` = removed from shelf, no future POs. `discontinued` = permanently removed, cannot be re-listed without a new buyer commitment. The card counts active → delisted transitions; pending-review → delisted is also counted (the more typical path). | | **Reason codes** | Costco may include a `delisting_reason_code` on the item-master change: `velocity_below_threshold` (sales too slow), `category_review_cut` (range refresh), `case_pack_change` (supplier failed to update case-pack on time), `gtin_invalid`, `compliance_failure`, `other`. The card surfaces the reason where Costco supplied it; many delistings come without a reason and require buyer follow-up. | | **Cancellations / pre-launches** | Items that never went active (Costco set up but cancelled before launch) are excluded. Pre-launch pending-review items that were cut without going live are also excluded; only active → delisted transitions count. | | **Currency / value** | The card is a count, not a value. To estimate revenue exposure pair with [Revenue at Risk](/nerve-centre/kpi-cards/costco-sip/revenue-at-risk) which multiplies item velocity by ASP. | | **FBA / FBM** | Not applicable; Costco SIP is wholesale, not marketplace fulfilment. | | **Time window** | `7D` (rolling 7-day count, refreshes on every item-master sync). | | **Alert trigger** | `>0`. Triggers on any delisting because each one is a direct revenue impact and time-sensitive (re-listing conversations need to happen within 1 to 2 weeks of delisting; later than that the buyer has moved on). | | **Roles** | owner, sales, operations | ## Calculation Calculated automatically from your Costco SIP data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading. ## Worked example The same US household-goods supplier on Costco SIP, around 84 active items in the catalogue across 4 Costco merchandise categories. Reading taken at 09:00 PT on Monday 09 Mar 26 for the trailing 7 days (02 Mar 26 to 08 Mar 26). | Item | Supplier SKU | Costco item # | Category | Reason code | Avg weekly velocity (units) | ASP (USD) | | ------------------------------ | ------------ | ------------- | ------------- | -------------------------- | --------------------------- | --------- | | 24-pack premium paper towels | PT-24-PREM | 1234567 | Cleaning | `velocity_below_threshold` | 1,840 | 18.99 | | Travel toothbrush 4-pack | TB-04-TRV | 1234890 | Personal Care | `category_review_cut` | 920 | 9.49 | | Glass storage 8-piece set | GS-08-LRG | 1235123 | Kitchen | `case_pack_change` | 480 | 24.99 | | **Total delisted (this card)** | **3 items** | | | | **3,240 units/week** | | The card reads **3**; alert at `>0` is firing. Five things to notice: 1. **Three delistings is meaningful, even though the count looks small.** The estimated revenue at risk (units × ASP) is roughly `1,840 × 18.99 + 920 × 9.49 + 480 × 24.99 = USD 55,378 per week`. Annualised at typical buying cadence that is around USD 1.4M of shelf revenue gone unless reversed. 2. **Read the reason codes carefully because each implies a different action.** (a) `velocity_below_threshold` for the paper towels is the hardest to reverse: Costco buyers cut on velocity, and arguing the velocity was depressed by an off-shelf situation (recent stock-out, location reset) is the only path back. Pull the [Fill Rate](/nerve-centre/kpi-cards/costco-sip/fill-rate) history for that item to make the case. (b) `category_review_cut` for the toothbrushes is a "we are refreshing the range" cut, not a performance cut; the supplier should propose an alternative SKU at the next buyer meeting. (c) `case_pack_change` for the glass storage is a process failure on the supplier side: the supplier did not update the case-pack on Costco's deadline, Costco delisted automatically. This is recoverable by submitting the corrected case-pack via item-master update and asking the buyer for re-activation. 3. **The delisting reasons cluster matters more than the individual reasons.** If 3 of 5 weekly delistings are `velocity_below_threshold`, the supplier has a whole-portfolio velocity issue (pricing, packaging, location) that needs commercial response. If 3 of 5 are `case_pack_change` or `gtin_invalid`, the supplier has a data-quality issue that needs operational response. 4. **The 7-day window is operational not strategic.** Use the rolling 30-day count for trend (typical SIP suppliers see 2 to 8 delistings per quarter depending on portfolio size); use this 7-day count to drive the same-week buyer-conversation queue. 5. **Pair with [Item Delisting Burst (24h)](/nerve-centre/kpi-cards/costco-sip/item-delisting-burst) for clusters.** A 3-in-a-week count distributed evenly is normal portfolio churn; a 3-in-24-hours cluster is a category-wide review event and needs an urgent buyer call to understand the strategic context. ## Sibling cards merchants should reference together Items Delisted is the shelf-loss dial. Pair with these for the full ranging picture: | Card | Why pair it with Items Delisted | What the combination tells you | | ------------------------------------------------------------------------------------------------- | ------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------ | | [Items Active](/nerve-centre/kpi-cards/costco-sip/items-active) | The denominator. | 3 delistings on 84 active items is 3.6 percent weekly churn; on 800 items it is 0.4 percent. Same count, different signal strength. | | [Items Pending Review](/nerve-centre/kpi-cards/costco-sip/items-pending-review) | The pre-delisting queue. | Pending-review items often graduate to delisted within 2 to 4 weeks; the pending-review count is a 4-week leading indicator of next month's delisting count. | | [Item Delisting Burst (24h)](/nerve-centre/kpi-cards/costco-sip/item-delisting-burst) | Cluster detection. | A burst signals a category-review event; an even drip signals normal portfolio churn. | | [Items with Field Drift](/nerve-centre/kpi-cards/costco-sip/items-with-field-drift) | Data-quality precursors. | Items with case-pack or GTIN drift are at risk of `case_pack_change` or `gtin_invalid` delistings; closing the drift prevents avoidable delistings. | | [Revenue at Risk (live)](/nerve-centre/kpi-cards/costco-sip/revenue-at-risk) | Dollar form of the consequences. | The card's count plus ASP times velocity gives the dollar exposure; the revenue-at-risk dial pre-computes it. | | [Fill Rate](/nerve-centre/kpi-cards/costco-sip/fill-rate) | Historical context for `velocity_below_threshold` reversals. | If fill-rate dipped on a delisted item, depressed velocity has an explainable cause and the buyer conversation has a path. | | Cross-connector: [`shopify.product_sales_velocity`](/nerve-centre/shopify/product_sales_velocity) | DTC velocity comparison. | If a delisted Costco item is also stocked on the supplier's DTC site, DTC velocity informs the buyer conversation. | | Cross-connector: [`jira.tracker_open_issues`](/nerve-centre/jira/tracker_open_issues) | The buyer-conversation queue. | Each delisted item should generate a Jira ticket; cross-connector view confirms triage. | ## Reconciling against the vendor's own dashboard **Where to look in Costco's own portal:** [Costco Supplier Portal](https://www.costco.com/supplier) → **Item Master → My Items** filter to *Status: Delisted, Last 7 days*. The portal exposes the same item-master records the card reads via the API or SFTP feed. Counts should reconcile to the unit; gaps usually mean the supplier's item-master ingest is stale. **Why our number may legitimately differ from Costco's portal:** | Reason | Direction | Why | | ------------------------------- | -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | **Item-master sync lag** | Ours sometimes lower | Item-master changes flow through Costco's daily file or hourly API poll. If the supplier's ingest is on a 24-hour cadence, the portal can show today's delistings while the card waits for tomorrow's sync. | | **Status definition** | Either | Costco distinguishes `delisted` (range cut, can be re-listed) and `discontinued` (permanent). Some portal views aggregate the two; the card counts the active → delisted transition specifically. | | **Region scope** | Ours sometimes lower | Costco SIP has US, Canada, Mexico, UK, and AU regions. The card reads the integration scope; if the supplier only integrated US-region SIP, Canadian delistings do not appear. | | **Pending-review intermediate** | Either | Some delistings flow active → pending-review → delisted over 2 to 4 weeks; the portal sometimes shows them in the pending-review state during the transition while the card already counts them as delisted. | **Cross-connector reconciliation:** | Card | Expected relationship | Causes of legitimate divergence | | -------------------------------------------------------------------------------- | ------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------- | | [`shopify.product_sales_velocity`](/nerve-centre/shopify/product_sales_velocity) | DTC velocity for the same SKU. | Strong DTC velocity does not save a Costco listing; Costco's velocity threshold is per-item-per-store and DTC sales do not count. | | [`jira.tracker_open_issues`](/nerve-centre/jira/tracker_open_issues) | One open ticket per delisted item is the healthy state. | Triage gap if delisted-item count exceeds open-Jira-ticket count referencing those items. | ***
Documentation cross-reference (for retailers running multiple wholesale programs) Item-delisting metrics exist with conceptually similar definitions across other wholesale programs. * [`walmart_dropship.wm_items_delisted_week`](/nerve-centre/walmart_dropship/wm_items_delisted_week) (US wholesale peer) * [`amazon.amzn_listings_oos`](/nerve-centre/amazon/amzn_listings_oos) (marketplace peer; different mechanic)
## Known limitations / merchant FAQs **An item showed as delisted yesterday and is back to active today. Did the dial double-count?** The card counts active → delisted transitions in the period; if Costco reactivated the item, the active → delisted transition still counts. The reactivation is good news for the supplier but does not zero the delisting event. Use the drill-down to see the status-change history for each item. **Costco delisted an item without a reason code. How do I find out why?** Direct buyer conversation is the only path. Reason codes are populated for the most common Costco-side automated flags (`velocity_below_threshold`, `gtin_invalid`, `compliance_failure`); buyer-team curation cuts often arrive with no code. Email the buyer within 1 to 2 days of delisting; later than that the buyer has typically moved on and reactivation conversations need a new commitment cycle. **My item shows delisted but customers can still buy it on costco.com. What gives?** Two possibilities. (1) **In-store delisting only.** Costco's warehouse-club shelf and costco.com online range are managed separately by different buyer teams; an item can be delisted from warehouse-club while remaining listed online (or vice versa). The item-master flag in this card reflects the warehouse-club status by default. (2) **Existing inventory sell-through.** A delisted item is no longer ranged for new POs, but Costco may still be selling through inventory in stores or DCs for several weeks; the consumer-facing experience lags the buyer decision. **Should I treat `velocity_below_threshold` differently from `category_review_cut`?** Yes. `velocity_below_threshold` is a performance-based delisting; reversal requires presenting evidence that velocity was depressed by an explainable cause (off-shelf, location reset, pricing) and proposing a fix. `category_review_cut` is a strategic decision; reversal is harder because the buyer has decided to refresh the range, but the supplier can propose an alternative SKU. Different reasons, different conversations, different probability of reversal. **The dial says 3 delisted but the supplier portal says 5. Why the gap?** Most likely two of the five were `pending_review` → `delisted` transitions where the pending-review state lasted longer than the supplier's item-master sync cadence (24 hours typical). The portal shows 5 because it can see all 5 transitions; the card may show 3 because the sync only saw the active → delisted snapshot for 3 of them. Force a refresh or extend the integration look-back window. **Costco issued a `case_pack_change` delisting. The case-pack changed because Costco asked us to change it. Why are we being delisted?** Process gap. Costco's request for a case-pack change goes through the buyer; the supplier needs to update the case-pack in Costco's item-master through the corrected item-master sync file before the deadline. If the supplier does not update by the deadline, Costco's automated process delists the old case-pack record. The fix: submit the corrected item-master, request reactivation through the buyer; reversible within 2 to 4 weeks if caught quickly. **Can I prevent `gtin_invalid` and `compliance_failure` delistings?** Mostly yes. (1) `gtin_invalid` triggers when the GTIN on the item-master record fails check-digit validation or is duplicated across items. Add GTIN validation to the supplier's item-master submission process; this prevents most occurrences. (2) `compliance_failure` triggers when Costco's compliance team flags an item for label, claim, or testing-document gaps. Maintain compliance documents (FDA, FCC, CPSC as applicable) and refresh annually. Both classes of delisting are usually preventable through process discipline; `velocity_below_threshold` and `category_review_cut` are commercial decisions and require commercial response. **My delisted-count is consistently rising over months. What do I do?** Treat as a strategic signal. Rising delisting count suggests the portfolio is losing buyer favour systematically (range refresh underway, competitor encroachment, pricing pressure, packaging dated). Three responses: (1) commission a portfolio review with the Costco buyer team for next quarterly meeting, (2) prioritise new SKU proposals to backfill the cuts, (3) review pricing and packaging vs the categories the buyer is favouring. The dial is the symptom; the buyer relationship is the lever. **Does the count include items delisted from costco.com but still active in warehouse-club?** The default integration scope is the unified item-master record, which has separate flags for warehouse-club (`is_active_warehouse`) and online (`is_active_online`). The card reads the consolidated `current_status` which goes to delisted only when both flags are off. Configure the integration to read either channel separately if your business case differs. **Should I get paged on every new delisting or only on bursts?** Every delisting, but route to a Slack channel or Jira queue rather than a phone-page. The 24-hour response window is operationally important (buyer conversations are easier same-day than 5 days later) but a single delisting is not a P1 incident; bursts (>3 in 24 hours) are P1 and warrant the [Item Delisting Burst (24h)](/nerve-centre/kpi-cards/costco-sip/item-delisting-burst) alert. *** ### Tracked live in Vortex IQ Nerve Centre *Items Delisted This Week* is one of hundreds of KPI pulses Vortex IQ tracks across Costco SIP and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English. [Start for free](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.