Blog/Logística

Ecommerce inventory control: how to keep your stock accurate

Practical guide to ecommerce inventory control: stock statuses, receiving, cycle counting, returns and key metrics to avoid overselling.

Ecommerce inventory control: how to keep your stock accurate

Controlling inventory for an ecommerce store means making sure the number your customer sees on the website matches what's actually on the shelf, at every moment. If your store shows 120 units and there are really only 94 left, you're going to sell 26 you can't deliver: 26 cancellations, 26 emails to support, and probably a bad review or two.

The solution isn't counting more often, it's stopping stock from drifting in the first place. That comes down to five connected things: a catalogue with unique SKUs, validated receiving, every movement logged with a scanner, separate stock statuses (available, reserved, blocked) and cycle counts that look for the root cause of every discrepancy. Let's go through them one by one.

Theoretical stock versus real stock

Theoretical stock is what should be there according to your records. Real stock is what's physically located, in good condition and ready to go out on an order. The whole point of stock management is closing the gap between the two.

That gap almost never appears overnight during the annual stocktake. It builds up every day through uncontrolled movements: a delivery signed off by box count rather than by unit, a return put back on the shelf without being checked, a location change nobody logs, or an order picked in the wrong size. Each one throws off one or two units. After a few months, the mismatch starts showing up in sales.

And it costs money either way. If the system shows stock that doesn't exist, you oversell. If it hides stock that does exist, you stop selling and end up over-ordering from your supplier out of caution, tying up cash and space.

The four stock statuses in ecommerce inventory control

The most expensive mistake we see in stores just starting out is having a single stock figure. What's physically in the warehouse isn't the same as what you can actually sell. At the very least, separate out:

  • Physical stock: everything that exists in the warehouse.
  • Reserved: units already committed to paid orders that haven't shipped yet.
  • Blocked: damaged goods, returns pending inspection, quarantined stock, samples or units set aside for a B2B order.
  • Available: physical minus reserved minus blocked. This is the only figure your website should display.

This separation also fixes your purchasing. Your reorder decision should depend on how much sellable stock you have left, not how many boxes are sitting in the warehouse. It also lets you react on the marketing side: if a SKU is running low on available units, you can pull back ad spend or push an alternative with better cover before it sells out completely.

How to set up inventory control that doesn't drift

1. Clean up your catalogue before touching the warehouse

Every product and every variant needs a unique, stable SKU with its own barcode. Having

Back to blog