Skip to content

Building a Shopify Inventory Dashboard That Gets Used

What belongs on a Shopify inventory dashboard, where each number comes from in Shopify's reports, and the four numbers a small maker should check weekly.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed October 27, 2026 · 3 min read

Shopify doesn't have one inventory dashboard; it has an Inventory page that lists counts and nine reports under Analytics that answer separate questions. A useful dashboard pulls four numbers from them and shows them together: what will run out soon, what isn't selling, what stock is worth, and what changed without a sale. You can build that by saving a few report views in Shopify, or in a spreadsheet updated weekly. More than about six numbers, and nobody reads it.

The short version

  • Running out: Inventory remaining per product, sorted by days left.
  • Not selling: Products by sell-through rate, lowest first.
  • Worth: Month-end inventory value.
  • Changed without a sale: Inventory adjustment changes.
  • Look at them every week on the same day. A dashboard nobody opens on schedule isn't one.

The four numbers and where they come from

Number Shopify report What to act on
Products with fewer than 14 days left Inventory remaining per product Order or make now
Products with low sell-through over 30 days Products by sell-through rate Stop reordering; discount or bundle
Stock value at cost Month-end inventory value Cash tied up; is it rising faster than sales?
Units adjusted out (damaged, loss, count) Inventory adjustment changes Breakage, theft, or a counting problem

Add a fifth if you sell at markets: Gross profit by POS location, to see which stall or shop earns its keep.

Saving views in Shopify

Each report in Analytics can be filtered and saved. Make one saved view per question, name them "Weekly 1" to "Weekly 4", and open them in order. The Inventory page can be filtered and saved too: a view of products at your main location with available under 10 is a quick shelf check.

A made-up example: Monday at a soap company

Kaimukī Soap Co. opens its four views every Monday at 8:

  1. Days left: Lemongrass bar, 9 days. The next pour cures for four weeks, so it's already late; the owner moves Lemongrass to the front of this week's pours and turns on continue selling with a ship-date note.
  2. Sell-through: Charcoal facial bar, 6% in 30 days. Stop pouring it; bundle the 80 on the shelf into gift sets.
  3. Value: $11,400, up $2,000 in a month while sales were flat. That's the charcoal bars and a large label order.
  4. Adjustments out: 22 bars marked damaged. A shelf is too close to the window and bars are sweating. Move the shelf.

Four decisions, ten minutes.

Where this stops working

Every number on a Shopify dashboard is about finished products. The soap company's real constraint is upstream: oils, lye, fragrance, and four weeks of curing racks. "9 days left" is useless if the coconut oil runs out tomorrow. A maker's dashboard needs the ingredients on it too, and Shopify doesn't have them. Shopify inventory report covers each report, and Shopify raw materials inventory covers the missing half.

How TaroStack does it

TaroStack for Shopify runs inside your Shopify admin and puts the upstream numbers beside Shopify's: a reorder list in days of cover for ingredients and packaging, stock value including materials, what will expire unsold, and what each count difference was worth. Exceptions are written in plain words, like what will run short or arrive too late. Free for 14 days.

Questions people also ask

Does Shopify have an inventory dashboard?

Not a single one. The Inventory page lists counts, and Analytics has inventory reports you can save as views.

What's the most important inventory number to watch?

Days of stock left for your best sellers. Running out of an A-grade product costs more than anything else on the list. Shopify inventory forecasting covers it.

Can I build a Shopify inventory dashboard in Google Sheets?

Yes, by exporting the reports weekly and pasting them into fixed tabs. Shopify inventory export covers the exports.

How often should I check inventory numbers?

Weekly for most small makers, daily in a busy season.

Sources

  1. Shopify Help Center: Inventory reports · read October 27, 2026
  2. Shopify Help Center: ABC inventory analysis · read October 27, 2026
  3. Shopify Help Center: Viewing inventory · read October 27, 2026
  4. Shopify Help Center: Understanding inventory states · read October 27, 2026

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

TaroStack for Shopify

Free for 14 days.