Year/Make/Model Filtering for Auto Parts Stores
No7 Engineering Team
Growth Architecture Unit
Selling auto parts online without proper vehicle filtering is like running a clothing store where customers can't filter by size. They'll leave. The challenge is that Shopify wasn't built for this—but it can be made to work.
The Problem
Auto parts fitment is complicated. A brake pad might fit 47 different vehicles across 15 years and 8 manufacturers. Standard Shopify variants and tags can't handle this cleanly. You need:
- A way to store fitment data for thousands of year/make/model combinations
- A cascading dropdown UI (select year → makes populate → models populate)
- Fast filtering across a large catalogue
- The ability to save a customer's "garage" of vehicles
Solution Architecture
Option 1: Metafields + Custom App
Store fitment data in product metafields as structured JSON. Build a custom app that reads this data and provides a search/filter interface. This keeps everything in Shopify but requires development work.
Best for: Stores with under 10,000 products and relatively simple fitment requirements.
Option 2: External Fitment Database
Use an external database (we typically use custom PostgreSQL or specialised automotive databases like ACES/PIES) to store fitment data. Shopify products link to external IDs, and the frontend queries the external service.
Best for: Large catalogues, complex fitment data, or when you need to integrate with industry-standard databases.
Option 3: Custom YMM Solution
For the best results, we build custom YMM filtering solutions that integrate seamlessly with your Shopify theme. This gives you full control over the UI, performance, and data structure—essential for auto parts stores where fitment accuracy is critical.
Key Technical Considerations
- databaseData Structure: Normalised vehicle database with relationships to products
- speedPerformance: Index properly—YMM lookups must be instant
- sync_altData Sync: How will you update fitment data when products change?
- personMy Garage: Let customers save vehicles for faster shopping
The "My Garage" Feature
This is surprisingly valuable. Let customers save their vehicles (stored in local storage for guests, in customer metafields for accounts). When they return, they see parts that fit their vehicles first.
It sounds simple but significantly improves conversion rates. Auto parts shoppers often buy repeatedly, and remembering their vehicle builds loyalty.
Mobile UX Matters
The three-dropdown pattern works on desktop but gets cramped on mobile. Consider:
- A single search field with autocomplete ("2019 Honda Civic")
- Full-screen modal selectors on mobile
- Recent vehicles shown prominently
Our Experience
We've built YMM systems for several auto parts retailers on Shopify. The right approach depends on your catalogue size, data quality, and budget. Happy to discuss what might work for your situation.