Magento: Guides and Practical Know-how | Page 52 | mironsoft Blog
Magento
-
Feb 18, 2025
A Magento GraphQL product query that looks simple can internally trigger dozens of SQL joins across EAV tables. Anyone who does not understand how the Entity-Attribute-Value model works ends up optimizing the wrong thing. This article explains why EAV is expensive, which measures actually help, and where the limits are.
-
Feb 18, 2025
Working tag invalidation is the basic prerequisite for the Magento full page cache to stay usable at all, without serving stale prices or stock levels. Understanding how X-Magento-Tags gets set, how Redis internally manages these tags, and why cache:clean does something fundamentally different from cache:flush lets you fix invalidation problems precisely instead of resorting to a blanket cache wipe.
-
Feb 17, 2025
Company Credit Limits let company customers order against an invoice up to a defined balance, with its own history, its own checkout validation, and a connection to the Payment on Account method. Building a custom approval workflow for overruns means understanding exactly how and when Magento actually calculates and reserves the available balance.
-
Feb 17, 2025
Magento's standard dashboard shows revenue, bestsellers, and returning customers, but there's no ready-made tile for business KPIs like stock alerts or open RMA requests. Understanding the dashboard architecture, data aggregation, and a clean caching strategy lets you build custom widgets that don't hit the full database on every single dashboard load, even at scale.
-
Feb 17, 2025
Service Contracts, Data Interfaces, SearchCriteriaBuilder and REST API: build custom repositories that guarantee stable APIs across upgrades.
-
Feb 17, 2025
Hyvä's default search box only jumps to the results page once you press Enter, showing no suggestions while you type. Live Search autocomplete in the Hyvä header closes exactly that gap: a GraphQL suggestion query returns products, categories, and prices, a lean Alpine.js component handles debouncing, request cancellation, and keyboard navigation, and CSP-compliant rendering keeps the shop safe and fast at the same time.
-
Feb 15, 2025
Adding a column or changing an index on a table with millions of rows in a live Magento store risks long table locks and a visible outage at checkout. A well planned zero-downtime migration combines declarative schema deployments with online schema change tools such as gh-ost and pt-online-schema-change, so customers never notice a schema change happening underneath them.
-
-
-
Feb 12, 2025
Filling thousands of Magento product pages with unmodified manufacturer copy or pasted descriptions systematically creates duplicate content and hands valuable ranking positions to competitors with unique text. This article shows how to reliably scale unique, SEO-effective content through EAV attributes, attribute sets, and intelligent templates, without manually editing every single product page.