Stock & Inventory
Every product in your catalog automatically gets an inventory entry in each warehouse. Stock levels are tracked per product, per warehouse.
Stock quantities
Each inventory entry tracks three quantities:
| Quantity | Description |
|---|---|
| On hand | The total physical stock in the warehouse. |
| Reserved | Stock that is reserved for pending orders but not yet shipped. |
| Sellable | Stock available for new sales. Calculated as on hand − reserved. |
When a customer places an order, stock is reserved — reducing the sellable quantity without changing the on-hand count. When the order is shipped or picked up, the reserved stock is released and the on-hand quantity is reduced.
Viewing stock levels
You can view stock levels in two ways:
Per warehouse
Navigate to Inventory → Warehouses and click on a warehouse to see all products and their stock levels in that location. You can search and filter by product name, SKU, or stock status.
Per product
Navigate to PIM → Products → Product → Warehouses to see how stock is distributed across all warehouses for a specific product.
Adjusting stock
To manually adjust stock for a product in a specific warehouse, use the stock adjuster. This is available from the product's warehouse view.
- Navigate to PIM → Products → Product → Warehouses.
- Click on the warehouse where you want to adjust stock.
- Select an adjustment type:
- Increase (+) — Add stock to the warehouse.
- Decrease (−) — Remove stock from the warehouse.
- Enter the quantity to adjust by.
- Select a reason code:
| Reason code | Description |
|---|---|
| Stock Taking | Adjustment based on a physical stock count. |
| Damaged | Items that are damaged and removed from stock. |
| Found in Warehouse | Items found that were not previously counted. |
| Shrinkage / Theft | Stock lost due to shrinkage or theft. |
| Supplier Correction | Correction based on supplier information. |
| Other | Any other reason. Add a comment for context. |
- Optionally add a comment to explain the adjustment.
- The form previews the new balance before you confirm.
All adjustments are logged and can be reviewed in the warehouse ledger.
Bin tracking
If bin tracking is enabled on a warehouse, stock is tracked down to individual bin/shelf locations. Each inventory entry can have multiple bin codes, each with their own quantity.
This is useful for larger warehouses where knowing the exact shelf location speeds up picking and stock management.
Inventory initialization
When you create a new product, Avvyr automatically creates an inventory entry in every warehouse with all quantities set to zero. You don't need to manually add products to warehouses — they appear automatically.
Similarly, when you create a new warehouse, inventory entries are created for all existing products.
Sellable calculation
The sellable quantity determines whether a product can be sold:
$$\text{sellable} = \text{on hand} - \text{reserved}$$
- In POS, the system checks the selling warehouse's sellable quantity before completing a sale (unless negative quantities are allowed).
- On the storefront, sellable quantities from all storefront-visible warehouses are aggregated to determine availability.
Negative stock
By default, stock cannot go below zero. If you need to sell items before they physically arrive (e.g. backorders), enable Allow negative quantity on the warehouse.
When negative stock is allowed, the sellable quantity can go below zero, and sales will not be blocked due to insufficient stock.