Reading a Spare Parts List: From Mixed Enquiry to Purchase Order

Most buyers do not send a part number; they send a list. It arrives as a spreadsheet, a PDF, a photograph of a handwritten page or a forwarded email with numbers accumulated over months. Turning that into orders is a discipline, and the quality of the list determines how fast and how accurately it can be quoted.

The types of line you will find on a real list

• Exact, live references — straightforward: check stock, price, ship.
• Obsolete references — need a successor or a qualified equivalent.
• Partial or ambiguous numbers — a base number without its suffix, or a code that belongs to a drawing rather than a catalogue.
• Brand-plus-description lines — “Schmersal safety switch” with no reference, which must be narrowed down before anything can be quoted.
• Duplicates — the same part listed twice under different spellings.

How to make a list quotable

• One part per line, with quantity and any acceptable condition in their own columns.
• Mark the urgent lines, and say what “urgent” means — a date, not a feeling.
• Group by category or by machine, so the desk can work it efficiently.
• Attach nameplate photos for anything whose reference is uncertain.
• Note the target price only if it is real; an unrealistic one wastes everyone’s time.

How we work a list

We split it into immediate stock, items needing cross-reference, and items needing clarification, then come back with a structured quotation: per line, the exact part or the proposed equivalent, the condition, the price, the lead time and any residual uncertainty. Where a part genuinely cannot be sourced, we say so rather than leaving the line open.

A worked list, line by line

A real enquiry is rarely a clean column of part numbers. It arrives as a spreadsheet, a photograph of a printed list, or a pasted block with inconsistent formatting. What follows is the pattern we see most often, and how each type of line is handled.

Line as received	What it actually is	What we do	What we need from you
A full part number with a maker name	Unambiguous	Quote directly, including the supersession chain if the number has been replaced	Quantity, and whether a functional equivalent is acceptable
A partial number or one with the suffix missing	Matches several variants	Return the candidate list with the specific attribute that separates them	A photograph of the old part, or confirmation of the separating attribute
A description with no number: “seal kit for the pump”	Machine-level identification	Work backwards from the machine model and the position in the parts list	Machine nameplate photograph and the position number if known
A drawing number that is not a catalogue part	A made-to-print item	Treat as a manufacturing enquiry, not a sourcing enquiry	The drawing, or a sample plus the material and heat treatment
A brand name with no number: “Schneider contactor”	A specification that is entirely missing	Cannot be quoted. Guessing here produces a wrong part every time	The reference, or the machine’s schematic showing coil voltage and rating
A number that returns nothing anywhere	Often a typographical error, an internal customer number, or a genuine one-off	Search the variants around it before concluding anything	A photograph; a single character corrected is often the whole answer

The single most useful thing you can attach to any list is a photograph of the machine nameplate. It costs nothing, and it converts several of the rows above from “needs clarification” into “answered”.

The lines that block a whole quotation

One unresolvable line should not hold up the other forty. The practical approach is to quote what is clear and list the rest separately:

• Missing quantity. Applies to the whole document, not one line. A quantity of one versus ten changes both price and freight markedly for heavy items.
• Ambiguous alternative. “Or equivalent” is only useful once you have said which attributes may vary. Equivalent in function is very different from equivalent in footprint.
• Obsolete with no replacement stated. We will say whether stock exists, what it costs, and what the alternatives are — but the decision on whether to substitute is yours.
• Two different numbers on one line. Usually a superseded number alongside the current one. Send both; it tells us the vintage of your fleet.

Turning a list into a purchase order

The gap between a quotation and an order is where errors are introduced, because it is where information is compressed. Three habits close it:

1. Carry the maker’s name on every order line, not just the part number. A number without a maker is an invitation to supply an equivalent.
2. State the destination and the required date on the order, not in a separate email. Lead time is only meaningful when the destination is known.
3. Keep the enquiry number on the order. It links the order back to the specification conversation, which is the only reliable defence when a dispute arises about what was agreed.

Questions we are asked about spare parts lists

How many lines can you handle at once? There is no practical limit for quoting. Where a list runs to hundreds of lines, expect it to come back in stages so the urgent items are not held up behind the slow ones.

Can you work from a photograph of a printed list? Yes, provided the numbers are legible. Where they are not, we will come back with the specific lines that need re-photographing rather than guessing at them.

Will you tell me if a line is not worth buying? We will. If a part is available at a price that bears no relation to its function, or if a simple alternative exists, saying so is more useful than a quotation.

References we have recently quoted in this category

Need a specific reference? Send the exact number to [email protected] with quantity and target date — we reply with sourcing options, equivalent/replacement candidates, condition and lead time.

Related reading

• Obsolete PLC, Sensor & Motor Parts: A Cross-Reference Workflow
• MRO Spare Parts Management
• Spare Parts Management: Principles and Practice