prestashop shows error-Name (ID: ID) cannot be saved when importing product csv - Ecommerce x PrestaShop [ARCHIVE BOARD] - PrestaShop

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


Posted 26 January 2013 - 05:38 AM


    PrestaShop Newbie

  • Members
  • Pip
  • 2 Active Posts
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   102 downloads
  • Attached File  e4.jpg   126.18KB   115 downloads
  • Attached File  e3.jpg   203.99KB   83 downloads
  • Attached File   5.45KB   65 downloads


Posted 26 January 2013 - 07:41 AM


    PrestaShop Newbie

  • Members
  • Pip
  • 2 Active Posts

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


Posted 14 February 2013 - 12:45 PM

Maury Markowitz

    PrestaShop Enthusiast

  • Members
  • PipPip
  • 259 Active Posts
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!


Posted 21 February 2013 - 04:16 PM


    PrestaShop Newbie

  • Members
  • Pip
  • 2 Active Posts
if your csv file has columns name then you should skip the first line from your csv file when you importe it.


Posted 15 May 2013 - 03:56 PM


    PrestaShop Enthusiast

  • Members
  • PipPip
  • 110 Active Posts
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!


Posted 15 May 2013 - 06:04 PM


    PrestaShop Legend

  • Global Moderators
  • 11637 Active Posts

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 1.6.x Votre problème est résolu ? Cliquez sur Mark Solved en bas du post à droite. http://www.prestasho...s-dutilisation/ Règles et conseils du Forum.

Modérateur depuis 19/04/2013signature364x57.pngUn soucis avec les noms de domaines venez vers moi :)


Posted 22 July 2013 - 12:46 PM


    PrestaShop Newbie

  • Members
  • Pip
  • 5 Active Posts
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.


Posted 12 November 2013 - 07:23 PM


    PrestaShop Newbie

  • Members
  • Pip
  • 5 Active Posts

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 ...


Posted 11 December 2013 - 02:53 AM


    PrestaShop Newbie

  • Members
  • Pip
  • 6 Active Posts

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


Posted 11 December 2013 - 03:20 PM


    PrestaShop Enthusiast

  • Members
  • PipPip
  • 110 Active Posts

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!


Posted 30 December 2013 - 09:16 PM


    PrestaShop Newbie

  • Members
  • Pip
  • 21 Active Posts



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


Posted 10 November 2014 - 07:27 PM

    PrestaShop Enthusiast

  • Members
  • PipPip
  • 116 Active Posts
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


Posted 14 November 2014 - 03:57 PM


    PrestaShop Apprentice

  • Members
  • PipPip
  • 42 Active Posts

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,



Posted 03 May 2015 - 10:16 PM


    PrestaShop Newbie

  • Members
  • Pip
  • 2 Active Posts

When did you guys change this? In previous ver of PS we did not need every heading basically a few required and what else you needed and it worked flawlessly. I dont see why we would want to mess with a item that worked so well just to make it complicated and combersome.


Posted 10 October 2015 - 06:32 PM


    PrestaShop Apprentice

  • Members
  • PipPip
  • 39 Active Posts

We have uploaded hundreds of thousands of items by prestashop csv import but have had numerous problems in the process.  The worst error is "cannot be saved" with no explanation?  Have spent hours trying to fix when this error occurs attempting to  adjust the name and id for it to take with no success.


Posted 05 April 2017 - 12:38 PM


    PrestaShop Newbie

  • Members
  • Pip
  • 17 Active Posts

We have uploaded hundreds of thousands of items by prestashop csv import but have had numerous problems in the process.  The worst error is "cannot be saved" with no explanation?  Have spent hours trying to fix when this error occurs attempting to  adjust the name and id for it to take with no success.


We have the the same error now on

I can't find any explanation or solution abut it.

Are you found something?


Posted 25 April 2017 - 12:44 AM


    PrestaShop Newbie

  • Members
  • Pip
  • 1 Active Posts

This is absurd...

Any update on this? I even tried imporing the very same DEMO csv, and failed with this error...

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

Cookies help us deliver our services. By using our services, you agree to use our cookies.     Learn more