Browse & search the product inventory list
The product list is where most inventory work starts. From it you find a product, read its live stock figures across the inventory columns, scan a barcode to jump straight to a unit, or select several products at once and send them into a stock take. This guide covers searching, reading the columns, tuning which columns show, and the bulk stock-take entry point.
Before you begin
- Open the list at Inventory → Products (also reachable from the Products area of the left navigation).
- Anyone with product-list access can browse, search, and read the columns. Bulk actions such as Stock Take and Archive are permission-gated — buttons you lack permission for don't appear.
- The on-screen inventory numbers are a fast cache rebuilt from the movement ledger; the ledger, not the cache, is the source of truth. See Stock states for what each figure means.
Search for a product
The search box at the top of the list runs a full-text search over each product's SKU, MPN, and name.
- Type into the search box (placeholder Search by SKU, name, barcode, MPN, brand...).
- Results rank by field weight — a SKU match outranks an MPN match, which outranks a name match — so typing a full or partial SKU surfaces the exact product first.
- Use the searchable-field chips (SKU, Name, Barcode, MPN) shown on the search box to scope a term to one field.
Full-text search runs against the products search index, not a raw database LIKE. A brand-new product becomes searchable once it's indexed (near-instant in normal operation). If a product you just created doesn't appear, wait a moment and search again, or find it with an advanced filter instead.
Read the inventory columns
The Inventory column group carries a product's live stock figures. Each is a separate state that answers a different question — see Stock states for the full model and Stock states & fields reference for exact definitions.
| Column | Shows | Notes |
|---|---|---|
| Stock | Total inventory you own | Includes in-flight transfer stock. On Hand equals Stock − In Transit, and also equals Available + Allocated + On Hold + Non-Sellable. |
| Available | On-hand units free to sell | On Hand minus everything committed, floored at zero. |
| On Hold | Units fenced off by a stock hold | On-hand but withheld from sale. Not a separate "reserved" status — SKU.io has no "reserved" state. |
| Non-Sellable | On-hand units flagged unsellable | Damaged, quarantined, or otherwise not fit to sell. Counts toward On Hand but never toward Available. |
| Incoming | Unreceived units on open purchase orders | Inbound supply from suppliers, not yet on hand. Sorting uses the PO unreceived-quantity figure. |
| In Transit | Units in flight between your warehouses | On a shipped transfer, not yet received. |
| Inventory | On-hand quantity per warehouse | Filter and sort by a specific warehouse name. |
| Inventory (Available) per Warehouse | Available quantity per warehouse | Filter and sort by a specific warehouse name. |
| Stock Value | On-hand cost value | The one inventory column shown by default. |
| Daily Average Consumption | Average units consumed per day | Also available as a net-of-returns variant. |
| Min Stock Level | Reorder threshold | Editable inline — click the cell to change it. |
SKU.io has no "reserved" inventory status. On-hand stock is split into Available, Allocated (units promised to open sales-order lines), On Hold (units fenced off manually), and Non-Sellable. The list carries On Hold and Non-Sellable as first-class columns; Allocated isn't a list column — to see a product's full breakdown open its stock across warehouses. Allocated stock is explained in Allocations & backorders.
Show or hide columns
Most inventory columns are hidden by default to keep the list readable — only Stock Value shows out of the box.
- Open the Columns selector in the list toolbar.
- Turn on the inventory columns you want (for example Available, On Hold, Non-Sellable, Incoming, In Transit).
- For the per-warehouse columns (Inventory and Inventory (Available) per Warehouse), pick the warehouse whose quantity you want to see, sort, and filter on.
Your column choices are remembered, and you can capture a column layout together with its filters as a saved view.
Filter, narrow, and save the list
- Archived toggle. The list footer carries an All / Active / Archived toggle. It opens on Active, so archived products are hidden by default. Switch to Archived to see only archived products, or All to see both.
- Advanced filters. Build a filter tree — for example Available
is less than10 combined with a warehouse condition — from the Advanced filters button. Every inventory column is filterable and sortable. - Saved views. Save a filter-plus-column combination (such as "Low stock, Main Warehouse") as a view you can reopen in one click.
- Import / Export. Export the current list to a spreadsheet, or import product updates in bulk.
Scan a barcode or SKU
Barcode lookup resolves a single scanned code straight to one product — useful at a scanner or on the warehouse floor.
- Trigger the scan action and enter or scan a code.
- The lookup matches exactly — no partial or fuzzy matching. It checks barcode first, then SKU, and returns the first exact match.
- Archived products are never returned by a scan.
When no active product has that exact barcode or SKU, the lookup returns an empty result rather than an error — nothing is opened. Re-check the code, or search by SKU or name instead. Partial codes won't match; use search for partial terms.
Start a bulk stock take from a selection
You can turn a set of products on the list into a stock take without leaving the page — a fast way to count a shelf, a supplier's range, or a filtered low-stock set. This also establishes an opening on-hand figure for products that have never had a movement.
- Select the products with the row checkboxes. A bulk-actions bar appears.
- Click Stock Take.
- In the Perform Stock Take dialog, choose the Warehouse to count in. If you have only one eligible warehouse, it's selected for you.
- Click Create to open the stock take. SKU.io takes you to the new stock take's detail page with your selected products already added — enter your counts there.
The warehouse picker lists only warehouses whose stock you manage yourself. Channel-managed warehouses — Amazon FBA, Amazon AWD, and Walmart WFS — and virtual or supplier warehouses are excluded, because their quantities are owned by the channel and can't be set by a manual count or transfer. Reconcile those through the channel's own inventory sync instead.
If you establish a product's opening balance through a stock take rather than a purchase-order receipt, the product reads as having "no movements" in some views, but it does carry a full movement ledger — the stock take writes the opening entry that every later figure reconciles against.
Common problems
| Symptom | Likely cause | Fix |
|---|---|---|
| A product you just created isn't in the list. | It hasn't been indexed for search yet, or the Active archived filter is hiding it. | Wait a moment and search again, or clear filters; check the All / Active / Archived toggle. |
| The inventory figures you want aren't shown. | Most inventory columns are hidden by default. | Open Columns and enable Available, On Hold, Non-Sellable, Incoming, In Transit, or a per-warehouse column. |
| You expected an Allocated figure in the list. | Allocated isn't a product-list column — the list shows On Hold and Non-Sellable directly. | Open the product's stock across warehouses for the full Available / Allocated / On Hold / Non-Sellable breakdown. |
| A barcode scan opens nothing. | No active product has that exact code (lookup is exact-match, barcode then SKU; archived excluded). | Verify the code, or search by SKU or name for partial matches. |
| A channel warehouse is missing from the stock-take dialog. | Channel-managed (Amazon FBA/AWD, Walmart WFS), virtual, and supplier warehouses are intentionally excluded. | Reconcile channel-managed stock through the channel sync, not a manual stock take. |