Glossary

What is data mapping?

Data mapping defines how fields and values in one source correspond to those in another structure. In product operations, it connects supplier columns or system attributes to the intended catalogue fields and records any required transformation. A mapping must preserve meaning as well as format, including units, product identifiers, packaging levels and the conditions under which a value applies.

Map meaning before matching labels

A source column named "Size" could describe a garment size, a package dimension or a nominal fitting diameter. Similar labels are therefore a starting point for review, not enough evidence to establish the correct destination. Use field definitions, example values and source documentation to resolve the correspondence.

A mapping specification should identify source and target fields, transformations, defaults and exception handling. Distinguish field mapping from value mapping, which aligns options such as supplier finish names with a controlled list.

Example: a supplier product spreadsheet

A supplier sends "Mfr Part", "Length cm" and "Pack". The receiving catalogue has manufacturer part number, length in millimetres and selling-pack quantity. The first mapping preserves the part number as an identifier, including leading zeros. The second requires an explicit unit conversion.

Before mapping "Pack", the team confirms whether it means units per sellable pack or packs per shipping carton. An incorrect assumption could produce a technically valid but misleading result.

Maintain mappings when sources change

Reusable mappings need review when column names, meanings or schemas change. A successful import only shows that processing completed. Test representative records and keep unresolved fields visible. Destination-specific channel mapping builds on this same principle but applies the requirements of the receiving channel.

Related terms

Sources and further reading

Product Data Services

Explore practical support for organising, improving and maintaining product information.