Inventory Health Report

Aged inventory brackets, days of supply, sell-through rate, restock recommendations, and estimated storage costs per SKU.

Use cases to connect google sheets to amazon and ecommerce

4.8 Rating · 11k+ Downloads · Trusted by Sellers

Encased
Pet Lovers
Vahdam Teas
Boldify
Viva Naturals
Hyperzon
Ridgeline Insights
Lovebug Probiotics
Encased
Pet Lovers
Vahdam Teas
Boldify
Viva Naturals
Hyperzon
Ridgeline Insights
Lovebug Probiotics
Last updated -
June 12, 2026

What This Report Covers

✅ The Inventory Health report returns Amazon's full inventory planning dataset per SKU, including aged inventory brackets, days of supply, sell-through rate, and inventory health status.

✅ Estimated aged inventory surcharges are included by day bracket so you can see exactly which SKUs are approaching fee thresholds before the charge hits.

✅ Amazon's restock recommendations, recommended ship-in quantity, and recommended ship-in date are included so you can act on restocking signals directly from the data.

The Amazon FBA Inventory Health report returns Amazon's full inventory planning dataset for each SKU. It covers aged inventory by day bracket, days of supply, sell-through rate, restock recommendations, estimated storage costs, and aged inventory surcharge projections in a single report.

Supported Fields

|Report Name|API|Field Name|Description| |---|---|---|---| |Inventory Health|Reports API|marketplace|Amazon marketplace for the inventory health row| |Inventory Health|Reports API|sku|Seller SKU for the inventory item| |Inventory Health|Reports API|asin|Amazon product identifier for the inventory item| |Inventory Health|Reports API|snapshot-date|Date Amazon captured the inventory health snapshot| |Inventory Health|Reports API|product-name|Product title or product name in the inventory health report| |Inventory Health|Reports API|condition|Condition of the inventory item| |Inventory Health|Reports API|available|Units available for sale| |Inventory Health|Reports API|pending-removal-quantity|Units currently pending removal| |Inventory Health|Reports API|inv-age-0-to-90-days|Units aged 0 to 90 days in FBA| |Inventory Health|Reports API|inv-age-91-to-180-days|Units aged 91 to 180 days in FBA| |Inventory Health|Reports API|inv-age-181-to-270-days|Units aged 181 to 270 days in FBA| |Inventory Health|Reports API|inv-age-271-to-365-days|Units aged 271 to 365 days in FBA| |Inventory Health|Reports API|currency|Currency used for price, fee, and savings values| |Inventory Health|Reports API|alert|Inventory health alert returned by Amazon| |Inventory Health|Reports API|your-price|Your current item price| |Inventory Health|Reports API|sales-price|Current sale price when Amazon returns one| |Inventory Health|Reports API|lowest-price-new-plus-shipping|Lowest new offer price plus shipping| |Inventory Health|Reports API|lowest-price-used|Lowest used offer price| |Inventory Health|Reports API|recommended-action|Recommended action Amazon suggests for the inventory item| |Inventory Health|Reports API|fba-minimum-inventory-level|Amazon's minimum recommended FBA inventory level| |Inventory Health|Reports API|fba-inventory-level-health-status|Amazon's health status for the SKU's FBA inventory level| |Inventory Health|Reports API|recommended-sales-price|Amazon's recommended sales price for the item| |Inventory Health|Reports API|recommended-sale-duration-days|Recommended number of days for a sales price or promotion| |Inventory Health|Reports API|recommended-removal-quantity|Recommended number of units to remove from FBA| |Inventory Health|Reports API|Recommended ship-in quantity|Recommended quantity to ship into FBA| |Inventory Health|Reports API|Recommended ship-in date|Recommended date to ship inventory into FBA| |Inventory Health|Reports API|estimated-cost-savings-of-recommended-actions|Estimated savings if recommended actions are taken| |Inventory Health|Reports API|sell-through|Sell-through rate for the SKU| |Inventory Health|Reports API|item-volume|Volume of the item| |Inventory Health|Reports API|volume-unit-measurement|Unit used for item volume| |Inventory Health|Reports API|storage-type|Storage type assigned to the inventory| |Inventory Health|Reports API|storage-volume|Storage volume used by the inventory| |Inventory Health|Reports API|product-group|Amazon product group for the item| |Inventory Health|Reports API|sales-rank|Sales rank returned for the product| |Inventory Health|Reports API|days-of-supply|Estimated days of supply available| |Inventory Health|Reports API|historical-days-of-supply|Historical days of supply metric returned by Amazon| |Inventory Health|Reports API|estimated-excess-quantity|Estimated excess units in FBA| |Inventory Health|Reports API|weeks-of-cover-t30|Weeks of cover based on the trailing 30-day period| |Inventory Health|Reports API|weeks-of-cover-t90|Weeks of cover based on the trailing 90-day period| |Inventory Health|Reports API|featuredoffer-price|Featured offer price returned by Amazon| |Inventory Health|Reports API|inv-age-0-to-30-days|Units aged 0 to 30 days in FBA| |Inventory Health|Reports API|inv-age-31-to-60-days|Units aged 31 to 60 days in FBA| |Inventory Health|Reports API|inv-age-61-to-90-days|Units aged 61 to 90 days in FBA| |Inventory Health|Reports API|inv-age-181-to-330-days|Units aged 181 to 330 days in FBA| |Inventory Health|Reports API|inv-age-331-to-365-days|Units aged 331 to 365 days in FBA| |Inventory Health|Reports API|estimated-storage-cost-next-month|Estimated storage cost for the next month| |Inventory Health|Reports API|inbound-quantity|Total inbound quantity| |Inventory Health|Reports API|inbound-working|Inbound quantity in working shipments| |Inventory Health|Reports API|inbound-shipped|Inbound quantity shipped to Amazon| |Inventory Health|Reports API|inbound-received|Inbound quantity received by Amazon| |Inventory Health|Reports API|quantity-to-be-charged-ais-181-210-days|Quantity expected to be charged aged inventory surcharge for 181 to 210 days| |Inventory Health|Reports API|estimated-ais-181-210-days|Estimated aged inventory surcharge for 181 to 210 days| |Inventory Health|Reports API|quantity-to-be-charged-ais-211-240-days|Quantity expected to be charged aged inventory surcharge for 211 to 240 days| |Inventory Health|Reports API|estimated-ais-211-240-days|Estimated aged inventory surcharge for 211 to 240 days| |Inventory Health|Reports API|quantity-to-be-charged-ais-241-270-days|Quantity expected to be charged aged inventory surcharge for 241 to 270 days| |Inventory Health|Reports API|estimated-ais-241-270-days|Estimated aged inventory surcharge for 241 to 270 days| |Inventory Health|Reports API|quantity-to-be-charged-ais-271-300-days|Quantity expected to be charged aged inventory surcharge for 271 to 300 days| |Inventory Health|Reports API|estimated-ais-271-300-days|Estimated aged inventory surcharge for 271 to 300 days| |Inventory Health|Reports API|quantity-to-be-charged-ais-301-330-days|Quantity expected to be charged aged inventory surcharge for 301 to 330 days| |Inventory Health|Reports API|estimated-ais-301-330-days|Estimated aged inventory surcharge for 301 to 330 days| |Inventory Health|Reports API|quantity-to-be-charged-ais-331-365-days|Quantity expected to be charged aged inventory surcharge for 331 to 365 days| |Inventory Health|Reports API|estimated-ais-331-365-days|Estimated aged inventory surcharge for 331 to 365 days| |Inventory Health|Reports API|exempted-from-Low-Inventory-Level-fee|Whether the SKU is exempt from the low inventory level fee| |Inventory Health|Reports API|long-term-historical-days-of-supply|Long-term historical days of supply metric| |Inventory Health|Reports API|Inventory-Supply-at-FBA|Inventory supply available at FBA|

What Sellers Use This For

Aged inventory surcharge forecasting. The quantity-to-be-charged-ais-* and estimated-ais-* fields by day bracket show exactly which SKUs are approaching or already in surcharge territory and what the projected cost is. Acting on this data before the charge date is how you avoid paying it.

Restock planning. Recommended ship-in quantity, Recommended ship-in date, and days-of-supply give you Amazon's own restocking signals per SKU. Pull these into a sheet to build a reorder calendar without manually checking each product.

Sell-through monitoring. sell-through, weeks-of-cover-t30, and weeks-of-cover-t90 show how quickly each SKU is moving relative to available stock. A low sell-through with high aged inventory is the signal to run a promotion or plan a removal before surcharges accumulate.

Storage cost projection. estimated-storage-cost-next-month gives you the forward-looking storage fee per SKU so you can factor it into margin calculations before the bill arrives.

How Gorilla ROI Pulls This Data

Gorilla ROI connects to the Amazon SP-API ReportsAPI using the GET_FBA_INVENTORY_PLANNING_DATA report type. Data updates automatically on a regular schedule. No csv exports. No manual downloads. The numbers are current the moment you open the sheet. Feed AI with our data to stay on top and ahead of your business.

For field definitions, see the Amazon Seller Data Supported article in our help center.

Other Reports and Supported Fields

| Report | What It Covers | Fields | |---|---|---| | [AWD Inbound Shipments](/amazon-seller-central-reports/awd-inbound-shipments/) | Shipment status, origin, destination, carrier, and received quantity per AWD inbound order | 26 | | [AWD Inbound Shipment Items](/amazon-seller-central-reports/awd-inbound-shipment-items/) | SKU, ASIN, package type, prep category, and dimensions for every item in an AWD inbound shipment | 16 | | [Business Report](/amazon-seller-central-reports/business-report/) | Sessions, page views, Buy Box percentage, unit session rate, and ordered product sales by SKU | 26 | | [Buy Box](/amazon-seller-central-reports/buy-box/) | Marketplace, competing offer count, and Buy Box winner status per SKU | 5 | | [Buy Box Offers](/amazon-seller-central-reports/buy-box-offers/) | Every competing offer per SKU with pricing, fulfillment method, seller feedback, and Buy Box status | 16 | | [Buy Box Winner Full](/amazon-seller-central-reports/buy-box-winner-full/) | The current Buy Box winning offer per SKU with pricing, fulfillment method, and seller detail | 15 | | [Category](/amazon-seller-central-reports/category/) | Full browse category path, top level category, and child category per SKU and ASIN | 6 | | [COGS](/amazon-seller-central-reports/cogs/) | Centralized cost of goods sold per SKU matched against Amazon sales and finance data | 4 | | [Competitive Price](/amazon-seller-central-reports/competitive-price/) | Amazon's competitive price per SKU by pricing model, condition, offer count, and landed price | 11 | | [Cost Dump](/amazon-seller-central-reports/cost-dump/) | Raw uploaded cost of goods per SKU with currency, the source behind all COGS calculations | 4 | | [Fees Estimate](/amazon-seller-central-reports/fees-estimate/) | Estimated and final Amazon fees per SKU broken down by FBA, referral, per-item, and variable closing fees | 16 | | [Finance](/amazon-seller-central-reports/finance/) | Every financial event posted to your account: shipments, refunds, fees, charges, and adjustments | 7 | | [Finance Total](/amazon-seller-central-reports/finance-total/) | Summed finance amounts filtered by marketplace, SKU, event type, and charge type | 6 | | [GrossProfit](/amazon-seller-central-reports/gross-profit/) | Calculated gross profit per SKU using Amazon finance amounts, fee data, and uploaded cost inputs | 4 | | [Inbound Shipments](/amazon-seller-central-reports/inboundship/) | FBA shipment name, ship-from address, destination fulfillment center, status, and prep requirements | 19 | | [Inbound Shipment Items](/amazon-seller-central-reports/inboundship-items/) | SKU, quantities shipped and received, fulfillment network SKU, and status per FBA inbound shipment | 9 | | [Inventory](/amazon-seller-central-reports/inventory/) | Total, fulfillable, reserved, inbound, unsellable, and future supply quantities per SKU | 19 | | [Inventory Health](/amazon-seller-central-reports/inventory-health/) | Aged inventory brackets, days of supply, sell-through rate, restock recommendations, and storage cost estimates | 65 | | [Inventory History](/amazon-seller-central-reports/inventory-history/) | Daily FBA inventory snapshots per SKU stored by Gorilla ROI for historical trending and stockout analysis | 21 | | [Inventory Ledger](/amazon-seller-central-reports/inventory-ledger/) | Starting and ending warehouse balances with every inventory movement: receipts, shipments, returns, and losses | 20 | | [Inventory OOS](/amazon-seller-central-reports/inventory-oos/) | Out-of-stock days and out-of-stock percentage per SKU calculated from stored inventory history | 5 | | [Inventory Received](/amazon-seller-central-reports/inventory-received/) | Received date, fulfillment center, FNSKU, and quantity received per FBA inbound receipt | 10 | | [Inventory Restock](/amazon-seller-central-reports/inventory-restock/) | Amazon's recommended replenishment quantity, ship date, days of supply, and restock alerts per SKU | 16 | | [Orders](/amazon-seller-central-reports/orders/) | Every order and order item with pricing, taxes, discounts, fulfillment channel, shipping address, and return quantity | 27 | | [Price](/amazon-seller-central-reports/price/) | Buy Box price, lowest price, and your price per SKU with listing price, shipping, and landed price broken out | 20 | | [Product](/amazon-seller-central-reports/product/) | Full catalog attributes per SKU: title, brand, dimensions, identifiers, keywords, variation details, and image URL | 46 | | [ProfitLoss](/amazon-seller-central-reports/profit-loss/) | Calculated profit or loss per SKU using Amazon sales, fees, charges, and uploaded cost of goods | 8 | | [ProfitLoss Orders](/amazon-seller-central-reports/profit-loss-orders/) | Order-level calculated profit or loss per order ID and SKU with sales, fees, charges, and COGS | 10 | | [ProfitLoss Total](/amazon-seller-central-reports/profit-loss-total/) | Total profit or loss for any selected period summed across marketplace, SKU, and ASIN filters | 8 | | [Ranking](/amazon-seller-central-reports/ranking/) | BSR by top-level category and child category per SKU and ASIN across all marketplaces | 5 | | [ReconcileRefunds](/amazon-seller-central-reports/reconcile-refunds/) | Original order quantity matched against returned quantity per order ID and SKU | 8 | | [Refund](/amazon-seller-central-reports/refund/) | Refund rate, units refunded, and total refund amount per SKU and ASIN | 6 | | [Refund Total](/amazon-seller-central-reports/refund-total/) | Total refund percentage, units refunded, and refund amount for a selected marketplace and period | 4 | | [Reimburse Details](/amazon-seller-central-reports/reimburse-details/) | Every FBA reimbursement with reason, condition, cash and inventory quantities, and total amount | 17 | | [Reimburse Inventory](/amazon-seller-central-reports/reimburse-inventory/) | Inventory adjustment events from the ledger with date, fulfillment center, quantity, reason, and disposition | 10 | | [Reimburse Replace](/amazon-seller-central-reports/reimburse-replace/) | Every FBA replacement shipment with reason code, fulfillment center, and original order ID | 9 | | [Reimburse Returns](/amazon-seller-central-reports/reimburse-returns/) | Every customer return with reason, disposition, status, fulfillment center, and customer comments | 14 | | [Removals](/amazon-seller-central-reports/removals/) | Amazon's recommended removal quantities per SKU split by sellable and unsellable age brackets | 14 | | [Removals Details](/amazon-seller-central-reports/removals-details/) | Every removal order line with status, quantities, disposition, removal fee, and last updated date | 16 | | [Sales](/amazon-seller-central-reports/sales/) | Sales amounts, unit counts, and order counts per SKU broken down by every Amazon order status | 33 | | [Sales Total](/amazon-seller-central-reports/sales-total/) | Summed sales amounts, unit counts, and order counts for any selected period and order status | 33 | | [Settlement](/amazon-seller-central-reports/settlement/) | Settlement ID, period dates, deposit date, and total amount per Amazon settlement payment | 6 | | [Settlement Details](/amazon-seller-central-reports/settlement-details/) | Every transaction line inside each settlement with amount type, description, order IDs, and posted date | 19 | | [Storage Fees](/amazon-seller-central-reports/storage-fees/) | Estimated monthly storage fee per ASIN with dimensions, weight, size tier, storage rate, and discount eligibility | 24 |

Frequently
Asked Questions

Black upward arrow on white background

How long does setup take?

Setup takes a few minutes. You connect your Amazon, Shopify, or Walmart account and choose the data you want in Google Sheets. After that, data loads and syncs automatically in the background going forward.

Black upward arrow on white background

How does it get data into Google Sheets?

Gorilla ROI connects directly to your ecommerce platforms and syncs structured data into Google Sheets automatically. Once connected, data stays available without re-downloading files.

Black upward arrow on white background

What platforms can I connect?

Gorilla ROI supports Amazon, Shopify, and Walmart. The focus is ecommerce operations rather than connecting dozens of unrelated platforms.

Black upward arrow on white background

Will my data stay accurate and update automatically?

Yes. Once connected, data syncs automatically based on your settings so Sheets stays current without manual exports or re-imports.

Black upward arrow on white background

Does the data match my platform?

Yes. Gorilla ROI pulls data directly from the source. What you see in your sheet matches what the platform API reports.

Black upward arrow on white background

Do I need coding or technical skills?

No. Gorilla ROI works through a point-and-click interface inside Google Sheets. Advanced users can use formulas if they want, but coding is not required.

Manual Exports Waste Your Team's Time

Replace the Manual Spreadsheet Work and Save 40 Hours a Month