Amazon FBA Stranded Inventory Report
Learn more about Amazon FBA Stranded Inventory, and how to avoid it or fix the issues.
primary-action
Action needed to bring your inventory out of stranded status. The possible actions are:
Relist: For products that have been listed previously but do not have an active offer, click Add a Product in the Inventory drop-down menu to create an offer. If you see a message indicating that your product is already listed but needs to be edited, click the provided link to update your listing.
Create removal order: For products you no longer want to sell, go to the Manage FBA Inventory page, select the product, and choose Create Removal Order from the drop-down menu on top.
Change to Fulfilled by Amazon: If you have an offer, but it is for a product that you fulfill yourself, none of your FBA inventory for that product will be available for sale. On your Manage Inventory page, select the product and click Change to Fulfilled by Amazon in the Action drop-down menu to enable FBA to pick, pack, and ship those products.
Create a new listing: If you have FBA inventory of a product that has never been listed, create a listing for your SKU by clicking Add a Product in the Inventory drop-down menu.
date-stranded
This date shows how long your inventory has been stranded and without an active offer.
date-classified-as-unsellable
This is the date when the inventory will be classified as unsellable unless the offer is made buyable. You are required to remove unsellable units (which are “Unsuitable Units” as defined in the Amazon Services Business Solutions Agreement) as described in our Required removals policy.
status-primary
Identifies whether the offer is active, inactive, or incomplete. Incomplete offers are those missing price or condition.
status-secondary
For inactive offers, this field identifies the reasons — for example, blocked or out of stock.
error-message
For select inactive offers, additional information is displayed here — for example, quality alerts.
asin
Unique blocks of 10 letters or numbers that Amazon assigns to identify products. You can find the ASIN on the product details page.
sku
Unique blocks of letters or numbers that you assign to identify your products
fnsku
Unique identifiers that Amazon assigns to items stored in and fulfilled from a fulfillment center
product-name
The title of your product
condition
The condition of your product
fulfilled-by
Indicates whether the product is listed for fulfillment by Amazon or by you.
fulfillable-quantity
The number of units of a SKU that you have in Amazon fulfillment centers and that can be picked, packed, and shipped
your-price
Your current selling price
unfulfillable-qtyThe number of units of a SKU that you have in Amazon fulfillment centers and that are in unsellable condition
reserved-quantity
The number of units of a SKU that you have in Amazon fulfillment centers and that are currently being picked, packed, and shipped or that are sidelined for measurement, sampling, or other internal processes
inbound-shipped-qty
The number of units of a SKU that you have shipped to Amazon and that are in transit
Take the next step.
Add the Hopted browser extension to Google Sheets.
Add Hopted to Google Sheets