ProductSearch loader

It loads given rows to the spy_product_search 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_product 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_product_search">
    <unique name="uqc_product_search">
        <unique-column name="fk_product" />
        <unique-column name="fk_locale" />
    </unique>
</table>

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

Usage:

<product-search
    productConcreteIdField="productConcreteId"
    localeIdsField="localeIds"
/>

Attributes:

  • productConcreteIdField - name of the field containing the product concrete id

  • localeIdsField - name of the field containing the locale ids