How long has your FBA inventory been sitting in Amazon warehouses?

Q: What database does this query work with?

This query is designed for Amazon Seller Central. Taptic Data reads your live schema, so the generated SQL always matches your actual table and column names.

Amazon charges long-term storage fees on units sitting in FBA for over 181 days, and surcharges on units over 365 days. This query shows your inventory age distribution by SKU so you can act before the fees hit.

📊 Amazon Seller Central👥 Amazon FBA sellers🔤 Plain-English → SQL

This is part of the Taptic Data Amazon query library. Explore related queries: SQL query for Amazon return rate by SKU, SQL query for Amazon net margin after FBA fees, SQL query for Amazon buy box percentage by ASIN, and more.

The question

Show me FBA inventory aging by SKU with days in warehouse and estimated long-term storage fee risk

↓

The SQL Taptic generates

Amazon FBA Inventory Aging by SKU — generated by Taptic Data AI

SELECT
  inv.sku,
  inv.condition,
  inv.sellable_quantity,
  inv.unsellable_quantity,
  inv.in_bound_quantity,
  inv.inv_age_0_to_90_days          AS age_0_90,
  inv.inv_age_91_to_180_days        AS age_91_180,
  inv.inv_age_181_to_270_days       AS age_181_270,
  inv.inv_age_271_to_365_days       AS age_271_365,
  inv.inv_age_365_plus_days         AS age_365_plus,
  COALESCE(inv.inv_age_181_to_270_days, 0)
    + COALESCE(inv.inv_age_271_to_365_days, 0)
    + COALESCE(inv.inv_age_365_plus_days, 0)   AS units_at_risk,
  ROUND(
    (COALESCE(inv.inv_age_181_to_270_days, 0)
      + COALESCE(inv.inv_age_271_to_365_days, 0)) * 3.80
    + COALESCE(inv.inv_age_365_plus_days, 0) * 6.90
  , 2)                               AS estimated_lts_fee
FROM amazon_fba_inventory inv
WHERE inv.sellable_quantity > 0
ORDER BY estimated_lts_fee DESC
LIMIT 40

Schema-aware SQL generated from plain English23 lines

This query was generated by Taptic Data from plain English against a real Amazon Seller Central schema. In Taptic, you type the question — the AI writes the SQL, runs it, and returns the result. You can edit the SQL, ask for explanations, and save it as a refreshable report.

How this query works

Breaking it down line by line

Reads from amazon_fba_inventory which contains Amazon's aged inventory report with bucket breakdowns
Sums all buckets above 181 days to calculate total units at risk of long-term storage fees
Applies Amazon's current LTS fee rates: $3.80 per cubic foot for 181-365 days, $6.90 for 365+ days
Estimates are per-unit approximations — actual fees depend on product dimensions
Ordered by estimated fee descending so your biggest liabilities surface first

What it returns

Result description

Per-SKU inventory breakdown by age bucket with estimated long-term storage fees — sorted by highest fee liability.

Why it matters

The business impact

Long-term storage fees can silently destroy margins on slow-moving SKUs. A product with 200 units sitting over 365 days could cost you $1,380 in storage alone. This query gives you a clear removal or liquidation candidate list before the next LTS fee assessment.

FAQ

Common questions

How do I generate a "Amazon FBA Inventory Aging by SKU" query automatically?

In Taptic Data, type "Show me FBA inventory aging by SKU with days in warehouse and estimated long-term storage fee risk" and the AI generates schema-aware SQL against your real Amazon Seller Central data — no manual writing required.

What database does this query work with?

This query is designed for Amazon Seller Central. Taptic reads your live schema so the generated SQL always matches your actual table and column names.

Can I edit the generated SQL?

Yes. Taptic shows you the exact SQL it generated. You can edit it directly, ask the AI to explain any line, or request a revision in plain English.

Can I save this as a scheduled report?

Yes. Once you run this query in Taptic, you can save it as a report, add charts and KPIs, and schedule it to email your team on any cadence — daily, weekly, or monthly.

Generate this automatically

Skip the SQL. Ask the question.

In Taptic Data, you type "Show me FBA inventory aging by SKU with days in warehouse an..." and this SQL runs automatically against your real Amazon Seller Central data.

Try Taptic Free — $29.99/mo

No credit card required. Connect your data source in under 5 minutes.

Compare tools

Compare Taptic Data vs Sellerboard →Compare Taptic Data vs Helium 10 →Best Amazon analytics tools compared →