Ecommerce Inventory Management: Quantity, Value, Reorder Points

A stockout on your best seller costs you twice. First you lose the sales themselves; then you lose the ranking, ad efficiency, and repeat-purchase momentum that took months to build. Overstocking the wrong SKU is just as expensive — cash sits on a shelf earning nothing while storage fees accumulate.

Inventory management is the discipline that keeps you between those two failure modes. For an ecommerce seller it comes down to four jobs: know how many units you have, know what they're worth, know when to reorder, and keep every sales channel telling the same story. This guide walks through each job with worked numbers you can copy.

Track Quantity AND Value: Perpetual Inventory

Most sellers track unit counts. Far fewer track value — what those units actually cost — and that gap is where books quietly go wrong. A perpetual inventory system updates both quantity and cost value with every transaction: a purchase order receipt adds units at their landed cost, a sale removes units and moves their cost to cost of goods sold (COGS), and an adjustment (damage, shrinkage, a lost FBA shipment) writes the difference off.

The alternative — periodic inventory, where you count everything once a quarter or once a year and back into COGS — tells you nothing in between. You can't see margin by SKU, you can't spot shrinkage until it's months old, and your monthly P&L is essentially fiction until the next count.

Practically, perpetual inventory means every SKU carries a cost basis. If you bought 500 units at $6.20 landed and later 500 more at $6.80, your system needs a costing method (weighted average or FIFO are the common choices for ecommerce) so each sale relieves inventory at a defensible cost. Get this right and your balance sheet inventory number, your COGS, and your physical counts all reconcile to each other.

The Reorder Point Formula, With a Worked Example

A reorder point is the stock level that triggers a new purchase order. The formula is simple: reorder point = (sales velocity × lead time) + safety stock. Velocity is average units sold per day, lead time is the number of days from placing a PO to sellable stock on the shelf (or checked in at the warehouse), and safety stock is your buffer against demand spikes and supplier delays.

Worked example. Suppose a SKU sells an average of 12 units per day. Your supplier takes 14 days to produce and ship, plus 4 days for receiving and check-in, so total lead time is 18 days. Lead-time demand is 12 × 18 = 216 units. For safety stock, a simple approach is to cover the gap between your worst realistic day and your average: if your busiest days hit 19 units, that's 7 extra units per day of lead time, so 7 × 18 = 126 units of safety stock. Reorder point = 216 + 126 = 342 units. When on-hand plus inbound stock drops to 342, you reorder.

Two refinements matter in practice. First, use velocity from a recent, representative window — a 30- or 60-day average — and override it manually around promotions and seasonality. Second, count inbound units (open POs, FBA shipments in transit) toward your position, or you'll double-order every time a shipment is slow to check in.

• •Velocity: average daily units sold over a recent 30-60 day window
• •Lead time: PO placed to sellable stock, including receiving and check-in days
• •Safety stock: buffer for demand spikes and late shipments
• •Reorder point = (velocity x lead time) + safety stock = (12 x 18) + 126 = 342 in this example

Multichannel Stock Sync and Oversell Protection

The moment you sell on more than one channel — a Shopify store plus Amazon, eBay, Walmart, or a wholesale portal — you have a synchronization problem. Each channel holds its own copy of your stock level, and every copy decays the instant a sale happens somewhere else. Sell your last 3 units on Amazon while Shopify still shows 3 available, and you've oversold: now you're refunding a customer, eating a defect metric, or scrambling to drop-ship at a loss.

The fix is a single source of truth. One system holds the master quantity per SKU, decrements it on every order from every channel, and pushes the updated number back out to each channel within minutes. Shopify inventory management gets you part of the way for Shopify-only sellers — it tracks quantities per location natively — but it doesn't know what Amazon or eBay just sold, so multichannel sellers need a layer above the channels.

Two oversell protections are worth configuring even with good sync: a stock buffer (list 95 units when you hold 100, so a burst of simultaneous orders can't take you negative) and channel-level allocation (reserve units for your highest-margin channel so a marketplace spike can't strip stock from your own store).

Where Inventory Meets Your Books: COGS and Valuation

Inventory management isn't just operations — it's half of your income statement. Units sitting in a warehouse are an asset; the moment they sell, their cost becomes COGS. If your quantity records or cost bases are wrong, your gross margin is wrong, and every decision built on it (ad budgets, pricing, which SKUs to kill) inherits the error.

Channel fees compound the stakes. Amazon referral fees typically run 8-15% of sale price depending on category, so a SKU that looks healthy on revenue can be marginal once fees and true landed cost are netted out. You only see that if cost flows through to each sale.

Accurate cost records also pay off when inventory goes missing. Since March 31, 2025, Amazon values FBA lost-inventory reimbursements at the seller's manufacturing or sourcing cost — using its own estimate unless you provide your actual cost — excluding your margin and fees. Sellers with documented per-SKU costs can substantiate higher claims; sellers without them take Amazon's estimate. And since October 23, 2024, the window to claim fulfillment-center losses is just 60 days, so stale records mean forfeited money. This is the niche BeanHawk works in: perpetual SKU-level inventory valuation with a PO and landed-cost engine, plus a free FBA reimbursement audit where you keep 100% of recoveries.

One caveat: your choice of costing method (weighted average, FIFO) and how you value inventory can affect your tax return, not just your management reports. Confirm your approach with an accountant or tax professional before you standardize on it.

When Spreadsheets Break

A spreadsheet is a fine inventory system for a single channel and a couple dozen SKUs. It breaks predictably as you grow, and the failure is rarely dramatic — it's a slow accumulation of small mismatches until nobody trusts the numbers and someone orders a full recount.

Watch for these signals that you've outgrown manual tracking:

• •You sell on two or more channels and update quantities by hand — every delay is an oversell window
• •Physical counts disagree with the sheet by more than a percent or two, and nobody can explain why
• •Cost basis lives in someone's head: the sheet has quantities but no landed cost per SKU
• •Reordering is vibes-based — no velocity data, no reorder points, just 'looks low'
• •Month-end close requires hours of manual COGS math before your P&L means anything
• •Returns, bundles, and multi-warehouse stock each have their own side spreadsheet

Anatomy of a Healthy Restock Cycle

Good inventory management is a loop, not a task. Each cycle through the loop tightens your numbers: velocity estimates improve, lead times get measured instead of guessed, and safety stock shrinks to what you actually need. Here is the full cycle from signal to reconciliation.

Choosing Inventory Management Software

When the spreadsheet breaks, the question becomes which inventory management software to adopt. The honest answer is that the category spans everything from inexpensive single-purpose sync tools to enterprise ERPs, and most ecommerce sellers need something narrow: multichannel quantity sync, per-SKU cost tracking, reorder points, and clean handoff to accounting.

Evaluate against your actual failure modes. If oversells are your pain, prioritize sync speed and buffers. If your books are the pain, prioritize perpetual valuation and accounting integration — for example, BeanHawk posts summarized settlement journals to QuickBooks Online and Xero with flat all-channel pricing from $19/mo. If reordering is the pain, prioritize velocity-based PO suggestions that account for inbound stock. The wrong move is buying the biggest system available and configuring 10% of it; the right move is fixing your most expensive failure mode first and confirming the tool's numbers reconcile to a physical count before you trust it.