CSV Products Import - ID cannot be saved - after update to 1.6.1.15

[Motuman]

Hello community,

 

my shop was working fine on PS 1.5 and 1.6.x, I recently updated to 1.6.1.15

and found out now that I'm not able to use the CSV products import as normal anymore 

 

I have changed and updated the CSV file over 10 times now, little tweaks like:

double check on having no characters, Ignore this collum and then ignore other collum, not more the 3 Capitals letter in a row, gave them own IDs where normally they create themselve, you name it, but no change....

 

I changed back php7 to php5, hoping this was the problem, but no...

 

Tried to put on Debug mode, don't see anything strange happening... just the same warning

(could be because I don't know good how to read it...)

 

I'm out of ideas, do you have any ?

 

I work on MacBook Air with Numbers and export to CSV in Unicode (UTF-8), always worked perfect

 

Thank you for reading,

hope anyone has a solution for this issue

 

[Scully]

I have seen similar reports on 1.6.1.15 with csv import issues so far. Unfortunately with no solution so far.

[Motuman]

I have seen similar reports on 1.6.1.15 with csv import issues so far. Unfortunately with no solution so far.

 

Hi Scully, 

Thank you for sharing, hopefully someone creates a solution then

as I have no idea how to get it working again 

 

Although I'm listing manually now, it does take too much time 

['Woger]

The problem is still there in 1.6.1.16.
Running on Debian/Apache24/PHP7.0 
 

I try to import 300 products using these lines:
Active;name;category;price excl.;Description;Image URL;quantity;Available for order

0;95004023750;44;75.00;95004023750;"http://www.domain.com/upload/95004023750.jpg";12;1

0;95004123750;44;75.00;95004123750;"http://www.domain.com/upload/95004123750.jpg";12;1

0;95004213750;44;75.00;95004213750;"http://www.domain.com/upload/95004213750.jpg";12;1

0;95004412450;44;49.00;95004412450;"http://www.domain.com/upload/95004412450.jpg";12;1

With these results:

 

1. 95004023750 (ID: No ID) cannot be saved
2. Property Product->link_rewrite is empty
3. 95004123750 (ID: No ID) cannot be saved
4. 95004213750 (ID: No ID) cannot be saved
5. 95004412450 (ID: No ID) cannot be saved
6. 95004514250 (ID: No ID) cannot be saved
7. 95004613450 (ID: No ID) cannot be saved
8. 95004724450 (ID: No ID) cannot be saved
9. 95004824450 (ID: No ID) cannot be saved
10. 95004914450 (ID: No ID) cannot be saved
11. 95005033950 (ID: No ID) cannot be saved
12. 95005324450 (ID: No ID) cannot be saved
13. 95005424450 (ID: No ID) cannot be saved
14. 95005534450 (ID: No ID) cannot be saved
15. 95005634450 (ID: No ID) cannot be saved
    etc......

Does anyone allready have a good solution for this?

 

Thanks,

Roger

Edited September 6, 2017 by 'Woger (see edit history)

[Scully]

Added a field ID before all fields set to zero and imported on ps 1.6.1.15 with no problems:

ID;Active;name;category;price excl.;Description;Image URL;quantity;Available for order
0;0;95004023750;44;75.00;95004023750;"https://lofthome.ch/docs/2015/01/loft-07-kueche-wohnen1.jpg";12;1

Edited September 6, 2017 by Scully (see edit history)

['Woger]

Yep indeed,

 

I changed the last column (all 1's) to ID and now it worked.
 

Thanks,

Roger

['Woger]

Whoops,

Too early. After 30 minutes working nothing was added, but also no errors 

The only thing I can think of now is that the URL of the webshop is pointing elsewhere now. Only the hosts file on the server and on my computer link to the IP address of the prestahop

 

 

Edit: Nope, after changing the domainname tot a test subdomain, still not working.

Edited September 6, 2017 by 'Woger (see edit history)

['Woger]

Ok,

Little further. I use ID =1  on all products and on CSV Import I have "Force all ID numbers" on No. However, it creates a product with ID=1 and adds all pictures from the other 297 products to this product. Seems the "Force all ID numbers" is not working.

['Woger]

Adding ID numbers in the CSV file  gives these errors:

 

6 errors 

1. 95004023750 (ID: 3180) cannot be saved
2. Property Product->link_rewrite is empty
3. 95004123750 (ID: 3181) cannot be saved
4. 95004213750 (ID: 3182) cannot be saved
5. 95004412450 (ID: 3183) cannot be saved
6. 95004514250 (ID: 3184) cannot be saved

× There are 5 warnings

• Rewrite link for 95004023750 (ID: 3180) was re-written as 95004023750.
• Rewrite link for 95004123750 (ID: 3181) was re-written as 95004123750.
• Rewrite link for 95004213750 (ID: 3182) was re-written as 95004213750.
• Rewrite link for 95004412450 (ID: 3183) was re-written as 95004412450.
• Rewrite link for 95004514250 (ID: 3184) was re-written as 95004514250.

[Scully]

I had not cared about some force all ID settings. Just ID = 0 in the file and upload with default settings from prestashop. And of course => map the new ID field with the corresponding from prestashop.

['Woger]

I had not cared about some force all ID settings. Just ID = 0 in the file and upload with default settings from prestashop. And of course => map the new ID field with the corresponding from prestashop.

 

You mean; let Prestashop take care of the ID numbers ? I have that too, but still the same errors. Also with ID = 0 on all products.

[Scully]

Yes, I let prestashop generate the IDs. The just began and a last used ID plus 1. And once again with some more details. Choosen the CSV above with ID field at the beginning (first column). Then import with the following settings:

 

Delete pre-existing products: NO

Use product numbers as key: NO

Skip regeneration of images: NO

Keep IDs from file: NO

 

(I use german so above translations are not 100% precise to default)

 

Choose the correct columns => import => Ok. Your problems seems to be your try to import with a name which only consists of figures. And the name will be used to generate the friendly url. Try to adapat this. Name with only figures dosn't sound good to me.

['Woger]

 

Added a field ID before all fields set to zero and imported on ps 1.6.1.15 with no problems:

ID;Active;name;category;price excl.;Description;Image URL;quantity;Available for order
0;0;95004023750;44;75.00;95004023750;"https://lofthome.ch/docs/2015/01/loft-07-kueche-wohnen1.jpg";12;1

I took your string to test (even your link) and got this:

2 errors 

1. 95004023750 (ID: No ID) cannot be saved
2. Property Product->link_rewrite is empty

×

• Rewrite link for 95004023750 (ID: null) was re-written as 95004023750.
•  

And no errors in the apache logs  

 

I am going to move back to a php5.6 server. See if that helps.

[Scully]

Please upload a screenshot of your field mapping.

Edited September 7, 2017 by Scully (see edit history)

['Woger]

I copy/pasted yours and used the same fields. So it must be 1.6.1.16 pr php7.0. I got an almost identical prestashop running on the same server with 1.7.2 which imports the same files without a problem.

greetings,
Roger

['Woger]

Well,

Just installed a copy on a server with php5.6.30 and got the exact same error. 

['Woger]

Now I did a rollback to 1.6.1.0 and tried another import and BOOM, it worked! 

['Woger]

Well, I did a lot of upgrades and rollbacks and found out that it works til 1.6.1.7 and stops working after upgrade to 1.6.1.8. So for now I start over with a 1.6.1.7 version.

[Eusebio100]

Any solution for this?
I have prestashop 1.6.1.18 and the same problem.

[Robineero]

Prestashop 1.7.6 still getting this error. Have spent several hours do understand how to get by all these errors during import and have not succeeded

 

[Justin BRown]

Dear All - I have had this problem all morning and I believe the issues is that the file structure on PS for Products it is looking for an import field called 

id_product (not ID as even specified in the sample file)

If you export the SQL data and look at products you will see the id file in PS is using this name.

On your CSV import change ID to id_product

Sorry this is not the total answer although I was successful after I had converted my data into a table in excel and then saved as csv file

 

Edited April 19, 2020 by Justin BRown (see edit history)

[Utkarsh Agrawal]

I don't Know who needs the solution now. But, I was in search of one and couldn't find it. BUT, I have figured out something, it worked for me, may it work for you too.

SO, when it shows, ( See the image ) 1st bullet point :- (ID: No ID) cannot be saved. 

Just ignore it,

now listen to me. Understand that through this, it is notifying that which listing has the issue (here for example, Glowing Buzz Pure Vitamin E Oil 10ml (100%...) has the problem.

And what problem is it? that's written in the 2nd bullet point. So for eg, here the issue was that characters were above the character limit.
And as and when I solved and saved it, everything worked!

I was stuck on this problem for days and couldn't find any solution too. 
Now, It worked flawlessly for me, you just need to focus on the bullet point after the [ (ID: No ID) cannot be saved ] bullet point where [ (ID: No ID) cannot be saved ]  is telling the name of the listing that has the issue.

I even gave IDs and everything else! It worked perfectly, Let me know if it works for you too!! Thanks

Edited June 30, 2020 by Utkarsh Agrawal (see edit history)