0 votes from 0 votes

Assign Products to Categories Having Category IDs in the Import File



Having products logically grouped within Magento categories will ensure that your shoppers are able to easily navigate though your e-shop and reach the products that best suit their needs. Keeping products and categories up-to-date is a significant component in the overall usability of your site, facilitating customers who are going to buy or are merely browsing.


What is the main practice, you fall back upon to instantly renew or add merchandise? It goes without saying, Magento product import heads the list of tools for catalog management and merchants can’t dispense without it if they want to maintain product catalog on sufficient level.


When appending products to catalog listings, you should indicate, what category or subcategory they will be placed to, as pointed out above. Formerly Store Manager for Magento allowed to assign products to categories having full category path for each product indicated in the file.


Starting from Manager version 2.16.0.992, Magento users get the possibility to assign merchandise to categories by category ID as well.


If you have categories or subcategories created and are going to add new products to some categories, place them to more than one category or rearrange product-category associations, you can accomplish it having ID of categories in the file, instead of lengthy paths. This is highly convenient and now Store Manager accepts files exported with Dataflow.

What Settings Should Be Configured to Get Products Placed to Necessary Categories

Before uploading the file with product import wizard, check whether category IDs are provided for each product listing. Beside product related data to be imported, the spreadsheet must contain column responsible for categories, that will include IDs.

Proceed with usual import wizard settings, but consider “Fields Delimiters and Additional Settings” window. If you use category IDs, you must check “Use ID as category path” box here.


  • If products that you import already exist at your in category A, but you want to add them to other category (B) without removing from A, they are disposed at the moment, check “Keep current categories association(s) (place products to categories specified in the file, not removing them from current ones)”. In such a way, after product import finishes, you will find these items in both A and B categories.
  • In case, one and the same product must be placed to more than one category or subcategory, you must provide their IDs in the column and detach them by delimiter used to separate categories in the category tree (look at the screenshot provided above).
  • Please, note only comma delimiter (,) can be used to separate multiple category IDs within column.

Another point to examine is fields association. You are supposed to correctly ascribed file columns to database fields and choose correct identifier. File сolumn containing IDs of categories should be assigned to Category Path database field.



After suitable import options are selected, start import procedure. Data upload outcomes will be accessible in the last wizard window.


Store Manager is being always enriched with new functional capabilities meant to refine data manipulations and improve shop management respectively. Identifying categories by their IDs in the course of products transfer is another maneuver to shorten time spent on pre-import arrangements.

Try FREE Product Import with Store Manager for Magento Try Import Tool

Further Reading:

    Free upgrade to Magento 2 supported version