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.

Accounting recognizes two inventory systems, and perpetual is only one of them. The other, 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.

Perpetual doesn't mean you stop counting. It means you count differently: small rolling cycle counts (a handful of SKUs per week, highest-velocity first) verify the system instead of rebuilding it. When a count disagrees with the record, you investigate while the trail is fresh: a mis-shipped bundle, an unlogged return, a receiving error. That's the difference between finding a $40 discrepancy this week and finding a $4,000 one at year-end with no idea where it came from.

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. Third, let stock position gate your ad spend: PPC for an ecommerce SKU that's days from a stockout buys clicks you can't fulfill, and a campaign you pause and restart rarely comes back at the same efficiency.

• •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. That layer is what multi channel inventory management software actually is: a master count plus fast two-way sync, not a fancier spreadsheet.

None of that is a knock on any particular cart. Ecommerce platforms for small businesses all ship with a stock counter scoped to their own orders, which is the correct design for a storefront. Choosing the best ecommerce platform for a small business is a decision about checkout, payments, themes, and apps; it is not a decision about who owns your master inventory count.

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).

FBA adds a wrinkle worth naming. Units in Amazon's warehouses are yours but not under your control: some are reserved for transfers, some are in-transit between fulfillment centers, and some go missing. Amazon inventory software worth using treats FBA stock as its own location, tracks the reserved and inbound states separately from sellable units, and flags when Amazon's count drifts from yours, because that drift is either a sync bug or money you're owed.

Where Inventory Meets Your Books: COGS and Valuation

Inventory management isn't just operations. It's half of your income statement, and the point where inventory data becomes ecommerce accounting. 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.

The inventory valuation methods worth knowing in accounting come down to two for most online sellers. Weighted average cost smooths price changes across all units of a SKU and is the easier one to run at ecommerce volumes. FIFO relieves the oldest cost first and tracks reality better when your landed costs move a lot, say a freight spike or a tariff change mid-year. LIFO exists in US accounting but is rare among online sellers and isn't allowed under IFRS. Whichever of these inventory accounting methods you choose, apply it consistently per SKU; switching mid-year makes period-over-period comparisons meaningless.

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 up to ecommerce ERP software that runs purchasing, warehousing, and finance in one system, and most sellers need something far narrower than the top of that range. Good ecommerce inventory management software does four things: multichannel quantity sync, per-SKU cost tracking, reorder points, and clean handoff to accounting. Everything else is optional.

A few category labels are worth decoding, because the products overlap and the names don't. Small business accounting software with inventory management means your ledger tracks stock as well (QuickBooks Online's higher tiers, Xero with an inventory add-on); it's fine at low SKU counts and gets blunt once you have variants, bundles, and several channels. Small business warehouse inventory software is bin, pick, and pack software for people holding their own stock, and it solves nothing about valuation. Small business invoice and inventory software bundles quoting and invoicing for sellers doing wholesale orders alongside retail. And what most people mean by the best inventory app for a small business is a phone screen for barcode counting, which is genuinely useful for cycle counts but is the easy half of the job; the ledger underneath it is the part that's painful to replace later.

Cheap inventory management software isn't automatically the wrong answer either. A simple small business inventory tool that syncs two channels accurately beats an expensive platform nobody finishes configuring. The price worth worrying about is the second one: what it costs in hours and errors when you outgrow it, because inventory history migrates badly and most sellers end up rebuilding cost bases by hand.

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; BeanHawk, for example, pairs SKU-level valuation with summarized settlement journals posted 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. And if Amazon is your dominant channel, weigh dedicated amazon inventory management software features (FBA locations, reserved-stock states, reimbursement flagging) more heavily than generic multichannel breadth.

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. One quiet warning sign during trials: if a tool's on-hand number can't explain itself (no transaction log showing how the count got there), you'll be back to recounts within a quarter.