BFI
      Back to home
      1. effectmanager academy
      2. POS Data
      3. BFI

      How to set the correct POS file format for BFI

      This guide shows you how to get BFI POS reports for effectmanager.

      BFI sends you the POS data reports, and you upload these at effectmanager. 

      If you are looking for a guide on how to upload BFI POS data, see our guide How to upload BFI POS reports

      BFI POS reports for effectmanager

      The file format for BFI POS reports is CSV files. The reports must contain the following headers in the order given below. 

      🔴OBS! Be careful not to open your CSV file before uploading it, this will damage the number format in the file, and the Vare ID will be in a wrong format creating duplicate products in the cube.

       

      Headers Sales Report

      BFIKundenummer must be number format, for data to be read into the cube. Sales on stores without a customer number or without a number format will not be visible in the cube. 
      Accepted file format: CSV
      Accepted number format: 1000,00
      VAT: Including VAT.  
      Accepted date format: WYYYYWW eg. W201947

      • Column A: BFIKundenummer
      • Column B: Site Name
      • Column C: Adresse
      • Column D: Post Nr
      • Column E: By
      • Column F: Ejer
      • Column G: Vare ID
      • Column H: Vare Navn
      • Column I: DRS Vare Grp Descr
      • Column J: Week Text Long
      • Column K: Salg incl. moms
      • Column L: Salg volume

      🔴OBS! It is important to note that Column F: Ejer must always equal one of the values below, as this mapping is coded for the import to match on Chain Name. 

      • Ejer = DCC - The ChainName = Shell RBA
      • Ejer = DO - The ChainName  = Shell DO
      •  Ejer = Extra - The ChainName = extra

      Headers Category Report

      BFIKundenummer must be number format, for data to be read into the cube. Sales on stores without a customer number or without a number format will not be visible in the cube. 
      The accepted number format in the raw data file is 1000,00.

      • Column A: BFIKundenummer
      • Column B: Site Name
      • Column C: Adresse
      • Column D: Post Nr
      • Column E: By
      • Column F: Ejer
      • Column G: Week Text Long
      • Column H: DRS Vare Grp Descr
      • Column I: Salg incl. moms
      • Column J: Salg volume

      🔴OBS! It is important to note that Column F: Ejer must always equal one of the values below, as this mapping is coded for the import to match on Chain Name. 

      • Ejer = DCC - The ChainName = Shell RBA
      • Ejer = DO - The ChainName  = Shell DO
      •  Ejer = Extra - The ChainName = extra

      Download our printer-friendly guide with translations of Excel column headers