Rating 5 stars - 1 votes

Magento – Import Categories

It might be rather inconvenient to manually add a large number of Magento categories at once. Inserting categories one by one will take long time, especially when multiple categories and subcategories of different levels are planned to be created. In such a case, you will find it more reasonable to add those entities in an automatic and fast way.

Store Manager for Magento is adapted to any business requirement and caters for efficient category import tool, called wizard. Magento category import is organized within several wizard steps, where you actually need to designate import settings in order to accomplish this process successfully.

Pre-import Tasks

Category import is a bulk procedure and if something goes wrong, it can negatively influence store data and, correspondingly, cause misfortunes. To bypass malfunctions, fluently create necessary categories in the course of data uploading and build hierarchical category tree you are expected to fulfil pre-import preparations

Use this sample file to import Magento Open Source and Adobe Commerce categories Download File Now!

  • save Magento shop data to the file performing the database backup. In case data are corrupted or lost and some inaccuracy occurs, you can reconstitute original information
  • to upload images for categories or subcategories, you should configure FTP connection. Pictures must be provided in the respective column of the .csv file, categories and associated information will be imported from
  • provide appropriate category details in the file. You might need to renew some categories only, some should be created or, what also often occurs, new categories should be created as well as current ones updated. Accordingly, you should prepare the spreadsheet for import. If categories are going to be updated, the file should comprise product category identifier (ID, category name) and information to be updated. There is no necessity to include each and every detail. On contrary, when you create new categories, you most likely want to import maximum info on them and, accordingly, all the details must be included in the file.
  • as to file structure, each category or subcategory should take a separate row in the file. There should also be provided the path for each category or subcategory, you are going to create, in other words, you must indicate what is its place in the hierarchy
Categories Import File Structure
Categories Import File Structure

What Settings Should Be Done to Successfully Import Categories

We will address the main steps you need to take in order to achieve a successful import.

Having checked all the points and prepared Magento import category file, launch category import/export wizard, clicking on corresponding icon on category toolbar or find it in the list of Store Manager import/export wizard tools in Store section.

Launch Category Export Import Wizard through either Buttons
Launch Category Export Import Wizard through either Buttons

Afterwards the wizard will ask you to select the file for data transfer. Very often store owners save import settings and use them for further data uploads. You can select configuration and bypass setting configuring.

If you do not use configuration, proceed with usual category data import settings. In the succeeding window, you can preview data to be uploaded.

This step also requires you to do the following:

  1. Input correct separators to ensure successful file parsing and category import.
  2. Pay attention to delimiter used to separate categories in the category tree, it should be the same as the one indicated in the file
  3. If you upload images, set FTP connection directly from this window if you haven’t configured it previously. Do not forget to check “Import images” box and select the local folder, that contains images you are going to upload
Preview .csv File, Set Delimiters and Image Options
Preview .csv File, Set Delimiters and Image Options

*Category IDs are incremented by Magento system itself, Store Manager does not allow to force ID during import in order to ensure data integrity.

After you select store view categories will be imported into, you should correctly assign file columns to database fields. List of database fields is provided in the left pane of the window. If names of .csv file columns and database fields are identical, you can associate them automatically using “Auto link all” button.

Select correct category identifier - Magento category ID or name and category path.

Assign .csv Columns to Database Fields
Assign .csv Columns to Database Fields

One more time you can check category data, that will be transferred, on preview step. Afterwards you must decide on the most suitable Magento import category method. Take into note, if you opt for “Just Add” method, you may get duplicates, since Store Manager will not search for existing categories, but simply create categories and subcategories indicated in the file. If you want to use settings for further category uploads, save them to configuration below in this window.

Store Manager for Magento amplifies category handling and helps you bypass most of the routine tasks.

Download trial version of Store Manager for Magento and use fully functional program for 14 days Get It Now

Related Articles:

Card image

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...

Card image

Import Magento Products Quickly and Safely

Video and text tutorial on how to perform Magento product import using Store Manager. Read More...

Card image

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...

Card image

Magento Categories Are not Visible at the Website

The list of actions to take when categories are not displayed on the storefront. Read More...

Be the first to comment.