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.
| Location | SKU | Available | On hand | Committed | Incoming |
|---|---|---|---|---|---|
| Reno warehouse | MCS-3PK-L | 812 | 860 | 48 | 600 |
| Reno warehouse | IB750-STL | 390 | 404 | 14 | 0 |
| Reno warehouse | TR2-BLK-10 | 236 | 262 | 26 | 120 |
| Toronto 3PL | MCS-3PK-L | 208 | 215 | 7 | 0 |
| Toronto 3PL | TR2-BLK-10 | 82 | 91 | 9 | 120 |
| Portland store | TR2-BLK-10 | 0 | 3 | 3 | 0 |
| Total | 1,728 | 1,835 | 107 | 840 |
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.
More reports
Sales by product
What did each product actually earn after discounts and refunds?
Inventory value
What is the stock we hold worth right now, at cost and at retail?
Gross margin by product
Which products make money after the cost of goods, and which only look like they do?
Sales by vendor
Which vendors' products earned the most after discounts and refunds?
Inventory on a date
What did we hold, where, and what was it worth, on any past day?
Monthly tax summary
How much tax was recorded on last month's orders, and where?
Custom reporting
Your reports, your shape, on schedule. Or our team builds them for you.