Skip to main content

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 needWhy
inventory.items.viewTo open the page.
inventory.items.manageTo add, edit, delete, import, bulk-change and print labels. The Warehouse Manager role has both.
Units of measureThe 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:

ColumnMeaning
SKUThe stock-keeping unit — your unique code for the item, always upper case.
BarcodeA barcode image of the SKU.
Item NameThe full name shown everywhere else.
DescriptionHidden by default; turn it on from View → Columns.
CategoryThe group the item belongs to.
UOMUnit of measure — how the item is counted (pcs, box, kg…).
StockTotal quantity on hand across the warehouses you can see.
Reorder AtThe reorder point.
Unit CostThe item's cost per unit.
TrackingHidden by default. None, Serial or Lot.
StatusActive or Inactive.

Table menu extras on this page: Import CSV, Export CSV, Export PDF, Scan Barcode and Print Labels.

Add an item​

  1. Select Add Item. The Add Item drawer opens.
  2. Fill in the fields:
FieldRequiredWhat to enter
SKUYesYour 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 NameYesThe full name people will search for.
DescriptionNoSpecifications, brand, model.
CategoryNoPick from the list, or leave No category.
Unit of MeasureYesHow the item is counted.
Reorder PointNoWhen stock falls to or below this, the item counts as low stock and reorder alerts fire.
Reorder QuantityNoHow 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 StockNoThe 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.
ClassificationNoMerchandise, 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 (₱)NoA list or standard cost used when nothing better is known. Stock value always uses the moving-average cost the system calculates from receipts.
Tracking TypeNoNone (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 CodeNoPre-filled on quotation, order and invoice lines, for example VAT 12% or VAT-exempt.
Preferred SupplierNoSuggested first when the item is added to a purchase requisition or order.
Status—Active, or Inactive to hide it from transaction forms.
  1. Save. You see "Item created" and the item appears in the grid with a stock of zero.
Choosing a tracking type
  • 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​

  1. Open the Table menu and choose Import CSV.
  2. Under Step 1, select Download Template CSV. The template has the columns sku, name, description, category, unitOfMeasure, reorderPoint, unitCost, trackingType and status.
  3. Fill it in, one item per row, and save it as CSV.
    • sku and name are required.
    • category must match an existing category name exactly.
    • trackingType must be None, Serial or Lot.
    • status must be Active or Inactive.
    • reorderPoint and unitCost must be numbers.
  4. Under Step 2, select Choose CSV File and pick your file. A preview of the first rows appears.
  5. 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.

note

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​

  1. Table → Scan Barcode.
  2. Allow the browser to use your camera, and point it at a barcode or QR code.
  3. The grid filters to the matching item.
  1. Table → Print Labels.
  2. Search for and tick the items you want. A preview of the labels appears on the right.
  3. Select Print Labels. Each label shows the item name and a barcode of its SKU.

Common issues​

ProblemWhat to check
"An item with SKU '…' already exists"SKUs are unique. Search for the existing item.
The unit you need is not in the listAdd it on Inventory Settings → Units & Reason Codes.
A new item has defaults you did not expectThey come from Inventory Settings → Item Defaults.
An item does not appear on a receiving or sales formIt is Inactive, or not Purchasable / Sellable.
Import row fails with Unknown categoryThe category name must match an existing category exactly.
Stock looks lower than expectedIt only counts warehouses you can see. See Warehouse Access.
The camera does not start for scanningThe browser needs camera permission, and the page must be served over HTTPS.