Catalog for a major lubricants brand
A CRM module that finds the right oil for a car by make, model and specification, or by engine code — or straight from a car in our TecDoc catalog, in one click.
Problem
Shops needed the right oils and fluids for a specific car without leaving the CRM.
Approach
- Parsed the maker’s full catalog — 600 articles — with a queue-driven parser into MariaDB.
- Linked every article to the vehicles it fits: 12M+ article-to-vehicle links.
- Cached frequently requested cars in Redis: lookups dropped from ~1.5–2 s to ~0.2 s.
- Tied it to TecDoc: the M button on a vehicle opens its fluids; an unlinked car is matched once and remembered.
Result
- 600 articles, 12M+ vehicle links
- ~1.5–2 s → ~0.2 s for cached cars
- PHP
- Vue.js
- Redis
- Python



