Magento 1.9 – Solution for ‘Category Does Not Exist in Rows’

importmagento-1.9

I have an export of like 1.3k products.. so I selected only the first two from it.

I go to, System > Import / Export > Import ( Products , Append Complex Data ) just to check the file, uploading this file, imp1.csv containing the following:

sku,_type,_attribute_set,_product_websites,_root_category,_category,name,size,price,special_price,description,short_description,image,small_image,thumbnail,status,visibility,tax_class_id,qty
"3108831022134","simple","Default","base",2,165,"Garnitura oala sub presiune","","132.00","","Garnitura din cauciuc pentru oala sub presiune. Daca vechea dumneavoastra garnitura pentru oala sub presiune s-a stricat, inlocuiti-o cu una noua si folositi din nou oala. Potrivita pentru oale de 4, 6, 8 si 10 litri.","","/022134 garnitura oala sub presiune sitram_1.jpg","/022134 garnitura oala sub presiune sitram_1.jpg","/022134 garnitura oala sub presiune sitram_1.jpg","1","4","4","10"
"3367305120848","simple","Default","base",2,165,"Oala fonta aluminiu 24 cm","0-10 l","305.00","","Oala cu capac din sticla, realizata dintr-un aliaj de fonta si aluminiu. Interiorul este perfect finisat. Manerele sunt din bachelita de culoare neagra. Se preteaza tuturor tipurilor de plite, inclusiv cea cu inductie. Diametru: 24 cm.","","/120848 oala fonta aluminiu 24cm GERS _1.jpg","/120848 oala fonta aluminiu 24cm GERS _1.jpg","/120848 oala fonta aluminiu 24cm GERS _1.jpg","0","4","4","10"

And then, this happens:

enter image description here

I have checked the category ID's ( currently 165 ) and it exists:

enter image description here

What can I do.. I have changed and even removed the _root_category from "Frarom" ( originally "Default" ) to its ID, 2.

I have no idea what to do.. I have tried other answers here but it was a matter of quotes.. what is to be done here ? Thanks in advance !

Best Answer

In your csv file please use root category name and category name instead of id.