Inventory Health Score Calculator

What is an inventory audit — and why does it matter for Shopify stores?

An inventory audit is a full review of every SKU in your catalog, looking for products that are costing you more than they earn. For most Shopify stores, that means dead stock that hasn't sold in 90 days or more, listing gaps like missing images and empty descriptions, and variants nobody ever picks — sizes, colors, or styles that just sit there taking up space in your admin.

The average Shopify store carries between 18% and 25% dead inventory at any given time. On a 500-product catalog at $40 average cost per unit with 10 units per SKU, that's roughly $36,000 sitting on shelves doing nothing. That capital could be in a new product line, reinvested in paid ads, or just out of your bank account and not tied up in inventory.

The five signals in a catalog health score

This tool uses the same five-signal model ShelfMerge applies to live Shopify data. Dead inventory gets the heaviest weighting at 35% because it's the most capital-intensive problem. Dead variants follow at 20% — zero-sale variants inflate your SKU count, confuse shoppers, and waste reorder budget. Missing images carry 15% because products without photos have conversion rates 40–60% below the category average. Missing descriptions add 10% because they hurt both SEO ranking and shopper confidence. Duplicates and cannibalization each contribute 10%, capped at a sensible threshold so one bad product pair doesn't dominate the score.

How ShelfMerge automates your inventory audit

When you connect your Shopify store, ShelfMerge pulls your full order history and product catalog using the Shopify Admin API — read-only, no write access required. Five analysis engines run in parallel: dead inventory classification by sales velocity, variant performance by SKU-level order data, image and description gap detection, duplicate product identification using title and tag similarity, and cannibalization scoring using Pearson correlation on weekly sales. Your first health score appears in under 60 seconds.

Unlike a one-time spreadsheet audit, ShelfMerge recalculates daily. You get a weekly digest email when your score drops, new dead inventory appears, or a cannibalization pair emerges. The dashboard shows score trends over time so you can see whether catalog cleanups are actually working.

Store owners who complete their first cleanup cycle — removing dead variants, filling listing gaps, and archiving dead products — typically see health scores jump 15–25 points within 30 days. That's not just a better number; it's less wasted ad spend, faster page load times from a leaner catalog, and improved Shopify search ranking for products that actually sell.

Common questions about inventory audits