Excess Inventory on Shopify: What to Clear, Bundle, or Keep

Excess inventory is stock you hold beyond what you expect to sell within your target cover. To deal with it on Shopify, work out the surplus units for each SKU, find out why they exist, and choose the cheapest way out. Stopping the next purchase order comes first, because every new unit makes the surplus larger.

Excess stock differs from dead stock. A slow SKU that sells two units a week can still be excess if you hold three years of it. A SKU with no sales in the period is dead stock, and it sits at the top of the list. For how long units have been sitting by receipt date, use an inventory aging report. This guide answers a different question: how many units are too many, and what you do with them.

Overstock has a real price. IHL Group estimated that retailers lose $1.77 trillion a year to inventory distortion, as reported by Supply Chain Dive. That number combines stockouts and overstocks across global retail, so it is a sign of scale and not a Shopify benchmark.

Work out how many units are too many

Set a target cover for each SKU: the number of weeks of stock you want on hand. It should cover your supplier's lead time, your review cycle, and a buffer. A fast seller from a slow supplier needs more weeks than a slow seller you can reorder in days. The reorder point guide covers the lead-time side.

Excess units are what you have on hand minus what that cover requires.

Excess units = units on hand − (units sold per week × target weeks of cover)

Here is a hypothetical catalog with a 12-week target. The cash column uses unit cost, because that is the money you already spent.

This store has $7,374 in excess, and more than half of it sits in one scarf. The mug is short of its target, which is why a store can carry excess stock and stockouts in the same week.

Find the surplus in Shopify

Three reports get you most of the way. All of them sit in Shopify's inventory reports under Analytics > Reports.

1. Open Inventory remaining per product and sort by days of inventory remaining. Variants with no sales in the period show N/A, because Shopify has no sales pace to project. Treat those as your first candidates.
2. Open ABC product analysis. Shopify warns that overstocking C-grade products, the ones that make up the last 5% of revenue, can cost you more in warehousing than they earn.
3. Open Products by sell-through rate and look for low rates on variants with high ending quantities. The [sell-through guide](/blog/sell-through-rate) explains how to read the number.

To do this across the catalog in one pass, paste your units sold and stock left into the free sell-through rate calculator. It adds weeks of supply for every product and marks the ones to mark down: anything with no sales in the period or more than 26 weeks of supply.

Find out why it happened

The exit depends on the cause, and a discount on a product that was never seen just gives margin away.

Three guides go deeper on these causes: inventory forecasting for a buy that was too big, economic order quantity for supplier minimums, and traffic but no sales for a page that does not convert.

Choose the cheapest exit first

Work down this list in order. Each step costs more margin than the one before it.

1. Stop the inflow. Cancel or delay open purchase orders for that SKU. This costs nothing and protects cash at once.
2. Add exposure. Move the SKU up in collections, feature it in email, and send paid traffic to it if it converts.
3. Bundle it. Pair a slow SKU with a fast one, using the [bundle pricing guide](/blog/bundle-pricing-strategy-shopify) so the bundle does not strand your bestseller.
4. Discount that SKU. Shopify's [discount types](https://help.shopify.com/en/manual/discounts/discount-types) let you take an amount off a product or a collection, or run buy X get Y. Use the [SKU discount gate](/blog/ecommerce-discounts-sku-decision) to decide the depth and when to stop.
5. Sell it in bulk. Offer it to a wholesale buyer, an outlet, or a liquidator. You recover part of the cost and clear the space in one move.
6. Donate or write it off. Use this for the stock nobody will buy. Ask your accountant how to record it, because the treatment depends on where you operate.

Set a price floor before you discount

Work out the lowest price you can accept before you start. For most SKUs, the floor is what the sale costs you: the unit's shipping, payment fees, and packaging. The unit cost is already spent, so a sale above that floor still returns cash even if it books a loss on paper. The contribution margin guide shows how to build that number.

Then compare the discount against the cost of waiting. Take the scarf from the example, at a hypothetical price of $40. At 2 units a week, its 276 excess units would take 138 weeks to clear. A 30% discount brings the price to $28 and still leaves $14 above unit cost before shipping and fees. If that discount doubles the pace to 4 a week, the surplus clears in 69 weeks, which is still too slow. That result tells you to add a bundle or a bulk sale and to stop relying on price alone.

Holding stock has its own cost in storage, insurance, and risk, and the inventory carrying cost guide shows how to estimate it for your store.

Stop it coming back

• Set a target cover per SKU and check it before every purchase order.
• Buy a new product in a smaller first order, then reorder from real sales.
• Keep a written reason on any buy above your forecast.
• Review the excess list each month and more often during your peak season.
• Sort the list by cash, because a small number of SKUs usually holds most of it.

How to tell the plan worked

Compare the same list a month later. Excess units should fall, the cash in excess should fall, and your best sellers should not run short. Check the margin too: a cleared SKU that sold below its floor is a loss you chose, so write down why.

Stock Intelligence keeps sales pace and stock levels current for every product, so the list stays up to date without a monthly export.