How does the category tree work (3 levels: Category → Subcategory → Item Type)?

Categories form a self-referencing tree up to three levels: Category → Subcategory → Item Type. Each category record can have a parent (a null parent means it's top-level), plus a display order among its siblings, so the hierarchy is both structured and orderable. The bulk importer builds this tree automatically from a spreadsheet's Category/Subcategory/Item Type columns. The three-level…

Categories form a self-referencing tree up to three levels: Category → Subcategory → Item Type. Each category record can have a parent (a null parent means it's top-level), plus a display order among its siblings, so the hierarchy is both structured and orderable. The bulk importer builds this tree automatically from a spreadsheet's Category/Subcategory/Item Type columns. The three-level structure is deep enough to organize large catalogues meaningfully (department → category → specific type) while staying simple to navigate, and products attach to categories at any level via a many-to-many link.