We have received support tickets for clients using Magento as their shopping cart software who receive exporting errors when exporting large amounts of data using Magento Mass Export Tool.
The common error is: “Internal server error” or “500 Internal Server Error”
when you try to export large number of item from the Magento admin area the server requires a lot of time to process all this data.
For this particular client they had over 10,000 products.
The first place to check is the apache error logs, this should shed some reason for the Internal Server Error.
[warn] [client xx.xx.xx.xx] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server,
[error] [client xx.xx.xx.xx] Premature end of script headers: index.php, referer: http://domain-name.com.au/index.php/admin/system_convert_gui/edit/id/1/key/b5d2b7970a07e989016674fd9a84687c/
If you see something like above then it’s due to phpfastcgi timeout.
So the solution for this is to increase the timeout values. You should add below lines to your php config file or change the existing values if they exist: /usr/local/apache/conf/php.conf and restart the apache for the settings to take effect.
If are hosting with Nerdster, please contact our support team who can manage this for you.