Jump to content
Motuman

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

Recommended Posts

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  :blink:

 

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

 

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

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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  :blink:

 

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

Share this post


Link to post
Share on other sites

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 by 'Woger (see edit history)

Share this post


Link to post
Share on other sites

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 by Scully (see edit history)

Share this post


Link to post
Share on other sites

Yep indeed,

 

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

Thanks,

Roger

Share this post


Link to post
Share on other sites

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 by 'Woger (see edit history)

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

 

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Well,

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 :D

 

pilt.png

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More