Magento variant ceiling — does it really handle 10,000+ SKUs?

Yes — with the right indexing and storefront stack. The biggest fashion catalog I ship today runs ~78,000 variants across 1,200 product families and holds a 95+ Lighthouse mobile.

The model is Magento configurable + simple products with EAV attributes for size, color, fit, season, fabric. The performance gotchas:

• Catalog product flat tables off, EAV indexed cleanly. Flat tables hurt at this scale.
• Custom denormalised stock-status table for "in-stock by size/color" filtering — native price/stock indexers slow at 50k+ variants.
• Hyvä theme instead of Luma. Luma re-renders the swatch picker on every interaction; Hyvä uses Alpine state and stays under 200ms INP.
• Lazy-loaded swatch images (browser-native loading="lazy" plus IntersectionObserver fallback for the PDP swatch grid).

Shopify hits a hard ceiling at 100 variants per product (Plus: 2,000) which forces fashion brands above that into multi-product workarounds that fragment SEO and analytics. Magento has no such ceiling.