Amazon Inventory Tracking in 2026: What Counts as Stock, Daily Checks and Reorder Points

"Watch total inventory and reorder when it's low" misses the main point. Track available, fulfillable units first, not a headline total that includes stock customers can't buy. Inbound and stranded stock get their own columns: they take up capacity but don't support today's sales.

Which units count as stock

Example, made-up product: the TrailSnap Lantern shows a total of 40 units. Split by state, that's 12 available, 8 reserved, 15 inbound and 5 unfulfillable. Only the 12 count for today's sales and ad decisions. The states come from Amazon's FBA inventory help.

Owning stock and having it available on Amazon aren't the same thing. For the accounting side, see AI2Fin's trading stock definition. Write the available figure next to each SKU before any other calculation. Report labels can change, so check their definitions when you set up the sheet.

Where to get the numbers

Seller Central is enough to start; you don't need a paid subscription.

All four reports are free in Seller Central. The Amazon Fulfilled Inventory report is a near-real-time snapshot you can schedule, but you still have to read it by inventory state. Helium 10 and Jungle Scout help with listing, keyword and product research; neither replaces Amazon as the source of fulfillable quantity.

Sheet columns: SKU, fulfillment method, report date, available units, inbound status, lead time, next action.

Reconcile every day

Supplier stock, your own warehouse and Amazon available stock each get their own column. They answer different questions.

• Download the Inventory Report. It's a tab-delimited file with SKU, price, quantity and ASIN; Quantity means units available to buy right now (Amazon's Inventory Report help).
• Split by fulfillment method. Your own warehouse count must never overwrite an FBA figure.
• Filter to active SKUs. Keep SKU formatting consistent, especially leading zeros and variant suffixes, so lookups match.
• Compare like with like. Amazon available vs the Amazon-available column in your sheet. Supplier balance stays alongside as separate information.
• Log every movement. Orders, cancellations, returns, removals and manual adjustments, each with a reason.
• Flag exceptions. Differences with Amazon, unexplained negative adjustments, reserved or inbound units counted as sellable. Check orders and movements before you change a listing quantity.

Example, made-up SKU: BLUE-MUG-12 shows 18 units in your sheet and 7 on Amazon. Your working balance becomes 7, and you add a note with the report time, the likely cause and the next check. Changing the number doesn't erase the gap.

For merchant-fulfilled offers, don't treat the last quantity you sent as the live one. Amazon's Selling Partner API guidance recommends inventory-change notifications plus a daily full snapshot and your own record of orders and cancellations.

Selling the same stock on several channels? Give each physical pool its own balance first: see multichannel inventory management. If an automated download fails because of network filtering, not Amazon permissions, an administrator can use Scrappey's guide to troubleshoot encrypted DNS monitoring failures. Meanwhile, export manually.

Save the untouched export with its date, and the reconciled sheet separately. Tomorrow you need both.

Set a reorder trigger

Reorder trigger = average daily sales × lead time in days + safety stock

Flag the SKU when available units fall to or below the trigger. Lead time covers supplier time, transport and Amazon receiving, not just the supplier's dispatch promise. Safety stock covers a late shipment or a short sales spike: size it from real demand and the longest delay you've had, and review it after each replenishment.

Days of cover = available units ÷ average daily sales

Amazon's reports show sales for the last 7 and 30 days (Amazon's inventory reporting documentation). Use 30 days as the baseline and 7 days to spot acceleration. If days of cover are shorter than the lead time, a new purchase order alone won't prevent a gap: cut ads, speed up confirmed shipments or fix a blocked listing.

Capacity and availability are different questions. Amazon's Minimum Inventory Level guidance counts sellable stock plus FC transfers, while restock-limit use also includes shipments in Working, In transit or Receiving. A healthy capacity number doesn't mean you have enough to sell today.

When the trigger fires, check confirmed inbound before ordering again. Count it toward future cover only with a credible receiving date. New products, long sales gaps and seasonal items need your own judgment. To see what runs out first, use the Amazon what-runs-out prompt.

When too much stock is the problem

Slow or stranded units still use restock capacity and storage budget while a fast seller runs toward a stockout. Amazon's inventory-management guidance calls stock excess at more than 90 days of supply, flags units aged over 90 days, and sets consequences for stranded stock not fixed or removed within 30 days of notification. Check the rules for your marketplace and note the date.

What to handle first:

• Fast SKU running low: reorder, or cut ads if new stock can't arrive in time.
• Stranded: fix the listing or request removal before the deadline.
• Excess: consider a discount, a promotion or removal.
• Aged: compare liquidation or removal with holding longer.
• Inbound pile-up: delay the next shipment where you can.

Example, made-up seller: 300 phone stands. The question is whether demand justifies keeping them. For each slow SKU, compare expected proceeds after fees, ads and more storage with the cash and space a price cut, promotion or removal would free. The prompt for cash trapped in slow stock gives each SKU a dated decision.

What to measure

Before you change the routine, record:

• SKUs where your sheet differs from Amazon's report.
• Days of cover for your top sellers, with one fixed sales window.
• Excess and stranded units from Seller Central.
• Which exceptions got a fix, a reorder, a promotion or a removal.

Repeat after the next replenishment cycle with the same marketplace, fulfillment method and report settings. A shorter discrepancy list means cleaner records, not stronger demand. Tracking won't fix supplier delays or weak search visibility on its own.

How SellerAI helps

SellerClaw connects to your Amazon store and works with your real data, inside Claude or ChatGPT or as an agent in the SellerClaw app and Telegram. It reads stock and sales speed for each FBA product, counts the days left including shipments on the way, and works out how many units to send and by when. It drafts purchase orders for you to approve. Check its figures against your Seller Central exports.

Example request: "Which of my FBA products will run out in the next 30 days at the current sales speed, and how many units should I send so they arrive in time?"

Download today's Inventory Report, split one real SKU by state and set its reorder trigger. Want it done for every SKU? Start free with SellerClaw.