Inventory Friction Audit Framework
Co-Founder & CEO
What Is Inventory Friction?
This framework shows you how to find it in minutes and how to calculate a single number that tells you exactly how bad the problem is.
Inventory friction is what happens when a customer lands on your store and can't buy what they came for. A sold-out product in a prime collection position. An ad pointing to a product with no stock. A size run so depleted it might as well be gone.
Most brands don't know how much friction they have because Shopify doesn't surface it. You'd have to manually check every collection, every product, every variant to find it. Nobody has time for that.

The Friction Rate Formula
The friction rate is a single number that tells you what percentage of your catalog is actively working against conversion.

| Friction Rate | Severity | What It Means |
|---|---|---|
| 0-10% | Healthy | Minor gaps, manageable |
| 10-20% | Moderate | Noticeable revenue impact |
| 20-30% | High | Significant conversion loss |
| 30%+ | Critical | Immediate action required |
The 5-Step Audit Methodology
This is the exact process used to audit any Shopify store for inventory friction in under 10 minutes.

1. Pull the full catalog using Shopify's public API
Every Shopify store exposes its product data at: yourdomain.com/products.json. This gives you every product, every variant, and every availability status without needing login access.
2. Calculate the friction rate
Count fully sold-out products (zero inventory across all variants). Count partially sold-out products (missing key variants). Divide by total products and multiply by 100.
3. Audit the top 10 positions per collection
The top 10 positions in your highest-traffic collections are where the most damage happens. A sold-out product at position 1 means every customer who lands on that page hits a dead end immediately.
4. Find cross-collection contamination
The same depleted product appearing in multiple collections multiplies the damage. If your sold-out hoodie is in Best Sellers, New Arrivals, AND Sale — that's three separate traffic sources hitting the same dead end.
5. Check ads against inventory
Go to Meta's Ad Library (facebook.com/ads/library), search the brand name, and click through active ads. If the ad points to a sold-out or partially sold-out product, that's quantifiable wasted ad spend. Brands typically lose 10-15% of their monthly ad budget this way.
Manus Prompt
Copy and paste this prompt directly into Manus, Claude, or Gemini to run a full inventory friction audit on any Shopify store. Replace [STORE URL] with the brand's actual domain. Results may vary based on the LLM.
Run a full inventory friction audit on [STORE URL].
Step 1: Access [STORE URL]/products.json to retrieve the full product catalog.
Paginate through all pages if needed (?page=2, ?page=3 etc).
Step 2: For each product calculate:
- Total variant count
- Number of fully sold out variants (inventory_quantity = 0)
- Whether the product is fully sold out (all variants at 0)
- Whether the product is partially sold out (some key variants at 0)
Step 3: Calculate the overall friction rate:
Friction Rate = (fully sold out + partially sold out) / total products x 100
Step 4: Audit the top 10 positions in these collections:
/collections/all, /collections/new-arrivals, /collections/best-sellers,
/collections/sale (adjust collection handles to match actual store)
Flag any sold out or partially sold out products in prime positions.
Step 5: Identify cross-collection contamination:
Flag products that appear depleted in 2 or more collections simultaneously.
Step 6: Deliver results as:
- Overall friction rate with severity rating
- Top 3 most critical findings with specific product URLs
- Collection-level summary table
- Business impact summary
How to Check Ads Against Inventory
This connects the inventory problem directly to wasted ad spend. Here's how to do it in 5 minutes.
- Go to facebook.com/ads/library
- Search the brand name and filter by Active ads
- Click through any ad featuring a specific product
- Check whether that product is in stock, partially sold out, or fully sold out
- Screenshot both the ad and the product page

Beyond Stockouts and Other Friction Points
Inventory friction is the most urgent problem but it's not the only one worth flagging in a store audit.

What Akikumo Does
Akikumo is a Shopify merchandising intelligence tool that catches everything in this framework automatically and fixes it.


