CSV Import - Internal Server Error 500

[proevilz]

Hi all,

 

I'm trying to import my .CSV of products but every time I do it, the page hangs for a long time and then it eventually goes to an 'Internal server error' page. If I then go back into the back office, it will only manage to succesfully import around 50 products. (CSV contains approx. 1200 products) 

 

The CSV it's self only has 8 headers.

 

And actually, I keep getting the same error when simply navigating between different menus within the back office too....

 

Is this a bug?

Edited December 2, 2014 by proevilz (see edit history)

[JPresta.com]

The import is long; I also had to use it and I finally split my file to make it work. You should split to 40 products and see if it's better.

[proevilz]

The import is long; I also had to use it and I finally split my file to make it work. You should split to 40 products and see if it's better.

 

Split to 40 products... Baring in mind have over a thousand.. that will take forever...

[JPresta.com]

30 files to create :-)

Or you can use a dedicated module to do it... I found this one but I never tested it

[proevilz]

30 files to create :-)

Or you can use a dedicated module to do it... I found this one but I never tested it

I created all those files with 40 products and it's still failing to import them successfully. 

 

This is extremely irritating as I can't afford to manually enter them and it's making want to leave prestashop for another platform...

[JPresta.com]

Can you enable profiling http://dh42.com/blog/prestashop-debug-profiling/

and DEV mode in /config/defines.inc.php

 

Then try to import a file and show us the stats displayed at bottom of the page or the error message if any.

 

As I remember the long part was the download of images (in my case).

[proevilz]

Can you enable profiling http://dh42.com/blog/prestashop-debug-profiling/

and DEV mode in /config/defines.inc.php

 

Then try to import a file and show us the stats displayed at bottom of the page or the error message if any.

 

As I remember the long part was the download of images (in my case).

Actually I think you're right about the images part as when I uploaded the 1000+ CSV without the image url's in there, it did them all just fine... 

 

That's an image from the homepage whilst the import is going on. The stat's only increased a tiny bit but the queries shot up from around 40, which is understandable.