Am using Magento version 1.8.1. Created categories in admin and prepared the CSV file filling out all the categories for the products.
when importing am getting error "category does not exist in row .." when i checked the csv file the categories are all there. Checked for the case sensitivity too. I used find method in the browser and the categories are found.
Import error
My categories in admin
My CSV file.
Please advice me to solve this issue. Thanks.
UPDATE
Saving the csv file to UTF-8 Solved the issue. But after that when i import, i get errors on other categories.
Some category rows in csv file are
Apparel/Girls Clothes 2T – 4T/Dresses – Daywear
Madame Alexander/Supplements For Dolls/Doll Clothes 16" And Up
I get category not exist where ever i have the (-),(") and numbers in category names in CSV.
Checked for the spaces and case-sensitivities and its all correct.
Please help me to solve this issue..
Best Answer
Initially My CSV file was in ANSI encoding format. Saving the CSV file to UTF-8 encoding Solved the issue.
But after that when i import, i get errors on other categories. WHICH WAS DUE TO SPACING BETWEEN THE SLASHES SEPARATING THE CATEGORIES.
I Looked for the Case-sensitivity and fixed few and now all the products are imported, Even if my category name contains (-) (") and numbers.
Thank you.