This article provides best practices for number of categories limit for Adobe Commerce on-premises and Adobe Commerce on cloud infrastructure.
The maximum recommended number of categories varies depending on Adobe Commerce version:
- Starting with Adobe Commerce 2.4.2, the maximum recommended number of categories is 6000.
- For Adobe Commerce 2.3.x, and 2.4.0-2.4.1-p1, the maximum recommended number of categories is 3000.
Note: This article only addresses best practices for supported versions of Adobe Commerce on-premises and Adobe Commerce on cloud infrastructure.
The potential site impact of exceeding the limit is:
- Tangible increase in response time on non-cached catalog pages
- Long execution/timeouts during managing categories in the Admin Panel
- Increase in size of corresponding DB tables
- Growth of indexation time [category/product relation index]
- Heavier operations on categories tree building, menu retrieval, and category rules management operations
Recommendations to reduce the number of categories are:
- Managing unique product features through attributes and custom options
- Removing inactive categories
- Optimizing catalog depth