Custom fields in the real world: 10 ways teams use them
The best way to understand custom fields is to see what other teams track with them. Fields can sit at the item level (shared catalog facts) or the unit level (per stock line or physical unit). Here are ten setups from different industries. Notice the pattern: each one is a detail the standard count-and-cost columns can’t hold, but that the business can’t run without.
1. Pharmacies and clinics: lot & expiry
Lot # and Expiry as unit-level fields on every consumable mean a recall is a search, not a scavenger hunt, and stock rotates first-expiry-first even when one SKU has several lots. The backbone of dental and medical inventory.
2. Retail and boutiques: color & size
Color and Size as item-level fields turn one style into countable, sortable variants, so a rack of fifteen things stops counting as one. See retail inventory.
3. Construction and trades: serial & condition
Serial number and Condition as unit-level fields make every drill and generator individually accountable, with maintenance dates so nothing fails on site. More in tool and equipment tracking.
4. Warehouses: bin location
A Bin or Aisle field (item-level for a fixed home, or unit-level when stock moves) shown as a column turns “somewhere in receiving” into “A-04,” so anyone can pick an order without a guided tour.
5. Makerspaces: material & specs
Track Filament type, Color and Diameter on spools, or Thread pitch on fasteners, so members grab the right thing the first time. See makerspace inventory.
6. Food and beverage: received date & allergens
A unit-level Received date drives FEFO rotation, and an item-level Allergens field keeps critical product info on the SKU, not in someone’s head. Handy across restaurant and bar inventory.
7. E-commerce: supplier SKU & barcode
Keep your own clean item names while storing the Supplier SKU and Barcode as item-level custom fields, so reordering and matching packing slips stays painless. Related: SKUs and barcodes vs QR codes.
8. Field and mobile teams: assigned vehicle
A unit-level Assigned to or Vehicle field records which van a tool lives on, so van stock stays accountable across the fleet.
9. Electronics & IT: warranty & purchase date
Unit-level Warranty until and Purchase date fields tell you instantly whether a failed unit is covered, and when it’s due for replacement.
10. Anyone reordering: minimum order & pack size
An item-level Pack size or Min order field keeps purchasing rules right on the SKU, so reorders go out in the units suppliers actually ship.