Can EasyStore Handle A Catalogue Of 75,000 Products? - Question | JoomShaper

is live, now with multi-currency selling.

Can EasyStore Handle A Catalogue Of 75,000 Products?

H

Hans

EasyStore 6 days ago

Hello,

Our EasyStore catalogue currently contains approximately 16,000 products, and we intend to expand it to around 75,000 products.

At approximately 14,000 products, EasyStore temporarily became inaccessible while importing the next ZIP file. The rest of the Joomla administrator, including SP Page Builder, continued to work normally. After waiting, clearing the Joomla cache and logging in again, EasyStore became accessible again.

As another example, selecting “All” in the backend product overview also caused EasyStore to return an HTTP 500 error.

Our main questions are:

  • Is EasyStore 3.0 designed and tested for approximately 75,000 products?
  • Will imports and the backend remain reliable at this catalogue size?
  • Will the frontend search work efficiently for searches by product title, SKU or article number?
  • Will categories and product filters remain performant?
  • Are there recommended PHP, server or database settings for approximately 75,000 products?

Our environment is Joomla 6.1.3, PHP 8.3.33 and MySQL 8.0.30.

Kind regards,

0
3 Answers
Atick Eashrak Shuvo
Atick Eashrak Shuvo
Accepted Answer
Support Agent 6 days ago #233798

Hello,

Thank you for checking the server error logs and for providing the additional details.

The error confirms that the previous HTTP 500 errors were caused by the PHP memory limit being exhausted. The message Allowed memory size of 268435456 bytes exhausted indicates that the PHP process reached the configured 256 MB memory limit while EasyStore was performing resource-intensive operations such as importing products and loading the complete product list.

Increasing the memory limit to 512 MB is therefore a good step, and we recommend testing the next imports with this configuration. There is no fixed memory requirement that we can guarantee specifically for a catalogue of 75,000 products, as the actual memory consumption depends on the amount and complexity of product data, variations, attributes, images, categories, filters, and the operation being performed.

We also recommend continuing to use pagination in the administrator rather than selecting “All”, particularly with a large catalogue. Loading tens of thousands of products in a single backend request can require considerably more memory than loading a paginated result.

Regarding max_execution_time, the current 300 seconds should generally provide a reasonable amount of time for a long-running PHP request. However, the exact processing time depends on the size and complexity of the import. Since your previous error was specifically a memory exhaustion error rather than an execution-time error, increasing the execution time is not expected to address that particular issue.

For the planned catalogue of approximately 75,000 products, we would also recommend ensuring that the hosting environment has sufficient available RAM and that MySQL and PHP are properly configured for a large database. Database indexing and query performance are particularly important for operations such as product searches, SKU/article-number searches, category filtering, and large product listings.

At this stage, we would suggest proceeding with the 512 MB memory limit and testing the next import. If you encounter another error, please provide the corresponding PHP/server error log. This will allow us to determine whether the remaining limitation is related to server resources or requires further investigation within EasyStore.

For the frontend search and filtering performance at approximately 75,000 products, we would not want to provide a blanket guarantee without testing the specific catalogue structure and server environment. Performance will depend on both EasyStore's database queries and the resources/configuration of the hosting environment.

Kind regards

0
Atick Eashrak Shuvo
Atick Eashrak Shuvo
Accepted Answer
Support Agent 6 days ago #233785

Thank you for reaching out and for providing the detailed information about your current catalogue and planned expansion.

Yes, EasyStore is capable of handling a large product catalogue of this scale. However, I would like to clarify that the overall performance and reliability of a website with approximately 75,000 products do not depend solely on EasyStore. They also depend significantly on the server environment and the resources available to the website.

With a catalogue of this size, operations such as importing products, loading large product lists in the Joomla administrator, performing searches, filtering products, and executing database queries can require considerably more server resources. Factors such as available RAM, CPU resources, PHP memory_limit, max_execution_time, PHP-FPM configuration, web-server limits, and MySQL configuration can all affect how efficiently these operations perform.

For this reason, the same EasyStore installation may perform differently depending on the hosting environment. A server with sufficient resources and a properly optimized MySQL/PHP configuration is particularly important when working with a catalogue of 75,000 products.

Regarding the HTTP 500 error you experienced when importing products or selecting “All” in the product overview, this could be related to a server/PHP resource limitation. We would therefore recommend checking the PHP and server error logs at the time the error occurs. The exact error message will help us determine whether the issue is caused by resource limitations or requires further investigation on the EasyStore side.

If you can share the relevant error log and your current PHP/server resource configuration, we can review them and advise you further.

0
H
Hans
Accepted Answer
6 days ago #233796

Hello,

Thank you for your reply. I checked the server error log and found the following fatal error at the exact time EasyStore became inaccessible:

PHP Fatal error: Allowed memory size of 268435456 bytes exhausted.

The error occurred several times while importing products and when selecting “All” in the EasyStore product overview. The log does not show a maximum execution time error.

I have now changed the PHP settings to:

memory_limit: increased from 256 MB to 512 MB max_input_time: increased from 60 to 600 seconds max_execution_time: remains 300 seconds, as this is the maximum allowed by my hosting provider upload_max_filesize: 256 MB post_max_size: 256 MB

I will test the next import with these settings and will continue using normal pagination instead of selecting “All”.

Could you please advise:

  • Is 512 MB sufficient for approximately 75,000 products, or would you recommend 768 MB or 1 GB?
  • Is a maximum execution time of 300 seconds sufficient for EasyStore imports, or does the importer process products in smaller batches? Are any specific PHP-FPM, MySQL, caching or database-index settings recommended for this catalogue size? Will frontend searches by product title, SKU or article number, as well as category filters, remain performant with approximately 75,000 products?

I can also provide the complete server error log if required.

Kind regards,

0