The Item Locations Report shows exactly how inventory is stored across your warehouses, down to the SKU and bin level. If your account has License Plate Numbers (LPNs) enabled, the report distinguishes between loose units sitting directly on a shelf and units stored inside an LPN. This distinction keeps inventory counts accurate for B2B and wholesale fulfillment.
Navigating the Item Locations Report
Each line on the report represents a SKU in the specified location. For SKUs stored in multiple locations, multiple lines will be displayed on the report.
Item Locations Report Search and Filter Options
Use the search field to narrow the report to specific SKUs and locations within your warehouse. The table below lists all available filters, each offering a multi-select option.
| Filter Type | Valid Options / Parameters |
|---|---|
| Warehouse | A list of physical warehouses in your account. (all warehouses shown by default) |
| Location Status | PICKABLE, UNPICKABLE, SELLABLE, UNSELLABLE, STOCKED, EMPTY. (Stocked locations shown by default) |
| Item Status | ACTIVE, INACTIVE. (Active products shown by default) |
| Lot Expiration | EXPIRED, TODAY, DAYS_7, DAYS_30, DAYS_60, DAYS_90, DAYS_180, NEVER. (all shown by default) |
| Store Integration | Filter by Platform (e.g., Amazon) or specific Shop Name. (All shown by default) |
| Location Search | Partial text search for specific bin names. |
| Hospital Status | All, Yes (flagged), or No (not flagged). Filter to locations that a picker has marked Hospital (non-pickable due to an inventory issue). (All shown by default) |
Item Locations Report Columns Defined
These columns represent the data fields included in the Item Locations report and CSV exports. Change which columns are displayed by editing the column visibility. Open the Columns menu in the top right-hand corner, check the columns you want to show and uncheck the columns you want to hide.
Availability may vary based on your account's feature flags. Contact ShipHero support to have these features enabled as needed.
| Column Name | Data Description |
|---|---|
| Item | The formal name and SKU of the product. |
| Warehouse | The specific warehouse building where the item is stored. |
| Client | The name of the client account (For 3PL accounts only). |
| Location | The specific bin or shelf name within the warehouse. |
| Type | The classification of the location (e.g., Picking, Overstock). |
| Total Units | The total quantity of the SKU physically present at this location. |
| Loose Units | The quantity of loose inventory stored in that location. (LPN activation required) |
| Units in LPN | The quantity of units stored in an LPN in that location. (LPN activation required) |
| Active Item | Status indicating if the product is currently active or inactive in the system. |
| Pickable | Indicates if the location is available for order fulfillment processes. (Pickable or Non-Pickable) |
| Sellable | Indicates if the inventory at this location is part of your available-to-sell stock. (Sellable or Non-Sellable) |
| Active Lot | Indicates if the specific lot is currently active. (Lots and expiration activation required) |
| Lot Name | The unique identifier for the production batch or lot. (Lots and expiration activation required) |
| Exp Date | The date the lot is scheduled to expire. (Lots and expiration activation required) |
| Days to Expire | The calculated number of days remaining until the expiration date. (Lots and expiration activation required) |
| Creation Date | The timestamp of when the item was first assigned to this location. |
Exporting the Item Locations Report
Export the report by selecting the Export button in the top right corner of the page. There are two options:
- All Rows to CSV: Downloads all report data based on active filters.
- Visible Rows to CSV: Downloads only the currently displayed data based on active filters.
Get Started
Beyond viewing and filtering, the Item Locations Report lets you adjust inventory, clear Hospital flags, and delete item locations. Jump to the guide you need:
- How to Adjust Inventory in the Item Locations Report: Update loose and LPN inventory quantities directly from the report.
- How to Clear the Hospital Flag in the Item Locations Report: Find and clear Hospital-flagged locations in bulk.
- How to Delete Item Locations in ShipHero: Remove a SKU's association with a location, one at a time or in bulk.