How to assign categories to the products?

How to assign categories to the products?

In order to assign categories to the products, the following fields should be enabled in the profile:

Root Entity fields



Product Category Relation Entity fields



The product_id field stands for the ID of the product from the product grid, located in Catalog > Products. The product_sku field should contain the SKU of the product, and categories value contains the full path to the category assigned. 

Here is an example of the import file:



More use-case scenarios may be found in the article Useful Tips and Popular Import Use Cases.


      • Related Articles

      • How to assign simple options to configurable products?

        In order to assign simple products to the configurable ones, it is necessary for them to already exist in Magento. Therefore, at first, I'd recommend importing all the products. Here are the minimum required fields to import a new product: Root ...

      • How to assign multiple websites to the products?

        At the moment, the following import fields are required to assign the product to multiple websites: Root Entity Product Website Entity Here is an example of the import file: More use-case scenarios may be found in the article Useful Tips and Popular ...

      • What is the required minimum of fields to import orders/products/customers?

              There is an option to automatically fill the import profile with fields for typical cases for all import modules. This option is available on creating a new import profile in the Import Settings tab:       If enabled, Fields Configuration will ...

      • How to import bundle products?

        In order to link a bundle product with the options, all the products should be imported to Magento first. Here are the minimum required fields to import a new product: For more convenience, please, feel free to add product attributes such as name, ...

      • How can I import multiple media gallery images?

        In order to import and link multiple gallery images to the product, the following fields should be added to the import profile: Sku or entity_id fields are added for the extension to identify the product and assign the rest of the mapped data to it. ...