Import/Export Spreadsheet Limits?

The web site I'm working on has several products with many colour options that cost an additional 10% or 15%. I'm doing all my development work in an external spreadsheet which saves lots of time and effort because you can cut and paste and then import the updates. I've just hit a problem. The products I' m adding have 24 colour options 17 of which involve additional cost and I'm finding that with more than approx 3000 lines in the options workbook of the spreadsheet importing isn't working. There's no error message, in Chrome it gets to 100% upload and then just ends. And the data in that import are not added.

This is a big problem for me as I still have quite a few more product options to add and if the system cannot accept them I'm in big trouble.

Are there limits on what the import/export spreadsheet can handle? I wouldn't have thought that 3000+ option lines is that many.

Roger

Hullo Roger
There are indeed limits on how much data the tool can handle. There is some info in the readme and on the forum about this, but there have also been some postings about a workaround:

http://forum.opencart.com/viewtopic.php ... 525#p90533
http://forum.opencart.com/viewtopic.php ... =40#p51635

- this seems pretty successful for those who have used it. Hope this info is helpful

Thanks for that.

It seems I'm quite lucky and can change the parameters myself on my server, see below

The maximum size at present is set at 5MB and the time-out is 30 seconds.
You can change these parameters using a php.ini (or php5.ini if you've enabled PHP5) file. Simply create a file of this name in the same directory of your script (or update the existing file), with the content:-
upload_max_filesize = 20M ;
post_max_size = 20M ;
max_execution_time = 60 ;
(this example would increase the maximum upload to 20MB, and timeout to 60seconds).

All I need to know now is which folder to put this php.ini file into. Anyone know?

Roger

I'm answering my own post yet again....

I put a file php.ini containing the following lines in the main admin folder ie the one that contains ....\admin\index.php

max_execution_time = 18000;
upload_max_filesize = 100M;
mysql.connect_timeout = 20;
post_max_size = 20M ;

There were other lines as well because I edited a file created by my system that was already in the folder but these I think were the key ones.

That worked for me - allowed me to upload a much bigger excel workbook. So if you're having problems check and see if your server will let you do the same. Saved me an awful lot of messing around.

Roger

The definitive answer to this...

The above ini file still failed when I got to a slightly bigger excel file. What I then did was increase the size of server memory allocated to opencart by adding the following line in the .htacess file

RLimitMem 128000000

This was the answer for me. See if your host will let you do the same. Much better than having a local copy of the database on your PC. You'll waste half your life trying to get MYSQL and php installed, configured and running otherwise, let alone being compatible for you to transfer data direct from your PC to your remote OpenCart installation without error.