Shopify inventory by location report

How many units of each SKU sit at each location, and how many are already spoken for?

Install on Shopify

14-day free trial.

Every location on one sheet, before the transfer goes out

Locations across the top

Pivot by location and each SKU is one row with a column per site. Where to pull from and where to send is obvious.

Just the ones running low

Filter to available below a number at one location, or to committed higher than on hand, and send it as the pick list.

In the warehouse inbox at 7

Schedule it daily as CSV or Excel, one version per location, to the people who move the boxes.

Or we build the version you need

Available units with cost and retail value per location, or stock against last week's sell-through? Describe it in the app and our team builds it. How it works.

What it looks like

One row per location and SKU: the units you can still sell, the units physically there, the units already on open orders, and the units on their way in. Sorted by on hand, so the deepest stock is at the top. The last row is the one that matters: three pairs on the shelf in Portland, all three promised to orders, none left to sell.

Sample output, as of 8 October 2026The built-in "Inventory by location" report. Made-up store, made-up numbers.
LocationSKUAvailableOn handCommittedIncoming
Reno warehouseMCS-3PK-L81286048600
Reno warehouseIB750-STL390404140
Reno warehouseTR2-BLK-1023626226120
Toronto 3PLMCS-3PK-L20821570
Toronto 3PLTR2-BLK-1082919120
Portland storeTR2-BLK-100330
Total1,7281,835107840

What each number means

So the figure means the same thing to everyone who reads it.

Location
The Shopify location the inventory is tracked at: a warehouse, a 3PL, a store.
SKU
The SKU on the inventory item. Product and variant names are fields you can add.
Available
Units that can be sold right now: on hand minus committed and unavailable.
On hand
Units physically at the location, whether or not they are spoken for.
Committed
Units on orders that have been placed but not yet fulfilled from that location.
Incoming
Units on inbound transfers and purchase orders that have not arrived.
Today only
This report reads inventory as it stands now. "Inventory on a date" gives the same columns for any captured day.

Already have Shopify's reports?

Shopify's own reports can be edited, saved and exported to a spreadsheet (Shopify Help). That covers a one-off. ReportNerds keeps the exact version your team needs, sends it on a schedule, and our nerds build the ones you would rather not.

Want this report for your store?

Install ReportNerds and run it on your own orders, or tell us the version you need and our nerds build it. 14-day free trial.

Install on Shopify