Cannot update items with Eszett (ß) in code via Impex

[former_member597]

Hello experts,

I want to update items in my SAP Commerce Cloud system via an impex file but some of them have an eszett (ß) in their 'code'.

My header is like this:

UPDATE Product; code[unique=true]; customValue;
                code1            ; thisCodeWorks
                codeß2           ; thisCodeDoesntWork

When I try to execute the impex it says:

 ,,,,no existing item found for update

The encoding of the impex file is 'UTF-8' and an import via the impex console in the HAC also does not work.

I double checked the 'code'-property of the affected items and copied it straight to my impex file without success.

Thanks in advance!

[former_member712212]

Hi Felix,

From the result that you posted, looks like Hybris can not find the items you are trying to update. Maybe because of the catalog version.

Which Catalog Item are you trying to execute? I can not see in the query the catalogVersion attribute.

Have you try it to execute, INSERT_UPDATE and check the result?

Best Regards,

[former_member597]

svetlin_serafimov I don't think it has something to do with the catalog version because in my actual impex file all the lines without eszetts have been updated successfully. And I dont use Product but a custom itemtype, independent from a catalog.

Would I use INSERT_UPDATE instead, it will always create a new item with the same (!) code, event though its [unique=true]

[former_member712212]

Hi Felix.

First, in the posted script are missing semicolon as geff.h.n.chang posted.

Second if you don't specify catalog version you will probably face the error like

,,,,More than one item of type Product

Third, it is aways good to know which version you are trying to update. Basically is aways good to update the stage version of the product.

One more the INSERT_UPDATE will create a product only if the product doesn't exist. This means that will create eventually a new product with the same code which I am sciptic that you will be able to insert it.
Most probably then you will get an error related with the catalog version.

Something like that ...
type Product requires missing column [catalogVersion]

Hope this helps.

Best Regards,

[former_member597]

I forgot to use semicola in my sample script in the question only, my actual ImpEx script is syntactically correct
It updated 80 lines successfully, only the ones that contain an 'ß' were skipped, because no items were found. It probably has something to do with encoding. The issue is reproducable on Version 1808, but not on 1905 and higher.