Maxi Zoo
      Back to home
      1. effectmanager academy
      2. POS Data
      3. Maxi Zoo

      How to set the correct file format for Maxi Zoo

      This guide shows you how to get the correct file format Maxi Zoo POS reports for effectmanager.

      The POS files from Maxi Zoo contain daily sales data. Data is stored on Maxi Zoo as both a corporation and chain in the POS cube. 

      Accepted file format: .xlsx
      Accepted number format: 1000,00
      VAT: POS files are without VAT.  effectmanager adds 25% VAT 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 Maxi Zoo, please see our guide How to upload POS reports for Maxi Zoo

      Maxi Zoo POS reports for effectmanager

      The file format for Maxi Zoo POS reports is Excel.xlsx files. The reports must contain the following headers in the file in the order given below. 
      POS data is stored on MaxiZoo 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