Shopify's inventory view shows current stock but not velocity. You're guessing at reorders until items go 'out of stock' and sales vanish. Multi-location stores make it worse - which warehouse stocks what, and when do you need to move inventory between locations?
Your first run is free - no card.
Get a ready-to-use file with everything you need
SKUs ranked by days-to-stockout, what runs out first
Exact qty per SKU with supplier deadlines
Ready for import: SKU, qty, supplier, deadline
Planned vs. actual supplier performance
Real outcomes for your Shopify business
Prevent lost sales: Avoid $10,000-$50,000 in stockouts with accurate days-to-stockout forecasts
Reorder list ready: Get CSV every week with SKU, qty, supplier, deadline - straight to POs
Weekly updates: Match your PO cycle with fresh forecasts that keep you in stock
What this Excel Decision Kit tracks from your Shopify data
Current stock ÷ 30-day sales velocity = exact days until each SKU runs out
Calculated qty based on lead time + safety buffer - no guesswork
Which SKUs to move between Shopify locations before stockout hits
Exact date to place PO for each SKU accounting for lead times
$ of lost sales if you stockout on high-velocity SKUs
From current inventory to exact reorder amounts
Definition: (Current stock + in-transit) ÷ daily sales velocity (30-day avg)
Source: Inventory levels + sales history
Granularity: Per-SKU, updated daily
Definition: (Daily velocity × (Lead time + safety buffer)) - (Current stock + in-transit)
Source: Sales velocity + supplier lead times + safety stock settings
Granularity: Per-SKU, by supplier
Definition: Date when PO must be placed to avoid stockout, accounting for lead time
Source: Days to stockout - supplier lead time
Granularity: Per-SKU, by supplier
What makes Shopify different and how we handle it
inventory_item.tracked: if false, we can't forecast
location.id: which warehouse/store has stock
inventory_level.available: actual sellable quantity
Shopify-specific setup in 7 steps
Authorize access to inventory levels, products, and sales history
One-time: enter lead days for each supplier (we pre-fill common ones like Alibaba 45 days)
Choose risk tolerance: aggressive (10 days), moderate (20), conservative (30)
Excel ranks SKUs by days-to-stockout showing what runs out first
See exact quantities to order per supplier with deadline dates
Download ready-to-use CSV: SKU, qty, supplier, deadline - send to suppliers or import to PO system
Get emailed reorder plan every Monday for smooth PO cycles
Start automating your Shopify reporting today and save hours every week.
Our report recipes are designed by e-commerce experts who understand what metrics matter most for your business decisions.
Connect your platforms in minutes, not hours. Our OAuth2 integration makes setup secure and simple.
Reports are delivered in perfectly formatted Excel files that work seamlessly with your existing workflow.
Our report recipes are designed to provide actionable insights and recommendations for your business.
Common questions for Shopify users
We use rolling 30-day average by default, but you can override with seasonal multipliers (e.g., 3x for Q4 holiday items).
We show per-location stockout forecasts AND recommend inventory transfers between locations before stockouts hit.
Yes - map supplier name to lead days once, we remember. Or manually enter per-SKU if lead times vary by product.
In-transit transfers are added to destination location's 'available soon' and factored into days-to-stockout calculation.
We flag SKUs where Shopify allows selling beyond stock and calculate true stockout date accounting for backorders.
"We were constantly stockout on best sellers and drowning in slow movers. The reorder plan cut stockouts by 80% and freed up $22K in dead inventory we reallocated."
Lisa Park
Operations Manager, Modern Kitchen Supply
80% reduction in stockouts
$22K cash freed from dead stock
Other decision kits for your Shopify data
Connect your Shopify account and generate your first reconciliation in under 5 minutes. First report free.
No card • Keep the file forever • Cancel anytime