Skip to main content

Excess Inventory Alert

How the Excess Inventory alert calculates excess units and the Est. Cost Impact of each recommended action

Written by Shelby Rothenberg

The Excess Inventory alert flags products where you're holding more fulfillable inventory than you need based on your restock settings and recent demand. You'll find it under Inventory > Opportunities > Excess Inventory.

How excess units are calculated

Kapoq estimates excess units by comparing your fulfillable inventory to how much you need to cover your restock cycle:

Fulfillable Inventory − (Lead Time + Reorder Frequency + Safety Stock) × Weekly Demand

Lead time, reorder frequency and safety stock come from your restock settings, so adjusting those settings will change how many units are flagged as excess.

The table also shows AWD on hand quantity, FBA on hand, Actual DOC (days of cover), Sell Through Rate and Estimated Units in Excess so you can see the context behind each alert. Sell Through Rate is your FBA rolling 90-day sell-through rate: the number of units sold and shipped over the past 90 days divided by the average number of units available at fulfillment centers during that time.

Recommended actions

Each product has an Actions dropdown with three recommended actions, each showing an Est. Cost Impact. Select an action to see the calculation behind it.

Create Sale / Promotion

Estimates the Est. Cost Impact of moving excess units through a sale or promotion.

Calculation: Excess Units × Average Price × 0.1

For example, 3,241 excess units at an average price of $24.87 gives an Est. Cost Impact of $8,060.

Create Removal Order

Estimates the Est. Cost Impact of removing excess units from Amazon's fulfillment centers. Removal orders are created in Seller Central, not in Kapoq.

Calculation: Excess Units × Removal Cost Per Unit

For example, 3,241 excess units at a removal cost of $0.25 per unit gives an Est. Cost Impact of $810. Removal cost per unit varies by product.

Do Nothing

Leaves the inventory as is, with an Est. Cost Impact of $0. This gives you a baseline to compare the other two actions against.

Monthly Financial Impact

The Monthly Financial Impact column shows the highest Est. Cost Impact across the recommended actions for that product, so you can sort to see where acting on excess inventory could matter most.

Snoozing or ignoring an alert

If you don't want to act on an alert right now, you can snooze it for 7 or 30 days, or ignore it entirely. Use the Show Snoozed/Ignored toggle at the top of the table to see those products again.

Did this answer your question?