• +1 407-906-9790
  • info@convergencedata.com
convergence-data-logo
  • Our Solutions
    • Data Services
    • Competitive Intelligence / Smart Teardown
    • Design for Retrieval
    • PLM
    • Image Services
  • Who We Serve
    • Industries
    • Marketing
    • Engineering
    • Ecommerce
  • About
    • Partners
  • Resources
    • Blog
    • Resource Center
    • Classification Community
    • DFR University
    Contact Us
    Contact Us
    con_logo

    What can we help you with?

    Follow Us

    4 Critical Steps to Control Duplicate Parts in Your PLM

    Richard Turner
    Sep 28, 2022
    Classification, Duplicate Parts, Data Cleansing

    4 Critical Steps to Control Duplicate Parts in Your PLM

    Duplicate parts are the software bugs of the data world—they’re hard to identify without specific tools and processes in place. If these “bugs” are not found during implementation, your PLM setup will become extremely time-consuming and costly down the road. 

     

    To put your organization in the best position for a successful PLM migration, you’ll want to give yourself enough lead time (i.e. six to 12 months) prior to the implementation to find duplicate parts and formulate a plan to deal with them.

     

    To exterminate the duplicate data pest, follow these four critical steps.

     

    1. Collect and Classify the Data

    It is key to run any duplicate analysis off of a specific category of data—which is why your first step is to classify the parts. Start by gathering all the purchase part data together from each legacy system, including:

    • Manufacturing part numbers
    • Supplier names
    • Pricing
    • Existing internal part numbers
    • Descriptions
    • Any existing commodity codes

    Typically, data from different systems need to be classified into a single data model, which will help dictate the categories. This, in turn, drives the attributes and allowed values of each part.


    2. Enrich and Validate the Data

    Once all the data from each system is classified, it’s time to enrich the data. You can harvest attribute data for each part using the manufacturer part numbers and associated source documentation.

    image3-4

    The data is usually obtained from approved manufacturer websites or company-approved documentation (e.g specifications, drawings, etc.). The harvested data should be loaded into a database and validated against the data model.

     

    For example, when validating air conditioner motors, enriching each motor with key information such as horsepower, speed, number of poles, phases, and frequency allows you to group duplicate motors and similar motors more easily. In some cases, motors with different manufacturer part numbers can have very similar characteristics.

     

    3. Perform a Duplicate and Near Duplicate Analysis

    Once the data has been enriched, normalized and validated, perform a duplication analysis. When grouping similar parts to help find near duplicates, a clustering tool will be helpful. 

     

    At Convergence Data, we refer to this as “neighbor distance.” It allows different weighting factors to be set on the critical attributes and the overall cluster. To make this analysis work, you must have normalized data with separate units of measurement.

    Duplicate_Blog_chart_v2.jpg

    These parts have the same attribute values and therefore may be duplicates.


    4. Process Identified Duplicates

    Last, take the groups of duplicates and select one internal part number to be the master for each manufacturer part number (MPN). Since you will likely end up with multiple internal part numbers for an MPN, we recommend setting up a master cross reference—this will consolidate spend and rationalize your inventory without disrupting existing BOMs.  

     

    Additionally, it’s encouraged to manage the master cross reference of internal part numbers to the MPN in your ERP system. Over time, engineering can use the master internal part number for new products, which allows a slow phase-out of the other internal part numbers.

     

    Solve Your Classification Problems

    Rich attribution and classification of data are pivotal to preventing and identifying duplicate and near duplicate data that lies within your systems today. Sign up for our Classification Community today for more tips on controlling duplicates.

    Join Our Classification Community Group

      Posts by Tag

      • Classification (46)
      • Convergence Data (26)
      • Cleansing Data (23)
      • Governance (16)
      • PLM (14)
      • Data Cleansing (13)
      • Duplicate Parts (13)
      • Teamcenter (12)
      • Cost Savings (11)
      • Ecommerce (11)
      • Part Cleansing (11)
      • PIM (10)
      • Product Analytics (10)
      • Cost Reduction (8)
      • Part cost (8)
      • DFR (7)
      • Part Standardization (7)
      • Benchmarking (6)
      • Duplicate Analysis (6)
      • Manufacturer Parts (6)
      • Parts Classification (6)
      • classification structure (6)
      • Part Rationalization (5)
      • Spend Rationalization (5)
      • Taxonomy (5)
      • categories (5)
      • Data Classification (4)
      • Part Preparation (4)
      • Searching (4)
      • Spend Analysis (4)
      • Analytics (3)
      • Clusters (3)
      • DFRv10 (3)
      • Direct Materials (3)
      • Engineering (3)
      • PTC (3)
      • Value Engineering (3)
      • Workflows (3)
      • data normalization (3)
      • 2019 Blogs (2)
      • B2B (2)
      • Customer Experience (2)
      • Enrichment Lifecycles (2)
      • Findability (2)
      • Integration (2)
      • Kalypso (2)
      • Loading Data (2)
      • PLM World (2)
      • Product Data (2)
      • Standard Parts (2)
      • reclassify (2)
      • smartclass (2)
      • supplier pricing (2)
      • 2016 Top Blogs (1)
      • 2021 blogs (1)
      • Aftermarket Parts (1)
      • B2C (1)
      • Category Editing (1)
      • DFR PLM Integration (1)
      • DFR University (1)
      • Electrical Parts (1)
      • Electronic Parts (1)
      • HVAC (1)
      • IoT (Internet of Things) (1)
      • Mechanical Parts (1)
      • National Oilwell Varco (1)
      • PTC LiveWorx (1)
      • PTC Windchill (1)
      • Part Reclassification (1)
      • Pricing Data (1)
      • Procurement (1)
      • Product Structures (1)
      • Relationship data (1)
      • Repair Parts (1)
      • Sales Conversions (1)
      • Siemens (1)
      • Supplier Management (1)
      • Supplier Rationalization (1)
      • WBR Research (1)
      • allowed values list (1)
      • cx (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

      © 2023 , Convergence Data All Rights Reserved.