[SOLVED] Wrong category association after import CSV

[moNTeZIon]

Hi experts,

I need your help.

After import my CSV file to Prestashop, I can see all the products has the field "Default Category" filled.

Thats right.

But not all of them have the "Associated Categories" selected, and this is a problem, because the products dont appear in the related category when you search for them in the store.

 

So my question is, why some products are setting the "default category" field, but are not associating the "associated categories"??

This information comes from the CSV file, column "Categories", and in my case, all the products has only 1 category.

Don't know why with some products is setting the "Default Category" and the "Associated Categories", and with other products is just setting the "Default Category"...

Thanks for your help.

Regards,

Edited July 20, 2015 by moNTeZIon (see edit history)

[moNTeZIon]

Here I'm attaching the sample images, when a product has been imported:

 

1. Product with right category association (good-product.jpg)

2. Product with wrong category association (bad-product.jpg)

 

Don't know what the difference between two products, reviewing the CSV file all seems right...

Thanks for your replies.

Regards,

 

[moNTeZIon]

Here I'm attaching a CSV sample file with 3 products.

The product related to the category "LIBROS DE ACUPUNTURA" is imported well, setting the Default category, and associating the same category in the associated categories list.

With the other 2 products, is only setting the Default Category, but is not associating the category in the associated categories list.

Somebody can tell me why??

Thanks a lot.

 

Edited: I cannot attach CSV files, but is only text, I paste here the text directly

 

5758;1;EL LENGUAJE SECRETO DEL CUERPO;LIBROS DE ADIVINACION;9.57;3;9.57;0; ; ;2014-07-16;2016-07-16;5051010;5051010;Productos Varios;Productos Varios;9788497778206; ; ; ; ; ;0.00;2.00;1; ; ; ; ;Práctico manual ilustrado...;Práctico manual ilustrado...;EL LENGUAJE SECRETO DEL CUERPO,LIBROS DE ADIVINACION;EL LENGUAJE SECRETO DEL CUERPO - LIBROS DE ADIVINACION;EL LENGUAJE SECRETO DEL CUERPO,LIBROS DE ADIVINACION;EL LENGUAJE SECRETO DEL CUERPO - LIBROS DE ADIVINACION - Práctico manual ilustrado;el-lenguaje-secreto-del-cuerpo;En stock; ;1;2014-07-16;2014-07-16;1;http://www.productosvarios.com/Images/Productos/Productos/el-lenguaje-secreto-del-cuerpo.jpg;1; ;0;new;0;0;0;0;0;0;0;0

9177;1;QUÉ ES LA ACUPUNTURA;LIBROS DE ACUPUNTURA;10.20;3;10.20;0; ; ;2014-07-17;2016-07-17;516678;516678;Productos Varios;Productos Varios;9789501712148; ; ; ; ; ;0.00;1.00;1; ; ; ; ;QUÉ ES LA ACUPUNTURA;QUÉ ES LA ACUPUNTURA;QUÉ ES LA ACUPUNTURA,LIBROS DE ACUPUNTURA;QUÉ ES LA ACUPUNTURA - LIBROS DE ACUPUNTURA;QUÉ ES LA ACUPUNTURA,LIBROS DE ACUPUNTURA;QUÉ ES LA ACUPUNTURA - LIBROS DE ACUPUNTURA - QUÉ ES LA ACUPUNTURA;que-es-la-acupuntura;En stock; ;1;2014-07-17;2014-07-17;1;http://www.productosvarios.com/Images/Productos/Productos/que-es-la-acupuntura.jpg;1; ;0;new;0;0;0;0;0;0;0;0

9784;1;GRAFOLOGÍA FÁCIL;LIBROS DE GRAFOLOGÍA;12.50;3;12.50;0; ; ;2014-07-17;2016-07-17;517636;517636;Productos Varios;Productos Varios;9788441430907; ; ; ; ; ;0.00;1.00;1; ; ; ; ;Nuestra forma de escribir...;Nuestra forma de escribir...;GRAFOLOGÍA FÁCIL,LIBROS DE GRAFOLOGÍA;GRAFOLOGÍA FÁCIL - LIBROS DE GRAFOLOGÍA;GRAFOLOGÍA FÁCIL,LIBROS DE GRAFOLOGÍA;GRAFOLOGÍA FÁCIL - LIBROS DE GRAFOLOGÍA - Nuestra forma de escribir;En stock; ;1;2014-07-17;2014-07-17;1;http://www.productosvarios.com/Images/Productos/Productos/grafologia-facil.jpg;1; ;0;new;0;0;0;0;0;0;0;0

Edited July 17, 2015 by moNTeZIon (see edit history)

[moNTeZIon]

Hi again,

I've solved my problem.

I think Prestashop is not working fine when you are importing using category names (Version: 1.6.0.14).

This is a BUG! 

I have changed the import method, and now i'm using Category IDs in place of Category Names, when importing.

By this way the import process is associating the categories to the products correctly.

 

In my previous example, the third product was related to a category named "LIBROS DE GRAFOLOGÍA".

In my prestahop there is only one category named "LIBROS DE GRAFOLOGÍA". No other that looks like that name.

And is EXACTLY this name.

So, why prestashop is not matching the name and associating the category? Don't know...

I think somebody should review this process...

If you are working with category IDs, you don't have this problem.

 

I hope it can help someone...

Regards,