This page has moved to Adobe Experience League and will be redirected soon.
Best practices for Adobe Commerce product options
Best practices for Adobe Commerce product options
This article provides best practices for product options in Adobe Commerce. Our recommendation is to have not more than 100 options per product, as performance can be affected.
Many product options leads to an increase in data retrieved for each product on all read and write operations resulting in:
Increase in SQL queries traffic and heavier sql JOIN
operations affecting database throughput.
Increase of Adobe Commerce indexes size and full-text search index.
The increases listed above can cause these potential site impacts:
Response time will be increased for most storefront scenarios related to products containing a large number of options in attributes.
Product management operations in Admin will significantly slow down and can lead to timeouts, especially on scenarios related to attributes list and trees retrieval (including promo rules management).
Product mass actions functionality can be blocked.
Affected products and versions
Best practices
Reduce the number of product options by:
Leveraging different variation mechanisms: complex products, custom options as a source of product variations.
Building specific product templates with targeting attributes and options, avoiding generalized product templates and option containers.
Managing products info through external Product Management System (PMS).
Refer to:
Was this article helpful?
Yes
No
0 out of 0 found this helpful