How to merge product categories

[vervinckt_joyca]

Hi,

When uploading Product Hierarchy/Categories,

I noticed the CATEGORY_ID is apparently capital-sensitive...

I have now a load of duplicate categories (e.g. Coffee and COFFEE)

Can I merge them?

I can't delete them all and then upload them again, because in the past a file was already uploaded in which some levels of the category were in Caps, and some were in lowercase, and they have already been used; so there's the error "category XYZ cannot be deleted since it's used in interaction 123". I want to fix this and have ALL my categories in Caps.

Any ideas?

[Josef_Ehbauer]

Dear Joyca,

unfortunately we do not have a solution to merge different product categeries with different IDs.
Note, the behaviour is different in comparison to products, where one can load data from different source systems. For product categories we asume that the entire product hierarchy and the included product categories are loaded from one unique source system.

One should also not confuse the named merge functionality with the named merge (i.e. PATCH) operation of the API API_MKT_PRODCAT_HIERARCHY_SRV.
Please refer to the documentation https://help.sap.com/viewer/0f9408e4921e4ba3bb4a7a1f75f837a7/1911.500/en-US/50f024e5cf4546d383b05d69....

As solution for your issue you have to delete the superflous product categories with the incorrect IDs and prior to this remove the related interactions using the available application jobs for deletion.

Kind regards,
Josef Ehbauer
SAP Marketing Cloud Product Management

[kedarnath_ellendula]

Hi Joyca

You Can use by deleting the interactions by Running the Job , Please find the below link as reference.

https://help.sap.com/viewer/ac1eab4c66bc490da7ac2c378c46b0e7/1905.500/en-US/39488a2d5ddc40a3bc31e569...

For the Merging Product Categories as per the https://help.sap.com/viewer/0f9408e4921e4ba3bb4a7a1f75f837a7/2002.500/en-US/50f024e5cf4546d383b05d69...

POST and PATCH call can be done.

Product Merging is Possible

You can find some Payload examples

https://help.sap.com/viewer/0f9408e4921e4ba3bb4a7a1f75f837a7/1902.500/en-US/c89a08a0954e4944aa1ac1c4...

Thanks and Regards

Kedar

[vervinckt_joyca]

Hi Kedar,

- I don't want to delete the interactions.

- On the Product Categories documentation page, yes there are POST and PATCH call options, but I can't find which payload to add that makes two product categories merge. In the payload example of Products there isn't a payload example to merge Categories (only to merge products)