Skip to main content

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​

  1. Go to Inventory → Warehouse Locations, open the warehouse, and select its Locations tab.
  2. To export one kind of location only, such as your reserve bins, set the Type filter to Reserve.
  3. Click Export Stock in the toolbar. On a phone, open the ⋮ menu and tap Export Stock.
  4. 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.
  5. Choose XLSX (Excel) or CSV.
  6. 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.

ColumnWhat it shows
SKUThe product's SKU.
Product NameThe product's name.
WarehouseThe warehouse the location belongs to.
Location CodeThe location's code, such as A-03-2.
Location NameThe location's name, when it has one.
Location TypeThe location's type, such as Reserve or Primary Pick.
SellableYes if stock in this location can be sold, No if it can't, as in a quarantine or damaged bin.
On HandThe units physically in the location.
AllocatedThe 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.
AvailableOn Hand minus Allocated. Always 0 in a location that isn't sellable.

Next steps​

Last verified: