This guide shows you how to get the correct format for Kesko POS reports for effectmanager.
POS data reports from Kesko can be sent automatically from Kesko to effectmanager. The file format for Kesko POS reports is CSV files.
🔴OBS! Be careful not to open your CSV file before uploading it, this will damage the number format in the file, and the EAN number format will be wrong leading to the creation of duplicate products in the cube.
If you are looking for a guide, that shows you how to upload your Kesko files to effectmanager, please see our guide How to upload Kesko POS reports
Kesko POS reports for effectmanager
The following POS reports are available from Kesko: Sales and Category. The reports must contain the following headers in the order given below.
Headers Sales Report
Data for products without an EAN number in the Sales Report will not be read into the cube.
Accepted file format: CSV
Accepted number format: 1000.00
VAT: Excluding VAT. The VAT is added to the cube 24%.
Accepted date format: YYYYMMDD eg 20191127
- Column A: Item
- Column B: Item no.
- Column C: EAN
- Column D: Store no.
- Column E: Store name
- Column F: Ketju
- Column G: Tuoteryhmä
- Column H: Tuotealaryhmä
- Column I: Tuotesegmentti
- Column J: Date
- Column K: Volume
- Column L: Value
Headers Category Report
Accepted file format: CSV
Accepted number format: 1000.00
VAT: Excluding VAT. The VAT is added to the cube 24%.
Accepted date format: YYYYMMDD eg 20191127
- Column A: Ketju
- Column B: Tuoteryhmä
- Column C: Tuotealaryhmä
- Column D: Tuotesegmentti
- Column E: Date
- Column F: Volume
- Column G: Value
🔴OBS! effectmanager has a limit of 20 MB for file upload.