Product Attribute Mapping Guide for Supplier Data

Product Attribute Mapping: A Practical Guide

Product attribute mapping is the critical step of connecting inconsistent supplier field names, units, and values to the canonical master schema used by your PIM or e-commerce catalog.

Because every vendor uses custom terminology, abbreviations, and units, automated mapping with alias detection is essential for scalable supplier onboarding.

The 5 Mapping Types

1. Direct Mapping (1:1)

Supplier field name matches internal master schema directly.

• Supplier: Brand → Master Schema: Brand

2. Alias Mapping (Synonyms)

Supplier uses custom terminology for standard fields.

• Supplier: Nominal Operating Voltage → Master Schema: Rated Voltage

3. Transformation & Unit Conversion

Values require unit standardization or mathematical conversion.

• Supplier: 0.4 kV → Master Schema: 400 V

4. Split Mapping (Compound Field Decomposition)

Supplier combines multiple attributes into a single string.

• Supplier: 400V AC, 3-Phase → Master Schema: Voltage: 400V, Current: AC, Phases: 3

5. Conditional & Category-Scoped Mapping

Fields map differently depending on product taxonomy.

• If Category = Sensor: Map Range to Measurement Range
• If Category = Valve: Map Range to Flow Rate Range

Canonical Attribute Dictionary Example

{
  "attribute_id": "rated_voltage",
  "display_label": "Rated Voltage",
  "data_type": "numeric_measurement",
  "canonical_unit": "V",
  "source_aliases": [
    "operating voltage",
    "nominal voltage",
    "supply voltage",
    "input voltage"
  ],
  "validation": {
    "min": 1,
    "max": 10000
  }
}

Related Solutions & Guides

• Product Catalog Automation
• PIM Data Preparation
• Supplier Data Quality Checklist
• Product Data Validation