Item Catalog
Inventory → Item Catalog (/inventory/items) is the master list of every
product and part your company stocks. Every other inventory page — receiving,
transfers, counts, pricing, sales and purchasing — picks items from this list,
so an item has to exist here before you can do anything with it.
An item record describes what something is. It does not say how many you have or where they are; that comes from stock movements and is shown on Stock Levels.
When to use this page
- Adding a new product before its first delivery arrives.
- Changing an item's reorder point, safety stock or preferred supplier.
- Retiring an item you no longer sell or buy.
- Loading many items at once from a spreadsheet.
- Printing barcode labels, or finding an item by scanning its barcode.
Before you begin
| You need | Why |
|---|---|
inventory.items.view | To open the page. |
inventory.items.manage | To add, edit, delete, import, bulk-change and print labels. The Warehouse Manager role has both. |
| Units of measure | The Unit of Measure list comes from Inventory Settings. Add any unit you need there first. |
| Suppliers (optional) | To set a Preferred Supplier, the supplier must exist on Suppliers. |
New items start with the defaults from Inventory Settings → Item Defaults, so check those first if you are about to add many items.
Understanding the page
The page uses the standard list layout described in Working with lists: tabs, a search box, the View and Table menus, and a row menu on each row.
Tabs: All, Active and Inactive, each with a count.
Columns:
| Column | Meaning |
|---|---|
| SKU | The stock-keeping unit — your unique code for the item, always upper case. |
| Barcode | A barcode image of the SKU. |
| Item Name | The full name shown everywhere else. |
| Description | Hidden by default; turn it on from View → Columns. |
| Category | The group the item belongs to. |
| UOM | Unit of measure — how the item is counted (pcs, box, kg…). |
| Stock | Total quantity on hand across the warehouses you can see. |
| Reorder At | The reorder point. |
| Unit Cost | The item's cost per unit. |
| Tracking | Hidden by default. None, Serial or Lot. |
| Status | Active or Inactive. |
Table menu extras on this page: Import CSV, Export CSV, Export PDF, Scan Barcode and Print Labels.
Add an item
- Select Add Item. The Add Item drawer opens.
- Fill in the fields:
| Field | Required | What to enter |
|---|---|---|
| SKU | Yes | Your unique code, for example BRK-PAD-001. It is converted to upper case. Used for barcodes and scanning, so keep it short and stable. |
| Item Name | Yes | The full name people will search for. |
| Description | No | Specifications, brand, model. |
| Category | No | Pick from the list, or leave No category. |
| Unit of Measure | Yes | How the item is counted. |
| Reorder Point | No | When stock falls to or below this, the item counts as low stock and reorder alerts fire. |
| Reorder Quantity | No | How many to order when the reorder point is reached. Used by the Low Stock & Reorder report; if blank, the report suggests enough to get back to the reorder point. |
| Safety Stock | No | The quantity kept back for emergencies. Stock status turns red below it, and sales and stock-outs can warn or stop there (see Safety Stock Checks). A warehouse can override this on Stock Levels. |
| Classification | No | Merchandise, Raw materials, Work in process, Finished goods or Supplies. Groups the item on the valuation report and the BIR annual inventory list. |
| Standard Unit Cost (₱) | No | A list or standard cost used when nothing better is known. Stock value always uses the moving-average cost the system calculates from receipts. |
| Tracking Type | No | None (bulk qty), Serial Number (one record per unit) or Lot / Batch (batch tracking with expiry). See below. |
| Sellable / Purchasable | — | Whether the item can appear on sales and purchasing documents. |
| Default Tax Code | No | Pre-filled on quotation, order and invoice lines, for example VAT 12% or VAT-exempt. |
| Preferred Supplier | No | Suggested first when the item is added to a purchase requisition or order. |
| Status | — | Active, or Inactive to hide it from transaction forms. |
- Save. You see "Item created" and the item appears in the grid with a stock of zero.
- None — you only care how many you have. Most items.
- Serial Number — each unit is individually identifiable and you need to know exactly which one went where: engines, phones, tools.
- Lot / Batch — units arrive in batches that share a batch number and often an expiry date: oils, chemicals, food.
Decide before the first receipt. Serial and lot items ask for numbers at every movement; see Serial Numbers and Lot Numbers.
Edit an item
Open the row menu and choose Edit, or double-click the row. Change the fields and save. You see "Item updated".
Editing an item never changes its stock or its past movements.
Retire an item
Set an item to Inactive rather than deleting it. Inactive items are hidden from transaction forms but stay on every past document and report.
Delete (row menu) asks you to confirm and removes the item. It only works for an item nothing refers to — one that has stock history, prices or documents cannot be deleted, and you will see an error instead.
Change many items at once
Select rows with the checkboxes. A bar appears above the grid with:
- Set Active / Set Inactive — sets the status of every selected item, after you confirm. Items already in that status are skipped.
- Export Selected — downloads just the selected rows as CSV.
- Delete — deletes the selected items after you confirm. This cannot be undone.
Clear deselects everything.
Import items from a spreadsheet
- Open the Table menu and choose Import CSV.
- Under Step 1, select Download Template CSV. The template has the
columns
sku,name,description,category,unitOfMeasure,reorderPoint,unitCost,trackingTypeandstatus. - Fill it in, one item per row, and save it as CSV.
skuandnameare required.categorymust match an existing category name exactly.trackingTypemust beNone,SerialorLot.statusmust beActiveorInactive.reorderPointandunitCostmust be numbers.
- Under Step 2, select Choose CSV File and pick your file. A preview of the first rows appears.
- Select Import N items.
Each row is imported on its own. When it finishes you see how many succeeded and failed, with a table of failed rows and the reason for each. Fix those rows and import just them again.
This imports the item list only. To load the quantities you already hold, use the opening stock import on Stock Levels.
Scan a barcode to find an item
- Table → Scan Barcode.
- Allow the browser to use your camera, and point it at a barcode or QR code.
- The grid filters to the matching item.
Print barcode labels
- Table → Print Labels.
- Search for and tick the items you want. A preview of the labels appears on the right.
- Select Print Labels. Each label shows the item name and a barcode of its SKU.
Common issues
| Problem | What to check |
|---|---|
| "An item with SKU '…' already exists" | SKUs are unique. Search for the existing item. |
| The unit you need is not in the list | Add it on Inventory Settings → Units & Reason Codes. |
| A new item has defaults you did not expect | They come from Inventory Settings → Item Defaults. |
| An item does not appear on a receiving or sales form | It is Inactive, or not Purchasable / Sellable. |
| Import row fails with Unknown category | The category name must match an existing category exactly. |
| Stock looks lower than expected | It only counts warehouses you can see. See Warehouse Access. |
| The camera does not start for scanning | The browser needs camera permission, and the page must be served over HTTPS. |
Related pages
- Item Pricing — selling prices for each item.
- Stock Levels — quantities, per-warehouse safety stock, opening stock.
- Serial Numbers and Lot Numbers.
- Bills of Materials — what an item is made from.