Stock Forecasting Weekly Data

This import allows you to update items with Stock Forecasting data that could vary by weeks, such as Seasonality, Demand, or Supplier Lead Time.

NB! To use this import you need to have the Stock Forecasting functionality enabled for your account. More info here.

ImportData StockForecastingWeeklyData

Available Columns

Legend

Key Description
Compulsory 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.
Additional 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.

Columns

Key Column Description
Paid  SKU The Linnworks Item Number as seen in the My Inventory screen.
Additional  Supplier Name Specify the supplier name when importing the Supplier Lead Time.
Paid  Type

Specify the type of modifier:

  • Sales Seasonality
  • Predicted Demand
  • Lead Time
    • NB! This is the lead time, not the modifier. For example, lead times change over the year. If you're ordering from China, lead times get much longer in February as the country shuts down for Lunar New Year.

The base value for seasonality and demand is 1.0. 

Paid  Week 1 (up to week 53) Add the value for each modifier per each week separately. 

How to Use Import

To use this import, follow the steps below:

  1. Prepare a CSV file with the required details. Check the table above for the obligatory columns.
  2. Go to Setting > Import Data.
  3. Click the Import Now button. 
  4. Select the Stock Forecasting Weekly Data import type.
  5. Choose file and complete Column Mapping
  6. Click Run Now.

For more detailed instruction on each step, see the following guide.

Example Files