Inventory & Logistics

What this dashboard tracks

The Inventory & Logistics Dashboard pulls your Shopify product and inventory data into Excel so you can monitor stock health, identify risk positions, and plan reorders without switching tools.

Key metrics

• Stock levels — current quantity on hand per SKU and location - Inventory turnover — how many times stock rotates in a given period - Days of supply — estimated days until stockout based on recent sales velocity - Low-stock alerts — SKUs below a configurable reorder threshold - Overstock positions — items with more than N days of supply relative to sales rate - Incoming stock — open purchase orders and expected receipt dates

Why these KPIs matter

A stockout on a top seller is lost revenue and a damaged customer experience. Overstock ties up cash and warehouse space. Days of supply is the number that bridges the two — it tells you which SKUs need action this week, not this quarter. Inventory turnover benchmarks efficiency: a ratio below 4 in most retail categories usually means too much dead stock. Tracking by location matters if you have multiple warehouses or fulfill from different places.

Data sources

This dashboard uses the products, variants, and inventory_levels objects from the Shopify connection. You can filter by location, product type, or vendor. Refresh daily to keep stock figures current.

Typical use cases

• Weekly stock review before placing supplier orders - Identifying overstock candidates for markdown or bundle promotions - Monitoring new product launches to catch unexpected sell-through velocity