csvimportimportexportmagento-1.8
I have created a Category with Special character called "Home Décor" http://puu.sh/k2ZOP/0267464f46.png. Now when I trying to import the products under this category, I got "Category does not exists in rows" error. http://puu.sh/k2ZRZ/be1e291542.png
Here is the CSV file screenshot: http://puu.sh/k2ZTX/5de537e978.png. I have try to save the file in UTF-8 Format, but still facing the same error.
Please help me.
Your CSV is not formatted correctly.
Do not separate it by "Tab" and "Comma", just comma. Steps 3 & 4 seem to be unnecessary (I have never need to do those steps in 5 years). I'm wondering what step broke your CSV to make it look like what it looks like now.
I edited your file correctly formatted it. Give this one a try. https://www.dropbox.com/s/g89jcrycfzhqbnf/product.csv
Place the image under media/import then in the CSV use /p1.jpg - there is no need for the extra /product sub-directory.
Best Answer
I have just copy the data into Google Spreadsheet and download. It's works fine now.