ProductManagementAttributeValue loader

It loads given rows to the spy_product_management_attribute_value and table spy_product_management_attribute_value_translation.

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_product_management_attribute column.

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_product_management_attribute_value">
    <unique name="uqc_product_management_attribute_value">
        <unique-column name="fk_product_management_attribute" />
    </unique>
</table>

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

Usage:

<product-management-attribute-value
    productManagementAttributeIdField="productManagementAttributeId"
    productManagementAttributeValueIdField="productManagementAttributeValuesId"
    valueField="values"
    translationLocalizedValuesField="localizedValues"
    translationLocalizedValuesValueField="value"
/>

Attributes:

  • productManagementAttributeIdField - name of the field containing productManagementAttributeId

  • productManagementAttributeValueIdField - name of the field containing productManagementAttributeValueId if existing, otherwise name to be saved to

  • valueField - name of the field containing the value

  • translationLocalizedValuesField - name of the field containing a localizedArray with the localeId as Key and translation

  • translationLocalizedValuesValueField - name of the keyField to read the translation given in translationLocalizedValuesField