Do you want to customize your environment to use aggregations and multi-level forecasts?
Good news ā itās possible to create and update custom fields to better suit your activity.
This article shows you how to fill in custom fields to host information specific to your SKU Science environment.
Note: You can upload custom fields (the subject of this article) along with sales or forecast data (covered in a separate article) in a single action.
However, this article focuses only on managing custom fields.
Update Fields to Personalize Your Environment
There are two types of fields in SKU Science: predefined fields and custom fields that you can create.
Predefined SKU Science Fields (General & Finance)
Below is a list of fields already available on the platform, visible in the "General information" section of each item.
You only need to map columns from your file to these fields to upload your data to SKU Science.
Important: An additional "Profit" field is calculated automatically by the platform based on the sale price and cost of each item. It cannot be manually imported.
Custom fields
You can customize your environment by creating custom fields in two ways:
Directly by going to the tool interface. You can also modify or delete fields you have previously created.
While uploading your file
To upload new data, click the gear icon at the top right of the tool.
Then click on "Data upload Wizard" to access import options.
Click the Upload SKUs data
button.
File selection
Select the Excel or CSV file you want to upload.
Import parameters
As with your first upload, the wizard will try to detect dates and automatically map your data to some predefined fields.
If the wizard detects dates in the file headers, it will display a table to help prevent interpretation errors.
Note: If your file doesnāt contain any dates, but the wizard has mistakenly checked the "My file contains dates" option, simply uncheck it.
This will allow you to assign your fields to platform fields in the "Map fields" section.
Mapping Fields
If the wizard has not mapped automatically some of your fields, you can decide how to map each field from your file to the platform fields in the "SKU Science Field" section:
Do not map - skip this field
Associate with an existing field ā map to a predefined SKU Science field
Create a new custom field ā select "Add new field"
Click on the little arrow to have the below window displayed.
Add new field
When clicking on Add new field
, the below window will appear:
Enter a name for the field or keep the one from your file, and click on Confirm
.
Add multiplier field
When creating a custom field, you can specify if it is a text field or a āmultiplier fieldā by ticking the box. A multiplier field is a numeric field that allows you to display your forecasts in other units by multiplying the forecasted quantities by this fieldās value.
For example, if your forecast is expressed in units (e.g., number of item), and you create a custom field called "Weight", your forecasts can be automatically displayed in kilograms, pounds or tons by multiplying the forecasted quantity by this fieldās value.
Use only multiplier field when it is appropriate.
Continue the upload process by selecting the right number format and matching level. Finally, click "Confirm" to start the upload process.
Upload confirmation
Once the upload is complete, check your items in SKU Science to ensure the information is populated correctly.
If you encounter any issues, contact us via the platform interface or email support@skuscience.com.