> ## Documentation Index
> Fetch the complete documentation index at: https://help.jetpack3pl.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Out of Stock Inventory with Exception Orders Report

> Monitor out-of-stock SKUs, identify unfulfillable exception orders, and track incoming inventory replenishment through WROs.

<div className="page-intro">
  When SKUs run out of stock, orders that depend on that inventory enter the Exception status and cannot be fulfilled until inventory is replenished. The Out of Stock Inventory with Exception Orders report gives you a centralized view of which SKUs are causing order exceptions, how many orders are affected, and which incoming WROs will resolve the shortages—helping you quickly prioritize replenishment and clear your exception queue.
</div>

## Report Overview

The Out of Stock Inventory with Exception Orders report refreshes once daily at **10:00 am UTC**. The dashboard displays the date and time of the last refresh at the top of the page.

Use this report to quickly resolve issues with orders stuck in the Exception status due to out-of-stock SKUs. By identifying which products need replenishment and tracking inbound WROs, you can prioritize inventory restocking and minimize order delays.

<Info title="What Are Exception Orders?">
  Orders enter the Exception status when they cannot be fulfilled due to issues like unavailable inventory. When a SKU is out of stock and an order requires that product, the order remains in Exception status until the inventory is replenished or the order is modified.
</Info>

***

## Available Sub-Reports

The Out of Stock Inventory with Exception Orders page provides five distinct sub-reports, each offering a different view of your inventory shortages and affected orders:

| Sub-Report                                                 | Purpose                                                                                |
| ---------------------------------------------------------- | -------------------------------------------------------------------------------------- |
| **Out of Stock Inventory with Exception Orders - Summary** | High-level overview of total exception orders and SKU replenishment status             |
| **Inventory and Exception Orders**                         | Detailed SKU-level view of shortages, exception orders, and expected restock timelines |
| **On-Hand Quantity across Fulfillment Centers**            | Distribution of available inventory across Jetpack fulfillment centers                 |
| **Incoming WRO**                                           | All WROs created to restock out-of-stock SKUs                                          |
| **Exception Orders**                                       | Individual orders stuck in Exception status due to out-of-stock SKUs                   |

***

## Out of Stock Inventory with Exception Orders - Summary

This sub-report provides a high-level snapshot of your out-of-stock situation and helps you understand how many SKUs have sufficient incoming inventory versus those that need additional replenishment.

<img src="https://mintcdn.com/jetpack/UH2x7zIe4mu_eyhk/images/analytics-reporting/oos-summary-overview.png?fit=max&auto=format&n=UH2x7zIe4mu_eyhk&q=85&s=2be584d0d7fe7db1436fce53cc80b5af" alt="Out of Stock Summary showing exception order counts and SKU replenishment status" className="screenshot" width="800" height="124" data-path="images/analytics-reporting/oos-summary-overview.png" />

The summary displays four key metrics:

| Metric                                            | What It Shows                                                                                                                                                                        |
| ------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Total Exception Order Count**                   | The number of orders currently in the Exception status due to SKUs being out of stock                                                                                                |
| **SKU with Incoming Quantity > Exception Count**  | The number of out-of-stock SKUs with inbound WROs containing enough inventory to resolve all orders in the Exception status (once the inventory is stored from inbound WROs)         |
| **SKU with Incoming Quantity \< Exception Count** | The number of out-of-stock SKUs with inbound WROs that will not have enough inventory to resolve all orders in the Exception status (once the inventory is stored from inbound WROs) |
| **SKU with No WRO Incoming**                      | The number of SKUs that are out of stock without any WROs inbound to replenish the SKU                                                                                               |

Use this summary to prioritize which SKUs need immediate attention—particularly those with no incoming WROs or insufficient incoming quantity to clear the exception queue.

***

## Inventory and Exception Orders

This sub-report provides detailed, SKU-level insight into inventory shortages, ongoing exception orders, and expected restock timelines based on created WROs.

<img src="https://mintcdn.com/jetpack/UH2x7zIe4mu_eyhk/images/analytics-reporting/oos-inventory-exception-orders.png?fit=max&auto=format&n=UH2x7zIe4mu_eyhk&q=85&s=0ff40d43da374fc3238fb4eb238774fd" alt="Inventory and Exception Orders table showing SKU details and WRO replenishment data" className="screenshot" width="1414" height="455" data-path="images/analytics-reporting/oos-inventory-exception-orders.png" />

### Column Definitions

| Column                             | What It Shows                                                                                                                                |
| ---------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------- |
| **Fulfillable On Hand Quantity**   | Quantity of a SKU currently available across all fulfillment centers (which includes units assigned to orders but not yet picked for orders) |
| **Orders in Last 30 Days**         | The total number of orders placed for the SKU in the last 30 days                                                                            |
| **Exception Orders**               | The total number of orders that could not be fulfilled because the SKU was out of stock at the time of order creation                        |
| **Quantity in Exception Orders**   | Total number of units included in orders in the Exception status                                                                             |
| **Total Incoming WRO Count**       | Total number of WROs created to replenish the SKU                                                                                            |
| **Total Incoming Quantity**        | Total number of units expected via the incoming WROs                                                                                         |
| **Total Incoming Filled Quantity** | The total number of units that have already arrived via WROs                                                                                 |

This view helps you compare current demand (exception orders) against incoming supply (WRO quantity) to identify which SKUs need additional replenishment beyond what's already in transit.

***

## On-Hand Quantity across Fulfillment Centers

This sub-report shows how your available inventory is distributed across various Jetpack fulfillment centers for each SKU.

<img src="https://mintcdn.com/jetpack/UH2x7zIe4mu_eyhk/images/analytics-reporting/oos-fc-distribution.png?fit=max&auto=format&n=UH2x7zIe4mu_eyhk&q=85&s=c70b0679a76269c14360db78005676f8" alt="On-Hand Quantity table showing inventory distribution across fulfillment centers" className="screenshot" width="1414" height="332" data-path="images/analytics-reporting/oos-fc-distribution.png" />

Use this view to understand which fulfillment centers have stock available and which locations are completely out. This information is particularly useful when determining where to send replenishment WROs or when considering [internal inventory transfers](/fulfillment/managing-inventory/inventory-transfers-page) to balance stock across your network.

***

## Incoming WRO

This sub-report displays all Warehouse Receiving Orders created to restock SKUs that are out of stock or causing orders to be in the Exception status.

<img src="https://mintcdn.com/jetpack/UH2x7zIe4mu_eyhk/images/analytics-reporting/oos-incoming-wro.png?fit=max&auto=format&n=UH2x7zIe4mu_eyhk&q=85&s=41f41da29233a221a3d4894fa3eb069c" alt="Incoming WRO table showing replenishment orders in progress" className="screenshot" width="1414" height="459" data-path="images/analytics-reporting/oos-incoming-wro.png" />

Review this table to track the status of your replenishment shipments and estimated arrival times. You can cross-reference WRO IDs with the [Managing Your Warehouse Receiving Orders](/fulfillment/sending-inventory/managing-wro) page for detailed tracking and status updates.

***

## Exception Orders

This sub-report lists individual orders stuck in the Exception status due to one or more required products being out of stock, along with the specific SKUs causing the status.

<img src="https://mintcdn.com/jetpack/UH2x7zIe4mu_eyhk/images/analytics-reporting/oos-exception-orders-list.png?fit=max&auto=format&n=UH2x7zIe4mu_eyhk&q=85&s=f0702d5851e2c3be04a04bc11dbe5c52" alt="Exception Orders table showing affected orders and out-of-stock SKUs" className="screenshot" width="1414" height="252" data-path="images/analytics-reporting/oos-exception-orders-list.png" />

### Column Definitions

| Column                           | What It Shows                                                                                                          |
| -------------------------------- | ---------------------------------------------------------------------------------------------------------------------- |
| **Order Quantity**               | Number of units ordered                                                                                                |
| **Quantity in Exception**        | Number of uncommitted units in the order                                                                               |
| **Fulfillable On-Hand Quantity** | The total units available across fulfillment centers, including units assigned to orders but not yet picked for orders |

Use this view to identify which specific orders are waiting for replenishment and prioritize resolution based on order age, customer importance, or order value.

***

## Filtering the Report

You can refine the data across all sub-reports using four filter options to focus on specific products, inventory conditions, or replenishment scenarios.

### By Product / SKU / Inventory ID

Use the dropdown or search bar to select specific products. By default, all products are shown.

<img src="https://mintcdn.com/jetpack/UH2x7zIe4mu_eyhk/images/analytics-reporting/oos-filter-product.png?fit=max&auto=format&n=UH2x7zIe4mu_eyhk&q=85&s=950a05e5ab2051d344e6a495a8ae10f2" alt="Product filter dropdown for selecting specific SKUs" className="screenshot" width="1521" height="554" data-path="images/analytics-reporting/oos-filter-product.png" />

### By Inventory Status

Use the dropdown to filter by stock availability:

| Filter Option    | What It Shows                                                                                           |
| ---------------- | ------------------------------------------------------------------------------------------------------- |
| **Out of Stock** | All SKUs with 0 units On-Hand (based on the Inventory Status page). This option is selected by default. |
| **In Stock**     | All SKUs with at least 1 unit On-Hand (based on the Inventory Status page)                              |
| **Select all**   | Both Out of Stock and In Stock SKUs                                                                     |

<img src="https://mintcdn.com/jetpack/UH2x7zIe4mu_eyhk/images/analytics-reporting/oos-filter-inventory-status.png?fit=max&auto=format&n=UH2x7zIe4mu_eyhk&q=85&s=a0a033315f751463c75d977d03db277e" alt="Inventory Status filter dropdown" className="screenshot" width="413" height="211" data-path="images/analytics-reporting/oos-filter-inventory-status.png" />

### By Exception Status

Use the dropdown to filter based on whether SKUs are associated with exception orders:

| Filter Option              | What It Shows                                                                                        |
| -------------------------- | ---------------------------------------------------------------------------------------------------- |
| **Orders in Exception**    | SKUs associated with at least one order in the Exception status. This option is selected by default. |
| **No Orders in Exception** | SKUs that are currently not linked to any exception orders                                           |

<img src="https://mintcdn.com/jetpack/UH2x7zIe4mu_eyhk/images/analytics-reporting/oos-filter-exception-status.png?fit=max&auto=format&n=UH2x7zIe4mu_eyhk&q=85&s=bea57e5e15018d358d28f3e62919cfef" alt="Exception Status filter dropdown" className="screenshot" width="509" height="251" data-path="images/analytics-reporting/oos-filter-exception-status.png" />

### By WRO Status

Use the dropdown to filter SKUs based on their replenishment status:

| Filter Option                                  | What It Shows                                                                                                                                                                                                         |
| ---------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Incoming Quantity \< Quantity in Exception** | SKUs that have a WRO in route to a Jetpack fulfillment center, with the WRO containing a quantity less than the total quantity needed to fulfill all orders in the Exception status                                   |
| **Incoming Quantity ≥ Quantity in Exception**  | SKUs that have a WRO in route to a Jetpack fulfillment center, with the WRO containing enough inventory to fulfill all orders in the Exception status (or exceeds the inventory required to fulfill Exception orders) |
| **No Incoming WRO**                            | SKUs that do not have WROs in progress                                                                                                                                                                                |

<img src="https://mintcdn.com/jetpack/UH2x7zIe4mu_eyhk/images/analytics-reporting/oos-filter-wro-status.png?fit=max&auto=format&n=UH2x7zIe4mu_eyhk&q=85&s=3d29572ddd46f4bc1b481706f58193c4" alt="WRO Status filter dropdown" className="screenshot" width="517" height="294" data-path="images/analytics-reporting/oos-filter-wro-status.png" />

***

## Exporting Sub-Reports

You can export any sub-report on this page to analyze data offline or share with your team.

<Steps>
  <Step title="Hover over the table you want to export">
    Locate the sub-report table you want to export and hover your cursor over it.
  </Step>

  <Step title="Click the three-dot menu">
    Click the three-dot menu (•••) at the top-right corner of the table. Additional menu options will appear.

    <img src="https://mintcdn.com/jetpack/UH2x7zIe4mu_eyhk/images/analytics-reporting/oos-export-menu.png?fit=max&auto=format&n=UH2x7zIe4mu_eyhk&q=85&s=13e8c0a94379ac4ebf7ffb4d6a831e58" alt="Three-dot menu showing export options" className="screenshot" width="1348" height="440" data-path="images/analytics-reporting/oos-export-menu.png" />
  </Step>

  <Step title="Select Export data and choose format">
    Click **Export data** from the menu, then choose your preferred export format:

    * **Current Layout** - Exports the table exactly as displayed with current filters applied
    * **Summary Data** - Exports a condensed version of the data

    <img src="https://mintcdn.com/jetpack/UH2x7zIe4mu_eyhk/images/analytics-reporting/oos-export-format.png?fit=max&auto=format&n=UH2x7zIe4mu_eyhk&q=85&s=2d5f4b99c8f00a3bbbf7ddb6a751bb5e" alt="Export format selection showing Current Layout and Summary Data options" className="screenshot" width="1045" height="454" data-path="images/analytics-reporting/oos-export-format.png" />
  </Step>

  <Step title="Click Export to download">
    Click **Export** to download the file. A progress bar will appear, and once completed, the file will automatically download to your computer.
  </Step>
</Steps>

***

## Let's Dive Deeper

<CardGroup cols={3}>
  <Card title="About Jetpack Reports" icon="chart-mixed" href="/fulfillment/analytics-reporting">
    Overview of all available reports and analytics tools
  </Card>

  <Card title="Inventory Status Page" icon="boxes-stacked" href="/fulfillment/managing-inventory/inventory-status-page">
    View real-time inventory levels and availability
  </Card>

  <Card title="Managing Your WROs" icon="clipboard-list" href="/fulfillment/sending-inventory/managing-wro">
    Track inbound replenishment shipments
  </Card>

  <Card title="Creating a WRO" icon="truck-ramp-box" href="/fulfillment/sending-inventory/creating-wro">
    Create new replenishment shipments to restock out-of-stock SKUs
  </Card>

  <Card title="Managing Replenishment Schedules" icon="calendar-check" href="/fulfillment/sending-inventory/managing-replenishment-schedules">
    Plan and optimize inventory replenishment
  </Card>

  <Card title="Order Status Overview" icon="list-check" href="/fulfillment/d2c/order-status">
    Understand order statuses including Exception status
  </Card>
</CardGroup>

<div className="jetpack-callout">
  <img src="https://mintcdn.com/jetpack/2iejPNBTYKEx6ntF/images/jetpack-logomark-256.png?fit=max&auto=format&n=2iejPNBTYKEx6ntF&q=85&s=340604ced4add3864f2641341826e1c9" alt="Jetpack" className="jetpack-callout-icon" width="256" height="256" data-path="images/jetpack-logomark-256.png" />

  <div className="jetpack-callout-content">
    <h4 className="jetpack-callout-title">Questions? Contact Jetpack Care.</h4>
    <p className="jetpack-callout-text">If you have any questions or run into issues, you can always contact Jetpack Care for help. Our team is always here to assist via Slack, phone, or email!</p>
  </div>
</div>
