Jump to content

Unable To Upload Product File .csv


Recommended Posts

Hello from Sweden my Prestashop-friends!

 

We are experiencing problems uploading a .CSV  productfile in Prestashop, even though we have mapped all the field right to the file in Prestashop. We also tried to ignore empty fields when uploading the .CSV. Our web provider have increased the time for max_limit in php.ini to upload the file on the webserver.

 

We have also tried to reduce the file and only take in 5 products in the file and then we get the following error: (see attached picture). We have also changed the authorization of files and folders to 755 on the ftp with no results.

 

The times we have tried to load the entire file and to ignore the empty fields, we get a: Server 500 error, but we succeed to load about 180 products, 

 

I've also tried to add all the fields possible for products of PrestaShop and then get a server 500 error

 

Please help me or give me a gun! has been stuck for five days now!!post-1146145-0-25628600-1449576300_thumb.png

 

 In php-error log:

[07-Dec-2015 15:52:37 Europe/Stockholm] PHP Warning: imagejpeg(/storage/content/81/145081/urmax.se/public_html/img/p/1/1.jpg): failed to open stream: No such file or directory in /storage/content/81/145081/urmax.se/public_html/classes/ImageManager.php on line 541

[07-Dec-2015 22:18:50 Europe/Stockholm] PHP Warning: Division by zero in /storage/content/81/145081/urmax.se/public_html/controllers/admin/AdminStatsController.php on line 599

[07-Dec-2015 22:18:53 Europe/Stockholm] PHP Warning: Division by zero in /storage/content/81/145081/urmax.se/public_html/controllers/admin/AdminStatsController.php on line 599

[07-Dec-2015 22:19:17 Europe/Stockholm] PHP Warning: Division by zero in /storage/content/81/145081/urmax.se/public_html/controllers/admin/AdminStatsController.php on line 599

Apachelog error:

apache-04-45.log:Dec 8 01:23:10 apache-04-45 httpd.worker[636934]: [error] [client 66.249.78.115] File does not exist: /storage/content/81/145081/urmax.se/public_html/en

apache-04-45.log:Dec 8 01:32:02 apache-04-45 httpd.worker[636934]: [error] [client 220.181.108.81] File does not exist: /storage/content/81/145081/urmax.se/public_html/se

apache-04-45.log:Dec 8 01:45:32 apache-04-45 httpd.worker[636934]: [error] [client 208.115.111.75] File does not exist: /storage/content/81/145081/urmax.se/public_html/robots.txt

Link to comment
Share on other sites

You appear to have two different problems. First is that your import is timing out trying to load too many products at one time. Second is that you have data problems with certain products when you are able to import them.

 

To solve #1 You should divide your CSV into smaller files. 

 

To solve #2 I would create a CSV with only one row and debug that row's data. If you can't figure out what is wrong, post the errors here (like you did before) and also post the CSV with the single row. Also post a screen shot of the admin import setup page.

  • Like 1
Link to comment
Share on other sites

Is the formatting different between the two files?  Different delimiter etc?

 

And you meant "100 rows" when you said "100 files"?

 

You can attach the file that worked and the file that didn't and I'll take a look.

Hello! Yes i mean rows. Thanks i will attach the file with 300 rows. The orginal is 5600 rows :)

 

Here is a link to the file in my dropbox: https://dl.dropboxusercontent.com/u/16861443/csv_presta_products_en.csv

Link to comment
Share on other sites

  • 1 year later...

I repeat:

 

You can attach the file that worked and the file that didn't and I'll take a look.

Hello

If your out there please save me, i get an internal server error ( timeout) when uploading my csv files, one file has about 3000 products, after uploading about 45 products the error just comes in, i do not know what i am doing wrong

 

"Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
xxxxxxxxxxxxxxxxxxxxxx
Additionally a 500 Internal Server error was encountered while trying to use an ErrorDocument to handle the request"

 

 

my php options are set to MAX see below

 

memory_limit = 1G
max_execution_time = 1000
max_input_time = 300
post_max_size = 1G
max_input_vars = 10000
file_uploads = -1
max_file_uploads = 35
upload_max_filesize = 1G
 
What am i doing wrong? do you need any additional information to help me with this issue?
Link to comment
Share on other sites

Try this - Remove the first 100 data rows from the file (save a copy) and try again.  If you still get an error around the 45th row then your server is timing out. This means that the data may be okay.  You might try uploading the file to your store and import from the uploaded file. If you are already doing this then I would consult with your server provider about the timeout.

Link to comment
Share on other sites

Hi All 

 

I have a similar issue needs some help on 

 

My CSV currently contains 75 products - 

If i import as is with image URLS it goes into error/times out

If i delete the URLS it uploads completely 

The images are stored on media manager module on the site 

 

Is there a limit on the amount of URLS ? 

 

Any help would be appreciated! 

 

Thanks

Giulia 

Link to comment
Share on other sites

Hi All 

 

I have a similar issue needs some help on 

 

My CSV currently contains 75 products - 

If i import as is with image URLS it goes into error/times out

If i delete the URLS it uploads completely 

The images are stored on media manager module on the site 

 

Is there a limit on the amount of URLS ? 

 

Any help would be appreciated! 

 

Thanks

Giulia 

Your server has the php module allow_fURL_open installed and set to YES ? If it is not installed or set to NO, than you are not able to import pictures, nor as a link from/to your same server. The protocol you are passing is HTTP, so read from this URL and write to this same/or other URL. allow_fURL_open is the main handler in this case.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...