Use this report to see which items are stockouts or will be soon, when the expected stockout will start and end, and how much lost revenue can be attributed to each stockout.
Before you start
- Managing Cin7 Core Reports
- This is a Cin7 ForesightAI report and requires an add-on to your subscription.
- ForesightAI reports require at least 6 months of sales history in Cin7 Core.
Report options
| Layout | Set to the default layout or select from a saved layout. |
|---|---|
| Save layout as | Save a layout for potential future use. |
| Reset layout | Resets layout to the default layout or selected saved layout. |
Select Apply filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing Cin7 Core Reports - Filtering Reports for more detailed information about using filters.
Export report data to Excel, PDF, or RTF.
Report fields
The following fields are available for this report. Open the Configure Layout menu to view all available fields.
Fields
| SKU | Product SKU |
|---|---|
| Product | The name of the product |
| Brand | Product brand |
| Category | Product category |
| Family | Product family name |
| Location | Location name |
| Supplier | Supplier associated with this product |
| Stockout from | The starting date of a stockout. Can be in the past (already occurring) or future (expected to start). |
| Stockout to | Expected date of end of the stockout, based on supplier lead and delivery times. |
| Days in stockout | How many days you are in stockout (Stockout to - Stockout from). |
| Demand segment | Winners are top sellers which generate the most revenue, chasers are still in demand products, losers are products that are rarely sold. It is very important to avoid stockouts for winners. |
Data headers
| Lost sales | Quantity not sold due to stockout according to sales forecasts |
|---|---|
| Lost revenue | Missed revenue due to stockout according to sales forecasts |
| Lost margin | Missed margin due to stockout according to sales forecasts |