We wrote a quick Python audit script to inspect 50 well-known public Shopify D2C storefronts (/products.json?limit=50) and check two simple conversion leaks:
- Out-of-stock products still occupying prime top-25 catalog positions
- Active sale pricing formatting (whether discounts use
.99/.95psychological endings vs. raw.40/.85decimals)
Out of 32 live stores where /products.json was accessible, the numbers were higher than expected:
- 19 out of 32 stores (59.4%) had completely Sold-Out products (all variants
available: false) sitting in their top 25 default catalog slots — including rank #1 on several multi-million-dollar brands. - 29 out of 32 stores (90.6%) had either fully sold-out items or broken popular size/color variants in their top 25 positions.
- 24 out of 32 stores (75.0%) were actively running compare-at-price markdowns, and 14 of those 24 stores had unrounded discounted prices like
$275.40,$65.40,$201.60,$68.80,$23.80, and$14.40instead of clean.99/.95endings.
3 Concrete Fixes You Can Apply in 10 Minutes
- Check why "Best Selling" sort traps your collection: Even if you try dragging products manually in Shopify Admin, if a collection's
sortOrderis set toBEST_SELLING, old bestsellers that just went out of stock stay pinned at the top of page 1 — burning paid Meta/Google ad clicks on 0-inventory pages. - Don't just hide OOS permanently — preserve pre-stockout rank: If your #2 hero product sells out for 5 days and drops to position #180, you lose momentum unless it snaps back near its original rank when inventory arrives.
- Psychological
.99/.95rounding + Anchor Guard on flash sales: If you run 15% or 20% off weekend drops on already-marked-down SKU batches, double-discounting silently kills margin unless your discount computes strictly off an original pre-sale price snapshot.
For agencies and outbound teams working with e-commerce brands: checking a store's /products.json for a #1 Sold-Out SKU takes 2 seconds and gives you a concrete, verifiable opener instead of a generic pitch.
Free Tools & Sample Data
If you want to inspect any Shopify storefront's catalog, stock availability, and app pixels yourself:
- Chrome Extension (
activeTab-only, zero background tracking): Shopify Product CSV Exporter & Theme Spy - Free 246-Row B2B & E-Commerce Sample CSVs (no email gate): Interactive Data Explorer
- Automated Shopify Merchandising & Pricing Tools: SortFlow Collection Merch & PriceGuard Margin & Pricing
Have you checked how many out-of-stock SKUs are sitting on page 1 of your Shopify collections lately?