Products Duplicated in Initial Mapping with UUID, Error on Subsequent Imports

[mrk-dzie]

Environment and configuration

1. "akeneo/module-magento2-connector-community": "^104.0"
2. Akeneo version (Serenity | Growth | 7.0) using uuid for entity mapping

Steps to reproduce

1. Create a product with the same SKU in Magento and Akeneo
2. Run the product import job. The import will end with no error, but the product will be duplicated in the database, and mapping is created with the sku attribute for the entity that already existed in Magento before import.
3. Run the product import job again. The job will end with the error Cardinality violation on the Match code with Magento/Adobe Commerce ID step.

Expected result

Existing products are not duplicated and are correctly mapped with Akeneo UUID code.

Actual result

Products are duplicated during the initial mapping and subsequent imports encounter errors due to multiple mappings for the same UUID in akeneo_connector_entities

SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row, query was: 
    UPDATE `tmp_akeneo_connector_entities_product` t
    SET `_entity_id` = (
        SELECT `entity_id` FROM `akeneo_connector_entities` c
        WHERE t.`uuid` = c.`code`
            AND c.`import` = "product"
    )

[krasii]

The same issue

[mrk-dzie]

@krasii Check out the solution here https://github.com/akeneo/magento2-connector-community/pull/669

[rbouma]

Same problem here! @mrk-dzie Thanks for the solution. We have applied this in composer patch.

https://patch-diff.githubusercontent.com/raw/akeneo/magento2-connector-community/pull/669.patch

[rbouma]

@magentix Also this is breaking for a lot of people so can you have a look at this also?

[pixiemediaweb]

same issue for our clients. it is not practical to tell users to re-sku all of their products. hopefully sense will prevail soon ;)