Category Attributes loader

It loads given rows to the spy_category_attribute table.

Warning

Unique Constraint Suggested to Prevent Duplicates

To ensure data integrity and prevent duplicate entries when running the importer multiple times with the same dataset, it is strongly recommended to add a unique constraint on the fk_category and fk_locale columns.

Without these constraints, duplicate relationships may be inserted on each import execution, leading to redundant data in the database.

Suggested SQL Constraint:

<table name="spy_category_attribute">
    <unique name="uqc_category_attribute">
        <unique-column name="fk_category" />
        <unique-column name="fk_locale" />
    </unique>
</table>

By enforcing this constraint, the CategoryAttributeLoader can reliably handle repeated imports without unintentionally duplicating entries.

Usage:

<category-attribute
     categoryIdField="categoryId"
     localizedEntriesField="localizedFields"
/>

Attributes:

• categoryIdField - name of the field containing the category id

• localizedEntriesField - name of the field containing the localized entries

  • Supports the following fields:

    • name (required)

    • metaTitle (optional)

    • metaDescription (optional)

    • metaKeywords (optional)

    • categoryImageName (optional)