This guide shows you how to get the correct file format Maxi Zoo POS reports for effectmanager.
The POS files from Maxi Zoo contain Sales data on a daily level. Data is stored on Maxi Zoo as both corporation and chain in the POS cube.
Accepted file format: .xlsm
Accepted number format: 1000,00
VAT: POS files are without VAT. Effectmanager adds VAT 25% to data in the cube.
Accepted date format: MM/DD/YYYY eg. 02/28/2023
The date format in the file is displayed like this: DD/MM/YYY
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
Maxi Zoo POS reports for effectmanager
The file format for Maxi Zoo POS reports is Excel.xlsm 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 and chain 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: Bogføringsdato
-
Column B: Afdelingskode
-
Column C: MaxiZoo Varenr
-
Column D: Beskrivelse
-
Column E: Beskrivelse 2
- Column F: Varegruppe nr
-
Column G: Antal, stk
-
Column H: Salgsbeløb (faktisk), DKK
-
Column I: Antal kunder,stk
-
Column J: Category - Hund/Kat
-
Column K: Category - Tør/Våd/Snacks
-
Column L: Royal Canin varenr
-
Column N: Butik navn
-
Column M: År
-
Column O: EAN