Inventory columns, filters and reasons
Exact names of columns, filters and options on the Inventory page, plus URL parameters and limits.
বাংলায়: ইনভেন্টরি পৃষ্ঠায় যে কলাম, ফিল্টার এবং বিকল্প আছে তাদের সঠিক নাম এখানে রয়েছে। স্টক সংরক্ষণ, ইতিহাস লেবেল এবং সীমাবদ্ধতা সম্পর্কে তথ্য।
Columns
| Column | What it shows | Sortable | Hideable |
|---|---|---|---|
| Product | Product name; variant name and parent SKU underneath | Yes (by name) | No |
| SKU | The product's SKU code | Yes (by SKU) | Yes |
| Available | Units ready to sell: On hand minus Reserved minus Unavailable. Shows "Out" or "Low" badge. | Yes (by available) | No |
| On hand | Total units at this location, before any hold. | Yes (by on hand) | No |
| Reserved | Units held for open orders that have not yet shipped. | No | Yes |
| Unavailable | Units marked as damaged or held back from sale. | No | Yes |
Stock filters
| Option | Shows |
|---|---|
| All | Every product at this location |
| Out of stock | Products with zero available units |
| Low stock | Products with 1 to 5 available units |
Conditions (multi-select)
| Condition | Shows |
|---|---|
| Oversold | Products with negative on-hand (below zero) |
| Has unavailable units | Products with 1 or more damaged or held units |
| Has reserved units | Products with units held for open orders |
| Missing SKU | Products with no SKU set |
Other filters
Location — choose a location to see its stock. Businesses with one location see no location picker. The first load shows the default location, or the business default if you have edit access.
Product Type — Simple (single variant) or Variants (multi-option products).
Sort options
Click a column header to sort: Product, SKU, Available, or On hand. Sort direction is ascending by default. Click again to reverse.
URL parameters
| Parameter | Example | Notes |
|---|---|---|
q | ?q=shirt | Search query text |
stock | ?stock=low | Stock filter: all, out, low |
type | ?type=variant | Product type: all, simple, variant |
has | ?has=negative,reserved | Conditions (comma-separated): negative, unavailable, reserved, no_sku |
loc | ?loc=42 | Location ID |
sort | ?sort=available | Sort by column: name, sku, available, on_hand |
dir | ?dir=desc | Sort direction: asc, desc |
page | ?page=2 | Page number (1-indexed) |
size | ?size=50 | Products per page (max 100) |
Adjust actions and reasons
When you press Adjust on a product row, four actions appear for managing stock: Receive, Remove, Set count, and Unavailable. Each action has its own reason options or adjustment fields.
Receive — New stock arrived
Adds units to on-hand. No reason field.
Remove — Lost, stolen or written off
Removes units from on-hand. Choose a reason:
| Reason | Use when |
|---|---|
| Theft or loss | Units are missing or stolen |
| Correction | Fixing a previous count error |
| Other | Any other reason |
Set count — What is on the shelf now
Replace on-hand with an exact count (e.g., "12" means 12 units, not 12 added). No reason field. Shows the difference: +3 or -2.
Unavailable — Damaged, held back from sale
Adds units to the unavailable (damaged) count. Subtracts from available. No reason field.
In all cases, you can add an optional note up to 500 characters.
Change types in history
When you view a product's stock history, each entry shows a change type:
| Change type | What happened |
|---|---|
| Received | Stock was manually added (Receive action) |
| Removed | Stock was manually removed |
| Adjusted | Stock was manually set to an exact count |
| Marked unavailable | Units were marked damaged or unavailable |
| Reserved | Units were held for an order (automatic) |
| Unreserved | Held units were released (order cancelled or shipped) |
| Order shipped | Stock left inventory for an order |
| Order cancelled | Stock was returned when an order was cancelled |
| Return received | Stock was returned from a returned parcel |
| Transferred out | Stock moved to another location |
| Transferred in | Stock arrived from another location |
Limits
| Limit | Value |
|---|---|
| Maximum note length | 500 characters |
| Page size default | 20 products per page |
| Page size maximum | 100 products per page |
Other ways people ask this
- inventory kye columns ache
- stock filter menu kothay
- change type label matlab kya
- adjust reason theft meaning
- unreserved inventory status
- inventory table column meaning
- স্টক ফিল্টার কী কী আছে
- কোন্ স্টক "লো স্টক" বলে
- আনরিজার্ভড মানে কি
- change type history meaning
- adjust action receive remove count
- inventory column sortable naki
Related pages
- The Inventory page — how to read the page
- Find and filter stock — using filters and search
- Inventory problems and fixes — when something goes wrong
Checked against the product on 2026-10-02.