A Complete Guide to Digitizing Your Parts Records from Scratch

Your CMMS is only as good as the data inside it. When part records are incomplete, inconsistently named, or missing critical fields, like minimum stock levels, even the most advanced inventory features become useless.

This guide covers the foundational elements of clean parts data: 

• Naming conventions your team will actually follow
• Required fields for every part record
• Criticality tagging
• QR code setup
• The part status lifecycle that keeps your available quantities accurate

Key takeaways

• Clean parts data makes your CMMS useful by giving technicians, planners, and managers records they can search, trust, and act on.
• Criticality tagging, minimum stock levels, and cycle counts help teams focus attention on the parts that create the most downtime, cost, or operational risk.
• QR codes and clear part status workflows reduce manual searching, prevent ghost inventory, and keep available quantities aligned with how parts actually move.

Why the quality of your parts data can determine maintenance success

Maintenance teams often struggle with stockouts for parts they need while the storeroom overflows with parts they don't. The root cause of this issue is usually a messy, disorganized parts catalog that even the most advanced maintenance software can’t fix.

When data is unreliable, technicians lose 30 minutes or more each shift walking, calling, texting, and waiting for parts instead of fixing equipment. Meanwhile, 30% of the average facility’s MRO inventory is excess, obsolete, or simply hasn’t moved in years.

When you add up these factors, maintenance teams can spend hundreds of thousands of dollars on missing inventory, inefficient repair processes, and wasted shelf space that can all lead to massive unplanned downtime costs.

Four characteristics of a well-structured parts inventory

Before you make any changes to your parts strategy or your computerized maintenance management system (CMMS), the foundational data has to be healthy. A well-structured parts inventory in maintenance software has four key characteristics:

• Searchable names: Parts have consistent, predictable names that everyone on the team can easily search for
• Complete part data: Location, minimum stock level, vendor, and part number are filled in for every part record
• Criticality tags: Critical parts are clearly identified so the system knows which items you absolutely cannot run out of
• Scannable codes: QR codes or barcodes are printed and attached to bins so technicians can scan items instead of typing

How to create a spare parts naming convention your team will follow

A solid naming convention helps your team find parts faster and reduces search errors. The format that works best for most teams is simple: what the item is, where it goes, and the size or spec.

The three-part naming formula

For example, a part could be named "Belt, Conveyor B, 42 inch." 

• ‘Belt’ is the kind of part
• ‘Conveyor B’ is the asset associated with it
• ‘42 inch’ is the spec. 

Including the equipment right in the name helps a technician at 2am quickly find the exact filter that belongs to a specific machine without guessing.

Use this framework as a baseline and then add fields to capture more granular details, like thread size, flow rate, compatibility notes, or installation specs.

Why consistency beats complexity

It doesn't matter what exact naming pattern you choose. What matters is that you agree to one and make sure the team follows it. The best naming convention is the one that everyone actually uses. If the naming convention only exists in one person's mind, finding parts becomes impossible for everyone else. Write it down, share the document, and hold a team meeting to align on the standard.

Required fields when adding parts to your CMMS

When creating a new part record, certain fields are essential for enabling powerful inventory management features.

Identification and description fields

• Part name: Follows the standardized naming convention your team agreed upon
• Description: Captures details the title can't, like thread size, flow rate, material, or compatibility notes
• Barcode: Can be auto-generated if the setting is enabled, saving manual work
• Part type: Designates the part's criticality (example, critical, standard), which powers filtering for cycle counts and reporting

Inventory and stocking fields

The unit cost field powers reporting and purchasing data. As you use and order parts, it captures how much you spend, which can then be compared to the cost of your strategy, like conducting PMs vs. settling for reactive maintenance. If you have a setting that captures the real-time average of costs, you can get a more accurate reading on the data if the price fluctuates or if you buy from multiple vendors at different price points.

Stocking fields also include:

• Location: The building or site where the part is stored
• Area: The specific bin, shelf, or aisle within the location
• Quantity in stock: The current physical count
• Minimum stock: The threshold that triggers low stock alerts

If the minimum in stock field is blank, the system assumes it's a non-stock part and will never generate a low-stock alert for it.

Vendor and ordering fields

The vendor name identifies your supplier, and the manufacturer part number is what your supplier actually recognizes when you reorder. Linking parts directly to vendors streamlines the reordering process.

Location vs area in a CMMS

A common point of confusion in inventory management is the difference between the location and area fields.

Location refers to the building, warehouse, or site where the inventory exists. Each location has its own separate inventory count. Area refers to where the part physically lives inside that building, like Aisle 3, Bin 2, or Shelf B. A single part can exist in multiple locations with different stock quantities tracked at each site.

How to tag part criticality using ABC classification

Not all parts deserve the same attention. The ABC classification framework, aligned with guidelines from the Society of Maintenance and Reliability Professionals (SMRP), is a simple way to categorize parts and determine how frequently they get counted.

A parts

High-value, high-criticality parts that receive the most attention. They may represent a small percentage of your total catalog but account for the majority of your inventory spend or downtime risk. Critical parts get prioritized for restocking, cycle counts, and escalation notifications. Per SMRP recommendations, count A parts monthly.

B parts

Moderate value and importance. A stockout is an inconvenience, but not catastrophic if the part is unavailable for a day. Count B parts quarterly.

C parts

High-volume, low-cost items like bolts, fittings, and lubricants. Necessary, but not where you spend the bulk of your management energy. Count C parts twice a year at minimum.

Setting up QR codes and barcodes for parts tracking

QR codes can help your team access parts quicker and improve parts inventory tracking by centralizing and standardizing data through a single input. Below are some tips on how to implement QR code and barcode tracking for spare parts.

Enabling auto-generated barcodes

Set up your CMMS to automatically generate a unique barcode or QR code every time a new part is created. This eliminates extra clicks and ensures every part is ready for scanning from day one.

Printing and attaching codes to bins and assets

Once codes are generated, print them directly from the part record and attach them securely to the corresponding storage bins, shelves, or drawers. Start with your critical parts this week. You can also create QR codes for asset profiles that include associated parts. Attach these QR codes to assets so technicians can instantly see which parts they need for replacements or repairs.

Scanning parts from the mobile app

With codes in place, technicians can scan the code on the bin instead of manually searching for a part name. Scanning instantly pulls up the part's details, allowing them to log usage, check stock levels, and trigger restock requests in seconds right from the storeroom floor.

How to set up your work orders for better parts tracking

Historically, CMMS platforms created "ghost inventory" issues. Parts were automatically reserved when added to a work order (even one scheduled months away), but only consumed when the work order was marked complete. Solving this problem requires a five-step process that decouples part consumption from work order status to reflect how parts actually move.

#1: Assigned

A part is identified as needed for a work order and added to it. Assigned is a planning signal, not a commitment. It does not reduce your available quantity because if it did, every work order scheduled three, six, or twelve months out would inflate your committed numbers, and you’d never trust your inventory again.

#2: Reserved

The part is now officially committed to a specific work order. At this stage, the part's stock count is reduced to reflect its status, preventing the same part from being promised to two different jobs. An auto-reserve window can automatically move parts from Assigned to Reserved as the work order date approaches. That way, Reserved reflects actual upcoming work, not someone's wish list.

#3: Kitted

A parts clerk or planner physically picks the reserved parts and groups them together for a specific job. Think of it like staging tools and materials before a planned shutdown—everything is ready when the technician arrives. The parts are still in the building, so this status does not reduce the In stock quantity.

#4: Staged

The kitted parts are moved to a designated pickup or staging area near the work location. The job is now officially parts ready, and a notification can be sent to the technician.

#5: Issued

The technician has the parts in hand and is performing the work. This is when the In stock inventory quantity is updated. Because part status is now decoupled from work order status, the work order can remain open for days while the part is correctly marked as issued and removed from inventory counts.

How to calculate available, committed, and in-stock quantities

Understanding the difference between in stock, committed, and available quantities is crucial for accurate planning.

• In stock is the total quantity physically sitting in your inventory, including items that have been kitted or staged. In a real emergency, you could still pull those parts for another job.
• Committed is inventory promised to work orders. Committed equals reserved, kitted, and staged. This doesn’t include a part being assigned, because that would mean you're planning for the work, but that the inventory is not actually being held for that job.
• Available is what can realistically be used today for other upcoming work orders. Available equals in stock, but not committed. This is the number your planners and schedulers look at when deciding whether work can actually start.

For example, you might have 10 filters in stock in various parts of their usage lifecycle:

• In Stock: 10
• Committed: 5 (3 reserved, 2 kitted)
• Available: 5 (10 in Stock with 5 committed)

Three KPIs that measure parts inventory health

The SMRP recommends three gold-standard KPIs for parts inventory:

1. Inventory accuracy

This KPI measures whether the quantity in your CMMS matches the physical quantity on the shelf. You should target 95% or better. Achieve high accuracy by setting minimum stock levels for every part and performing regular cycle counts on a schedule that matches part criticality.

2. Inventory turns

This KPI tells you if your inventory is actually moving. Parts that haven't budged in 12 months and are not designated as critical spares are hurting your operation. Target greater than one overall, and greater than three for non-critical spares. 

3. Stockout trends

Target stockouts trending down month over month. The minute a part walks out of the storeroom untracked, your inventory accuracy dies, and you can no longer trust any number in the system.

Five actions to improve your parts data this week

Here are five things you can accomplish this week:

1. Document and share your naming convention

Choose a simple structure, write it down in a shared document, and hold a brief team meeting to get everyone aligned. This single step turns a good idea into a process your team can follow.

2. Set minimum stock levels on critical parts

Don't try to clean up your entire storeroom in one week. Start with the parts that hurt the most when they're missing. What shuts production down? What causes emergency purchasing? Set the minimum stock levels for those parts first so your low stock alerts become useful and actionable.

3. Print QR codes for high-priority items

Enable auto-generated barcodes in your CMMS, print the codes for your most critical or frequently used parts, and attach them to the correct bins. Technicians can now scan instead of search.

4. Create a monthly cycle count for critical parts

Start simple. Create one recurring cycle count procedure for your critical parts, set it to repeat monthly, and assign it. This single action begins building a routine for inventory verification.

5. Build a parts-blocked work orders filter

In your work order list, add columns for part status and parts availability. Create and save a shared filter for work orders where parts are unavailable or overcommitted. Planners and storeroom staff can now spot problems before a technician arrives at a job they cannot complete.

Clean parts data is what makes inventory control possible

A CMMS can’t prevent stockouts, reduce excess inventory, or help planners trust availability numbers if the parts data behind it is incomplete. The system needs a clear structure with consistent names, required fields, criticality tags, and scannable codes.

You don’t have to fix every record at once. Start with the parts that matter most to uptime, safety, and production continuity, then set minimum stock levels, clean up naming, and print QR codes. Those actions may feel small, but they create the foundation for better planning, faster repairs, cleaner reporting, and fewer surprises on the floor.