StockSweep StockSweep | Help Center

Dead Stock Table (filters, saved views, bulk actions)

Use the dead stock list as a workflow: filter, sort, select, act, and track outcomes.

Last updated: February 21, 2026

Contents
Show all sections (25) ▼

The Dead Stock Table is your workbench for processing dead stock. The goal is not browsing — it is running a safe, repeatable workflow every week.

Estimated time: 7–10 minutes

What you'll accomplish

  • Understand every column and what it tells you
  • Use filters to isolate high-urgency, high-value inventory
  • Master bulk selection (checkboxes, shift+click, select all)
  • Apply actions in batches safely and verify outcomes

Requirements

  • Detection has run at least once (auto or manual)
  • Initial sales history sync is complete (status: Completed)

Table columns

Column What it shows
Product Product title from Shopify
Variant Variant title (size / color / etc.)
Days without sale How many days since the last qualifying sale. Default sort column (highest first)
Last sale date The date of the most recent qualifying order for this variant
Inventory on hand Current stock quantity in Shopify
Inventory value Frozen capital contribution: inventory on hand x cost per item
Severity badge Color-coded: yellow (30–59 days), orange (60–89 days), red (90+ days)

The table is paginated at 50 items per page. You can sort by any column by clicking its header.

Bulk selection

The table supports three selection methods:

  1. Individual checkbox — click the checkbox on any row to select/deselect it
  2. Shift+click — hold Shift and click a second checkbox to select the entire range between your first and second click
  3. Select all — click the header checkbox to select all items on the current page

Selection persists across pagination — if you select items on page 1 and navigate to page 2, your page-1 selections are preserved.

When items are selected, a sticky toolbar appears at the bottom of the table showing:

  • Selected item count (e.g., "23 items selected")
  • Apply discount button
  • Exclude button (archive selected items)

Smart filters

Use smart filters in the toolbar to quickly select groups:

  • "Select all 90+ days" — selects all items in the 90+ aging bucket
  • "Select all [Category]" — selects all items in a specific product type (e.g., "Select all Apparel")

These filters respect your current table filter state, so you can combine them: filter to 90+ days → then "Select all Apparel" to target a specific category within that age range.

Filters

Age / bucket filter

Multi-select dropdown with options: 0–30, 31–60, 61–90, 90+ days. Start with the oldest bucket to avoid discounting items that might sell naturally.

Category filter

Searchable dropdown of Shopify product types. Use it to focus on one product category at a time, which helps you test discount strategies per category.

Status filter

  • Active — items you can take action on (default view)
  • Excluded / Archived — items you intentionally removed from the active list

Clear all filters

One-click button to reset all filters to defaults.

  1. Filter to 90+ days using the age filter
  2. Sort by inventory value (highest first)
  3. Select a batch of 10–50 items (use shift+click for speed)
  4. Click Apply discount in the sticky toolbar
  5. Choose a percentage (start with 10–20%) and review the preview
  6. Confirm — then check Discount History after 24–72 hours

Bulk actions

Apply discount

Select items → click Apply discount → choose a preset (5%, 10%, 15%, 20%, 25%, 30%) or enter a custom percentage (up to 90%) → review the preview modal → confirm.

Processing behavior:

  • < 10 items: processed synchronously, results appear immediately
  • 10+ items: processed asynchronously in the background to respect Shopify API rate limits. You will see a progress indicator. Do not close the page.

After applying, items appear in Discount History with status Active.

Exclude / Archive

Select items → click Exclude to remove them from the active dead stock list. Use this for:

  • Seasonal inventory you do not want to discount yet
  • Items you plan to bundle, re-merchandise, or return to supplier
  • Products with brand restrictions on discounting

Excluded items move to the Excluded status filter view. If an excluded item had an active discount, excluding it also triggers tag cleanup for sale collections.

Restore (undo exclude)

In the Excluded view, select items → click Restore to move them back to the active list.

CSV export

Click the Export CSV button to download your dead stock data. The export respects your current filter selections.

Export size Behavior
< 1,000 rows Immediate download as a CSV file
1,000+ rows Processed asynchronously; you receive an email notification with a download link when ready

Exported columns: product, variant, days without sale, inventory value, product category, last sale date.

How to verify results

After applying a discount:

  1. Open one affected product in Shopify Admin → Products and confirm the compare_at_price shows the original price and the price shows the discounted price (creating the "Was $X, Now $Y" strikethrough on your storefront)
  2. Check Discount History to see the operation — each item should show status Active with the correct percentage
  3. If you use sale collections, confirm the item has the "clearance" tag and appears in your collection

After excluding items:

  1. Switch to the Active status filter — excluded items should not appear
  2. Switch to the Excluded filter — your items should be there
  3. If the excluded item had an active discount, check that sale collection tags were cleaned up

Troubleshooting (symptom-first)

"I applied a discount but only some items updated"

Likely cause: Shopify API rate limits caused some items in a large batch to fail. Fix: go to Discount History, identify the failed items, select only those items, and retry with a smaller batch. How to confirm: all targeted items show status Active in Discount History.

"Items disappeared from the list after detection ran"

Likely cause: those items sold (so they no longer qualify as dead stock), or detection updated their status. Fix: clear all filters first. If items genuinely sold, this is expected behavior — check the Discount History for "Sold" entries. How to confirm: items with recent sales are correctly removed from the dead stock list.

"Selection is lost when I change pages"

Likely cause: this should not happen — selection persists across pagination. Try refreshing the page. Fix: refresh and re-select. If the issue persists, contact support. How to confirm: select items on page 1, navigate to page 2, return to page 1 — your selections remain.

"Export CSV is taking a long time"

Likely cause: exports with 1,000+ rows are processed asynchronously. Fix: wait for the email notification with the download link. Check your spam/promotions folder. How to confirm: you receive an email with a working download link.