⚙️ Introduction

This job allows the creation and update of the classification tree (categories) and the association of attributes to these classifications via CSV import.

You can:

Create and organize the category hierarchy
Link attributes to specific classifications
Configure attribute behavior (facets, search, variants) per classification

📂 Import model

The CSV file must contain one row per classification-attribute association.

To create a classification without an attribute, leave the attr_code column empty.
To link multiple attributes to one classification, create multiple rows with the same classification identifier.

📄
Template
You can use the following spreadsheet as a template to structure your import:
Classifications - Template

📋 Fields

Field	Definition	Required for creation	Required for update	Editable	Default Value
`Classification Name`	Display name of the classification	✅		✅
`Classification External Id`	Unique external identifier of the classification	✅	✅
`Classication Parent External Id`	External ID of the parent classification. Use `Root` for top-level classifications	✅		✅	`Root`
`Attr Code`	External ID of the attribute to link to this classification			✅
`Attr Enabled`	Enables the attribute for this classification			✅	`TRUE`
`Attr Indexable`	Allows the attribute to be indexed			✅	`FALSE`
`Attr Required`	Makes the attribute mandatory for products in this classification			✅	`FALSE`
`Attr For Variant`	Uses the attribute for product variants			✅	`FALSE`
`Attr Faceted`	Displays the attribute in catalog filters			✅	`FALSE`
`Attr Searchable`	Enables search on this attribute's values			✅	`FALSE`
`Attr Sortable`	Enables sorting by this attribute			✅	`FALSE`
`Deleted`	Set to `TRUE` to delete the classification			✅	`FALSE`

🧠 Key Business Rules

Every classification must be attached to another classification's External Id or to Root via the Classification Parent External Id field.
Attributes must have attr_indexable = TRUE to function as attr_faceted, attr_searchable, or attr_sortable.
Any change to attr_indexable, attr_faceted, attr_searchable, or attr_sortable requires a full reindex of the system to take effect.
Attributes are linked at a specific classification level. If an attribute is needed on a child category, it must be explicitly linked to that child (unless your business logic uses inheritance).
To create a classification without linking any attribute, leave attr_code and all attr_* columns empty.
deleted set to TRUE removes the classification. This action is irreversible.

📌
Best Practices
✔️ Always define the full hierarchy top-down — ensure parent classifications exist before creating child classifications.
✔️ Set attr_indexable = TRUE before enabling attr_faceted, attr_searchable, or attr_sortable.
✔️ Plan a reindex after any change to indexing or search configuration.