Our goal is to provide you with the simplest possible experience so that you can get your forecasts.
One of the challenges that we have to face is to recognize all the date formats that our users can present in their file when importing historical sales (or demand) data. There are multitudes depending on the tool from which your data comes and the location of our users.
In order to simplify your life, SKU Science integrates a technology which allows you to define during the import process, the date format as it exists in your file.
(We have noticed however that some weird formats are not recognized. Let us know if this is the case for your file.)
So in the example below, our date format is "2018/Sep". Thus the month appear in the form of letters and not numbers.
First, we can notice that by default the date is misinterpreted.
Let's now pick another format to properly import our data. This format does not appear directly in the drop-down list "Format", but do not panic, we will tell the import wizard how to interpret this format.
First select the drop-down menu in "Format".
Select "Custom", the box below appears to define the format.
The table below contains many examples on how to set the format and illustrates the possibilities.
Glancing at the board, we find that:
- for a year on 4 digits, you must enter "YYYY"
- for the month on 3 letters here "Jan", just enter "MMM"
So just enter in the custom field "YYYY / MMM"
We can see that the date format is now correctly interpreted.
You can now try this method with your file, if the format is not listed by default.