How to Automatically Sync & Import the FBA Stranded Inventory Report to Google Sheets (The Hopted Way)

Using an Amazon to Google Sheets integration like Hopted, you set up the connection once, and your data flows automatically.

Step 1.

Install the Hopted browser extension and sign in using your Google Account.

Step 2.

Securely connect your Amazon Seller Central to Google Sheets using Hopted's integration wizard.

Step 3.

In Google Sheets, from the list of available Amazon Seller Central reports, select "Stranded Inventory".

Step 4.

Select columns that you need: asin, sku, product-name, fulfillable-quantity, stranded-reason, date-stranded, and estimated-storage-cost.

Step 5.

Set your schedule. Choose how often you want to export and refresh your stranded status—we recommend a Dailyschedule. Stranded inventory negatively impacts your IPI score every single day it sits there.

Step 6.

Save your data pipeline. This will export your stranded alerts from Seller Central into spreadsheets instead of dealing with CSVs. Your listing health dashboard will be up to date forever.

What is the Amazon FBA Stranded Inventory Report?

This report lists inventory that is physically present in an Amazon Fulfillment Center but does not have an active offer on Amazon. Unlike "Unfulfillable" inventory (which is damaged), Stranded Inventory is usually in perfect condition—it just lacks the digital "link" to a live product page.

Common causes include pricing errors (Amazon thinks your price is too high/low), missing listing attributes, suppressed listings, or accidentally deleting a SKU from your Manage Inventory page while stock was still at the warehouse.

This makes it the single source of truth for answering questions like:

• Which 10 ASINs are racking up storage fees but generating zero sales?

• Is my best-seller offline because of a "Pricing Error"?

• How much potential revenue is currently sitting in "Limbo"?

• Which items are about to be automatically disposed of by Amazon due to inactivity?

• Did a bulk upload accidentally convert my FBA listings to Merchant Fulfilled (stranded the FBA stock)?

How to Analyze & Track Your Stranded Inventory in Spreadsheets

Now that you have a live feed, you can move from data entry to data analysis. This is the real power of analyzing your Amazon Seller Central data in spreadsheets and building your Amazon excel-like template.

Here are 3 Amazon spreadsheet template ideas you can build immediately:

Template 1: The "Revenue Rescue" Prioritizer

ou likely have multiple stranded items. Fix the most expensive ones first.

How to build it:

• Formula: Create a column Potential Revenue = fulfillable-quantity * [Your Retail Price]. (Note: You may need to VLOOKUPthe price from your catalog sheet).

• Sort: Descending by Potential Revenue.

• What it shows you: You might see that while you have 50 different stranded SKUs, the top 3 represent €5,000 in frozen revenue. Fix those three before you even look at the rest.

Template 2: The "Root Cause" Analyzer

Fixing stranded inventory is often about fixing a process. This recipe groups errors so you can bulk-fix them.

How to build it:

• Pivot Table Rows: stranded-reason.

• Pivot Table Values: COUNT of sku and SUM of fulfillable-quantity.

• What it shows you: If 80% of your stranded inventory shows the reason "Merchant Fulfilled", you know you have a systematic error in your inventory loader files that is flipping FBA SKUs to FBM. You can fix the file template and solve 80% of the problems at once.

Template 3: The "Disposal Countdown"

Amazon will automatically remove (dispose or return) stranded inventory after a set period (usually 30-45 days) if you don't fix it.

How to build it:

• Formula: =DAYS(TODAY(), date-stranded)

• Conditional Formatting: Highlight cells where the result is > 25 in Red.

• What it shows you: The "Danger Zone." These items have been stranded for nearly a month. If you don't fix the listing or create a removal order now, Amazon might dispose of them, costing you the cost of goods + disposal fees.

Common workflows this report unlocks

• IPI Score Protection: Stranded inventory counts against your Inventory Performance Index. Clearing this report daily is one of the fastest ways to boost your IPI.

• Listing Reactivation: Quickly identify "Listing Error" vs. "Pricing Error" to assign the fix to the right team member (Catalog team vs. Pricing strategy).

• Prevention of Auto-Removal: Catch items before they hit the 30-day mandatory removal window.

• Catalog Hygiene: Identify "Ghost SKUs" that you deleted from your catalog but forgot to remove physically from the warehouse.

FAQ about Amazon FBA Stranded Inventory

Q: What is the difference between "Stranded" and "Unfulfillable"?

• Stranded: The item is in good condition (Sellable), but the Listing is broken. You fix this by editing the listing in Seller Central.

• Unfulfillable: The item is physically damaged or expired. You cannot sell it. You fix this by creating a Removal Order.

Q: Does Stranded Inventory affect my IPI score? Yes, heavily. Stranded inventory consumes storage limits and incurs fees without generating sales velocity. It is "dead weight" in the eyes of the IPI algorithm. Fixing it is a priority for maintaining your storage limits.

Q: Why does my inventory say "Merchant Fulfilled" in the stranded reason? This happens when you convert a listing from "Amazon Fulfilled" to "Merchant Fulfilled" (FBM) while you still have FBA stock in the warehouse. The FBA stock becomes stranded because it no longer has an active FBA offer to attach to.

Q: What happens if I ignore Stranded Inventory? Amazon has an "Automatic Action" setting. Typically, after 30 to 45 days of being stranded, Amazon will automatically classify the inventory as unsellable and may dispose of it or ship it back to you at your expense, depending on your settings.

Q: How is Hopted different from other Amazon seller software? Most Amazon tools force you into their rigid dashboards and pre-built reports. You have to change your workflow to fit their software. With Hopted it is the opposite. It’s a flexible data automation layer that works directly inside your existing spreadsheets (like Google Sheets). Instead of forcing you to learn a new system, Hopted brings all your scattered Amazon data (sales, inventory, orders, etc.) right to you. You can build the fully custom reports and automations you need, not the ones a rigid tool dictates.