web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Importing Product Categories & Category Hierarchy using DIXF

(0) ShareShare
ReportReport
Posted on by 555

Hello All,

I want to import procurement category, so i don't know how to import product category & Category hierarchy and all the cycle.. i don't know how to use Product category & product category hierarchy entities.. how to do parent & child.. Please i need full detailed steps.. 

Thanks in advance

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    nunomaia Profile Picture
    25 Moderator on at

    Open Product information management / Setup / Categories / Category hierarchies

    Select a Category hierarchy and click "Categories from file".

  • Hariharans87 Profile Picture
    34 on at

    I am just giving a reference link for Nuno's reply.

    technet.microsoft.com/.../hh242810.aspx

    Import commodity codes into a category hierarchy:

    www.microsoft.com/.../details.aspx

  • Nour Desoki Profile Picture
    555 on at

    this means i must design it first in excel file?? Nothing with DMF?

  • Suggested answer
    www.RahulSharma.in Profile Picture
    508 on at

    Hi Nour,

    You can use DIXF as well to import product categories.

    Use Category DIXF entity. Before you import, create product category hierarchy and parent node manually.

    In this example; I created hierarchy called RahCat and parent node as ALL.

    Note; you can skip parent node and system will create it for you...play with combinations.

    Sample file for Category entity will look like this.

    CategoryHierarchy|Name|Code|ParentName
    RahCat|Miscellaneous|MISC|All
    RahCat|Tool & Equipment|T&E|All
    RahCat|Paint & Body Equipment|PBE|All
    RahCat|Material Fabrication|MF&F|All
    RahCat|Rust Solutions|RS|Paint & Body Equipment
    RahCat|Painting Equipment|PE|Paint & Body Equipment
    RahCat|Auto Body Repair|BF|Paint & Body Equipment
    RahCat|Paints & Coatings|PA|Paint & Body Equipment
    RahCat|PowderCoat|HC|Paint & Body Equipment
    RahCat|Buffing & Metal Finishing|BU|Material Fabrication
    RahCat|BF Accessories|BF0|Buffing & Metal Finishing

  • BINAISSE Mathieu Profile Picture
    5 on at

    Hi All

    Just want to add something to the last post, you can also add the root node you just need to copy the name of the root node in the parent node.

  • Abdo Khoury Profile Picture
    14,855 on at

    Hello Rahul

    If i use DMF , which entity should i choose to be able to migrate the product categories

  • Community Member Profile Picture
    on at

    Hi Noureldeen, I saw somewhere that you had a template for this import. Would you mind sharing it? my email is: mka79@Hotmail.com

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans