How to set the correct POS file format for OK Plus
This guide shows you how to get OK Plus POS reports for effectmanager.
POS data reports from OK Plus are sent to you and you will upload these in effectmanager.
If you are looking for a guide on how to upload OK Plus data, see our guide How to upload OK Plus POS reports
OK Plus POS reports for effectmanager
The file format for OK Plus reports is Excel files. The report must contain the following headers in the order given below.
Accepted file format: Excel
Accepted number format: 1000,00 and 1.000,00
VAT: Including VAT
Accepted date format: DD-MM_YYYY eg. 27-11-2019
- Column A: Butiksnavn/store name
- Column B: Dato/date
- Column C: Varenummer som streng/product name as a string
- Column D: Empty row
- Column E: Varenavn/product name
- Column F: Empty row
- Column G: Empty row
- Column H: Antal (boner)/amount (receipts)
- Column I: Enheder/units
- Column J: Salgspris m. moms/sales price including VAT
🔴OBS! effectmanager has a limit of 20 MB for file upload.