Product CSV Import - Error when update a product

[Moritz]

When I want to update an existing product via the CSV import I get the following error.

import_error.png (16 KiB) Viewed 17923 times

[aimeos]

Seems like you've added a category twice to a product

[Moritz]

The product in my screenshot with code "MC_8_038876" already exists.
Is it then correct that the category is inserted again in mshop_product_list via INSERT?

[aimeos]

If the product is already in the database, it should be updated only including adding/replacing catalog relations. The "catalog" domain is fetched by the product importer:
https://github.com/aimeos/ai-controller ... er.php#L10

[Moritz]

I've debugged the import.
Here is the $listItem that throws the exception.
The ID is set to null.
In the next line when you call $listManager->save() the Exception occurs.

[aimeos]

What is the ID of the product item and the parent ID of the list item in your case?

[Moritz]

IDs.png (2.69 KiB) Viewed 17858 times

[aimeos]

The root cause of the problem is probably in these lines because a new list item seems to be created instead of the existing one reused:
https://github.com/aimeos/ai-controller ... #L136-L137

Please check if the product item fetched from the database contains list items for the catalog relations at all.

[Moritz]

Seems to be missing.

missing_catalog.png (96.95 KiB) Viewed 17851 times

[aimeos]

Did you overwrite this setting somewhere?
https://github.com/aimeos/ai-controller ... php#L3-L20

When using TypoScript, overwriting of the keys is enough to overwrite all child settings.