Stock Forecasting General Parameters
This import routine allows you to configure item parameters used for Stock Forecasting in bulk. Note that importing data that varies by weeks (like seasonality and demand) can be done through the Stock Forecasting Weekly Parameters import.
|This field is a compulsory requirement for import. The data must exist as a column in the CSV and be mapped to the named field.|
|This field relies on dependent data that is a compulsory requirement for the import. If this field is included in the import then the dependent fields must also be mapped.|
|Daily Average Consumption Days||The number of days you want your Daily Average Consumption to be calculated over (max value is 90 days; the default value is 90 days). This value will be saved for the Consumption Period setting in Product Details > Stock Forecasting > Stock Forecasting Parameters.|
|Default Reorder Quantity||Typical reorder amount for an item. It is normally influenced by business decisions. For example, better pricing for ordering at least X quantity from the supplier.|
|Historical Average Daily Consumption||Add this column to the file when using the SpecifyConsumption model strategy. Specify the historical value for the Daily Average Consumption ratio.|
|Lead Time Modifier||
This is used to define uncertainty in Lead Time. The default value is 2.0.
Use this column to import data for the stock forecasting method configured in the Product Details > Stock Forecasting > Stock Forecasting Parameters section.
The available methods are:
|Safety Stock Modifier||
This value is used to adjust the amount of safety stock used to determine when to reorder. The default value is 2.5.
|SKU||The Linnworks Item Number as seen in My Inventory.|
|Supplier Name||Specify the name of the supplier when importing Lead Time Modifier.|
|Surrogate SKU||Add this column to the file when using the Surrogate model strategy. Specify the SKU the consumption of which you would like to use for stock forecast calculations.|
|Surrogate Stock Location||Add this column to the file when using the Surrogate model strategy. Specify the location of the item to be used for stock forecast calculations.|
How to Use Import
To use this import, follow the steps below:
- Prepare a CSV file with the required details. Check the table above for the obligatory columns.
- Go to Setting > Import Data.
- Click the Import Now button.
- Select the Stock Forecasting General Parameters import type.
- Choose file and complete Column Mapping.
- Click Run Now.
For more detailed instruction on each step, see the following guide.