Industry Use Cases

Amazon FBA Stranded vs Reserved Inventory: How to Find the Cause

Two SKUs show zero available. One needs a listing fix. The other is tied up in fulfillment-center transfer. If both go on the same replenishment list, you can end up buying stock when the stock is already there.

Check Fix Stranded Inventory and Reserved Inventory alongside the current inventory view. Use aligned report dates and item identifiers to route listing problems and reserved inventory to the right follow-up.

Start with the next action for each SKU

These three SKUs show zero in the available-quantity field of the same synthetic snapshot. That field does not establish whether customers can place an order: Amazon notes that FC-transfer units can remain available for sale with a later ship date. Check the live offer and delivery promise separately.

Seller SKU / FNSKUStranded evidenceReserved reasonNext check
MUG-B / X00112 units, no active offerNone shownReview listing status
MUG-W / X002None shown18 in FC transferCheck transfer aging
TRAY-A / X003None shown6 customer ordersReview order commitments

MUG-B needs a listing review. MUG-W needs a transfer-status review. TRAY-A is accounted for by existing demand. A total of zero available is the start of the investigation.

Align the reports

Keep seller SKU, FNSKU, condition, marketplace and snapshot date where available. Retain the recorded reason instead of assigning a reason from quantity alone. If the Reports view and Inventory view were run at different times, refresh or document that gap.

Route, then reconcile only within comparable scopes

Flag stranded line items for listing review and reserved quantities by reason. Use ledger movements to investigate long-running cases. Avoid summing report columns unless Amazon’s definitions and the reporting scope confirm they are mutually exclusive.

Decide which SKUs need attention before you reorder

Keep the SKU and FNSKU mapping with the listing status and quantity evidence.

For zero-available SKUs, show which have a stranded listing, which are reserved by reason, and which remain unexplained. Cite the source rows and the snapshot date.

Confirm listing status before changing the offer. Confirm current inventory state before placing a replenishment order.

Amazon stranded inventory guidance · Amazon’s explanation of reserved inventory

The figures and identifiers in this example are synthetic. The displayed arithmetic was checked independently. A live Jolene.pro result could not be verified.

Try this with your own spreadsheet at Jolene.pro. Follow Jolene.pro on LinkedIn for more spreadsheet guides.

For more checked examples, see Jolene.pro Workbook Studies.

Related checks: Amazon FBA Shipment Closed but Units Are Missing: What to Check.

1 comment

Leave a comment