PrestaShop导入分类CSV失败，提示category->name is empty

I’ve helped a colleague troubleshoot this exact issue before—PrestaShop’s CSV import system has stricter requirements than many other platforms, so even if your file works elsewhere, small discrepancies can trigger this frustrating error. Here are the most common fixes to try:

• Verify column name matches PrestaShop’s requirements
  Unlike some platforms that tolerate aliases like "Category Name" or "Cat Name", PrestaShop expects the exact header for category names. For single-language shops, this should be Name (capitalized N). If you’re running a multi-language store, the header needs to follow the format Name (Language Code) (e.g., Name (en) for English, Name (fr) for French). Double-check that your CSV’s header matches this exactly—even a typo or wrong case will make PrestaShop fail to recognize the field.

• Check for hidden whitespace or invalid characters
  Sometimes the name column looks populated, but contains invisible characters (like line breaks, tabs, or UTF-8 BOM headers) that PrestaShop interprets as empty. Open your CSV in a text editor like Notepad++, enable "Show All Characters" under the View menu, and inspect each name cell. Delete any stray characters, then re-save the file.

• Ensure your CSV uses the correct encoding
  PrestaShop relies heavily on UTF-8 (without BOM) for imports. If your file is saved in ANSI, UTF-16, or another encoding, the system might misread the name field content. In Notepad++, go to Encoding > Convert to UTF-8 without BOM, save the file, and try importing again.

• Validate row endings
  Line ending formats (Windows CRLF vs. Unix LF) can sometimes cause parsing issues. In Notepad++, use Edit > EOL Conversion > Unix (LF) to standardize the line endings, then re-save.

• Test with a small sample first
  Instead of importing the entire file at once, take 1-2 rows of valid data, create a mini CSV, and test the import. If this works, you’ll know the issue is with specific rows in your full file—you can then isolate and fix those problematic entries.

内容的提问来源于stack exchange，提问作者Mehdi Naimi