⚙️ 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.
The parent of a classification category cannot be changed after creation. If a row declares a different parent for an existing category, the row is rejected. Classification categories are shared across the whole environment (they are not store specific). Reusing the same external IDs across two shops of the same environment refers to the same categories.
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.