OSHA + ANSI + NIOSH compliance flags per SKU, how do you actually wire it?
Four layers wired into Magento:
- EAV product attributes per standard,
osha_citation(multi-select: 1910.132 general PPE, 1910.133 eye, 1910.135 head, 1910.136 foot, 1910.138 hand, 1910.134 respirator, 1910.146 confined space, 1926.501 fall),ansi_z89_1_class(Type I / Type II + Class C / E / G),ansi_z87_1_marking(Z87+, D3, D4, D5),ansi_z359(anchor strength rating),niosh_approval_number(the literal NIOSH TC-84A-XXXX string),nfpa_70e_arc_rating(cal/cm² ATPV),astm_rating(F2413 boots, F2675 cut gloves),fda_eua_status(active / revoked / never-required). - Denormalised compliance-flag table with sku-to-standard-set mapping. Layered navigation queries this table, not 9 separate EAV joins. Without it, the category page is 3s+ slower at 20k+ SKUs.
- PDP compliance-badge component, renders the standards above the buy box. Safety managers scan for “NIOSH approval number visible” before brand or price; if the PDP does not show it on first paint, they bounce.
- Quarterly admin sweep, OSHA updates citations (rare but consequential), ANSI revises standards every 5-10 years (Z89.1-2014 vs Z89.1-2009), NIOSH revokes approvals (the 2020 N95 revocation wave). Cron + admin grid + email digest catches these.
I default to Adobe Commerce native EAV here; Open Source works fine with the Mageworx Advanced Product Attributes pattern. Either way the schema is the load-bearing piece.