How to set the correct file format for ICA
This guide shows you the accepted file format for ICA POS reports for effectmanager.
The POS files from ICA contain Sales data on a daily level.
Accepted file format: Excel.xlxs
Accepted number format: 1 000,00 and 1.000
VAT: Including VAT
Accepted date format: YYYY-MM-DD eg. 2019-11-27
If you need a guide that shows you how to upload POS data for ICA, please see our guide How to upload POS reports for ICA
🔴OBS! Due to an agreed rule, entires are disregarded if there are not values in both turnover and volume columns for each chain.
ICA POS reports for effectmanager
POS reports for effectmanager must contain the following headers in the order given below.
- Column A: EAN
- Column B: Märke
- Column C: Benämning
- Column D: Totalt antal
- Column E: % av vgr
- Column F: Belopp totel
- Column G: Maxi antal
- Column H: Maxi belopp
- Column I: Kvantum antal
- Column J: Kvantum belopp
- Column K: S-market antal
- Column L: S-market belopp
- Column M: Nära antal
- Column N: Nära belopp
🔴OBS! effectmanager has a limit of 20 MB for POS files when uploading.