importing product in magento with category name with slash

importing product in magento with category name with slash

August 22, 2026 · Illustrated author avatarBy Stefan Bogdanescu
importing product in magento with category name with slash

Solving Category Import Issues in Magento

Many developers face challenges when importing products into Magento, especially when dealing with category paths that contain special characters or spaces. In this post, we will address the common issue of importing products with categories containing slashes and spaces using a practical example.

The Problem: Importing Categories with Slashes and Spaces

You’ve encountered an error while trying to import a product into Magento where the category name contains both slashes (/) and spaces:

CSV File:

_sku,_category
MANGO123,Category/MANGO/ BANANA

Error Message:

Category does not exist in rows: (..)

The issue lies in how Magento interprets the category path. It expects a clean, hierarchical structure without unnecessary spaces or special characters.

The Solution: Cleaning Category Paths for Import

To resolve this problem, you need to ensure that the category paths in your CSV file match the actual directory structure in the Magento admin panel. Here’s how to approach it:

  1. Check Your Category Structure

    • Log into your Magento admin panel.
    • Navigate to “Catalog > Categories”.
    • Ensure that your categories are organized correctly with appropriate slashes (/) as separators.
  2. Clean Up Your CSV File

    • Remove any extra spaces before or after the category name: Category/MANGO/BANANA (not Category/MANGO/ BANANA).
    • Ensure there are no leading nor trailing spaces.
    • The final format should look like this:
      _sku,_category
      MANGO123,Category/MANGO/BANANA
      

Importing Your Products

Once you have cleaned up your CSV file, proceed with the import process:

  • Go to “System > Import”.
  • Select “Product”.
  • Choose your CSV format.
  • Upload your clean CSV file.
  • Click on “Import”.

If everything is set up correctly and there are no other issues in your CSV data, Magento should successfully import your products into their respective categories without any errors.

Conclusion

Dealing with category paths containing slashes and spaces during product imports can be frustrating. However, by following this guide and ensuring that your CSV data matches the actual category structure in Magento, you can avoid common import issues.

Remember to always validate your CSV files before importing them into Magento. This simple step can save you a lot of time and prevent unnecessary errors.

If you need further assistance with Magento imports or have other questions about e-commerce development, feel free to explore our resources at Laravel Company. We provide comprehensive guides and tutorials on various aspects of Magento development.

Catalog Admin Import/Export Errors

Our network