Import CSV Property Product->link_rewrite length

[doubleb]

Hello!

 

I have a problem with the import CSV section. When I try to import products from CSV I get this errors:

1. PRODUCT NAME HERE (ID: 2673) can't be saved
2. Property Product->link_rewrite length (139) must be between 0 and 128

I have ~500 products, I get this error only for 30-40 products (with long names). How can I fix this? Is there a way I can cut the name inside the import function?

 

Thank you!

 

 

FIXED! SOLUTION (PrestaShop 1.6.0.9):

 

1. admin/classes/product.php

 

Change "link_rewrite -> size" from 128 to 255 (Line 309)

Change "name -> size" from 128 to 255 (Line 315)

 

2. From phpmyadmin go to this table: ps_product_lang

 

Change "name" varchar(128) to varchar(255)

Change "link_rewrite" varchar(128) to varchar(255)

 

And so the import works ok

Edited September 10, 2014 by doubleb (see edit history)

[hstrom]

Hi,

I had great use of this above, but I got stuck on Product->description_short being too long when importing (Prestashop v1.7), it has to be between 0-927 according to the error message.

I checked the product.php and it was set with a max of 800 (sic!). I changed it to 2000. 

In phpmyadmin the "description_short" is set as "text". 

Cleaned the cache and tested the import again, but with the same result. The Product->description_short is too long (still it says 0-927). 

Any ideas?

 

With kind regards,

 - Johan.