How to load interactions with Product data by CSV?

[Former Member]

Hi,

I am trying to load into Hybris Marketing cloud some interaction data by CSV files.

I was able to load interaction without products properly. However, now I would like to load some sales orders. The problem is that I don't know which column name should I use to include product data. There is a way ( any documementation?) where I can find the available columns names for the csv load? ( I downloaded the template but it does not include any column for products).

Regards,

Ana

[vervinckt_joyca · Accepted solution]

Hi,

You cannot upload interactions with product data via csv in the Import Data of Hybris Marketing directly.

However there are two ways to still achieve this, these methods actually convert csv into OData loads which do support interactions with product data:

1) This blog explains how to set up SOAPUI to transform csv files into OData streams. There's one flow that allows for a file with interaction and then another file with the product data per interactions, both files need to be linked with a matching key field.

2) Also CPI allows for a file-based data load that converts csv into an OData load, which is explained in this blog.

Hope this helps you,

Kr,

Joyca

[KunalBansal]

Dear Ana,

Product Interactions can only be uploaded via OData and not CSV.

Also, refer to OData's Structures for below:

1. OData Service API_MKT_PRODUCT_SRV
2. OData Service API_MKT_PRODCAT_HIERARCHY_SRV

Hope this helps.

Regards,

Kunal Bansal

CRM & Hybris Marketing - Consultant

[Former Member]

Thanks all for your help!

Regards,

Ana

[SCHNEIDERT]

Hi Ana,

interactions with products can only be loaded into the system via OData and not via CSV.

Best regards

Tobias