Skip to content

How to use vehicle filter

Vehicle Filter is a spreadsheet where column headers define the vehicle key. Common headers are Year, Make, Model, Submodel, but you can also use custom sets (for example, RideType, Year, Make, Model). It is created in the client’s folder on GDrive and connected in schema.yaml in the Sources with the key vehicle_filter.

  • You can use the wildcard character * for any field within a single fitment in all fields;
  • * - all possible values, and an empty cell - mandatory absence of a value. For example, “Ford F-150 *” in the Vehicle Filter will pass both “Ford F-150” and “Ford F-150 XL”, whereas “Ford F-150” will pass only “Ford F-150”
  • In the Year field, you can include all the formats of years we support;
  • By default, the Vehicle Filter operates in whitelist mode, meaning only the fitments that match any of the rules will be included in the index;
  • To switch to blacklist mode, you need to create a row with asterisk * in all fields. This literally means “take everything except what is specified below”, i.e., all fitments will be included in the index except those that match any of the other rules;