Vote to Improve PrestaShop

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

 
Photo

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

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

  • Please log in to reply
10 replies to this topic
ringku2k

    PrestaShop Newbie

  • Members
  • Pip
  • 2 posts

Posted 26 January 2013 - 05:38 AM

hi,
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, webmaster@bestboutiquestore.net 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 www.........net 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   97 downloads
  • Attached File  e4.jpg   126.18KB   115 downloads
  • Attached File  e3.jpg   203.99KB   83 downloads
  • Attached File  csv_pro_f3.zip   5.45KB   37 downloads


ringku2k

    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
thanks

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!

reklonious

    PrestaShop Newbie

  • Members
  • Pip
  • 2 posts

Posted 21 February 2013 - 04:16 PM

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

PrestaToys

    PrestaShop Apprentice

  • Members
  • PipPip
  • 83 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!

Oron

    PrestaShop Superstar

  • Modérateurs
  • 7137 posts

Posted 15 May 2013 - 06:04 PM

Bonjour

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


surfgimp

    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.

gugu

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



yorubacorp

    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


PrestaToys

    PrestaShop Apprentice

  • Members
  • PipPip
  • 83 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!



awahab

    PrestaShop Newbie

  • Members
  • Pip
  • 14 posts

Posted 30 December 2013 - 09:16 PM

Hi,

 

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







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

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users