Timeout or file exceeds max size while importing CSV

If you are having trouble uploading a huge CSV file, let's say 40,000 products you might need to make a few adjustments to the web server.

In admin/.htaccess add the following lines:

RewriteRule ^ - [E=noconntimeout:1]

# Allow files larger than 20 Megabyte to be parsed by PHP
php_value upload_max_filesize 256M
php_value post_max_size 256M```

Edit admin/catalog.app/csv.inc.php at the top of the page, right after <?php, add:

```// Raise PHP timeout to 900 seconds instead of 30
set_time_limit(900);```

spectacular, it works perfectly