Magento Spreadsheet Import Size Limit

Have you ever received a magento spreadsheet that was just too damn big to fit through the door? Well don’t worry because there are things that you can do. The limiting factor of a Magento Speadsheet is normally the filesize – and this is what we will look at today. A normal message you will see is something like the following (depending of server values).

Your server PHP settings allow you to upload files not more than 2M at a  time. Please modify post_max_size (currently is 2M) and  upload_max_filesize (currently is 2M) values in php.ini if you want to  upload larger files.

Normally a server will limit your maximum upload filesize to something around 2MB. This is a bit awkward as I received a spreadsheet the other day which was around 8MB.

Now when this happens you normally have a couple of options. Firstly you can split the spreadsheet in to smaller chunks, this normally doesn’t take very long but its makes it harder to keep track of data.

The second way is to change your file size upload limit. Which is what I do.

Now there are two easy ways you can change the limit and I’ll show you both of them. First you can try changing it in your php.ini file. Look for the line which says:

upload_max_filesize
post_max_size

Increase both to between 10Mb and 20Mb.

The other option (which is my personal favorite) is changing these values in the .htaccess file. What I recommend is adding a few lines for safety’s sake.

Paste in the following:

php_value max_execution_time 200
php_value max_input_time 200
php_value upload_max_filesize 10M
php_value post_max_size 10M

You should see that now you can upload spreadsheets up to a maximum of whatever you have set above. Not bad eh?

Thanks for visiting the Magento Blog at E-commerce Web Design!

Robert Kent Author Page

• Custom Export Profiles
• Add Magento Attributes From Spreadsheet (CSV)
• Magento – Getting To Grips With Spreadsheets