In this article, you will learn about:
Introduction
We're thrilled to introduce you to our product forecasting tool, empowering you to accurately project sales demand, optimise stock levels and align orders to boost efficiencies and maximise profit.
🤖 Automation
Automatically generate sales forecasts using historical data and accurately capture demand using the True Rate of Sale.
🔢 Precise re-ordering
Receive size level reorder recommendations to ensure you have the right stock in the right size at the right time.
🧩 Customisation
Create forecasts at both weekly and monthly levels at the same time for your tailored product list and save your reports for fast, smart, actionable insights.
Getting Started: Product and Channel Selection
Define your product list
Using the filters at the top of your Products page, define the list of products you want to include in your forecast, such as category, department, etc. Once complete, you’re ready to begin forecasting.
Access the Forecast tool
Click the drop-down on the Products page.
Select Forecast mode to start forecasting.
Complete your Forecast channel set-up
Owners must select the channel level at which their business will forecast.
Products can be forecasted either across combined channels or within individual channels. A default channel will be selected upon entering the tool until a preferred selection is confirmed.
To adjust your Forecast channels, Owner users can navigate to Settings > Forecast channels and click Update to manage the preferred channel selections.
You can check which channels are available for forecasting at any time by opening the channel filter. Channels that support forecasting will display the Forecast tool icon next to them as pictured below.
Forecast Settings
Settings can be applied to multiple products or single products in your forecast list.
Multiple products: Settings can be applied to all or selected products by going to the top right-hand corner and clicking Multi Forecast.
Single product: Alternatively, settings can be applied to products individually via the Forecast button that is displayed when hovering the product image.
Apply Settings
First select the future timeframe you wish to apply to your forecast settings. The default timeframe is set to 52weeks, alternatively use the date picker to select a custom future date range.
Order Setup
Set the ideal weeks of cover for your products
Enter the lead time (how long it will take to receive the first order)
Enter the delivery frequency (how often you want orders delivered)
Enter the MOQ (Minimum order quantity) if applicable; recommended purchase orders will automatically adjust to meet the MOQ.
Sales Forecast
Select the time period to reference for sales demand. The forecasted Sales Units Before Returns reference the True Rate of Sale for that period.
You can edit this value using the pencil icon and adjust the % vs last year when historical data is available for the product.
The Var% displays the Forecasted weekly sales units vs Sales units before returns last year for the future 52 weeks.
For a product with partial LY% data
LY Rate of sale = 'Sales units before returns for last 52 weeks' / weeks since first activity
% vs LY = 'True rate of sale before returns' (for the period selected in the panel) / LY rate of sale − 1
*Tip: If you're applying multi-settings to products the Forecasted sales units before returns will display as 'multi', go to the product's individual settings to see actual values.
Hover on the magnify icon to display key metrics relating to the time period selected.
Similar product
Within the individual product forecast settings, another similar product code can be referenced as the base for your forecast.
Plan Stores
Within the sales forecast settings, click Plan stores to display the Ranged store count and Average store units/ week.
These metrics work bidirectionally with indicators showing the change vs. timeframe baseline to accomodate changes to a products store distribution.
Editing the Ranged store count keeps the Avg store units and recalculates the total Forecasted sales units before returns.
Editing the Avg store units keeps the Ranged store count and recalculates the Forecasted sales units before returns.
Editing the Forecasted sales units before returns or the vs LY % keeps the Ranged store count and recalculates the Avg store units.
Sales Shape
Select the weekly sales shape to apply to your future forecast:
None Applies the forecasted sales units before returns flat across all future weeks
Last Year shape: When the product you are forecasting has a full year of historical data available, you can select Last Year Shape. This will apply the average forecasted sales to the future period using last years weekly shape.
Similar product Applies the weekly sales the shape of the similar product if entered in your settings.
Click Apply once all your settings are complete and automation of your forecast begins 🪄.
Forecast Grid: Layout & Indicators
Layout
The forecasting table layout is split into two sections:
Left: Historical data
Right: Future forecast group by week or month
Highlighted rows on the forecast side can be edited directly in the grid.
👉 Tip: Click the product image to open the product detail page and view detailed product information.
Indicators
Highlighted cells on the grid correspond to forecast actions.
🟣 Purple: A re-order is recommended; click the icon to display a detailed order overview.
🟠 Orange alert: Stock is insufficient to meet projected sales demand. You will need to manually adjust your forecasted sales units until your re-orders and stock levels can accommodate demand.
🔵 Size detail: To view data at the size level for a product, click ‘View by size’ beneath the product image. The grid will then display size-specific information for that product. To exit this view and return to all products, click the arrow at the top left corner of the grid.
👉 Tip: Use the + Metrics icon at the top left of the grid to adjust the metrics displayed in your view.
Bi-Directional Metrics
All rows highlighted in the forecast tool can be edited directly within the grid.
Total markdown & discount % after returns
Current and future weeks display at last year's value until edited
Edit on the product row, in Week view only
Size rows are read-only, to edit go to the product or total view
Sales $ after returns
Editing the Total markdown & discount % after returns on a future week will update the Sales $ after returns value
Current RRP (ex tax) × (1 − Total markdown & discount % after returns) × Sales U AR
Total markdown & discount % after returns can’t be edited in the By size view
At the size level the sizes add up to the product total for Sales $ after returns
Return rate %
Until edited, the forecasted Return rate % will display the rolling last 12 week return rate % for the product/ size.
The Return rate % can be viewed and edited at the total and size level
Past weeks show the actual return rate for that week
Return rate %, Sales units before returns and Sales units after returns are linked and will updated as values are edited.
Forecast grid: Recommended purchase orders
Purchase Order Recommended Units:
A key output of your forecast is the Purchase Order recommended units (Purple indicator).
Orders are calculated using all relevant product data, including stock levels, future orders, sales demand, and ideal cover settings, and are determined at the size level.
You can edit the re-order at either the size or total level. Edited orders will appear with a grey indicator in the grid to indicate that changes have been made.
Save and Export
Saving Your Forecast
Click the Save icon in the top-right corner of the grid to save your forecast for the products in your current filtered list.
If another user is editing the same products, you will receive a notification prompting you to re-save.
Download & Export
Click the Download icon and select the timeframe you wish to export.
Choose to download either Recommended re-orders by size or All metrics as a CSV file.
Save to Reports Library
You can save your forecasted product list in the Reports Library to quickly return to the same list the next time you manage your forecast.
Click the Save button at the top of the page.
Follow the prompts to save your forecasted product list.
Data refresh notifications
Forecasts are continuously aligned with the latest available data. When updates occur, you’ll be prompted to recalculate purchase order recommendations if required.
You’ll will see a prompt with two options:
'Recalculate all' - Instantly refreshes re-order recommendations for all products.
Recalculate a single product - If Actual forward cover differs from Ideal forward cover by more than 20%, the cell highlights red, flagging the PO recommendation requires recalculation. Select to recalculate one week or all future weeks.
*Re-calculating only impacts the Purchase order recommended units to reflect updated data.
This provides clear visibility into when updates may influence your recommendations, while giving you full control over when recalculations are applied.
Forecast metrics in Rollups
Product forecast metrics can be viewed in Rollups to give a summary across your product attributes or business channels. All forecasted metrics can be searched via the Rollups field picker and display (forecast) at the end.
🔎 FAQs
How far along can I do my forecast?
How far along can I do my forecast?
Up to 52 weeks into the future
What happens if I don't have stock history for a period of time?
What happens if I don't have stock history for a period of time?
Your forecasted sales data will be based on sales units before returns (which may include out-of-stock weeks) and not the true rate of sales (which exclude out of stock weeks).
How's the return rate % last 12 weeks (units) metric calculated?
How's the return rate % last 12 weeks (units) metric calculated?
This metric is calculated using the last 12 completed rolling weeks at the size level. Product-level return rates are then derived as the average of all associated sizes.
Questions or feedback? Feel free to reach out to our in-app chat for assistance! 😉




















