SKU Rationalization: A Keep, Fix, Bundle, or Retire Scorecard

SKU rationalization is a structured review of which variants to keep, fix, bundle, pause, or retire. The goal is not a smaller catalog at any cost; it is a catalog where complexity earns its keep. Source

Table of Contents

• Prepare one reconciled SKU dataset
• Score six dimensions from 0 to 2
• Route each SKU into a decision lane
• Investigate false positives before retiring
• Review on a stable cadence with safeguards
• Use tools that preserve SKU identity
• FAQ

Prepare one reconciled SKU dataset

Build one row per sellable SKU and reconcile identifiers, sales, margin, returns, inventory, stockouts, and strategic role before scoring. The same SKU should represent the same sellable item across storefronts, marketplaces, warehouses, purchasing records, and reporting systems. Source

Use a consistent identifier, variant description, product family, channel availability, and lifecycle status. Shopify’s SKU guidance emphasizes consistent SKU use for inventory tracking and reporting. A split identifier can make one variant appear to be several weak products, while a reused identifier can hide different economics inside one row.

Prepare, at minimum:

• Units sold and net sales for a comparable period
• Contribution margin after relevant fulfillment, marketplace, payment, and promotional costs
• On-hand, committed, inbound, and aged inventory
• Stockout days and estimated lost availability
• Return rate, refund reasons, support contacts, and defect signals
• Pick-pack, kitting, storage, and replenishment requirements
• Product family, substitutes, complementary products, and strategic role

Keep the measurement window, currency, cost basis, and channel scope stable. A short period can overreact to promotions or stockouts, while a long period can hide a recent quality or demand change. Inventory valuation also requires consistency: the IRS inventory accounting guidance illustrates why the cost method and its application should remain consistent when comparing inventory performance.

Score six dimensions from 0 to 2

Score evidence in separate dimensions so a bestseller cannot hide destructive returns or a low-volume item’s strategic role. SellerTrove’s scorecard is a decision aid, not a universal formula. It is an operating template for making evidence visible, not a replacement for judgment, category context, financial controls, or dependency checks.

Use 0, 1, or 2 in each dimension, with 2 representing favorable evidence:

Do not create a universal retirement cutoff. A total score can sort the review queue, but it should not make the decision alone. A strategically important SKU with weak demand may need a fix or bundle. A high-demand item with poor returns may need a quality correction. A profitable item with excessive inventory may need a purchasing or replenishment change. Source

Route each SKU into a decision lane

Route each SKU to keep, fix, bundle, pause, or retire only after checking dependencies and replacement risk.

Each lane also needs an operational instruction. “Retire” might mean stop purchasing, sell through existing inventory, archive the listing after stock reaches zero, and redirect customers to an approved substitute. “Fix” might mean correcting photography, price architecture, packaging, quality, discoverability, or replenishment. Source

Investigate false positives before retiring

Low sales do not automatically mean retire: stockouts, poor discoverability, wrong price, or a missing size can suppress demand. A SKU may look weak because customers could not find it, could not buy it, or did not see a credible reason to choose it.

Before retirement, check whether the SKU was available throughout the review period, received sufficient impressions and search visibility, had complete images and specifications, and was priced appropriately for its positioning. Also check missing adjacent sizes, colors, accessories, compatibility options, fulfillment delays, listing errors, channel restrictions, and seasonal or regional demand.

When the cause is plausible and measurable, use a controlled fix. Improve the listing, adjust the pack size, test a bundle, or correct replenishment, then define the evidence required to keep the SKU. If the cause cannot be tested or dependency risk is high, use pause instead of an irreversible decision.

Review on a stable cadence with safeguards

Review on a stable cadence and preserve a decision log, owner, effective date, and rollback trigger. Quarterly portfolio reviews provide stable evidence for many businesses, while monthly exception reviews can catch stockouts, quality issues, abrupt margin changes, and excess inventory sooner. Seasonal products should be compared with comparable seasonal periods. Source

Require a second review for strategic items, regulated products, core size runs, and SKUs tied to bundles or subscriptions. Set rollback triggers such as conversion decline, increased support contacts, lost attachment sales, or substitute-product stockouts. Separate leading indicators such as availability, impressions, price position, and listing completeness from lagging outcomes such as margin, returns, aged inventory, and service effort.

Use tools that preserve SKU identity

Inventory and profitability tools help when they preserve SKU identity across channels and expose the evidence behind the score. Start with SellerTrove’s inventory resources for stock, turnover, and availability analysis, and use the pricing resources when price architecture or margin pressure is part of the diagnosis.

The inventory turnover page helps frame how quickly inventory moves relative to its cost base. The DIO page translates inventory levels into days of capital tied up. These are signals, not standalone retirement rules.

Use the Stack Builder to connect storefront, inventory, analytics, and profitability systems when evidence is distributed. The key capability is traceability: every score should lead back to a SKU, period, calculation, and source record. Background literature also places SKU rationalization within retail and ecommerce assortment management, as shown in this SKU rationalization reference. Apply the method to your own economics and constraints rather than copying an external cutoff.