Skip to main content

Customer Parts Mapping - Guide

S
Written by Shivprasad Vaidyanathan

1. What is the Customer Parts ?

Many drawings use Customer Part Numbers (CPNs) rather than Manufacturer Part Numbers (MPNs). This requires translation of the part numbers to the MPN. Customer Parts contains the mapping between the CPN and MPN, enabling the system to automatically translate these part numbers.

Because distributor search engines cannot identify custom numbers or physical descriptions, Cableteque uses Customer Parts as an automatic translation layer. It maps your Customer Part Numbers (CPNs) and generic wire specifications directly to orderable Manufacturer Part Numbers (MPNs) (e.g., from TE Connectivity or Southwire).

2. How is it Used?

Customer Parts translates and sources parts in two ways, preserving the original design identifiers on your screen. Below is an explanation of each scenario followed by a real-world example:

Scenario A: Custom Part Number (CPN) Mapping

  • The Scenario: In this workflow, a customer's incoming design or BOM contains proprietary, customer-specific part numbers instead of open-market manufacturer codes. Since commercial distributors do not recognize these private customer part numbers, Cableteque intercepts them. The system uses Customer Parts to cross-reference the CPN and translate it into a valid commercial Manufacturer Part Number (MPN) for sourcing, while retaining the original CPN on your dashboard for perfect engineering traceability.

  • The Example:

    1. The Mapping: You upload a template linking Customer PN 256936 (your customer's internal code for a circular connector plug) to Manufacturer PN D38999/26TJ43PA under a specific customer or Global.
      ​

      image-20260526-143359.png
    2. The Sourcing: Under the hood, Cableteque's sourcing engine queries distributors for D38999/26TJ43PA.

    3. The Materials View: The system continues to display 256936 on your dashboard to match the customer's design drawing, but dynamically populates live inventory and pricing offers from the mapped MPN (e.g., showing Heilind's active pricing and lead times).
      ​

      image-20260526-143214.png

Scenario B: Generic Wire Attribute Mapping

  • The Scenario: In this workflow, the wire harness design drawing defines wires by their physical properties (such as specification standards, copper wire gauges, and color schemes) instead of a specific part number. To handle this without search failures, Cableteque reads the attributes, normalizes them into a standard synthetic part number string, matches this synthetic code against Customer Parts to retrieve a real purchasable wire spool, and prevents the unresolvable raw description from being sent to distributor search APIs.

  • The Example:

    1. The Ingestion: The system reads raw wire attributes (TXL, 14 AWG, Blue) from an ingested drawing and builds a standard synthetic identifier:

      [Specification][Size AWG][Color]

      (resulting in the synthetic identifier: TXL 14 AWG Blue).
      ​

      image-20260526-143754.png
    2. The Mapping: This identifier is mapped against Customer Parts (either in your specific customer's folder or the Global folder) and resolved to Southwire's actual spool part number: F140231630.

    3. The Sourcing & Materials View: The system queries active distributors (such as IEWC) using the real spool number F140231630. Your dashboard displays the wire as TXL 14 with a blue color indicator to match the drawing, but pulls in IEWC's active, real-time cost of $0.15/ft and available stock.
      ​

      image-20260526-143909.png

Upload Scope Options

When uploading your bulk mapping spreadsheet, you can choose where the translations apply:

  • Customer-Specific Mappings: Applies only to quotes for a designated customer (ideal for highly proprietary OEM components).

  • Global Mappings: Applies system-wide across all customers (highly recommended for generic components and standard wire attributes).

3. Key Benefits

  • 🚀 Drastic Quoting Acceleration: Eliminates hours of manual component lookup. Once mapped, the system auto-resolves parts instantly in all future quotes.

  • 🔍 Full Design Traceability: The parent rows in the Materials view show your custom drawings' exact designations, keeping everyone aligned without confusing translation sheets.

  • 📦 Consolidated Purchasing Discounts: Identical wires and terminals are automatically pooled across all assemblies in a quote, helping you secure high-volume wholesale pricing breaks with suppliers.

  • 🛡️ Complete Offer Retrieval: Ensures you receive all available distributor quotes and options. By translating unresolvable Customer Part Numbers (CPNs) and raw wire attributes into standard Manufacturer Part Numbers, Cableteque eliminates "No Results" errors and guarantees full coverage of live pricing and stock availability.

Did this answer your question?