Chat with us, powered by LiveChat
NewDrillerDB Enterprise SalesSee it

Adding Items

Create materials, services, and products in your catalog

Adding Items

Adding items to Products & Services builds the catalog that powers usage tracking, project costing, and purchase orders. Only a name is required, so you can start small and fill in detail over time.

Quick Start: Add an Item

  1. Select Products & Services in the sidebar
  2. Click Add Item
  3. Enter a Name (required) and choose an Item Type
  4. Add SKU, category, unit, and unit cost as needed
  5. For materials, set an initial quantity and reorder point
  6. Click Create Item

Choosing an Item Type

The item type determines whether the item tracks stock.

TypeTracks quantity?Example
MaterialYes6" PVC casing, bentonite, well caps
ServiceNoDrilling, pump installation, water testing
Non-inventoryNoDrop-shipped or one-off goods

When you pick Service or Non-inventory, the quantity and reorder-point fields disappear, since those items are stockless.

Item Fields

FieldRequired?Purpose
NameYesThe label shown throughout the system
Item TypeYesMaterial, Service, or Non-inventory
SKUNoYour internal code, used for search and reordering
Manufacturer SKUNoThe vendor or manufacturer part number
CategoryNoGrouping for filtering and reporting
UnitNoHow the item is measured (foot, bag, each, hour)
Unit CostNoCost per unit, used for value and project costing
DescriptionNoSpecs, usage notes, or vendor detail

Categories are free text. Type a new category name on any item to create it, then reuse it from the category filter on the list.

Common Units

UnitUsed for
FootCasing, pipe, screen
BagBentonite, grout, cement
GallonChemicals, fuel
TonSand, gravel
EachFittings, caps, seals
HourLabor and services

Pricing

Unit Cost drives value and cost calculations: quantity times unit cost equals total value. Updating an item's cost applies to future calculations; past transactions keep the cost recorded at the time.

On an item's detail page you can also work out a retail price from a markup (or a markup from a target retail price) using the built-in calculator.

Stock Settings (Materials Only)

Material items can hold two stock fields at creation.

FieldPurpose
Initial QuantityThe count on hand when you create the item
Reorder PointThe threshold that triggers a Low Stock warning

If you are migrating from another system, you can create items with a zero quantity first, then set opening balances with a stock adjustment noted as "Beginning inventory count" so the transaction history stays clean.

Tax and Accounting

SettingPurpose
TaxableWhether tax applies when the item is billed
Tax CategoryHow tax is resolved for the item on invoices
Income AccountThe accounting income account the item maps to

Multi-entity companies also see an Entity selector; leaving it on the default shares the item across all entities.

Setting Initial Stock After Creation

If you did not set a quantity up front, add it with a stock adjustment.

  1. Open the item from the list
  2. Click Adjust Stock
  3. Choose Add (or Set to enter an exact count)
  4. Enter the quantity from your physical count
  5. Add a reason note like "Initial inventory count"
  6. Save the adjustment

Importing Many Items

To add items in bulk, use Import CSV on the Products & Services list. The wizard uploads a CSV, auto-maps columns, previews the result, and creates the items. Name is the only required column; SKU, category, unit, unit cost, quantity, reorder point, description, and location are optional. Imports are capped at 1,000 rows.

Troubleshooting

Can't create the item?

  • Confirm the Name field is filled in
  • Check that unit cost and quantity are valid numbers

Item not showing in project dropdowns?

  • Refresh the page and confirm the item saved
  • Check that your user has access to Products & Services