1.7 csv import

[oshoot]

I am trying to import my products CSV and getting these errors. Any idea what could be wrong? is it the 3rd column Product name, does this need to be less than 128 characters?

 

 

 

Errors occurred:
    •    UTG 3-9x32 AO Compact CQB Bug Buster Rifle Scope Illuminated Mil-Dot Reticle 1 4 MOA 1 Tube Medium Max Strength Lever Lock Weaver Rings (ID: No ID) cannot be saved
    •    Property Product->link_rewrite length (135) must be between 0 and 128
    •    UTG 4-16x56 Bubble Leveler AO Rifle Scope SWAT AO EZ-TAP Illuminated Etched-Glass Mil-Dot Reticle 1 8 MOA 30mm Tube Weaver Picatinny Rings (ID: No ID) cannot be saved
    •    Property Product->link_rewrite length (138) must be between 0 and 128
    •    UTG 4x32 AO Bug Buster Compact Rifle Scope EZ-TAP Illuminated Mil-Dot Reticle 1 4 MOA 1 Tube Low Max Strength Lever Lock Weaver Rings (ID: No ID) cannot be saved
    •    Property Product->link_rewrite length (133) must be between 0 and 128
 

[razaro]

Like error says those are really long names  133,135 and 138 characters so do try to rename those.

[oshoot]

I see this fix for 1.6. Not sure how to do it in 1.7

 

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)

Edited November 24, 2016 by oshoot (see edit history)

[fonekase]

i just installed prestashop 1.7 and i tried using the csv import and i kept getting errors for such things like meta character to long so i changed that but i have a csv file with well over 2000 products and i cant get it to work properly. my csv file is formatted correctly. is there anyone out there that can help me.

[oshoot]

I could not get any help and when it did work it was very erratic I had 6000+ items. I gave up and had to go to another platform

[fonekase]

Have you tried the Csv import pro module?