1 - Sell-in file specifications

1.1 First Reception

In the format mentioned in the Excel file:

" TBL-180 824 CUSTOMER -SELL-IN file format for SI - SO_MP analysis »

  • Granularity :

Mandatory : detailed both by point of sale / month / product

If possible : per order / day

  • Pharmacies:

Be sure to include the information needed to identify pharmacies as listed in the file " TBL-CLIENT 180824-SELL-IN file format for SI - SO_MP analysis "

pQ

  • Products:

It must include all of your products concerned by the scope of the analysis.

Mandatory fields : GTIN (code on 13 digits / designation)

Optional fields : Any product qualification / segmentation field can be useful

  • History required:

3 years (be sure to include all products and pharmacies active during this period, even if the product is no longer sold or the pharmacy is closed or is no longer a customer).

  • Sell-in / Indicators:

> In volume and value (excluding tax)

> Identify free units

> Include repeats

1.2 Recurrence: monthly receipt

Receipt each month (in the same format as specified in 1.1) of your sell-in for the past month.

By fully integrating any new products and pharmacies concerned by the analysis.

2 - Stream

We can of course put you in touch with our IT department for the reception format of your sell-in data.

This to handle big data and automate the send-in flow from sell-in to OpenHealth.

Do not hesitate to ask us about this at the address: csc@openhealth.fr

Did this answer your question?