This guide shows you how to get Salling Group POS reports for effectmanager.
POS data reports from Salling Group are sent automatically from Salling Group to effectmanager. The format for the POS reports is set from Salling Group.
If you are looking for a guide, that shows you how to upload your Salling Group files to the FTP-server please see our guide How to set-up Salling Group POS integration with effectmanager
If you want to receive POS data from Salling Group to effectmanager, you need to set-up an integration from Salling Group to the effectmanager FTP-server.
File format: CSV
Number format: 1000,00
VAT: POS files are without VAT. Added VAT 25% to data in the cube.
Date format: YYYYMMDD eg. 20191127
🔴OBS! Before effectmanager can submit a request to Salling Group on POS data, you must have agreed with Salling Group on what reports you should receive.
The following POS reports are available for upload to effectmanager:
Articles: Contains the articles delivered to Salling Group on your Supplier number. Salling Group sends POS data on the articles in this file.
Category: Contains POS data for the categories you are active in.
Customer: Contains customer traffic data on each product on a store level.
Sales: Contains sales amounts and values for each product on a store level.
Stock: Contains stock amounts and values for each product on a store level.
Store: Contains a list of all Salling Group Stores.
Waste: Contains shrinkage amounts for each product on a store level.
For all file formats above we only accept numerical integer numbers for volume. We apply Banker rounding, where values below 0,5 go down and above 0,5 go up. Value exactly of 0,5 always goes to the nearest even number.
Examples
- 4,4 go down to 4
- 4,5 go down to 4 (nearest even number)
- 4,6 go up to 5
- 5,5 goes up to 6 (nearest even number)
Download our printer-friendly guide here