Skip to content

Getting an Out of Stock Report From Shopify

Ways to list out-of-stock products in Shopify: an Inventory page filter, the inventory remaining report, a CSV export, and a Flow alert for new stockouts.

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 a report named "out of stock", but four things produce one. On Products > Inventory, filter or sort available to zero and below, and save the view. In Analytics, Inventory remaining per product shows products at 0 days remaining. An inventory CSV export, sorted by available, gives a list for a spreadsheet. And a Shopify Flow workflow can tell you the moment something sells out. The saved view is enough for most small shops.

The short version

  • Saved view: Products > Inventory, filter available at or below 0, save.
  • Report: Inventory remaining per product, 0 days remaining.
  • Export: inventory CSV, sort by Available.
  • Alert: Shopify Flow when available reaches 0.
  • Watch negatives: continue selling makes stock go below zero rather than "out".

Option 1: A saved Inventory view

  1. Products > Inventory, choose the location (or all locations).
  2. Sort by Available, lowest first, or filter to products at 0 and below.
  3. Save the view as "Out of stock".

Open it each morning. It shows variants, so a T-shirt in medium can be out while other sizes aren't.

Option 2: Inventory remaining per product

Under Analytics > Reports, this report's chart counts variants predicted to run out soon (0 days remaining) and its table lists days remaining per variant. It's built on the last 28 days' sales, so it also shows what will be out soon, which is more useful than what already is. Shopify inventory forecasting covers it.

Option 3: CSV export

Export inventory from Products > Inventory and sort by Available. Useful for sharing a list with a supplier or a co-maker. Shopify inventory export covers formats.

Option 4: A Flow alert

A Shopify Flow workflow triggered when inventory changes, with a condition on available reaching 0, can email or message you. It catches stockouts the day they happen.

A made-up example

Kapaʻa Kombucha's saved view on a Monday shows three variants at 0 and one at -14. The three are sold out. The -14 is Ginger 4-packs, with continue selling on: fourteen customers are waiting. That one goes to the top of brew day. The Inventory remaining report adds two more that will be out by Thursday.

What to do with the list

  • Out and selling well: order or make now; consider turning on continue selling with a ship date.
  • Out and slow: leave it out, or retire it. Not every stockout needs a restock.
  • Negative: customers are waiting. Make or order first, and email them a date.
  • Out at one location only: transfer stock instead of making more.

Go through it with the reorder list beside you, so restocking decisions take a few minutes rather than a morning.

Hiding sold-out products

If you'd rather not show sold-out products in collections, use an automated collection condition such as "Inventory stock is greater than 0", or a Flow workflow. Shopify sold out error covers products that show sold out when they shouldn't.

Where this stops working

Every option lists finished products already out. The more useful list, for a maker, is what can't be made: the ingredient or jar that ran out and is about to make three products go out next week. Shopify can't list those. Shopify raw materials inventory covers watching what's upstream.

How TaroStack does it

TaroStack for Shopify runs inside your Shopify admin and lists what will run short before it does, in plain words: finished products, ingredients and packaging, with days of cover and what's on order. Free for 14 days.

Questions people also ask

Does Shopify have an out of stock report?

Not by that name. A saved Inventory view filtered to zero, or the Inventory remaining per product report, does the job.

How do I find all sold out products on Shopify?

Products > Inventory, sort or filter by Available at or below zero.

Can Shopify email me when something sells out?

Yes, with a Shopify Flow workflow.

Why do some products show negative instead of zero?

Continue selling when out of stock is on, or POS sold below zero.

Sources

  1. Shopify Help Center: Viewing inventory · read October 27, 2026
  2. Shopify Help Center: Inventory reports · read October 27, 2026
  3. Shopify Help Center: Exporting and importing inventory with a CSV file · read October 27, 2026
  4. Shopify Help Center: Hiding out of stock products · 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.