Ecommerce inventory management: a practical starting guide

The short answer

Ecommerce inventory management means keeping one accurate count of stock, updating it whenever an item is sold, returned, damaged or received, and selling only what is available after reservations. To avoid overselling, share the count across every channel, record offline sales at once and run regular counts, starting with the fastest sellers.

The stock numbers in ecommerce inventory management

Ecommerce inventory management starts with separating the different meanings of "in stock". One number is not enough, because stock can be on a shelf, promised to a customer or still on a delivery van. Define each state once and use the same words everywhere.

Sell against the available number, not the on-hand one. A shop that shows on-hand stock will sell the same unit twice whenever an order is waiting to be packed.

Choose one source of truth

One system should hold the master count, and everything else should read from it. When a spreadsheet, a platform dashboard and a warehouse list each hold their own figure, the three will drift apart within days.

The right tool depends on the size of the operation:

• A spreadsheet can cope with a small catalogue sold on one channel, if one person updates it and updates it every day.
• The inventory tools built into your store platform suit most single-channel stores that hold stock in one place.
• A separate inventory system makes sense when you sell on several channels, hold stock in more than one location, use bundles or need integration with a warehouse.

Tools differ in what they cost and what they connect to. Extras such as apps and connectors can add to the monthly bill, as the guide to Shopify store costs beyond the plan explains. A custom build can link directly to a warehouse or accounting system, but it needs development work, a trade-off described in custom ecommerce or Shopify.

How overselling happens and how to stop it

Overselling happens when the website sells a unit you cannot ship, almost always because the count is wrong, late or not shared. Understanding the cause points to the fix.

• Two channels sell the same unit before either updates the shared count.
• Two shoppers reach checkout for the last unit at the same moment.
• A sale in person or by phone is never recorded online.
• A returned item is restocked before anyone has checked its condition.
• Damaged or lost units remain in the count.
• A supplier's stock figure is out of date or wrong.

To prevent it, reserve stock at the point you choose, such as when an item is added to a cart or when checkout begins, and release it after a set time if the order is not paid. Each choice has a cost: holding stock at add-to-cart protects the last unit but locks it against shoppers who may never buy. Keep a small buffer on slow-syncing channels, limit the quantity on rare items and record offline sales immediately.

When an order cannot be filled, tell the customer at once, offer a refund, a substitute or a wait, and note the cause. An early, honest message is far better received than a silent delay.

What to count and how often

Count the items that matter most to your sales and cash more often than the rest. A common approach sorts stock into groups: fast sellers and high-value items in one, steady sellers in a second, and slow movers in a third. Count the first group most often and the last group least, and you spend counting time where errors cost the most.

Two methods work together. A full count stops everything while every item is counted, and is best done at the end of an accounting period or when a warehouse moves. Cycle counting spreads the work by counting a few products each week so that, over time, everything is covered. Ask your accountant how stock should be valued and recorded, because rules differ by country.

1. Choose the products to count this week and print or open the list without the system quantity, so the counter is not influenced.
2. Count the units on the shelf, and separately any in returns, damaged or on hold.
3. Compare the count to the system and note every difference.
4. Look for the cause: a mis-pick, a damaged unit, an unrecorded sale or a data entry error.
5. Adjust the system with a reason, so patterns can be seen later.

Recurring differences on one product are a signal to check how it is stored, labelled or picked, not just to correct the number.

Reorder points and safety stock

A reorder point is the available level at which you place a new order so that stock arrives before it runs out. In plain terms, it is the typical daily sales multiplied by the supplier's lead time, plus a buffer. A short, reliable lead time needs a small buffer. A long or unreliable one needs more.

The calculation is simple, but the inputs need honesty. Use real sales from your own records, not hopes. Allow for supplier minimum order quantities, for seasonal peaks and for the time it takes to receive and shelve goods. More stock reduces the risk of running out, but it ties up cash, takes space and risks being marked down if it does not sell, so there is no free option.

Review the reorder levels on your fastest sellers regularly, as sales rates change with promotions, seasons and new competitors.

Codes, names and records

Every sellable item needs a unique stock code that never changes and is never reused. Keep the format consistent, and give each size and colour its own code. Record the supplier's code beside it, so purchase orders and deliveries can be matched.

Barcodes speed up receiving and picking and cut the errors that come from reading codes by eye. Label shelves and boxes the same way every time.

The details on your product pages should match the stock record: the same size labels, materials and model names. Writing from a clean master list also avoids mistakes. The guide to writing product descriptions shows how to build descriptions from verified facts.

Connecting stock to product pages and feeds

What a shopper sees on the page should match what you can ship, and the same applies to anything you send to a shopping service. Show only statuses you can stand behind: in stock, low stock, sold out and, if you accept them, available to order on backorder.

Google Merchant Center asks that the availability in your product data match what the landing page shows, and says availability should be consistent across the landing page, structured data, checkout and data source. A mismatch can lead to the product being disapproved. A common cause is the time gap between a website update and a feed update, so schedule feed updates to match how quickly your stock changes. The guide to what you need for Google Shopping covers the rest of the set-up.

Low-stock messages should be true. Show them only when the figure comes from the real available count.

Moving stock data to a new platform

A platform move is the riskiest moment for stock accuracy, because two systems can briefly disagree. Plan the cut-over date, count before and after, and freeze changes in the old system while the data moves.

After the move, check a sample of products against physical counts, test an order through to the stock update and confirm that every sales channel reads from the new count. The ecommerce platform migration checklist lists the other things that move with the store. If your store needs inventory logic that your current platform cannot provide, the ecommerce solutions page explains what Liftup Technologies builds.

A weekly stock routine

A short, regular routine catches most problems before customers do. Weekly is enough for many small stores, with more frequent checks in busy seasons.

• Check the list of items below their reorder level and place orders.
• Cycle count the products you chose for this week and correct differences with a reason.
• Check that incoming deliveries are received and added to the count promptly.
• Look at returned items waiting for inspection and decide whether to restock them.
• Review orders that could not be filled and find out why.
• Compare what the website shows for a sample of products with the shelf.

Related guides

• Ecommerce solutions
• How to write product descriptions that sell
• Custom ecommerce website vs shopify
• Ecommerce Migration Checklist: Move Your Store Safely
• How to price products for an online store
• Ecommerce website vs mobile app for your store

Questions and answers

How do I manage inventory for an online store?

Keep one master count, update it whenever stock is sold, returned, damaged or received, and sell against the available number, which is on-hand stock minus reserved stock. Count regularly, set reorder levels and make sure every sales channel reads from the same figure.

How do I avoid overselling?

Sell against available stock, share one count across channels, reserve stock when an order begins, record offline sales immediately and keep a small buffer on slow-syncing channels. If an order cannot be filled, tell the customer straight away and offer a refund, a substitute or a wait.

What should I count and how often?

Count fast sellers and high-value items most often, and slow movers less often. Use cycle counts, which cover a few products each week, alongside an occasional full count. Ask your accountant how stock must be valued and recorded in your country.

Do I need inventory software?

Not always. A spreadsheet can work for a small catalogue on one channel, and your store platform's built-in tools suit many single-channel stores. Consider a separate system when you sell on several channels, hold stock in more than one place or use bundles.

What is safety stock?

Safety stock is a buffer held to cover sales or deliveries that run ahead of plan. It protects against running out when a supplier is late or demand rises, but it ties up cash and space, so set it from real sales and lead times.

How should I handle returned items?

Inspect each item, then decide whether to restock, repair, discount or discard it. Add it back to the count only when it is physically back and checked, so the available figure stays reliable.

What should a product page say when stock is low?

Show a low-stock message only when it reflects the real available count. A message that is not true can mislead shoppers and may break consumer rules in some countries, so keep it linked to the live stock figure.