Lens-to-camera compatibility matrix, how do you actually model it in Magento?

Mount accuracy is the #1 trust signal on a camera-store PDP. Get it wrong once and the customer goes back to B&H forever.

Data model:

• Each body (Sony A7 IV, Canon R5, Nikon Z9, Fuji X-H2S, Panasonic S5 II, Hasselblad X2D) has a primary mount attribute: sony_e, canon_rf, canon_ef, nikon_z, nikon_f, l_mount, fuji_x, mft, hasselblad_xcd.
• Each lens has a mount attribute + AF support level (full / phase-detect only / contrast-only / MF only) + aperture-ring behaviour + IBIS cooperation.
• A compatibility relationship table models adapted pairs: Canon EF lens + Sigma MC-11 adapter → Sony E body with phase-detect AF on ~80% of EF lenses. Each row carries the AF support level, the IS cooperation flag, and a known-issues field.
• PDP filter + a /lens-finder tool: customer picks body → sees compatible native + adapted lenses ranked by AOV and your margin.

Source of truth: I maintain a curated spreadsheet seeded from Sony / Canon / Nikon / Fuji / Sigma / Tamron / Viltrox / Metabones official compatibility lists, plus the DPReview + B&H + LensRentals community-tested adapter data. Sync runs monthly via a CSV import patch.

Don’t use a third-party matrix-as-a-service, the data is too brand-specific to outsource. You own the matrix, you own the trust.