Stellantis Dealer Locator Source

The dealer locator raw data is fetched from the bdlws/MDLSDealerLocator endpoint via brand-specific URLs (one call per brand: chrysler, dodge, jeep, ram, fiat, alfa_romeo). A physical dealer that sells multiple brands appears in multiple source queries and is merged at transform time using (dealer_code, location_seq) as the key.

Known data quality issues

website — brand-URL contamination

Observed: 2026-06-26 materialization, dealer_code 61098 (location_seq 000)

The Stellantis backend returns different website values depending on which brand URL is queried. For multi-rooftop dealer groups, the chrysler/dodge/jeep queries may return the parent dealer group URL (e.g. serrachevrolet.com — a GM brand site) while the ram query returns the brand-appropriate CDJR URL (serracdjrsouthfield.com). The two URLs point to different physical addresses on opposite sides of the same highway.

A heuristic like "prefer URLs containing cdjr" handles obvious cases but is not reliable across the full dealer population. Resolving this correctly would require scraping each URL and classifying the resulting page, or cross-referencing a trusted dealer registry.

business_center — border-case dealers assigned to different zones per brand

Observed: 2026-06-29 materialization, dealer_code 69235 (Napleton Alfa Romeo-FIAT, Schererville, IN)

The Stellantis dealer locator returns a single-letter regional zone code (A–G) for each dealer. The zones map roughly to geographic sales territories: A=East Central, B=Northeast, C=Southeast, D=South, E=West, F=Upper Midwest, G=Central/Plains. For the vast majority of dealers the value is identical across all brand endpoints. Dealer 69235, a Chicago-area Alfa/Fiat dealer in northwest Indiana, is the only known case where the alfa_romeo endpoint returns 'A' (Indiana-side) and the fiat endpoint returns 'F' (Chicago-metro cluster). Both assignments are geographically defensible for a dealer on the IL/IN border.

departments — per-brand contact storage

Observed: 2026-06-26 materialization, dealer_code 43666 (Northtown CDJR), dealer_code 44402 (Hendrick Dodge Ram FIAT)

The Stellantis backend stores department contacts (sales email, service phone, etc.) per-brand, not per physical location. The same dealer queried through different brand URLs returns different named contacts for the same department within a single run — for example, sales at dealer 43666 returns m.sims@northtownauto.com via one brand and j.rogers@northtownauto.com via another.

Multiple departments differing simultaneously at the same dealer rules out timing as a cause.