This guide shows you how to read the notifications in the email you will receive after the POS upload.
When uploading the Pets POS report to effectmanager, we validate the format and data in the file. This is to ensure that your data imported to effectmanager is not corrupted.
If corrupted data is in your file, you will receive an email detailing the error.
Below notification match rules and validation in the file:
- Sheets in the file validation
- Headers in the file validation
- Max value validation
- Number format validation
- Mandatory fields
- Zero Sales Validation in the file
- A Date Validation
Sheets in the file validation
The Pets file should contain only 1 sheet (tab) in the Excel file.
Only the first sheet is used for import to effectmanager.
If the data to import is not on the first sheet, 0 entries will be imported:
Headers in the file validation
The Pets file should contain specific headers in the Excel file, see this guide, for the accepted headers and order of columns.
How to set the correct POS file format for Pets
If the file does not have the correct headers or is not in the right order, you will receive an alert email.
Make sure that the columns in the file are in the correct order and have the right headers before attempting to import the file again.
Maximum digits value validation
The database allows for a maximum of 10 characters for sales figures.
We have a rule for importing the file, where the sales values format allows for a maximum of 8 whole numbers and 2 digits after the decimal point.
If the file contains more than 2 digits after the decimal point we apply standard rounding rules.
Number format validation
Sales Turnover values format allows for the following format: 1000,12 (no thousand separator, only decimal separator).
Sales Volume values format allows for the following format: 1000 (no decimals)
Mandatory fields
The following columns are required in the file to maintain high data quality: A, B, C, E, F, G, H.
Zero Sales Validation in the file
To maintain data quality we have a rule to prevent importing zero sales into the database. This rule rejects lines, that do not have both; Turnover and Volume data for the last 6 periods during the import process.
If you want to report on Zero Sales, please use the POS cubes Key figures.
The rule:
- Volume 0 + Turnover 0 = Both Columns have 0 → DO NOT IMPORT
- Volume BLANK + Turnover BLANK = Both columns have BLANK → DO NOT IMPORT
- Volume is different from 0 + Turnover 0 → Import the data.
- Volume 0 + Turnover is different from 0 → Import the data.
Date Validation
Date format accepted: YYYY-MM-DD
