Export stock by location
To see exactly what sits in each bin, export stock from the warehouse's Locations tab. The file has one row per product per location, so you can count reserve stock, check a zone before a stock take, or hand a bin list to your 3PL.
Before you begin
- Turn on warehouse locations, both in settings and on the warehouse. See Manage warehouse locations.
- To export only some locations, select them in the grid first, or filter the grid by Type.
Steps
- Go to Inventory → Warehouse Locations, open the warehouse, and select its Locations tab.
- To export one kind of location only, such as your reserve bins, set the Type filter to Reserve.
- Click Export Stock in the toolbar. On a phone, open the ⋮ menu and tap Export Stock.
- Under Records to export, choose which locations to include:
- All records exports every location in the warehouse.
- Filtered results exports the locations that match the Type filter. It appears only when the Type filter is set.
- Current page exports the locations on the page you're looking at.
- Selected records exports the locations you selected. It appears only when you've selected at least one.
- Choose XLSX (Excel) or CSV.
- Click Export. The file downloads as
stock-by-location-<warehouse>-<date>.
The counts beside each choice are numbers of locations, not stock rows.
What's in the file
Each row is one product in one location. Locations that hold no stock are left out.
| Column | What it shows |
|---|---|
| SKU | The product's SKU. |
| Product Name | The product's name. |
| Warehouse | The warehouse the location belongs to. |
| Location Code | The location's code, such as A-03-2. |
| Location Name | The location's name, when it has one. |
| Location Type | The location's type, such as Reserve or Primary Pick. |
| Sellable | Yes if stock in this location can be sold, No if it can't, as in a quarantine or damaged bin. |
| On Hand | The units physically in the location. |
| Allocated | The units in this location that are already reserved, for example to an open sales order. Stock reserved to the warehouse as a whole, without a bin, isn't counted here. |
| Available | On Hand minus Allocated. Always 0 in a location that isn't sellable. |
Next steps
- Top up pick faces from reserve bins: refill the pick faces your export shows are running low.
- Move stock between bins (location transfers): move stock the export shows is in the wrong place.
Last verified:
Was this helpful?