Product update via csv import fails in 2022.04
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Product update via csv import fails in 2022.04
Hi,
after upgrading to Aimeos 2022.04 product updates using csv import fails:
Products are already imported, but I have to update prices, texts etc.
The csv worked for Aimeos 2020, but now the update fails. I could not find any new settings for shop.php or any changes for the csv mapping.
Thanks!
after upgrading to Aimeos 2022.04 product updates using csv import fails:
Code: Select all
Unable to import product with code "238530": SQLSTATE[23505]: Unique violation: 7 FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »unq_msproli_pid_sid_dm_ty_rid«
DETAIL: Schlüssel »(parentid, siteid, domain, type, refid)=(37254, 1., catalog, default, 16)« existiert bereits.:
INSERT INTO "mshop_product_list" (
"parentid", "key", "type", "domain", "refid", "start", "end",
"config", "pos", "status", "mtime", "editor", "siteid", "ctime"
) VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)
["37254","catalog|default|16","default","catalog","16",null,null,"[]",0,1,"2022-05-16 23:30:52","aimeos:jobs","1.","2022-05-16 23:30:52"]
The csv worked for Aimeos 2020, but now the update fails. I could not find any new settings for shop.php or any changes for the csv mapping.
Thanks!
Re: Product update via csv import fails in 2022.04
The problem should be fixed with this patch and it will be part of the next release:
https://github.com/aimeos/ai-controller ... c07ede72ec
In the meantime, you can add a configuration with the new values to your ./config/shop.php
https://github.com/aimeos/ai-controller ... c07ede72ec
In the meantime, you can add a configuration with the new values to your ./config/shop.php
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Product update via csv import fails in 2022.04
perfect - its working with the added configuration
Thank you!
Thank you!