Free Tool
Inventory Health Score Calculator
Five inputs. One score. Know which parts of your Shopify catalog are bleeding money before your next reorder.
Researched by the ShelfMerge Research Team
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
How to use this inventory audit tool
Install from the Shopify App Store
OAuth takes 30 seconds. ShelfMerge requests read_products and write_products scopes — nothing more. No credit card for the Free plan.
Run your first scan
ShelfMerge pulls your full product catalog and runs all three detection layers simultaneously. A 2,000-product store scans in under 8 seconds.
Review duplicates, merge in bulk
Duplicates are grouped by confidence score. Select a group, pick the primary product, click Merge. The duplicate is archived and variants consolidated. Click Undo at any time.
Common questions about inventory audit
Will ShelfMerge permanently delete my products?
No. ShelfMerge archives the duplicate product — it moves to Archived status in your Shopify admin and remains fully recoverable. Before any merge, ShelfMerge creates a complete snapshot of both products. You can restore to the exact pre-merge state from the Merge History tab at any time.
How does fuzzy title matching work without creating false positives?
We use Levenshtein distance with a configurable threshold (default 85% similarity). Every match is assigned a confidence score from 0-100%. Matches above 95% are "High confidence". Matches below 70% are flagged "Review needed". You always see the score before deciding to merge.
Does ShelfMerge work with stores that have thousands of products?
Yes. We use cursor-based pagination against the Shopify Admin API with a built-in rate limiter (2 req/s, burst 40). A 10,000-product store scans in under 60 seconds. The Agency plan is tested against catalogs up to 50,000 products.
What happens to variant inventory when I merge products?
Variants from the duplicate are consolidated onto the primary product. Inventory quantities are summed. Pricing, weight, and fulfillment settings from the primary product take precedence. The merge preview shows exactly which variant data will change before you confirm.
Get your real score — connect your Shopify store
ShelfMerge connects directly to your Shopify store and runs this analysis automatically — across your entire catalog, updated daily.
Free plan — no credit card required.