Page 1 of 1

Export/Import too many products

Posted: Sun Jan 19, 2014 11:39 pm
by southernbusiness
Hi,

I have increased my product database to about 14,000 and wanted to have it up to over 20,000. But the module won't allow me to export a copy of my products and so rather than changing via my spreadsheet I will have to manually type in the products and adjust prices.

I have been looking on the forums but can't find a solution. Does anyone know how to fix this?
Thanks

Re: Export/Import too many products

Posted: Mon Jan 20, 2014 12:23 am
by southernbusiness
There is no error in my logs after receiving this page and my host said I have the following memory
Memory Limit 4GB
Post Max Size - 100m
Upload max file size - 100m

Re: Export/Import too many products

Posted: Mon Jan 20, 2014 2:21 pm
by butte
memory_limit = 512M;
max_execution_time = 36000;
post_max_size = 999M;
upload_max_filesize = 998M;

Note that post exceeds upload, that is required.

Try phpinfo.php to see what the server thinks is going on. The tiny one-line utility phpinfo.php (here: http://forum.opencart.com/download/file.php?id=18153) can be uploaded into OC (or your account, public) and addressed in the browser. Put it in both your OC root and your /admin/. Address it as usual, but after domain/whatever/phpinfo.php (and domain/whatever/admin/phpinfo.php).

You do NOT need to wade through these just to set the foregoing, but they'll give you your bearings.

On php.exe and php.ini:
http://forum.opencart.com/viewtopic.php ... ni#p426535
On master php.ini:
http://forum.opencart.com/viewtopic.php ... 80#p444711
http://forum.opencart.com/viewtopic.php ... r+#p445305

Re: Export/Import too many products

Posted: Wed Jan 22, 2014 6:42 am
by southernbusiness
erm... does that ... not sure what that means. Sorry, but is there any chance I could pay you to get it going again?

Re: Export/Import too many products

Posted: Thu Jan 23, 2014 4:04 am
by butte
PM sent.

Re: Export/Import too many products

Posted: Thu Jan 23, 2014 8:48 pm
by nvedia
Using PHPExcel library cache mechanism would solve the problem as phpexcel save method inherently has a bug that when it timeouts there is no error thrown

Re: Export/Import too many products

Posted: Thu Jan 23, 2014 11:59 pm
by butte
That is subject to a php setting and is not a bug, the thing needs settable memory ceiling and time to do what it does.

Re: Export/Import too many products

Posted: Fri Jan 24, 2014 12:23 am
by southernbusiness
Solved. Thank you so much. It works!!

Re: Export/Import too many products

Posted: Fri Jan 24, 2014 12:49 am
by nvedia
butte wrote:That is subject to a php setting and is not a bug, the thing needs settable memory ceiling and time to do what it does.
Sorry for putting it in different way
I meant without caching it only works till 14K rows and throws no errors and no warnings when it times out
Not sure if error can still be thrown

Re: Export/Import too many products

Posted: Fri Jan 24, 2014 1:32 am
by butte
That is good, southernbusiness, go ahead and edit your opening title Solved.