Products list columns, search & filters reference
This is a lookup reference for the products list (the main products table) and for the search boxes and typeahead pickers that find products elsewhere in SKU.io. For the task of driving the list — searching, filtering, sorting, saving views — see Browse, search & filter the products list.
Before you begin
- Reading the list requires the products read scope. Row actions (archive, edit) require their own permissions — see Product permissions reference.
- Inventory numbers (On Hand, Available, In Transit, and the rest) are computed from real-time stock. For how those figures are derived across warehouses, FIFO layers, and opening balances, see the Inventory guide — this page only documents how the columns are labelled and combined for display.
Column selector
The toolbar Columns control opens the column selector, where you choose which columns are shown and in what order.
- Search the palette by column title, group, or type to narrow a long list quickly.
- Reorder visible columns by dragging. Locked columns and hidden columns keep their natural position.
- Locked columns (the image thumbnail, SKU, and the row actions menu) are marked Required — they're always shown and can't be toggled off or reordered. The image and actions columns are hidden from the palette entirely, so you never see them as toggle rows.
- Freeze a column with the pin on its row to keep it in view while you scroll sideways. See Choose and freeze table columns.
- Column choices, order and frozen columns are written to the page URL, so a saved view or a shared link reproduces the exact column layout.
Columns marked "Hidden by default" below are available in the selector but off until you turn them on.
Columns
Over 80 columns are available, grouped by facet. All columns except the computed cells map to a product field or a real-time inventory figure.
Core
| Column | Sortable | Default |
|---|---|---|
| (image) | No | Shown (locked) |
| ID | Yes | Shown |
| SKU | Yes | Shown (locked) |
| Name | Yes | Shown (expandable) |
| Type | Yes | Shown |
| Product type | No | Hidden |
| Channels | No | Hidden |
| Stock UoM | No | Hidden |
| Brand | No | Shown |
| Suppliers | No | Shown |
| Tags | No | Shown |
| Created | Yes | Shown |
| Updated | Yes | Shown |
The Name column is expandable: long names truncate by default, and you can expand the column to show them in full without leaving the list.
Inventory
| Column | Sortable | Default |
|---|---|---|
| On Hand | Yes | Shown |
| Available | Yes | Shown |
| Available to Sell | Yes | Shown |
| Allocated | Yes | Shown |
| On Hold | Yes | Shown |
| Non-Sellable | Yes | Hidden |
| In Transit | Yes | Shown |
| Total Inventory | Yes | Hidden |
| Inbound | Yes | Shown |
| Backorder | Yes | Shown |
| Stock Value | Yes | Hidden |
See The computed inventory cells below for how On Hand, Available to Sell, Total Inventory, and Non-Sellable are combined and colored.
Cost & pricing
| Column | Sortable | Default |
|---|---|---|
| Default Cost | Yes | Shown |
| Avg Cost | Yes | Shown |
| Default Price | No | Hidden |
| DAC | Yes | Shown |
| DAC Net Returns | Yes | Hidden |
| Min Stock | Yes | Shown |
Avg Cost shows the unit-weighted average across active FIFO layers, refreshed on every inventory change; hover it for that explanation. For the model behind FIFO layers and average cost, see FIFO layers & COGS.
Identifiers & flags
| Column | Sortable | Default |
|---|---|---|
| Image URL | No | Hidden |
| Barcode | No | Hidden |
| MPN | No | Hidden |
| Category | No | Hidden |
| Lot Tracking | Yes | Hidden |
| Lot Method | Yes | Hidden |
| Dropshippable | No | Hidden |
| Archived | Yes | Hidden |
Dimensions
| Column | Sortable | Default |
|---|---|---|
| Weight | Yes | Hidden |
| Weight Unit | No | Hidden |
| Length | Yes | Hidden |
| Width | Yes | Hidden |
| Height | Yes | Hidden |
| Dimension Unit | No | Hidden |
Case packing
| Column | Sortable | Default |
|---|---|---|
| Case Qty | Yes | Hidden |
| Case Weight | Yes | Hidden |
| Case Weight Unit | No | Hidden |
| Case Length | Yes | Hidden |
| Case Width | Yes | Hidden |
| Case Height | Yes | Hidden |
| Case Dim Unit | No | Hidden |
Proforma / costing
| Column | Sortable | Default |
|---|---|---|
| Proforma Ship Cost | Yes | Hidden |
| Landed Cost % | Yes | Hidden |
| Marketplace Cost % | Yes | Hidden |
| FBA Prep | No | Hidden |
Sourcing (default supplier)
| Column | Sortable | Default |
|---|---|---|
| Supplier Name | No | Hidden |
| Supplier SKU | No | Hidden |
| Supplier Leadtime | No | Hidden |
| Supplier MOQ | No | Hidden |
| Target Stock Days | No | Hidden |
| Default Supplier Price | No | Hidden |
| Supplier Discontinued | No | Hidden |
| Supplier In Stock | No | Hidden |
| Total Supplier Stock | No | Hidden |
| Total Units Sold | Yes | Hidden |
| Total Orders | Yes | Hidden |
These reflect the product's default supplier. For managing the full supplier list, see Manage a product's suppliers.
Tax & nominal codes
| Column | Sortable | Default |
|---|---|---|
| Taxable | No | Hidden |
| Tax Rate | No | Hidden |
| Sales Nominal Code | No | Hidden |
| COGS Nominal Code | No | Hidden |
| Inventory Nominal Code | No | Hidden |
| Inv In Transit Nominal Code | No | Hidden |
| Accrued Purchases Nominal Code | No | Hidden |
| Discount Nominal Code | No | Hidden |
The nominal-code columns show the account each product posts to. To set them, see Set a product's accounting & financial line type.
Taxonomy
| Column | Sortable | Default |
|---|---|---|
| Category Path | No | Hidden |
| Other Categories | No | Hidden |
| Other Categories (Path) | No | Hidden |
For how category paths are built, see How product taxonomy works.
Relationships
| Column | Sortable | Default |
|---|---|---|
| Has FBA | No | Hidden |
| Parent SKU | No | Hidden |
| Variations | No | Hidden |
| Component SKUs | No | Hidden |
| Component Of | No | Hidden |
| Other Images | No | Hidden |
| Last COGS Rebuild | Yes | Hidden |
Component SKUs and Component Of describe kit/bundle relationships — see Kit & bundle component reference.
Bundles
| Column | Sortable | Default |
|---|---|---|
| Bundle Sets Possible | No | Hidden |
| Bundle Component Avg Cost | No | Hidden |
Both columns fill in for bundles only, and show a dash for every other type.
- Bundle Sets Possible — how many complete sets the component stock can make. It's worked out warehouse by warehouse and then added up, because pieces in different warehouses don't make a set.
- Bundle Component Avg Cost — what one set costs in components: each component's average cost times the quantity per set, added up. It shows a dash when any component has no average cost.
Point at a value for the same explanation. See Kit & bundle component reference.
For example, with Bundle and Kit picked under Type and both columns on, a two-bottle bundle shows 251 sets possible at 13.37 in components per set, and the kit shows a dash:
Both columns sit after Avg Cost. To keep the SKU in view while you scroll across to them, freeze it from Columns with the pin beside it.
The computed inventory cells
Four cells aren't stored fields — they're computed for display and carry a hover tooltip explaining the formula.
On Hand
On Hand is the sum of four sellable-and-non-sellable buckets, and it deliberately excludes In Transit:
On Hand = Available + Allocated + On Hold + Non-Sellable
Non-Sellable is included on purpose: stock sitting in QC, quarantine, or damaged bins is physically on hand even though you can't sell it, so it must count toward the on-hand total. The header tooltip reads "Available + Allocated + On Hold + Non-Sellable (excludes In Transit)."
When the product's stock unit of measure isn't EACH, the cell appends the UoM code (for example 12 CASE). See Units of measure reference.
Consigned chip. If any of the On Hand quantity is consigned (supplier-owned) stock, a purple consigned chip appears under the number showing the consigned quantity. Consigned stock is counted in On Hand and Available to Sell, but is excluded from inventory (GL) value until it sells. Hover the chip for that explanation.
Available to Sell
Available to Sell is the net promiseable position across all warehouses:
Available to Sell = Available − Backorder Planned − Backorder PO Covered
This value can be negative (rendered in red) when open commitments exceed on-hand stock — for example when you have promised more than you physically hold and the shortfall isn't yet covered by an incoming purchase order.
Total Inventory
Total Inventory adds the in-transit bucket back in — it's everything you own, whether physically present or already shipped to your locations:
Total Inventory = On Hand + In Transit
Non-Sellable
Non-Sellable is on-hand stock in non-sellable bins (QC, quarantine, damaged). It counts toward On Hand but isn't sellable, so it's broken out as its own column. Any value greater than zero is rendered in orange to flag it.
Type badges
Type is the column described here — the product's shape, from a fixed list. Product type is a separate, hidden-by-default column carrying the taxonomy you build yourself, which decides which category a product publishes into on each channel. See Product type vs Type.
The Type column renders each product's type as a colored badge (plain colored text in the list, a chip on the product detail page). The same color map is used in both places.
| Type | Badge color |
|---|---|
| Standard | Primary (blue) |
| Bundle | Purple |
| Kit | Info (cyan) |
| Matrix | Warning (amber) |
| Blemished | Grey |
| Manufactured | Teal |
Any unrecognized type falls back to grey.
A product's type determines which detail tabs and row actions appear. In particular, the types that carry their own tracked inventory are Standard, Kit, Blemished, and Manufactured — a matrix parent and a bundle don't hold stock of their own (a matrix's stock lives on its variations; a bundle's availability is derived from its components). For what each type means and how conversion works, see Product types explained and Convert & auto-detect product types.
How product search boxes behave
Every product search box and typeahead picker in SKU.io matches on SKU, Name, and Barcode, and hides archived products unless you ask for them.
How results are ranked. Exact and prefix matches always beat substring matches, in this order: exact SKU, exact barcode, exact name, then SKU/barcode/name "starts with", then SKU/name "contains". Typing a full SKU surfaces that exact product first even when many SKUs share the prefix. With the box empty, a picker shows your most recently created products so there's always something to choose from.
Individual pickers narrow the list further, depending on where they appear:
| Picker | What it shows |
|---|---|
| Channel-listing pickers | Sellable products only — non-sellable items like decoration consumables never appear. |
| Manufacturing Simple Mode assemble/disassemble | Only products that actually have components, so a picker can't offer something that would fail when you submit it. |
| POS register search | Only products flagged Show in register, leading with best-sellers before falling back to most-recent. |
Barcode scanning is exact-match only — no partial or fuzzy matching. A scan matches a Barcode first, then falls back to an exact SKU, skipping archived products. A near-miss returns nothing rather than guessing.
Search stays available even if the index is down. Search normally runs against a search index rather than scanning the whole catalog. If that index is unavailable, SKU.io falls back automatically to a direct text search on SKU, name, and barcode — you won't see a failure, only a slightly slower result.
Next steps
- Browse, search & filter the products list — the task guide for driving this table.
- Product fields & validation reference — the source fields behind these columns.
- Product detail page reference — where a row opens.
- Export products — the same columns, exported to a spreadsheet.
Channel listing and publishing seams are out of scope here — those are covered in the Listings guide (coming soon).