*Reduced by 1% after each order
Rating 5 stars - 1 votes

How to perform category import to Magento 2

How to Import Products to Magento 2: Learn how to accomplish product import in deep details (CSV sample & step-by-step guide)

Having launched Magento 2 store or upgraded to newer version, you should commence on catalog setup and traditionally it starts from adding its backbone, product categories.

Magento boasts of its hierarchical category navigation, that allows you to arrange categories and subcategories of different levels and simplify catalog browsing for customers visiting your online shop. Out-of-the box there is no option to perform Magento 2 import of categories in the back-office so that you can resort either to manual category tree creating or import categories together with products through default import option.

In case you do not install sample data in Magento 2, you will have only Default root category under which required categories of any levels can be created. If you prefer to create category tree manually, add one by one specifying its place in hierarchy.

magento 2 category hierarchy
How to Import Categories to Magento 2

Import Category Tree to Magento 2 with Default Import Tool

Magento 2 extends import possibilities and facilitates category creation if there is a full category path in the import file. In this way, if you specify category path for a product A in the import file and no category exists by this path, Magento 2 will create it and place product A there.

Below you can find the extract from the file used for product import via Magento admin. Each of products has full category path or several paths ascribed. Import will result in creating category tree structure as it is outlined in the file.

How to Import Categories to Magento 2

Theoretically, this trick may help you import category tree to Magento 2 Open Source or Adobe Commerce. Though there are several aspects to consider. Suppose you have thousands of products to be uploaded to Magento 2. There is only default category and you should specify imaginary category paths to each product in the file. Certainly there might be multiple levels and sublevels of categories and to create them you should accurately fill paths, so that hierarchy will be preserved after import.

Moreover, you might need to set multiple category associations, that means one item will be assigned to several categories. Then paths to each category must be indicated in the import file and separated by multiple value delimiter, for example

Default Category/Beauty&Health,Default Category/Beauty&Health/Hair Colors,Default Category/Beauty&Health/Hair Colors/L'Oreal

When uploading this file via default import functionality, you should use the same separator.

magento import categories from csv
How to Import Categories to Magento 2

These manipulations make it possible to import category tree to Magento 2 but it is hardly possible to prevent muddles when setting up import file.

To bypass them you can first import categories to Magento 2 and afterwards replenish them with products via Store Manager for Magento. It greatly enhances this implied process and reduces it to a few intuitive tasks.

Perform Category Import to Magento 2 with Store Manager

Store Manager possesses category import wizard for bulk category/subcategory adding. It allows to create Magento 2 categories and specify related details, like description, display settings, meta information, category image within several clicks only.

Import Categories to Magento 2 FREE Import Categories Now!

What details should import file include to get category tree of multiple levels created? Look at the screenshot attached.

Magento Store Manager Category import file

Missing these fields you will not perform category import to Magento 2 though it does not mean these are enough. Provide also meta data, display settings, description and other.

The file with category details should be imported via category import wizard (Store->Import/Export->Import/Export Categories or at the category toolbar).

  1. Launch Magento 2 category import wizard and select the file:

  2. Magento Store Manager Category Import Browse File
    Select file for import

  3. Preview your CSV file and set file delimiters to get details parsed correctly on the next step:

  4. Magento Store Manager Category Import Preview and Delimiters
    Preview .csv and set delimiters

  5. Map file columns with fields at Magento database and select category identifier Category Name and Category Path (category ID is used for update only).

  6.  Map File Columns
    Map File Columns

  7. Preview category related info and confirm upload.

  8. Category Import Preview
    Preview Category Import

  9. Select appropriate category import option: Add an modify, Add only, Modify only, Just add. Press "Import" to start the upload:

  10. Category Import Options
    Choose appropriate category import option

  11. Now you can check the result in Store Manager.

How to Import Categories to Magento 2
How to Import Categories to Magento 2

Magento 2 category tree structure has been imported. At the moment they are empty but you can use product import wizard and instantly rich categories with goods.

Store Manager for Magento will help you create catalog from scratch and easily maintain it further.

Import Magento 2 Category Tree FREE with Store Manager Get It Now!


Related Articles:


how to set multi lingual category tree in magento 2 article

Set Multi-Lingual Category Tree in Magento 2

Find out how to translate category data from the back-end or via Store Manager using the import tool. Read More...

change product position in category in magento 2 via import tutorial

Change Product Position in Category in Magento 2

It is possible to change product position in category in Magento 2 manually for each category via CSV file. Read More...

magento export categories article

Magento – Export Categories

Export Magento categories (all categories or specific ones) into a .csv file with a possibility to select particular fields to be exported. Read More...

list of magento products without category

Get a List of Magento Products Without Category

Check the methods of detecting Magento products not assigned to any category of your store and find out the reasons why they appear. Read More...


Be the first to comment.
Live Chat