Ecommerce assistant scanning a boxed product with a handheld scanner beside stock shelves
RESOURCES · ECOMMERCE · INVENTORY MANAGEMENT

Ecommerce inventory management for online sellers

Run one stock count across every sales channel, set simple reorder rules and check it against the shelf. Software holds the numbers; a person keeps them true.

Tools our VAs use for this

  • Linnworks
  • Cin7
  • Brightpearl
  • Shopify
  • Excel
  • Google Sheets
  • Amazon Seller Central
  • ShipStation
  • Updated
  • 13 min read
  • By Ant Assist
In short

Ecommerce inventory management means tracking every product line (SKU) in every place you hold and sell it, so your stock count is right, your listings never oversell and you reorder before you run out. That means one stock count shared by all your sales channels, a few simple rules (which lines matter most, how much buffer to hold, when to reorder), regular checks against the physical stock and a stock value at year end for your accounts. The software holds the numbers; a person still has to keep them true. Our ecommerce inventory management service gives you a dedicated VA to run it.

On this page
E-commerce

What ecommerce inventory management is

Inventory management defined

Ecommerce inventory management is how an online shop tracks and controls the stock it holds to sell. Managing it covers buying, receiving, recording, storing, selling and counting it, and knowing at each step how many units you have and what they cost you. For a small online shop the core question each morning is simple: what can I sell today without letting a customer down, and what do I need to order this week? Some sellers give that daily check to an ecommerce VA.

How online stock differs from shop stock

A high street shop sells what is on the shelf. An online store sells what its listings say it has, and the listing can be wrong. Stock may sit in your garage, a rented unit, a third-party warehouse or a marketplace's own fulfilment centre, and the same unit may be listed on your website and on two marketplaces at once. The gap between the number on screen and the item on the shelf is where most online stock problems start.

SKUs, variants and locations

Each sellable version of a product gets its own stock keeping unit (SKU): the blue T-shirt in medium is one SKU, the blue in large is another. Variants multiply SKUs quickly, so a handful of designs in several sizes and colours soon becomes dozens of lines to track. Each SKU then has a count per location. Inventory also includes stock in transit, stock reserved for unshipped orders and returns waiting to be checked.

Part 3

Why inventory management matters

Fewer stock-outs and oversells

Run out of a best seller and you lose the sale, and often the customer, who buys elsewhere. Oversell, by taking an order for stock you no longer have, and you have to cancel, apologise and live with the review. Accurate counts and timely reorders prevent both.

Less cash tied up in slow stock

Every unit on the shelf is money you have already spent. Stock that does not sell costs you storage, ties up cash you could put into faster lines or marketing, and may end up discounted or written off.

Customer satisfaction and reviews

Customers notice when the item they ordered was in stock, arrives on time and matches the listing. Reliable stock means better reviews and fewer support emails. If returns are high, start by measuring your ecommerce return rate.

Part 4

Common inventory challenges

Common inventory challenges include overstock and dead stock, stock-outs and overselling across channels, and inaccurate counts in manual spreadsheets.

Tall warehouse racks packed with cartons, showing how stock levels build up

Overstock and dead stock

Overstock usually starts with an optimistic order, a bulk discount that looked good or a trend that faded. Dead stock is the end state: lines that have not sold for months. The fix is visibility: a regular report of slow movers, so you can stop reordering them and bundle, discount or clear them before they lose all value.

Stock-outs and overselling across channels

Sell on more than one channel and each sale has to reduce the count everywhere. When channels update at different speeds, or one is updated by hand, two customers can buy the last unit. It has its own section below. For growth, read how to scale an ecommerce business.

Inaccurate counts and manual spreadsheets

Spreadsheets work until they do not. A typing error, a delivery booked in twice, returns never added back and breakages never written off all make the sheet drift away from the shelf. Regular cycle counts (counting a few lines each week instead of everything once a year) and one person owning the records keep the numbers honest. Returns need their own routine, covered in ecommerce returns management.

Part 5

Inventory management techniques

Inventory management techniques include ABC analysis, safety stock and replenishment rules, first in, first out (FIFO) and just in time.

ABC analysis (the 80/20 rule)

ABC analysis ranks your lines by how much they contribute to sales. A lines are the small group that make most of your revenue, B lines sit in the middle and C lines are the long tail that sells now and then. The 80/20 label is a rule of thumb, not a law: in most ranges a minority of lines does most of the work, and your own sales report shows where your groups fall. Give A lines the tightest counts, a safety buffer and the closest supplier watch, and review C lines for clearance.

ABC analysis: a few A lines make most sales and get the tightest control, C lines are a long tail reviewed for clearance
ABC analysis ranks lines by sales, so effort goes where it matters.

Safety stock and replenishment rules

Safety stock is a buffer of extra units held to cover a sales spike or a late delivery. A replenishment rule says when to reorder and how much: reorder when stock falls to a set level, say, or top up to a target every fortnight. Rules turn reordering from a judgement made under pressure into a routine anyone can follow.

FIFO and just in time

First in, first out (FIFO) means selling the oldest stock first, which matters for anything that dates, expires or changes packaging. Just in time means ordering close to when you need stock, so less cash sits on the shelves. It works with reliable, nearby suppliers and is risky when lead times are long or uncertain.

Which method suits which seller

The right mix depends on how fast your lines sell, how reliable your suppliers are and how many channels you sell on. Our guide to stock control methods compares the main methods side by side, with a table for choosing one.

Part 6

Forecasting demand and setting reorder points

Excel stock control sheet with live reorder point formulas and a movement log (.xlsx, Excel, 91 KB)

What forecasting adds

Forecasting uses your sales history, seasons and planned promotions to estimate what you will sell over the coming weeks, so you order ahead of demand instead of reacting to it. The inventory forecasting guide walks through the methods and a worked example for a small shop.

The reorder point formula

A reorder point is the stock level at which you place the next order. The standard formula is average daily usage multiplied by supplier lead time in days, plus safety stock; the ACCA, a professional accountancy body, describes the re-order level as the demand in the lead time in its inventory control article. Our reorder point formula guide works it through with an example.

Skills and tools

Inventory management software

What inventory software does

Inventory software keeps one stock count per SKU per location and updates it as orders, deliveries and returns come in. Most systems pass the available quantity to each connected sales channel, and many raise purchase orders, flag lines that reach their reorder point and report on stock value and slow movers.

Does Shopify have inventory management?

Yes. At the time of writing (19 October 2026), the Shopify Help Center page on inventory and locations explains that Shopify tracks inventory by location and that you need at least one location set up to track it. What the native tools cover beyond that depends on your plan and the apps you add, so check the help page and your plan before you buy anything extra. Ask the same questions you would ask of any system: does it hold stock for every channel you sell on, raise purchase orders and flag lines at their reorder point? If you want a hand running the store itself, see our Shopify virtual assistant page.

Warehouse staff with a handheld scanner and clipboard checking stock along shelving aisles

When to move from a spreadsheet

A spreadsheet is a sound start for a single channel and a modest range. Signs it is time to move: you sell on more than one channel, you have oversold more than once, the sheet takes longer to update than the orders take to pack, or only one person understands it. Move before your busy season.

How to choose software

Write down what you need before you look at products: the channels to connect, the number of stock locations, batches or expiry dates, purchase orders, bundles, and the reports you will read. Then ask each vendor to run your own workflow on a trial: a delivery, an order on two channels, a return and a count. Check how you get your data out if you leave.

Part 8

Keeping stock in sync across Shopify, Amazon and eBay

Keep stock in sync across Shopify, Amazon and eBay by making one system the master record of stock that every channel reads from, and updating it first with every sale, return and delivery.

Why multichannel causes overselling

Each sales channel holds its own copy of your stock figure. If your website and your Amazon and eBay listings all show the same units, a sale on one has to reduce the other two before the next customer buys. Manual updates, delays between systems and stock held in a marketplace's own warehouse all open a window in which the same unit can be sold twice.

What a single stock count looks like

Pick one system as the master record of stock and let every channel read from it. Every sale, return and delivery updates the master first. Hold a small buffer back on the channels where a cancellation hurts most, so a sync delay costs you a sale instead of an apology. Check the master against the shelf on a cycle-count rota, and compare each channel's quantities with the master every week. Returns need the same discipline: an item is back in stock only once it has been checked and booked in, which is part of order processing and returns. If you sell on Amazon or eBay as well as your own site, this weekly check is one of the first jobs worth handing to someone else.

Sales, deliveries and checked returns update one master stock count, which your website, Amazon and eBay read from
One system holds the count: every movement updates it first, every channel reads from it.
Part 9

Stock records and valuation for UK tax

Counting stock at year end

Your accounts need a value for the stock you hold at the end of the accounting period. For sole traders, the gov.uk page on self-employed records lists the value of stock and work in progress at the end of your accounting period among the records you must keep. In practice that means a full stock count, or a perpetual record you have checked against the shelf, at your year end.

Lower of cost and net realisable value

HMRC's Business Income Manual says that, for trade profits, stock is valued at the lower of cost and net realisable value, or on a mark to market basis, and that other bases are not acceptable for Income Tax or Corporation Tax (BIM33125). Cost covers what you paid to buy the stock and the other costs of bringing it to its present location and condition (BIM33135). Net realisable value is what the stock will now sell for, less the costs of selling it. So a damaged or dead line goes into the accounts at what it will fetch, where that is below cost.

How long to keep records

For Self Assessment, gov.uk says to keep your records for at least 5 years after the 31 January submission deadline of the relevant tax year. Limited companies follow different rules, so check with your accountant. This is general information, not tax advice.

Admin

Handing the stock admin to a virtual assistant

Software holds the numbers; somebody still has to book deliveries in, count, chase suppliers, correct listing quantities and spot the line about to run out. That is steady, rule-based work, and it suits a dedicated virtual assistant. The guide to ecommerce tasks to delegate lists the wider set of jobs. Stock admin is one part of what a dedicated e-commerce assistant looks after.

At Ant Assist your VA is one named person, never shared, working full time from our own managed office in Cairo, where every VA is recruited, managed and supervised. They are not freelancers and not AI, and the service is UK-managed. Your inventory management VA can take on cycle counts, reorder checks, purchase orders, supplier chasing and channel quantity updates in UK business hours, 9am to 5pm Monday to Friday, from 20 hours a week up to a full 40-hour VA. If the fit is wrong, we replace the VA without restart cost. Access is revocable, runs through password managers and sits under NDAs and data-processing agreements.

The rate starts at £5 per hour for the first 6 months on the Entry tier (3 months on Mid, 1 month on Expert). After that, Entry is £6.50 per hour full time (£1,040 a month for 160 hours) or £6.80 per hour part time (£544 a month for 80 hours). Put your own hours into the calculator to compare.

Rated 5.0 on Google.Trusted by our clients
FAQ

Inventory management FAQs

There is no single official list, and guides number the steps differently. Most cover the same ground: buy stock, receive and check it, record it, store it, sell and ship it, then count and review. The review is where you decide what to reorder, what to clear and what to stop buying.

Lead time is the gap between placing an order with a supplier and the stock being ready to sell. It includes the supplier's own preparation, shipping, and the time you take to check and book the delivery in. Measure it from your own purchase records, because a quoted lead time is often the best case.

Give each SKU a row with its name, location, opening stock, units received, units sold and a closing stock column that adds and subtracts the others. Add a reorder level column and a simple formula that flags any line at or below it. Keep one master copy, record every movement the same day and check the sheet against the shelf on a regular rota.

AI tools can spot patterns in sales history, draft forecasts, flag unusual stock movements and answer questions about your data. They depend entirely on the data you give them, so a wrong stock count produces a confident wrong answer. Use them to speed up analysis and keep a person checking the figures before any order goes out.

Sources group them differently, so treat any fixed list as a convenience. The methods that come up most are just in time, ABC analysis, first in first out, and safety stock with reorder points. Matching the method to how each of your lines sells matters more than which list you follow.

Didn't find your answer? Browse more common questions in the Help Center.

Get Started

Stock counts you can trust.

One dedicated ecommerce VA, from £5 per hour. Book a call.

Discovery callRole briefVA matchedOnboarded into your tools