Long Product Names

[MarlboroMan]

Hi Guys

 

Prestashop 1.6 is limited to accept product names only up to 128 Characters.

Are there anyway I can make this more like 300 Characters when uploading via csv.

 

[Knowband Plugins]

Try following these 2 steps.

 

1. Open database using PhpMyAdmin, search for table 'product_lang', now you need to change type of column "name". Change its type length from 128 to 300.

 

2. Now edit /classes/product.php file, search for "isCatalogName". Now in the search result line, replace 128 with 300.

 

This should do the trick for you.

 

PS: Don't forget to create database backup, just in case.

[MarlboroMan]

Hi

 

Thanks for the info.

Edited May 26, 2016 by MarlboroMan (see edit history)

[MarlboroMan]

"now you need to change type of column "name". Change its type length from 128 to 300"

I found the table 'product_lang' but are not sure how to edit the column "name".

Where or how do I change the length 

Must I add some code?

[Knowband Plugins]

If you are using phpmyadmin, click on the structure tab in top bar on right side.... then search for column "name" in the list.. then click "change" against "name" column.

 

Then you will find 128, just change it to 256

[MarlboroMan]

Thanks!

I'm learning something new every day.

Will test this tonight.

[Knowband Plugins]

Let us know if you need screenshots help for the same.

[MarlboroMan]

Changed the value's but when I try to import my csv I receive the following error.

 

"Property Product->link_rewrite length (147) must be between 0 and 128"

[Knowband Plugins]

Have you made the suggested changes in code?

[MarlboroMan]

Yes, I've also tried lower values.

[MarlboroMan]

Hi

 

Thanks for your help. I've also changed the link_rewrite length. Now I can import via csv also with long product names.

Could there be any other complications because of the long "link_rewrite length" like on search engines and so on?

Edited May 27, 2016 by MarlboroMan (see edit history)

[Knowband Plugins]

Hi,

 

No, it will not cause any issue to you

 

We are glad that your issue is fixed now.