Hi @Sagesrepo,
Managing 1 million products in ERPNext can be challenging and depends on factors like database optimization, server resources, network speed, version, and customization. The system’s ability to handle such a large catalog relies on proper indexing, partitioning, and resource allocation. It’s essential to use an adequately configured server with sufficient CPU, RAM, and storage. The version should be up-to-date to benefit from any optimizations. Customizations, including scripts and fields, must be optimized for scalability.
I hope this helps.
Thank You!