• +1 407-906-9790
  • info@convergencedata.com
convergence-data-logo
  • Our Solutions
    • SmartSwitch
    • Data Services
    • Competitive Intelligence / Smart Teardown
    • Product Information Management (PIM)
    • Product Lifecycle Management (PLM)
    • Digital Asset Management
  • Who We Serve
    • Industries
      • HVAC
    • Marketing
    • Engineering
    • Ecommerce
  • About
    • Events & Conferences
    • Partners
  • Resources
    • Blog
    • Resource Center
    • Classification Community
    • DFR University
    Contact Us
    Contact Us
    con_logo

    What can we help you with?

    Follow Us

    Challenges Managing Duplicate Parts

    Ryan Donovan
    Sep 1, 2015
    Cleansing Data

    Challenges Managing Duplicate Parts

    1. Overview

    Duplicates and near duplicates add costs throughout a products lifecycle, so it sensible to standardize on parts and avoid creating redundant or duplicate parts. Identifying duplicates and near duplicates is a cost effective exercise with excellent ROIs.

    Duplicates-2Finding exact duplicates is not too difficult, however identifying near duplicates can be difficult. For example, two screws might have the same thread size, same length, and same coatings. Viewing the items in a stock room, it might not be able to tell the screws apart. However, the material strengths of the screws might be different and to haplessly swap the screws could have catastrophic results.

    There are varieties of specifications to consider identifying near duplicates. Every type of part will require special consideration.

    The first step to identify duplicates is to organize parts using a classification scheme. To categorize the parts, organize technically similar parts into categories based on a hierarchical structure. The hierarchical structure can be a custom structure or an existing classification structure (ECCMA/ISO 8000, eClass, or UNSPSC). Using an existing classification structure is usually sufficient and can save lots of internal debate working out the subtitles of a custom structure.

    Attributes are associated with each category. The attributes allow comparison between components in the category. To compare components, each parts’ attributes need to be complete and consistent. For example, a material attribute might have different values for the same material. Consider values for stainless steel, it might have values of “Stainless Steel”, “SS”, or “SS 316”.

    Before identifying duplicates, the attributes values need to be normalized so each unique attribute value only has one allowed value.

    After components have been categorized and the attributes values have been normalized, exact duplicates can be found by identifying components whose attributes all match. After exact duplicates are identified, a preferred component should be selected to promote a single standard and increase part reuse.

    Searching for near duplicates is more complicated, since some components might not have exact matching attributes, but still might be able to be substituted for each other. Identifying near duplicates is an opportunity to consolidate part count and increase part reuse. For example, an electrical component such as a resistor, might be functionally identical but might have different form and fit preventing them from being substituted on designs. Or consider clamps which have identical form and fit, but are made of different materials. One material only being able to function at standard temperature while the other can withstand high temperatures. Substituting the low temperature material clamp for the high-temperature clamp could lead to a dangerous failure.

    With near duplicates, distinguishing near duplicates is dependent on a company’s specific use of the components, so each near duplicates analysis requires a unique set of criteria to assess. To define the criteria, consider grouping component attributes according to the three ‘F’s - form, fit, and function. Using the 3Fs can help establish which attributes are important for a company’s use case.

      • Form refers a part’s shape, size, mass, and physical distinguishing features.
      • Fit refers to a part’s ability to interface with, connect to, or integrate with other parts.
      • Function refers to a part’s intended action(s)

    Depending upon the component type and use case, priority could be given to a different one of the three Fs. Electrical parts have many types of components which are functionally identical, but have different fit and form, so priority might be given to fit and form over function. Mechanical parts, however, might have some bolts with identical form and fit, but might have different materials with different strengths, so their function might different. So for mechanical parts, function might need to be prioritized.

    Identifying duplicates and near duplicates requires effort to set up a system to categorize and compare components, but the benefits are worth it. Identifying duplicates improves engineering’s ability to select parts, increases part reuse and standardization, decreases inventory, and improves purchasing’s leverage with vendors.

    There may be several reasons why a company may have duplicates including: more than one new part creation process, having a new part creation process that doesn’t enforce data standardization and categorization, very poor legacy data impossible to search, etc. If your company has any of these characteristics, there will always be a struggle to address duplicate part proliferation issues.



    10 critical REQ classification System


      Posts by Tag

      • Classification (53)
      • Cleansing Data (43)
      • PIM (35)
      • PLM (35)
      • Duplicate Parts (32)
      • Cost Savings (28)
      • Ecommerce (27)
      • Convergence Data (26)
      • DFR (23)
      • Governance (20)
      • data normalization (20)
      • Data Cleansing (18)
      • Parts Classification (17)
      • Taxonomy (17)
      • Data Governance (16)
      • Data Migration (16)
      • Digital Thread (16)
      • Manufacturer Parts (16)
      • Product Data (16)
      • Aftermarket Parts (15)
      • Bulk Loading Data (15)
      • Data Classification (15)
      • ERP (15)
      • Business Integration (13)
      • Product Information Management (13)
      • B2B (12)
      • Part Cleansing (12)
      • Product Analytics (12)
      • Teamcenter (12)
      • New Part Introduction (11)
      • Part Standardization (11)
      • Data Integration (10)
      • Digital Commerce (10)
      • Service Parts (10)
      • Cost Reduction (9)
      • DFR PLM Integration (9)
      • Engineering (9)
      • Findability (9)
      • Repair Parts (9)
      • Spend Rationalization (9)
      • Benchmarking (8)
      • Digital Transformation (8)
      • Duplicate Analysis (8)
      • Part cost (8)
      • Supplier Management (8)
      • Aerospace (7)
      • B2C (7)
      • HVAC (7)
      • Sourcing (7)
      • Spend Analysis (7)
      • Analytics (6)
      • Data Management (6)
      • Data Onboarding (6)
      • Mergers & Acquisitions (6)
      • Part Rationalization (6)
      • Workflows (6)
      • classification structure (6)
      • DAM (5)
      • Data Factory (5)
      • Direct Materials (5)
      • Distributor (5)
      • Enrichment Lifecycles (5)
      • Product Structures (5)
      • Purchased Parts (5)
      • Supplier Rationalization (5)
      • categories (5)
      • Business Case (4)
      • Clusters (4)
      • Customer Experience (4)
      • Data Validation (4)
      • Digital Assets (4)
      • Electrical Parts (4)
      • Electronic Parts (4)
      • OEM (4)
      • PTC LiveWorx (4)
      • Part Preparation (4)
      • Procurement (4)
      • Product Attributes (4)
      • Searching (4)
      • Value Engineering (4)
      • Windchill (4)
      • Competitive Analysis (3)
      • Component Data (3)
      • DFRv10 (3)
      • Data Policies (3)
      • Integration (3)
      • Loading Data (3)
      • Match and Merge (3)
      • PIM 101 (3)
      • PIM Migration (3)
      • PTC (3)
      • PTC Windchill (3)
      • Regulatory Compliance (3)
      • Relationship data (3)
      • SiliconExpert (3)
      • Standard Parts (3)
      • supplier pricing (3)
      • 2019 Blogs (2)
      • A2L (2)
      • Acquisition Onboarding (2)
      • B2B2C (2)
      • D2C (2)
      • Data Mapping (2)
      • Design Parts (2)
      • HFCs (2)
      • Hybris (2)
      • Kalypso (2)
      • M&A (2)
      • Mechanical Parts (2)
      • Omnichannel (2)
      • PLM World (2)
      • ROI (2)
      • Refrigerants (2)
      • Sales Conversions (2)
      • reclassify (2)
      • smartclass (2)
      • suma (2)
      • 2016 Top Blogs (1)
      • 2021 blogs (1)
      • Aftermarket (1)
      • Arbortext (1)
      • Category Editing (1)
      • DFR University (1)
      • DFR v13 (1)
      • Dictionary (1)
      • EPA (1)
      • Finished Goods (1)
      • GWP (1)
      • IHS (1)
      • IoT (Internet of Things) (1)
      • LiveWorx 2023 (1)
      • Metadata (1)
      • Multi-Tier Data Model (1)
      • NPI (1)
      • National Oilwell Varco (1)
      • Part Approval (1)
      • Part Obsolescence (1)
      • Part Reclassification (1)
      • Partnership (1)
      • Pricing Data (1)
      • Purchasing (1)
      • SAP Hybris (1)
      • SCM (1)
      • Shape-Based Search (1)
      • Siemens (1)
      • Sustainability (1)
      • Syndication (1)
      • Teardown (1)
      • Vendor Portal (1)
      • WBR Research (1)
      • allowed values list (1)
      • attribute data (1)
      • cx (1)
      • data (1)
      • outsourcing (1)
      • prune (1)
      • units of measure (1)
      See all

      Recent Posts

      Stay in the know!

      con_logo
      Convergence Data's proprietary software and time-tested processes eliminate the clutter in your data—so you can use it to make sound business decisions.
      Our Solutions
      • Data Services
      • Competitive Intelligence
      • DFR
      • Image Services
      Who We Serve
      • Industries
      • Marketing
      • Engineering
      about
      • About Us
      • Partners
      Resources
      • Blog
      • Resource Center
      • Classification Community

      © 2025 , Convergence Data All Rights Reserved.