Ecommerce

How to Set Up Inventory Management for a Small Online Store

· 7 min read
How to Set Up Inventory Management for a Small Online Store

Learn how to set up simple inventory management for your small online store so you never oversell, run out, or lose track of what you have in stock.

Running out of a product you just sold is a bad feeling. So is telling a customer their order is cancelled because you had less stock than you thought. Good inventory management fixes both. It is just a clear system for knowing what you have, what is selling, and when to order more. This guide shows you how to set that up for a small online store, even if you have never done it before.

What inventory management actually means

Inventory is simply all the stuff you sell. Inventory management is how you keep track of it. That is the whole idea. You want to always know three things: how many of each item you have, how fast each item sells, and when you need to buy or make more.

When you get this right, you stop overselling (selling something you do not actually have), you stop running out of your best products, and you stop tying up money in things that never sell. For a small store, you do not need fancy software. You need a simple habit and one place to keep your numbers.

Step 1: List every product in one place

Start by writing down everything you sell. This is your master list. You can use a spreadsheet or the product section of your store platform. For each item, record a few basic details:

  • Product name so you know what it is.
  • SKU, which is just a short code you make up to identify each item (like a nickname). For example, a red medium t-shirt could be TSHIRT-RED-M.
  • How many you have right now.
  • Cost price, what it cost you, and selling price, what you charge.

If you sell items in different sizes or colors, count each one separately. A shirt in three sizes and two colors is really six different items to track. Setting these up properly matters, and it helps to learn how to set up product variants like size, color, and style so each version has its own stock count.

Step 2: Do a real, honest count

Now count what you physically have. Open the boxes. Check the shelves. Do not guess. Your whole system falls apart if your starting numbers are wrong. Write the real count next to each item on your list.

This first count is the most tedious part, but you only do the big one once. After that, you just adjust the numbers as things come in and go out. Set aside an hour or two, put on some music, and get it done properly.

Step 3: Connect your stock numbers to your store

Here is where an online store platform saves you a lot of pain. Most good platforms let you enter a stock quantity for each product. When someone buys one, the count drops by one automatically. When it hits zero, the platform can hide the item or show it as sold out, so nobody can buy what you do not have.

This one feature stops overselling on its own. Without it, you are updating numbers by hand after every sale, which is easy to forget on a busy day. If you would rather not juggle spreadsheets and manual updates, a builder like vq.pe tracks stock for each product and manages orders in the same place as your store and checkout.

Step 4: Set a reorder point for each item
Step 4: Set a reorder point for each item

Step 4: Set a reorder point for each item

A reorder point is the stock level where you say "time to buy more." It stops you from running out while you wait for new stock to arrive. To find it, think about two things: how many you sell in a week, and how long a new order takes to reach you.

Here is a simple example. Say you sell about 10 candles a week, and your supplier takes 2 weeks to deliver. You will sell around 20 candles while waiting. So set your reorder point a bit above 20, maybe at 25, to give yourself a small cushion. When your candle stock drops to 25, you place a new order. Simple.

Write a reorder point next to every product. Check your list once a week and reorder anything that has hit its number.

Step 5: Update stock every time something changes

Your numbers are only useful if they stay accurate. Update your stock whenever:

  1. A new shipment arrives (add the amount).
  2. You sell something outside your website, like at a market or over the phone (subtract it).
  3. Something breaks, expires, or gets returned (adjust it).
  4. You give away a free sample or use one yourself (subtract it).

If all your sales happen through your website, the platform handles most of this for you. The manual updates are mainly for offline sales and damaged goods. Make it a rule: the moment stock changes, you fix the number. Do it now, not later.

Step 6: Watch what sells and what does not

Inventory management is not just about avoiding empty shelves. It is also about spotting your winners and your dead weight. Every few weeks, look at which products sell fast and which just sit there.

Order more of the fast sellers before they run out. For the slow ones, try a discount to clear space and free up cash. Your store's numbers tell this story clearly, and it helps to know how to read your store analytics to find what loses sales so you can act on real data instead of hunches.

Step 7: Plan for items you do not have yet

Sometimes demand runs ahead of your stock. That is not always bad. Instead of hiding a sold-out product, you can let people pay in advance and wait. This keeps the sale instead of losing it to a competitor.

If a product is popular before you have made much of it, you can even run a pre-order campaign to sell before you build. That way you know exactly how many to make, and you get paid up front to cover your costs.

Common mistakes to avoid

A few simple slip-ups trip up most new store owners. Watch out for these:

  • Guessing your counts. Always count for real. Estimates snowball into big errors.
  • Keeping two lists. Use one source of truth. If your spreadsheet and your store disagree, you will trust the wrong one.
  • Overbuying to save money. A bulk discount is not a saving if the extra stock never sells. Cash tied up in a stockroom cannot pay your bills.
  • Forgetting delivery time. Reorder before you run out, not after. Your customers do not care that the supplier is slow.
  • Ignoring shipping expectations. When stock is low or an order is delayed, tell buyers clearly. A good shipping policy that sets clear delivery expectations prevents angry emails.
A simple weekly routine that keeps it all running
A simple weekly routine that keeps it all running

A simple weekly routine that keeps it all running

Once your system is set up, staying on top of it takes very little time. Try this short routine every week:

  1. Open your stock list and check for anything at or below its reorder point.
  2. Place orders for those items.
  3. Add any new stock that arrived during the week.
  4. Adjust for any offline sales, returns, or damaged goods.
  5. Glance at your best and worst sellers, and make one small decision based on what you see.

Fifteen minutes a week is usually enough for a small store. The goal is not a perfect system. The goal is knowing your numbers well enough to never disappoint a customer or waste your money.

Start with a simple list, count what you have, and connect those numbers to your store today. Once your stock manages itself in the background, you get to spend your time on the fun part: selling more and growing. Ready to get organized? Set up your products and stock in one place and let your store keep the count for you.

#inventory management #online store #ecommerce #stock control #small business

Frequently asked questions

Not for a small store. A simple spreadsheet works when you are starting out. But an online store platform that tracks stock automatically saves a lot of time, because it lowers the count with every sale and hides sold-out items so you cannot oversell.

A SKU is just a short code you create to identify each product, like TSHIRT-RED-M for a red medium shirt. It is not required, but it makes finding and counting items much faster once you have more than a handful of products, especially with different sizes and colors.

Set a reorder point for each item. Look at how many you sell in a week and how long a new order takes to arrive, then reorder before your stock drops below what you will sell during that wait. Add a small cushion so you never hit zero.

You can hide it, mark it as sold out, or let customers pre-order and pay in advance so you keep the sale. Pre-orders also help you learn how many to make next time, which keeps your inventory closer to real demand.

Do one full, honest count when you set up your system. After that, update numbers as things change and do a quick spot check every week or two. A full recount every few months helps catch small errors before they grow.

Ready to build your own website?

Launch a professional website and online store with vq.pe — no code needed.

Get started free