Part number generator

Set up the segments of your part numbers and the codes in each, then build a number, decode one back into plain words, and export the code table to Excel. Your scheme stays in this browser.

Part number

-

Checks

    What a part numbering system is

    A part number identifies one part design. Wikipedia's article on part numbers defines it as "an identifier of a particular part design or material," and separates it from a serial number, which identifies one physical unit. A part numbering system is the set of rules your company uses to give every new design its number.

    There are two kinds. In a significant, or smart, system, the number is built from codes that describe the part. In a non-significant system, numbers are handed out in sequence and carry no meaning; the description lives in the item master instead.

    Smart part numbers or plain sequential numbers

    Significant (smart)Non-significant (sequential)
    ExampleBC-060-3000-2-G100427
    What the number tells youThe family, size and options, read straight from the codeNothing; you look the item up
    When the design changesA code can stop being true, so the number needs careThe description changes and the number stays
    Best fitConfigured products and anything a person reads on the floor or in a quotePurchased components and parts that change often

    Wikipedia notes that non-significant numbers "are easier to assign and manage," while significant numbers let people recognise an item from its code. You can use both: a significant model code for the product a customer configures, and plain numbers for the components inside it.

    Part numbering standards

    The best-known rules come from US defence drawing practice. A 2008 NDIA briefing on engineering drawing practices quotes MIL-STD-100G, the Department of Defense standard practice for engineering drawings: a part or identifying number (PIN) uses letters, numbers or both, "shall not exceed 15 characters," and "shall not include the drawing revision."

    MIL-STD-100G is no longer current. EverySpec's record lists it as cancelled and superseded by ASME Y14.100, Engineering Drawing Practices and three other ASME standards. Customers still cite Y14.100 for numbering: NASA Kennedy Space Center's engineering drawing standard tells suppliers to assign a discrete PIN to each item and its parts "in accordance with ASME Y14.100." If a customer's contract names a standard, buy the current edition and follow it.

    The generator warns when a scheme can produce a number longer than 15 characters, when a segment is named for the revision, and when a code uses I, O or Q, which people misread as 1 and 0.

    How to set up a numbering scheme with the generator

    1. List the segments. Start with what a person needs to read from the number, such as the product family, the main size and the options that change the build.
    2. Give every code a meaning. Type one code per line, as "060 = 600 mm wide". A code with no meaning is a code nobody can decode later.
    3. Use a number segment for a dimension. Set the digits once, and the generator pads every value to that width, so 2400 and 3000 both read as four digits.
    4. Pick a separator. A hyphen makes numbers easy to read and to decode. Without one, every code in a segment must have the same length.
    5. Read the checks, then export. Download the code table for your item master, or every combination of the list segments as a CSV file for Excel.

    The decoder works the other way: paste a number and it reads each segment back in plain words, or says which segment is not valid.

    Part numbers for configured products

    A configured product needs a number for each combination a customer can order. In a configurator, the model code comes from the same choices that set the price and the bill of materials, so the code, the quote and the drawing always agree. To total the parts of an existing multi-level BOM, use the BOM explosion calculator. When an estimator types the code by hand from a spreadsheet, one wrong digit sends the wrong product to the floor.

    ThriveAI builds that configurator from the Excel builder your team already trusts. The rules for the code, the price and the drawing come from your workbook, and a named person approves every quote. See the AI CPQ offer, which starts with a free map of the workbook you quote from.

    Where AI helps with part numbers

    An AI model can read an existing item master and propose segments and codes from the descriptions already in it. It can flag two numbers that describe the same part, and decode a legacy number whose scheme nobody wrote down. A person reviews every proposed code before it goes into the ERP, because a part number outlives the people who assigned it.

    Questions

    What is a part number generator?
    A part number generator builds numbers from a scheme of segments and codes, such as a product family, a size and an option. This one also decodes a number back into words and exports the code table to Excel.
    What is the difference between a significant and a non-significant part number?
    A significant, or smart, part number is built from codes that describe the part. A non-significant number is assigned in sequence and carries no meaning, so the description lives in the item master.
    How long should a part number be?
    Keep it as short as the scheme allows. MIL-STD-100G, the old US defence drawing standard, capped a part or identifying number at 15 characters, and the generator warns past that length.
    Should the revision be part of the part number?
    No. MIL-STD-100G said a part or identifying number shall not include the drawing revision. Track the revision beside the number instead.
    Can I export the part numbers to Excel?
    Yes. Download the code table, or every combination of the list segments, as a CSV file that opens in Excel.
    Is my numbering scheme uploaded anywhere?
    No. The scheme and the numbers stay in this browser and are not saved when you close the page.

    Contact

    Get the rules behind your configured products written down

    Tell Derik which workbook your team quotes configured products from and how part numbers are built. He will reply with how to send the workbook for a free map of the rules and gaps.

    Prefer to talk? Book a meeting.

    Your message goes to Derik Lawlis, the founder.