In this guide 6 sections
An installed base register for a pump maker records, for each unit, the nameplate serial, model, impeller size, duty point, seal type, motor details, site and commissioning date. With those fields on hand, a spares or repair request can be quoted from the register instead of by phone calls.
Why spares quotes slow down
A customer rings: the pump is leaking. You ask for the model. They read half a nameplate, or send a photo taken in poor light, and someone at your end digs through old job files hunting for the original order.
That hunt is the delay. The part is usually on the shelf. Nobody can say which mechanical seal, which wear ring or which impeller trim the unit was built with, so the quote waits for someone to find a file.
A register fixes it. Every unit you ship gets one line, filled in at dispatch while the build sheet, the test certificate and the nameplate photo are still in the building.
Capture the nameplate and the build
Begin with the stamped plate. The serial number is the key. Add the model, the casing material, the impeller diameter and material, the shaft size, the frame number and the year of manufacture, each copied exactly as stamped.
Next come details the nameplate never shows: the seal make and type, the gland packing if any, the bearing numbers, the coupling and the baseplate. Trust the build sheet, not memory. A pump built with a double seal and an API flush plan needs different spares from one with simple packing, even when the two casings look identical.
Store the test certificate number and the performance curve used, so a later complaint about flow can be checked against what the pump delivered on the test bed.
- Serial number and model
- Impeller diameter and material
- Casing and shaft material
- Seal make, type and flush plan
- Bearing and coupling numbers
- Test certificate number
Record the duty point and the motor
Every pump has a duty point. Flow, head and liquid. Record all three, along with the liquid’s temperature, its specific gravity and any solids it carries, because a spares quote for the wrong duty is wasted effort.
If you supplied the motor, record its make, frame size, kilowatt rating, voltage and speed so the right replacement can be found. Flag any customer-fitted motor.
Note the drive too. A variable frequency drive changes how the seal and bearings wear, so record the control mode, daily running hours and any history of dry running or cavitation. Service staff then know before they arrive.
Add the site and the contact trail
Record the end customer, the plant, the exact tag number the customer uses for the pump and the person who looks after it. Callers quote tags, not serials. Search must work on either.
Include the dealer or contractor who installed it, the commissioning date and the warranty end date, and link the original order, the dispatch note and the commissioning report.
Add every service visit here. A replaced seal, new bearings and a trimmed impeller become the unit’s history, and over time the register shows which seals fail early on which liquids. Sales can offer a fix first.
- Customer, plant and pump tag
- Dealer or installing contractor
- Commissioning and warranty dates
- Linked order and dispatch note
- Service visits and parts replaced
Start with what you ship next month
Skip the ten-year backfill. Old paper job cards, dealer lists and warranty cards are patchy, and chasing them will stall the project before a single new pump is logged. Begin at the dispatch bay.
Let the dispatch clerk fill each line with the build sheet beside him, then work backwards through your largest customers and their oldest pumps. Repairs add units one by one. Within a year, the register covers the pumps that actually generate spares orders, seal kits and repair jobs for your service desk.
Installed pump register template
One row per unit. Columns are serial number, model, impeller diameter, seal type, motor rating, liquid, flow, head, customer tag, site, installer, commissioning date, warranty end date and last service date. Beneath it, a second table logs each service visit, every part replaced and the engineer who attended, all keyed to the serial number of the pump.
Open a blank worksheet to printQuestions owners ask
Which field matters most in the register?
The serial number. Every other record links to it. Next come the seal type and the duty point, since those two decide most spares and repair quotes for a typical unit in the field.
Do we need the customer’s tag number as well?
Yes. Plant staff rarely quote serial numbers when they ring in. They say the tag from their own piping drawings, so the register should let you search by either one.
How do we handle pumps sold through dealers?
Record the dealer. Then ask for the end customer and site at dispatch or at warranty registration, because a pump with no site recorded cannot be serviced quickly later.
Can a spreadsheet hold the register?
For a small number of units, yes, as long as the serial is unique and one person owns it. As volume grows, linked records help, because orders, spares and service visits attach to each unit.