Upload your Shopify data and get a plain-English breakdown of which products are working, which are draining your cash, and what the numbers actually mean.
This tool requires pulling two custom reports from ShopifyQL — that's easiest from a computer.
Save this link and we'll remind you. We'll also send you the exact queries to copy so you're set up in under 5 minutes when you're back at your desk.
Most founders know something is off. They just don't know which products are the problem, how much cash is tied up, or what to do first. This tool answers all three.
What you'll find out
Three things most founders don't know about their own inventory
The analyzer surfaces the signals that take consultants days to find manually — in under 5 minutes, from your actual Shopify data.
Output 01
Exactly how much cash is sitting in products that aren't moving
Every product with over 16 weeks of supply or no recent sales is flagged with its inventory value. Not a percentage. The actual dollar amount — so you know what you're working with.
Output 02
Which products are carrying your revenue — and which aren't earning their keep
Your top performers ranked by weekly velocity, not total revenue. A style that launched 3 weeks ago and is selling fast ranks above one that's trickled all season. New winners surface immediately.
Output 03
How your metrics compare to healthy apparel benchmarks
Sell-through, weeks of supply, gross margin, discount rate — each shown against real apparel benchmarks. You'll know not just what your number is, but whether you should be concerned.
How it works
Three steps. Five minutes at your desk.
No integrations, no API keys. Two CSV exports from Shopify and you're done.
1
Run two ShopifyQL queries
The tool gives you the exact queries to paste into Shopify's report builder. One pulls 120 days of sales. One pulls your current inventory snapshot.
Analytics → Reports → Create custom report → paste query → export CSV. About 2 minutes each. The queries are ready to copy — no editing required.
2
Upload both files and enter your email
Upload both CSV exports, enter your brand name and email. Everything is analyzed in your browser — your data never leaves your computer.
Email required to access your results and receive your PDF report.
3
Review your report and download the PDF
Headline metrics, products to review, top performers, and a full SKU breakdown — each with benchmarks and plain-English flags so you know what to act on.
Download a branded PDF to save, share, or bring to your next planning session.
Built from 15 years of frameworks used at
Walmart
Ralph Lauren
Gap
Saks Fifth Avenue
HBC
Gilt.com
What it measures
Every metric — with apparel benchmarks
Each metric comes with a plain-English explanation and a real benchmark so you know exactly what healthy looks like for a brand like yours.
⏱
Weeks of Supply
How long current inventory will last at your current rate of sale. Flags stockout risk and overstock per SKU.
Healthy: 4–12 wks (varies by lead time)
📊
Estimated Sell-Through %
Units sold ÷ (sold + on hand). Shows how efficiently each product moves — estimated, does not include on-order.
Healthy end-of-season: 70–80%
💰
Gross Margin %
Gross profit ÷ gross sales. Only shown where COGS is entered in Shopify, with a data quality flag if missing.
Healthy DTC apparel: 75%+
🏃
Weekly Velocity
Average units sold per active week — not per total weeks. New launches measured fairly against established styles.
Used to rank top performers
🏷
Discount Rate %
Discounts ÷ gross sales. High rate on a slow mover means discounting isn't driving velocity — it's compressing margin.
Review if over 20% on a specific product
📦
80/20 SKU Concentration
How many SKUs drive 80% of your velocity. Shows if your range is working or spreading OTB dollars too thin.
Typical: 20–30% of SKUs = 80% of velocity
What founders say
The system that changes how you see your business
"Bellamy helped us uncover over $80K stuck in inventory. Her approach is both strategic and practical."
DA
Founder
DTC Apparel Brand
"I think you're a genius. The data is changing my life."
MC
COO
Health & Wellness Startup
"Thanks to your guidance, our teams are now making data-driven decisions. The visibility we now have is something we didn't know we were missing."
JR
COO
Wholesale Retailer
You're on mobile
Save this for when you're at your desk.
This tool requires pulling two custom reports from ShopifyQL — that's easiest from a computer. Drop your email and we'll send you the direct link plus the exact queries to copy. You'll be up and running in under 5 minutes.
No spam. A few follow-up emails about inventory planning — unsubscribe any time.
✓
You're all set.
Check your inbox — we've sent you the analyzer link and the two ShopifyQL queries ready to copy. When you're back at your computer you'll be up and running in under 5 minutes.
Your inventory is trying to tell you something. Find out what.
Free. Takes 5 minutes. Requires a Shopify store and two quick CSV exports.
Enter your email to access results and receive your PDF report
Your data is analyzed entirely in your browser and is never sent to a server. Sell-through and weeks of supply are estimates based on Shopify export data and do not account for inventory on order. All metrics are directional — some flagged products may be pre-launch, seasonal, or intentionally held. This is a diagnostic starting point, not a substitute for a full planning system.
What founders do after their analysis
The diagnosis is just the beginning
Most founders find two or three things in their analysis they want to fix — but don't have the system to fix them yet. That's exactly what the cohort and 1:1 coaching are built for.
Most popular
Live cohort · $697
Founder Cohort: Inventory to Cash Flow
A 4-week live intensive for founders doing $500K–$5M. Small group, hands-on projects using your actual data. Build your OTB model, demand forecast, and 90-day action plan.
For brands doing $2M+ who want a faster, more focused engagement. Your data, your buying decisions, your 90-day plan. No group, no curriculum — just your business.
I've spent 15+ years as a fractional retail strategist working with brands from scrappy DTC startups to Fortune 500 retailers. The inventory problems are identical at every scale. I built this tool because founders shouldn't need a $10K consulting engagement just to know where their cash is sitting. This is the day-one diagnostic I run with every client — now free.