import CSV products are not assigned to categories

[idrissohs]

I have a csv file where products are linked to multiple categories when i import the csv file, the importer just creates new categories for every product.

 

 

 

Active,Descr 1,Make:Make; Model:Model,Part#,stock,categories,List,Descr 1

1,BMP COV FT ROE 92 94 VIGOR,Make:ACURA; Model:VIGOR,AC1000101R,1,1992; 1994; 1992; 1993; 1994,506.95,BMP COV FT ROE 92 94 VIGOR

1,BMP COV FT 88 89 INTEGRA,Make:ACURA; Model:INTEGRA,AC1000105,1,1988; 1989; 1988; 1989 ,292.72,BMP COV FT 88 89 INTEGRA

 

 

My categories are basically years the importer just creates a new categories with the years for every product. so I would have 700 different categories, and none of them are assigned to the product

 

If anyone can help please

[NemoPS]

Hi,

Try using category IDS instead, without spaces before and after numbers. It should fix it

[parsifal]

Try reversing the "delimiter" and the "multiple values per field" character. Use semicolon [ ; ] for field delimiting and comma [ , ] for multiple values per field delimiting. In addition, enclose the multiple values for a field in double quotes [ " ].

[idrissohs]

Thank you for your help. but i fixed it by just uploading my database through the prestashop desktop module