Data for the forecasting report is available from February 2023. This is a new report and won't show historic data prior to this date.
The forecasting report summarises the closing count, total items sold per day, sell through rate and day's cover. You can use this report to:
Discover top selling products throughout the year
Predict when a product might sell out so you can order ahead
Predict the cost of new stock orders
By default, the forecasting report shows data for all products based on sales in the last 30 days, sorted alphabetically (A-Z).
To view information on a specific tag, brand, supplier, category or subcategory, this can be requested in the search bar. You must use the search for the tag and use a colon before starting your search, e.g. 'brand: Marc Darcy'.
Tap All stores to filter by a specific store. Select either a pre-defined or custom date range to filter the report. The Name and Supplier within the table are sortable. The report displays the following information:
Name - Product name and variant
Supplier - Supplier assigned to the product
Closing count - Stock level at the end of the selected date range
Total sold - Total sold in the selected date range
Sold per day - Total sold in the selected date range ÷ The number of days in the selected date range
Sell through rate - Total number sold ÷ { Total number sold + Closing count }
Day's cover - Closing count ÷ Sold per day
Inventory cost - Cost of goods × Closing count
Retail value - Retail price × Closing count
Export report
Tap then Export to export all products within the filtered report. For example, if the report shows sales by product and sorted by total sold, a list of all products within the specified date range ordered by total sold (ascending to decending) will be exported.