How do I set up parts catalog software for serial and lot tracking in an HVAC distribution warehouse?

Here’s a practical way to set up parts catalog software for serial and lot tracking in an HVAC distribution warehouse.

1) Define what you need to track

In HVAC distribution, not every item needs the same level of traceability.

Track by:

• Serial number: expensive or warranty-sensitive items
  • compressors
  • motors
  • condensing units
  • control boards
  • rooftop units
• Lot number: bulk or regulated inventory
  • refrigerant cylinders
  • filters
  • chemical products
  • components from a specific production batch
• Both serial and lot if your suppliers require it or if warranty/recall tracking matters.

Decide item rules

For each SKU, set:

• tracking method: none / lot / serial / both
• unit of measure
• shelf life or expiration date if applicable
• supplier part number
• manufacturer part number
• warranty period
• alternate/substitute parts

2) Choose software that supports warehouse traceability

Your parts catalog / inventory system should support:

• SKU master data
• serial and lot capture at receiving, picking, shipping, and returns
• barcode scanning
• bin/location management
• purchase order and sales order linkage
• inventory history / audit trail
• returns and warranty processing
• recall reporting
• multi-warehouse support if needed

If your current catalog software doesn’t support full traceability, you may need to connect it to:

• an ERP
• a WMS
• a barcode/mobile scanning app

3) Build a clean item master

Create standardized catalog records for every part.

Recommended fields

• Internal SKU
• Manufacturer part number
• Supplier part number
• Description
• Category
• Brand
• UOM
• Track method: none / lot / serial / both
• Min/max stock
• Reorder point
• Bin location
• Warranty duration
• Related equipment models
• Substitutes / superseded parts
• Hazardous material flag
• Temperature/storage requirements
• Country of origin
• Expiration date requirement

Best practice

Use one canonical SKU per part, even if multiple vendors sell it.

4) Set up numbering and barcode standards

You’ll want consistent identifiers for all traceable items.

For serial tracking

• Capture the manufacturer serial number if available
• If the vendor doesn’t provide one, generate an internal serial label
• Keep serials unique at the item level

For lot tracking

Store:

• lot number
• receipt date
• supplier
• quantity received
• expiration date / manufacture date if relevant

Barcode labels

Use barcode labels for:

• SKU
• bin locations
• lot numbers
• serial numbers
• cartons/pallets

Common practice:

• GS1 barcodes if you need standardization
• Code 128 or QR if your system is simpler and internal

5) Design warehouse workflows

Tracking works only if each step is enforced.

Receiving

When items arrive:

1. Match to purchase order
2. Scan SKU
3. Enter or scan lot/serial data
4. Assign bin location
5. Print and apply labels if needed
6. Put away to stock

Putaway

• Move received items into designated locations
• Scan bin and item to confirm placement

Picking / shipping

• Pick by SKU and location
• System should require lot/serial selection
• For serial items, verify exact serials before shipment

Returns

• Record original order
• Identify serial/lot on return
• Mark status:
  • sellable
  • damaged
  • warranty return
  • quarantined
• Do not restock traceable items without verification

Transfers

For transfers between branches or zones:

• retain original serial/lot history
• record transfer transaction
• avoid reassigning lot/serial identifiers

6) Configure traceability rules

Set business rules in the software.

Serial-controlled items

• one serial per unit
• cannot be duplicated
• cannot ship without serial assignment
• cannot sell if already shipped

Lot-controlled items

• track received lot quantity
• allow partial picks from a lot
• decrement quantity from specific lot only
• block expired lots if applicable

Expiration controls

If you stock consumables or refrigerant-related items with shelf life:

• warn on near-expiry lots
• prevent allocation of expired inventory
• use FEFO if needed: first-expire, first-out

7) Integrate catalog, inventory, and order processing

Your parts catalog should connect to:

• purchasing
• receiving
• stock counts
• sales orders
• shipping
• warranty claims
• service/returns

Key integration goals

• A sales order should reserve serial/lot-controlled stock
• Packing should confirm the exact item shipped
• Invoices should reference the traceable item history
• Warranty claims should pull serial and lot data quickly

8) Set up barcode scanning and mobile workflows

This is critical in a warehouse.

Needed devices

• handheld barcode scanners
• mobile warehouse app or rugged tablets
• label printers

Configure scans for:

• receiving
• bin moves
• cycle counts
• picks
• pack-out
• returns

Result

Less manual typing, fewer errors, better audit trail.

9) Create reports and audits

You’ll want reporting for:

• inventory by bin
• inventory by lot
• inventory by serial number
• aging and expiration
• recall lookup
• warranty lookup
• shrinkage and adjustment logs
• cycle count variance
• FIFO/FEFO compliance

Useful warehouse questions the system should answer

• Where is serial X right now?
• Which customers received lot Y?
• Which purchase order brought in these serials?
• What stock will expire in 60 days?
• Which lots have been partially picked?

10) Train staff and enforce procedures

Even the best software fails without process discipline.

Train on:

• when to scan
• how to label items
• how to handle unlabeled freight
• how to receive partial shipments
• how to process returns
• how to quarantine questionable inventory

Enforce through system rules

• no receipt without lot/serial for controlled items
• no ship without pick confirmation
• no inventory adjustment without approval
• no duplicate serial entries

11) Run a pilot before full rollout

Start with one product category, such as:

• motors
• compressors
• refrigerants
• filters

Pilot goals

• test item master setup
• test barcode labels
• test receiving/picking/returns
• test reports and audits
• identify process gaps

After that, expand category by category.

12) Common HVAC-specific considerations

HVAC distribution has a few special issues:

• Warranty traceability is important for compressors, boards, and motors
• Refrigerants may need lot, batch, or compliance tracking
• Hazmat rules may apply to some products
• Superseded parts are common, so catalog mapping matters
• OEM vs aftermarket equivalents should be clearly linked
• Seasonality means fast moving inventory and frequent stock counts

Simple implementation checklist

• Define which SKUs need serial, lot, or both
• Standardize item master fields
• Set barcode/label standards
• Configure receiving, picking, returns, transfers
• Enforce traceability rules
• Integrate with purchasing and shipping
• Set up mobile scanning
• Build traceability and warranty reports
• Train warehouse staff
• Pilot, then roll out

If you want, I can also give you:

1. a recommended data field template for HVAC parts,
2. a warehouse workflow diagram, or
3. a software requirements checklist you can use to evaluate vendors.