Weekly Out of Stock Analysis by Item (117)
- Amy Midkiff (Unlicensed)
- Daniel Fitzpatrick (Unlicensed)
Overview
The Weekly Out of Stock Analysis Report is a handy report that allows you to quickly determine where and when out of stocks are becoming an issue. The report displays the number of stores that are out of stock for each SKU, by week. If you pull multiple weeks worth of data, there is a column for each week, and problem areas are color-coded in red or yellow (denoting severity), allowing you to quickly see which SKUs are having notable issues, as well as easily see whether the out of stock issue is getting better or worse with time. Drilling down into a cell brings up the Year-Over-Year Sales & Inventory by Store/Item/Week report (102). This allows you to see all inventory statistics for every store for the given item, and you can quickly filter to the out of stock stores to pinpoint the exact outages.
Video Tutorial
In this video, you will learn:
- How to locate the report
- How to run the report
How to drill down into the report data
Default Columns In This Report
- Item #
- Description
- Client
- Week (one column for each week requested)
Column Definitions
Many of the column names are common between reports. We also use abbreviations to save space. To learn about the meaning of a specific column click on the link below for the glossary of column terms.