This guide shows you the accepted file format for Dogman POS reports for effectmanager.
The POS files from Dogman contain Sales data on a Monthly level.
Accepted file format: Excel.xlxs
Accepted number format: 1000.00
VAT: Including VAT for each country.
- Finland 14%
- Norway 25%
- Sweden 25%
Turnover Currency: Turnover is in local currency for each country
Accepted period names: Filename_CountryCode_MM_YYYY. e.g Dogman_NO_Jan_2019
As months, the possible values are Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec (both upper and lower cases).
Accepted country codes for Chain Name: Filename_CountryCode_MM_YYYY. e.g Dogman_NO_Jan_2019
As country code, the possible values are SE, FI, and NO (upper and lower cases).
Chain Names: Dogman NO, Dogman FI, Dogman SE
If you need a guide that shows you how to upload POS data, please see our guide How to upload POS reports for Dogman
Dogman POS reports for effectmanager
POS reports for effectmanager must contain the following headers in the order given below.
Please look at this guide Dogman Error Handling in POS Upload, for rules and validation used for import.
-
Column A: Artikelbenämning
-
Column B: Leverantörens artikelnummer
-
Column C: EANkod
-
Column D: Butik
-
Column E: Antal
-
Column F: Förs.summa ink moms
-
Column G: Märke
-
Column H: Leverantör
🔴OBS! Since there are no Dogman categories in the file you cannot report on the sales data on Dogman Main Category, Category, or Sub Category.
🔴OBS! To create StoreID, we generate a unique key based on Chain Name + Country Code + Store Name.