Rating 5 stars - 1 votes

Assign Magento 2 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 through 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, Magento users get the possibility to assign products to categories by category ID as well.

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.

Category ID in the Import file
Assign Products to Categories Having Category IDs in the Import File

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.

Fields Delimiters and Category Options
Assign Products to Categories Having Category IDs in the Import File

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

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

Assign .csv Columns to Database Fields
Assign Products to Categories Having Category IDs in the Import File

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

Related Articles:

dhange display sort orde of magento categories

How to Sort Magento 2 Category Positions

Check the ways to reorder Magento categories (via drag & drop, import/export, change position number etc.) Read More...

list of magento products without category

Detect Products Without Category

Check the methods of detecting Magento products not assigned to any category of your store. Read More...

export products by category in magento

How to Export Products by Category in Magento

Find out how to easily export Magento products from specific category. Read More...

how to set multi lingual category tree in magento 2 article

Set Multi-Lingual Categoryies in Magento 2

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

Be the first to comment.
Live Chat