Analyzes Medium All plans Not yet verified on a live store

Dead Stock and Clearance Plan

/dead-stock  Finds products with stock but no sales in 90 days and proposes a clearance plan: bundle, discount, or remove.

Add to Sidekick

Add opens your Shopify admin with the skill prefilled; review it there and click Add. If nothing appears, use Copy and follow the steps below.

The skill

Suggested shortcut: /dead-stock
Find my dead stock and propose a clearance plan.

## Steps
1. Pull inventory by variant and units sold in the last 90 days. Select variants with more than 5 units on hand and 2 or fewer units sold.
2. Value the stock using cost per item where set, otherwise price, and say which. Rank by stock value.
3. For each of the top 15 by value, propose one action: bundle with a related best seller (name it), discount (suggest a percentage that keeps margin above cost if cost is known), feature in an email or on the homepage, or mark for removal. Give one reason each.
4. Estimate the cash that clearing the top 15 at the proposed discounts would release.

## Output
A table: product, variant, on hand, sold in 90 days, stock value, proposed action, reason. Then the cash estimate.

Do not create discounts, bundles or edits in this skill. Ask before anything is changed.
How to add it to Sidekick
  1. Click Add to Sidekick above. Your Shopify admin opens with the skill ready to review. Click Add. Done.
  2. If the button does nothing in your store: click Copy skill, open Sidekick in your admin, type /, choose Create new skill, name the shortcut dead-stock, paste the text as the instructions, and save.
  3. To run it, type /dead-stock in Sidekick. Sidekick keeps up to 25 skills; manage yours from the skills menu.

What you get

A prioritized list of what is sitting on the shelf and what to do about each item, with a rough cash-release number to justify the effort.

When to use it

Quarterly, and before peak season when you want shelf space and cash for winners.

Variations

  • “Exclude seasonal products” if you hold stock for next year on purpose.
  • Turn the plan into a sale with /flash-sale.

Limits

Products that sell in-person through POS may look dead online if POS sales are not attributed to variants correctly.

Status: Written for Sidekick but not yet run on a live store. Results may need a second prompt. Time saved: about 1 hour / quarter.

Author: MerchantSkill · License: CC0, no attribution needed · Updated: 19 Sept 2026 · Raw markdown

Report a problem or suggest an edit

Related skills

/cover Analyzes Medium

Days of Cover by Product

Shows days of stock cover for every active product, sorted from shortest to longest, with sales rate and stock value.

Inventory Not yet verified
/top-products Analyzes Easy

Top and Declining Products

Ranks products by revenue and units, flags fastest growers and decliners, and checks stock on the winners.

Analytics Not yet verified
/flash-sale Executes Advanced

Flash Sale in One Task

Builds a flash sale end to end: sale collection, automatic discount with start and end, and an email draft, with one approval.

Promotions Not yet verified
/discount-code Executes Easy

Create a Discount Code

Creates a percentage or fixed discount code with dates, limits and eligibility in one go, after checking for clashes.

Promotions Not yet verified
Add to Sidekick