This guide shows you how to get the correct file format nemlig.com POS reports for effectmanager.
The POS files from nemlig.com contain Sales data on a daily level. Data is stored on nemlig.com as both corporation, chain, and store in the POS cube.
👍Pro-Tip: To have the correct file format for pos upload you must have a Sense Enterprise license with nemlig.com
Accepted file format: .xlsx
Accepted number format: 1.000,00
VAT: POS files are without VAT. Added VAT 25% to data in the cube.
Accepted date format: YYYY-MM-DD eg. 2021-01-21
If you need a guide that shows you how to upload POS data for nemlig.com, please see our guide How to upload POS reports for nemlig.com
nemlig.com POS reports for effectmanager
The file format for nemlig.com POS reports is Excel.xlsx files. The reports must contain the following headers in the file in the order given below.
POS data for the webshop is stored on nemlig.com as both corporation, chain, and store in the POS cube.
NB! If you need to know how data is mapped in the cube, please see our printer download.
🔴OBS! Due to an agreed internal rule, POS data with zero sales in both volumes and turnover will not be read into the cube.
- Column A: Calendar date
- Column B: Calendar week of year
- Column C: Calendar month number
- Column D: Campaign type
- Column E: Item ean number
- Column F: Item group level 1
- Column G: Item group level 2
- Column H: Item group level 3
- Column I: Item number
- Column J: Item name
- Column K: Item description 2
- Column L: Item description 3
- Column M: Units sold
- Column N: Sales amount
- Column O: Cost
- Column P: GP2
- Column Q: GM2%
Download our printer-friendly guide here