Hybris Marketing Products and Product Categories not shown

[SCHNEIDERT]

Hi All,

I'm using Hybris Marketing on-premise.

I already uploaded some interaction contacts, interactions, product categories and products into Hybris Marketing using csv-import.

Using transaction SE16 I also checked, if the products & categories were in the HANA tables (CUAND_PROD_CATEG & CUAND_PROD_DESC). They are.

But I can't see them in the Segmentation. With the imported interactions it is working without any problems.

In the "Manage Interests" application I can see the product categories.

Has anyone maybe had that problem or has an idea what to do?

Thanks in advance!

Tobias

[Former Member · Accepted solution]

Dear Tobias,

Your interactions should be in table CUAND_CE_IA_RT, if you correctly added interactions containing products, these should then be available in table CUAND_CE_IA_PROD. Are you sure you have entries in this table?

The products that you can select in Segmentation are usually linked to the Interactions. Without any interactions there won't be any products that you can select in Segmentation.

[SCHNEIDERT · Accepted solution]

Dear Komur,

okay, then I think I made a mistake.

I have the entries for the interactions in CUAND_CE_IA_RT but no entries in the CUAND_CE_IA_PROD.

Thanks for your help.

[SCHNEIDERT · Accepted solution]

Dear Komur,

am I right, that there is no possibility to import products via interaction upload using CSV?

[Former Member · Accepted solution]

Dear Tobias,

Yes, you are right. You will either need to use OData to upload the interactions, or create an ABAP report in combination with a FM CUAN_CE_INTERACTIONS_POST. This FM can has a structure containing a table for the products.

[tcrifasi · Accepted solution]

I have problem loading interactions with products. I can see the interactions in CUAND_CE_IA_RT but not the related interaction products in CUAND_CE_IA_PROD.

I'm actually not sure how to track the products via SE16. Are the 2 tables above joined via DB key (CUAND_CE_IA_RT) and parent key (CUAND_CE_IA_PROD)?

[vervinckt_joyca · Accepted solution]

Hello,

You can use the existing report in SE38: CUAN_CREATE_INTERACTION

It allows you to create interactions including products and interests.

Kr,

Joyca

[Former Member · Accepted solution]

Dear Joyca,

That will depend on the version of Hybris Marketing you are running.In my case (1605 on-prem) this transaction does not exist.

[Former Member · Accepted solution]

Dear Thierry

these tables are linked as following:

CUAND_CE_IA_RT-DBKEY = CUAND_CE_IA_PROD-PARENT_KEY

After which the product from this table can be lead back to the product master as following:

CUAND_CE_IA_PROD-PRODUCT_KEY = CUAND_PROD_ROOT-DBKEY

[vervinckt_joyca · Accepted solution]

Oh,

I don't know when this report was added to the system.

However it is used in this video: https://youtu.be/LgnyAMfX9eM?t=438 and this video dates from March 2016 so I'm surprised that it doesn't exist in 1605.

[former_member432021 · Accepted solution]

Hello Thierry!

Did you succeed with that problem?

We have just imported interaction products but we cannot see them in segmentation with the All contacts segmentation profile.
The problem is that we cannot see Product Name either Product Description. We go to the table CUAND_PROD_ROOT and there is no Name and no Description.
Name and descipription are stored in CUAND_PROD_DESC

Thanks in advance!

Regards,

Carlos.

[former_member588419 · Accepted solution]

Hi Carlos

As I can see you can link these tables from Hana database with the product_key of table cuand_ce_ia_prod and table cuand_prod_desc parent_key.

I have a question does anyone knows how to load data from hybris commerce to hybris marketing? I am trying to do so but the only products that I have registered from there are from interactions. But these products doesnt have categories registered.

Regards

Aldo

[chrigu1 · Accepted solution]

Hi Aldo,

have you tried Expressway? If I am not mistaken there is a product sync job which I would expect to do what you are looking for.

Regards Christopher.

[former_member588419 · Accepted solution]

Hi Christopher

We used Y2Y vía datahub, as i know Expressway used something like that. Today we worked on it and it already send interactions, recommendations, products and customers, but now we have problem with recommendations. The ID of the product that is being send from Marketing to commerce is the product_key and not the object id. Commerce cant find that product and send an error. Did you know how to solve this or any documentations about it? In Marketing we have all the configuration and as we know this process is done by hybris commerce and not marketing.

Regards

Aldo