Inventory management

On this page 7

Inventory management is the discipline of tracking, planning and controlling stock so that a business has the right products, in the right quantity and location, at the right time. In e-commerce inventory, it balances two opposing risks: stockouts that lose sales and excess stock that ties up cash and storage space.

For an online seller, inventory management also determines what the storefront displays. The available-to-sell quantity shown on a product page must reflect physical stock, open orders, reservations and stock committed to other channels, often across several warehouses.

How inventory management works

Inventory management rests on accurate stock records per SKU and location, updated by every receipt, sale, return, transfer and adjustment. The record is only useful if it matches the shelf, which is why counting and reconciliation are part of the process, not an afterthought.

On top of the records sits replenishment logic. The business forecasts demand, compares it with stock on hand and stock on order, and decides when and how much to reorder. The decision depends on supplier lead time, minimum order quantities, cost of capital and how much risk of running out is acceptable.

Online sellers distinguish several stock quantities. Confusing them is a common reason why storefronts show items that cannot actually be shipped.

QuantityDefinitionWhy it matters
On handPhysically present in the warehouseBasis for counting and valuation
AllocatedReserved for open ordersCannot be sold again
Available to sellOn hand minus allocated and safety buffersWhat the storefront should show
On orderPurchased from suppliers, not yet receivedSupports backorders and pre-orders
In transitMoving between locationsNot yet sellable at the destination
Stock quantities used in inventory management

Key inventory parameters and formulas

A handful of parameters drive most replenishment decisions. They are calculated per SKU, because demand and lead time differ even within one product family.

ParameterBasic calculationPurpose
Reorder pointAverage daily demand × lead time + safety stockTriggers a new purchase order
Safety stockBuffer sized by demand and lead-time variabilityProtects against unexpected demand
Economic order quantitySquare root of (2 × annual demand × order cost ÷ holding cost)Balances ordering and holding costs
Inventory turnoverCost of goods sold ÷ average inventory valueShows how fast stock sells
Days of inventoryInventory on hand ÷ average daily salesShows how long stock will last
Sell-through rateUnits sold ÷ units received in a periodEvaluates seasonal and fashion buys
Core inventory parameters

These formulas assume reasonably stable demand. For seasonal products, promotions and new launches, they are a starting point that must be adjusted with forecasts and judgment. Service level targets, such as aiming to fulfill a high share of orders from stock, determine how large safety stock needs to be.

Inventory models in e-commerce

Online sellers can hold stock themselves, outsource storage or avoid holding stock entirely. The choice changes who carries the inventory risk and how much control the seller has over availability and delivery speed.

ModelWho holds the stockMain advantageMain drawback
In-house warehouseThe sellerFull control and fast changesFixed costs and staffing
3PLA third-party logistics providerScalable storage and shippingLess direct control, contract fees
DropshippingThe supplierNo capital tied in stockThin margins, limited visibility
Marketplace fulfillmentThe marketplace operatorFast delivery promise to buyersStorage fees and strict rules
Made to orderNo finished stockNo overstock riskLonger delivery times
Inventory models compared

Many businesses mix models, keeping fast movers in a 3PL and selling long-tail items by dropshipping. This works only if the store platform can show reliable availability from every source.

Classification and control methods

Not every SKU deserves the same attention. ABC analysis ranks SKUs by their share of revenue or consumption value: a small group of A items typically drives most revenue and receives the closest control, while C items are managed with simpler rules.

Counting methods follow a similar logic. Instead of a single annual full physical inventory, many warehouses use cycle counting, in which a few locations are counted every day and A items are counted most often. Cycle counting finds errors earlier and avoids closing the warehouse for a full count.

Valuation methods such as FIFO (first in, first out) and weighted average cost affect reported margins and taxes. They are an accounting choice, but they must match how stock is actually rotated, especially for products with expiry dates.

Common inventory management problems

SymptomLikely causeFix
OversellingSlow stock sync between channelsReal-time or event-based sync, channel buffers
Frequent stockoutsSafety stock too low or lead times ignoredRecalculate reorder points per SKU
Dead stockOver-buying or weak sell-through trackingReview slow movers, clearance, smaller buys
Record does not match shelfUnrecorded returns, damage or mis-picksCycle counts and scanner-based receiving
Symptoms, causes and fixes

Stripped to the essentials

Inventory management means knowing what you have, what you will need and when to order more. It is like running the pantry of a large family. Run out of milk and breakfast fails. Buy too much and it goes to waste.

For an online shop, the goal is easy to say and hard to do. Never sell what is not there, and never sit on stock nobody buys.

Where it is applied

An online pet supply store sells about 2,500 SKUs, and its best-selling dog food comes from a supplier with a lead time of ten days. The store sells around 40 bags a day of that product, so it sets a reorder point of 400 bags plus a safety stock of 150 bags to cover demand spikes and late deliveries.

Before this, purchasing was based on gut feeling, and the product ran out twice in one quarter while slow-moving accessories filled the shelves. After the team introduced per-SKU reorder points, ABC classification and weekly cycle counts of A items, stockouts on top sellers became rare and money tied up in slow stock decreased.