The following errors regularly occur because of server settings:
Fatal error: Maximum execution time of 30 seconds exceeded
Your import did not complete as your server's maximum execution of Xs was insufficient.
HTTP Error 500 Internal server error
Error 324 (net::ERR_EMPTY_RESPONSE)
These commonly mean that the PHP settings on your server have reached their maximum execution time, or your server is struggling to complete the import. That is to say, the import is taking longer than the server allows or can handle.
These can come about for a variety of reasons.
'Fatal error: Maximum execution time of 30 seconds exceeded' or 'Your import did not complete as your server's maximum execution of' Xs was insufficient.
These settings can be configured in your php.ini file on the server by changing the value of 'max_execution_time' in the php.ini file in your OpenCart/admin folder:
The value is in seconds, so in the image above, the max allowed execution time is 30 seconds. How long you require will depend on your server speed, but generally the importer will update about 1000 products per 10 seconds..
If you are not able to increase this value for some reason (such as server provider permissions), or your server is still struggling it is possible to import smaller batches of products. You can do this with the 'Items to Import' setting in Step 5.
If you are experiencing the other two errors: 'HTTP Error 500 Internal server error' or 'Error 324 (net::ERR_EMPTY_RESPONSE)'
This usually means that the server is struggling. For example the database is not keeping up or other settings are preventing proper execution. There are a few ways to deal with this.
- Use the 'Items to Import' setting in Step 5 to do smaller imports.
- Set up a cron task to run the import for you.
- Split the import file into smaller parts and try importing the sub sets of the file.