PrestaShop Forum: Build a free online shop. Count on the Community!

The best place in the world to ask questions about PrestaShop and get advice from our passionate community!

PrestaShop Forum: Build a free online shop. Count on the Community!

Jump to content


prestashop shows error-Name (ID: ID) cannot be saved when importing product csv

Name (ID: ID) cannot be saved prestashop prestashop prestashop 1.5 error prestashop csv import error

  • Please log in to reply
12 replies to this topic

    PrestaShop Newbie

  • Members
  • Pip
  • 2 posts

Posted 26 January 2013 - 05:38 AM

i have facing some crazy problems when uploading product csv file in localhost , it gives following errors
  • Name (ID: ID) cannot be saved
  • Property Product->on_sale is not valid

when ignoring On sale column it gives below error

  • Name (ID: ID) cannot be saved
  • Property Product->available_for_order is not valid
when ignoring Available for order (0 = No, 1 = Yes) column , error become
  • Name (ID: ID) cannot be saved
  • Property Product->condition has bad value (allowed values are: new, used, refurbished)

but i was wondering when i upload that csv file to online it shows :

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache Server at Port 80
the amazing thing is every thing works fine besides all products image shows the 1st image of the provided image link and 2/3 products shows 3 images where all image links are working , im getting stuck with those problem , if any one facing same kind of problem or had solution or solve on this issue , please help , nb, im adding the product csv file too in zip file

Attached Files

  • Attached File  e2.jpg   191.5KB   101 downloads
  • Attached File  e4.jpg   126.18KB   115 downloads
  • Attached File  e3.jpg   203.99KB   83 downloads
  • Attached File   5.45KB   49 downloads


    PrestaShop Newbie

  • Members
  • Pip
  • 2 posts

Posted 26 January 2013 - 07:41 AM

Look around in the forum, most of the people complain about the CSV import tool.

I can help you to import your CSV file with Easy Retail Manager. To find out more, please contact me.

please help me on the issue , how could i contact you , even u can explain ur help

Maury Markowitz

    PrestaShop Apprentice

  • Members
  • PipPip
  • 259 posts

Posted 14 February 2013 - 12:45 PM

I'm sorry I cannot help, because I have the same problems :-(

Actually mine is even worse, it is saying "date_add" is incorrect. There is no date_add!


    PrestaShop Newbie

  • Members
  • Pip
  • 2 posts

Posted 21 February 2013 - 04:16 PM

if your csv file has columns name then you should skip the first line from your csv file when you importe it.


    PrestaShop Apprentice

  • Members
  • PipPip
  • 102 posts

Posted 15 May 2013 - 03:56 PM

Yes... same sorts of problems here... I do set it to skip 1 line but still gives the error for ID (like it still reads the header record)

I am going to take the header line out of the CSV next import and see what happens.

But even with that error it still seems to do the import properly.

Also, the date thing is tricky... i put in dates where necessary. Microsoft Excel likes to override the date format (I really do hate Microsoft Products) so be advised to format date fields as text and then it will retain the yyyy-mm-dd format.

Did I mention that i hate Microsoft and Bill Gates? If excel can recognize yyyy-mm-dd as a date format, why is there no way to output the date in that format?

I just hate their products.

Anyway... I am having good luck with imports now and am cruising to the finish line. Forget the export file ... it sucks... look on the Prestashop Admin Import page and see all the fields to the right (set up a file with all these fields and your imports will work better. Again, put in dates where necessary.

Also, watch out for max string length on description field and meta description etc.

How hard would it be for Prestashop crew to put some text beside these fields with the max string length?

I really do believe much stress can be alleviated if Presta-people display and convey to us the field format, length, and the default value... it just makes sense.

But again, still a great product, great people... much obliged!


    PrestaShop Superstar

  • Modérateurs
  • 7715 posts

Posted 15 May 2013 - 06:04 PM


Topic en anglais déplacé du forum français vers le forum anglais

English Topic moved from French forum to English forum

Oron modérateur forum Français. moderator french forum.

PS Votre problème est résolu ? Merci de bien vouloir marquer devant votre 1er topic [Résolu]. http://www.prestasho...s-dutilisation/ Règles et conseils du Forum. Modérateur depuis 19/04/2013signature364x57.png


    PrestaShop Newbie

  • Members
  • Pip
  • 5 posts

Posted 22 July 2013 - 12:46 PM

Thank you for prompting me to think around this issue. I was using the example spreadsheet and wondering like everyone else why I was getting errors. I copied the fields list on the right hand side and realised that there are more fields there than in the example csv product file.

I then used those on the right hand side to create a new template to upload some products.


    PrestaShop Newbie

  • Members
  • Pip
  • 5 posts

Posted 12 November 2013 - 07:23 PM

can´t understand why it is so difficult import a csv file

I had mess with it in days now and I begin to be confuse


think we need a better tutorial for beginners so we can start import

new categories products etc ... how to do tutorial !


Thanks ...


    PrestaShop Newbie

  • Members
  • Pip
  • 6 posts

Posted 11 December 2013 - 02:53 AM

Im having the same problem ..  i have attemot all  fromats and i get erros any solotion to  this problem ?

7 errors

  1. Pink Wine (ID: 1) cannot be saved
  2. Property Product->on_sale is not valid
  3. Saffron (ID: 2) cannot be saved
  4. Ide Aganju (ID: 3) cannot be saved
  5. Azafran (ID: 4) cannot be saved
  6. Ide Aganju (ID: 5) cannot be saved
  7. Vino Rosado (ID: 6) cannot be saved


    PrestaShop Apprentice

  • Members
  • PipPip
  • 102 posts

Posted 11 December 2013 - 03:20 PM

It is difficult but not impossible.


1. Go to your admin,..  Advanced Parameters > CSV


2. Change "What kind of file would you like to import?" to the type you want.


3. Note the "Available Fields" names on the right hand column -- you will need all of these, even if leaving blank


4. make a spreadsheet with these field names in the first row  (I use Excel)


5.  Enter your data for each of your records ( can use MYSQL or export a data file to see examples of the data)


6.  Save your spreadsheet!


7. Change your delimiter to a semi-colon from a comma (whether in your operating system, in your spreadsheet programme, or when saving as a csv)


8.  save as a CSV


9.  Now for me, I need to re-open the csv with notepad and then save it again as a UTF-8 


9.1  I also inspect my csv to ensure only 1 header row, no trailing rows with semi-colons


10.  Go to the import screen and upload your file 


11.  make sure you have the right file now, as prestashop (strangely) does not always show the most recently uploaded csv


12  field separator is the semi-colon ... multi value is a comma  (everything else is blank)


13.  Click next step... click skip 1 line (for the header)


14.  I always seem to get errors and warning messages, but then i check my site and my data has been imported.


Hope it works!


ps. if you have images as well, they need to be uploaded to your server and the path must be specified in your upload file (path and filename are case sensitive)


good luck!


    PrestaShop Newbie

  • Members
  • Pip
  • 16 posts

Posted 30 December 2013 - 09:16 PM



I faced same internal server error to upload the data of product combination. I also attached the screen shots of the error screen and Ps Back Office CSV import tool.


When i import the csv file through Advanced Parameter -->CSV import tool they give a lot of time to working but they don't update the product info and they give me internal server error page.


Please help to solve this issue because urgent response.

Attached Files

    PrestaShop Apprentice

  • Members
  • PipPip
  • 106 posts

Posted 10 November 2014 - 07:27 PM

I have to change field seperator to commo from semicolan for CSV file to be uploaded as per your suggestions as while saving excel file I save it with CSV common seperated delimitted

Even after copying one by one in same order of right hand example values. When uploading CSV and matching all files with same headers don't match.

We need to individually match one by one.
Can anyone share there own experience as excel is the first step to get into eccommerce.

Why CSV upload is not simple and tricky for any one to understand.

Even after many people complaining nobody in PrestaShop is bothered to reply on


    PrestaShop Apprentice

  • Members
  • PipPip
  • 37 posts

Posted 14 November 2014 - 03:57 PM

I have been very frustrated with the csv import problem since 1.5 and have just got it to work in

I think a lot of people are frustrated by the fact that not even the downloaded template from prestashop works from beginning. I would have liked to share the template .csv i made, but are not allowed by presta forum :/  But i can give a few hints:


- Edit in excel! (+save in excel is fine) - Use ; and , as in the default import setting.

- No capital LETTERS!! ;)

- Always force ID numbers! If you already have products in the shop, edit the IDs in the .csv file so no 2 IDs are the same.

- Images are complicated if creating a new shop, if creating an old, copy the images from the img folder in old shop to img folder in new shop, and set the image url accordingly. With the whole adress!

- Some things like friendly url are auto generated from the name.

- Some columns needs to be 0< since blank is not a valid value (weight, height etc.)

- Leave all dates blank or edit them before import, prestas template dates are 2013 and are not valid!

- Create valid categories before import


Good Luck,


Also tagged with one or more of these keywords: Name (ID: ID) cannot be saved, prestashop, prestashop, prestashop 1.5 error, prestashop csv import error

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users