How can I load sales order in hybris marketing?

[j_cortesp]

hello experts

I am trying to create a buying propensity model but for this I need a sales order associated to a product (as I know).

I just created a sales order interaction but it is not assigned to any product, I need to know how can I do this? I need to upload these interactions via CSV to test and show in my system the creation of a predictive model.

Thank you

[JoanGarloff]

Hello Juan,

I would also like to draw your attention to the Quick Guide - Which API Service for Which Entity in the Integration Guide https://help.sap.com/viewer/DRAFT/0f9408e4921e4ba3bb4a7a1f75f837a7/1811.500/en-US/d9494291232f416fb7... which is designed to help you find the right service for whatever entity you want to import. You can use the search function e.g. to search for 'sales orders'. Best regards,

Joan

[former_member267312]

Hi,

CSVs are flat files and therefore do not support a deep structure with sales orders and products. You need to use the following OData service to load the sales orders:

CUAN_BUSINESS_DOCUMENT_IMP_SRV

The line items (i.e. bought products) of sales orders are interaction products.

You can also use tools like SOAP UI to inject CSV files via Odata:

Loading CSV Data with SOAP UI into SAP Hybris Marketing Cloud and SAP Hybris Marketing

For testing purposes I would suggest to use POSTMAN to post some sales orders with products to CUAN_BUSINESS_DOCUMENT_IMP_SRV. Kindly note that the master data of products should be loaded before loading the sales orders. This can be done via CSV (Import Data app).

Hope this helps.

BR

Theo