Fitment mapping & synonyms

Connection

There is one file, so the Action column determines what we do: replace or add.

• Add (synonyms)
• Replace (mapping)

It is connected through vehicle_mapping in the sources.

Synonyms

We can apply the fitments of one vehicle to another vehicle.

In this example, J-4000 will be compatible with all the same products as the vehicles on the left (J-4500/4600/4700).

Mapping

The same thing, but the vehicle on the left is replaced by the vehicle on the right:

The year can’t be mapped; hence the YearRange column is singular.

Nuances

In programmer speak:

• Empty “FieldFrom” -> Populated “FieldTo” = “FieldTo” value
• Empty “FieldFrom” -> Empty “FieldTo” = string.Empty
• Populated “FieldFrom” -> Empty “FieldTo” = “Universal” value
• Populated “FieldFrom” -> Populated “FieldTo” = “FieldTo” value

In layman’s terms:

• “Hole” -> “Non-hole” = Turns any submodel into a specific one
• “Hole” -> “Hole” = Leaves the submodel untouched (As-Is)
• “Non-hole” -> “Hole” = Turns a specific submodel into a universal one
• “Non-hole” -> “Non-hole” = Swaps one specific submodel for another