Chat with us, powered by LiveChat
NewDrillerDB Enterprise SalesSee it

Managing Items

Search, filter, edit, and organize your Products & Services catalog

Managing Items

The Items tab in Products & Services is the catalog for every material, service, and product your company tracks. It is a sortable, filterable table with inline stock controls, value summaries, and bulk actions.

Quick Start: Manage Items

  1. Select Products & Services in the sidebar
  2. Search or filter to find an item
  3. Click an item's name to open its detail page
  4. Edit fields, adjust stock, or review transaction history

Summary Cards

Three cards at the top of the list summarize the whole catalog.

CardShows
Total ValueQuantity times unit cost across all stocked items
CategoriesNumber of active categories
Low StockCount of materials below their reorder point

A usage chart and a Low Stock Alerts panel appear below the cards when there is data to show.

Searching and Filtering

The list supports fast search and stacked filters.

ControlWhat it does
Search boxMatches item name or SKU
Category chipsShow one category at a time
Type filterAll, Material, Service, or Non-inventory
Show Low Stock OnlyMaterials below their reorder point
Reset FiltersClear search, filters, and sort in one click

Multi-entity companies also get an Entity filter that scopes the list to one entity's items plus shared items.

Keyboard shortcuts speed up the list: press / (or Ctrl+F) to jump to search, n to open the Add Item form, and Escape to clear the search and selection.

The Item Table

Columns are sortable by clicking the header.

ColumnShows
ItemName and description; click to open the detail page
TypeMaterial, Service, or Non-inv
SKUYour internal code
CategoryGrouping badge
QtyOn-hand quantity (materials only)
UnitUnit of measure
Unit CostCost per unit
ValueQuantity times unit cost
SupplierPrimary supplier, when mapped
StatusOK, Low, or N/A for stockless items

Long lists are paged on the server; choose 10, 25, 50, or 100 rows per page.

Stock Status

For material items, status reflects the on-hand quantity against the reorder point.

StatusMeaningAction
OKAt or above the reorder pointNone needed
LowBelow the reorder pointReorder soon
N/AStockless (service or non-inventory)Not tracked

Material quantities update automatically as crews record usage on projects and work orders. Keep reorder points current so the Low Stock alerts stay meaningful.

Adjusting Stock from the List

Each material row has inline plus and minus controls. Click one, enter the amount, and apply it to add or remove stock without leaving the list. For a full adjustment with a reason note, open the item and use Adjust Stock.

Item Detail and Actions

Click an item's name to open its detail page, where you can:

ActionWhat it does
EditUpdate name, SKU, category, unit, cost, tax, and accounting fields
Adjust StockAdd, Remove, or Set the exact quantity, with a reason note
Transaction HistoryReview every recorded change for the item
Retail CalculatorWork out a retail price from a markup, or a markup from a target price
Copy Item IDCopy the item's identifier to the clipboard

Bulk Actions and Export

Select rows with the checkboxes to delete several items at once; the delete asks for confirmation first. Use Export CSV to download the current filtered list, or Import CSV to add items in bulk.

Troubleshooting

Can't find an item?

  • Reset filters, then search again
  • Try the SKU instead of the name (or the reverse)

Stock levels look wrong?

  • Review the item's transaction history for duplicate usage
  • Run a physical count and record a Set adjustment

A category is missing from the filter?

  • Categories only appear once an item uses them; add an item with that category first