Solution

Normalize compatibility without hard-coding one industry.

Represent product relationships to vehicles, machines, engines, devices or equipment models using canonical subjects, aliases and provenance.

Model manufacturer, model, generation, variant, year range and domain-specific metadata.

Resolve supplier-specific compatibility strings to canonical subjects with explicit confidence.

Store supported and excluded relationships, notes, approval state, source provenance and manual overrides.

Fitment is governed catalog data.

Compatibility can be reviewed, overridden and traced back to source/import evidence rather than being stored as an unexplained text field.