Automotive filter product attributes

Oil, air, fuel and cabin filters are sold almost entirely through fitment lookups, so it is tempting to treat vehicle coverage as the whole record. The trouble starts when a customer's vehicle is not in the lookup, when a filter is cross-referenced, or when two spin-ons share a thread but differ in gasket size or bypass pressure. Those physical specs usually sit in a supplier's spec table, not in the application file.

Performance claims need the same care. A micron figure means little without the efficiency percentage and the test method behind it, and suppliers mix nominal, absolute and multipass results in the same column. Media type, anti-drainback valve material and rated service interval are marketing-adjacent values that still drive selection, so they should be controlled fields rather than words buried in a description.

Filters also churn quickly. Part numbers are superseded, packaging changes and interchange lists grow every model year. A record that separates identity, physical dimensions, fitment and interchange can absorb those changes without rewriting everything, and gives a counter rep enough detail to confirm a substitute when the catalog lookup comes up empty.

The automotive filters attribute template

18 candidate fields in 5 groups, ordered the way a record gets built: identify the item, capture its specifications, then record fit and the evidence behind any claim. 10 are marked Core: without them the item cannot be identified or filtered. Example values show the expected format only; they do not describe a real SKU.

Identity

Which exact item, variant and pack this record describes.

Check before use: Preserve leading zeros and punctuation, validate against the manufacturer record, and check the GTIN check digit and packaging level before linking.

Attribute	Type	Priority	Example format
Manufacturer Part Number manufacturer_part_number	Identifier	Core	OF-2150
Brand brand	Controlled list	Core	Brand name as printed on the carton
GTIN / UPC gtin_upc	Identifier	Core	081234521509

Technical specifications

Measured or rated values that must travel with their unit and test conditions.

Check before use: Store the number and unit separately. Convert only when the source unit and test conditions are known.

Attribute	Type	Priority	Example format
Height height	Number · in	Core	3.40 in
Outer Diameter outer_diameter	Number · in	Core	2.92 in
Filtration Efficiency and Test Method filtration_efficiency_micron	Text	Buyer decision	99% at 20 µm (ISO 4548-12 multipass)
Bypass Valve Setting by_pass_valve_setting	Text · psi	Buyer decision	8-11 psi

Selection attributes

The type, material and option choices buyers filter and compare on.

Check before use: Map supplier wording to a governed vocabulary only after checking the source text and which variant it applies to.

Attribute	Type	Priority	Example format
Part Type (PCdb Terminology) part_type_pcdb_terminology	Controlled list	Core	Engine Oil Filter
Filter Style filter_style	Controlled list	Core	Spin-on
Filter Media filter_media	Controlled list	Buyer decision	Cellulose/synthetic blend
Anti-Drainback Valve Material anti_drainback_valve_material	Controlled list	Buyer decision	Silicone
Rated Service Interval service_interval_rating	Number · mi	Buyer decision	10,000 mi

Fit & compatibility

What the item mounts to, mates with, replaces or works alongside.

Check before use: Keep model and series qualifiers. A similar-looking part is not a verified fit until a source says so.

Attribute	Type	Priority	Example format
Vehicle Fitment (ACES) vehicle_fitment_aces	Text	Core	2011-2016 full-size pickup, 5.0L V8
Thread Size thread_size	Controlled list	Core	3/4-16 UNF
Gasket O.D. / I.D. gasket_o_d_i_d	Text · in	Core	2.73 in / 2.43 in
Interchange / Cross-Reference interchange_cross_reference	Text	Buyer decision	Brand A 3593; Brand B 14459

Evidence & compliance

Listings, standards, classifications and origin claims that need a document behind them.

Check before use: Link the manufacturer document or label with its edition or date. Never copy a certification from a neighboring SKU.

Attribute	Type	Priority	Example format
Country of Origin country_of_origin	Controlled list	Channel / evidence	US
CA Prop 65 Warning ca_prop_65_warning	Controlled list	Channel / evidence	Warning required

Normalize supplier values

The same value arrives in many spellings. Map each raw string to one governed value, and keep the raw text beside it so a reviewer can see what the supplier actually wrote.

Often missing from supplier files

These fields are commonly absent from price lists and basic feeds, even though the information usually exists in a datasheet, label or installation manual. Treat an empty value as a request for evidence, not as permission to fill it from a similar model.

• Interchange / cross-reference numbers
• Anti-drainback valve material
• Filtration efficiency with its test method
• Gasket O.D. / I.D.
• Bypass valve setting (psi)

Questions the record must answer

Buyers and counter-sales reps choosing automotive filters ask questions like these. Each one needs a specific field, sourced for the exact variant.

• My vehicle isn't in the lookup. Which filter has the same thread, gasket and height as the one I have?
• Does this filter have an anti-drainback valve for an engine where the filter mounts sideways?
• What does the micron rating mean on this one, and what test was it measured with?
• Is this filter rated for the longer change interval I run with synthetic oil?

From supplier file to record

1. Resolve identity first. Link the supplier SKU, manufacturer part number and packaging identifiers without merging distinct variants or pack sizes.
2. Extract with the source attached. Pull values from rows, tables and datasheets, keeping the raw text, unit and page or row reference.
3. Map to your classification. Assign the ETIM, ECLASS, UNSPSC or internal class your company licenses, and keep the supplier's original terms.
4. Review, sync and watch. Hold conflicts and safety-related values for a category expert, write approved values to ERP or PIM, and recheck when the supplier sends a new file.

For the full method, see how to build a category attribute template and the category catalog gap audit.

FAQ