Stock Management for Online Shop: A Simple Guide for Sellers

Few things annoy a customer more than ordering a dress, waiting for a confirmation call, and hearing "Sorry, apu, that one is sold out." Good stock management for an online shop prevents exactly that, and it also stops your money from sitting in products nobody buys.

You don't need warehouse software or an accountant to manage inventory well. This guide shows simple practices that work for small Bangladeshi sellers: a home-based clothing page, a gadget page in Chattogram, or a cosmetics shop selling on Facebook and a website at the same time.

On Facebook, it is easy to keep posting a product after it has sold out. Customers comment "price?", you reply, they order, and only when packing do you realise there is nothing left. Every one of those orders becomes a cancellation and a disappointed customer.

Good stock management helps you:

• Avoid overselling. You only take orders for items you actually have.
• Restock on time. Best sellers don't run out right before Eid.
• Free up cash. You notice slow-moving items and stop buying more of them.
• Find losses. Missing items, damaged returns and mistakes show up in your counts.
• Plan offers. If 40 pieces of a design haven't moved in two months, it is time for a discount.

The good news is that the basics are simple, and they all start with one habit: a single, trusted stock list.

Stock management for online shop basics: one master list

The single most important rule: one product, one stock number, in one place. Not one number in a notebook, another in your head and a third in your website.

For each product, record:

• Product name and a short code, for example "KRT-BLU" for a blue kurti.
• Variant, such as size or colour (more on this below).
• Quantity in stock that is ready to sell.
• Cost price and selling price, so you know the value of your stock.
• Supplier and how many days they take to deliver.
• Reorder point (explained later).
• Location, such as "shelf 2" or "blue box", if you store stock in more than one place at home or in a small godown.

If you use a store platform that tracks stock, that becomes your master list. If not, a single Google Sheet works, as long as everyone who takes orders updates the same sheet.

Avoid overselling across Facebook and your website

Most Bangladeshi sellers take orders in several places: Facebook comments, Messenger, WhatsApp, Instagram, a website and sometimes Daraz. Overselling happens when these channels don't share the same stock number.

Here is how to keep them in sync:

1. Make the website your stock source. If your website reduces stock automatically on every order, treat it as the master list.
2. Enter phone and Messenger orders in the same system. When a customer orders on Messenger, place the order through your website or add it to the same dashboard, so the stock goes down there too. Our guide on Facebook Page vs website for online business explains why this saves so much confusion.
3. Share product links instead of typing prices. When a customer asks about a product in Messenger, send the website link. They see the live price and whether it is in stock.
4. Keep a safety buffer for marketplaces. If you also sell on Daraz or another marketplace with its own stock, list slightly fewer pieces there than you have, and update it daily.
5. Mark sold-out items on Facebook. Edit old posts or comment "Sold out" so people stop ordering them, and point them to similar products.

Reorder points: when to buy more stock

A reorder point tells you when to place a new order with your supplier, so you get new stock before you run out. The simple formula is:

Reorder point = (average daily sales × supplier delivery days) + safety stock

Example 1: Cotton kurti from a Dhaka wholesaler

Suppose you sell about 4 blue kurtis a day. Your wholesaler in Islampur takes 3 days to deliver, and you want a safety stock of 6 pieces in case sales jump.

• Average daily sales: 4
• Supplier delivery days: 3
• Safety stock: 6
• Reorder point: (4 × 3) + 6 = 18 pieces

When stock falls to 18, you reorder. By the time the new batch arrives, you should still have about 6 left.

Example 2: Phone accessories ordered from China

A gadget page in Chattogram sells about 2 power banks a day. Imports take around 20 days, and the seller wants 10 extra as safety stock because shipping times vary.

• Reorder point: (2 × 20) + 10 = 50 pieces

Long supplier times mean a much higher reorder point. Many small sellers run out because they reorder only when the shelf is empty.

Example 3: Home-made food with short shelf life

A home-made pickle business in Sylhet can make a new batch in 2 days. It sells about 5 jars a day, but jars can't be stored too long.

• Reorder (production) point: (5 × 2) + 5 = 15 jars

For perishable products, keep safety stock small and produce more often, rather than making a huge batch that might expire.

Handling variants: sizes, colours and models

Variants are where stock goes wrong most often. "Kurti, 20 pieces" is useless if all 20 are size S and customers want XL.

Track stock for each variant separately:

From this table, you can see immediately that blue L and clear covers need reordering, and that XL is sold out.

Practical ways to manage variants:

• Separate products per variant if your store treats each product with one stock number. For example, list "Blue cotton kurti, size L" as its own product with its own stock, or keep the variant breakdown in your sheet.
• Write sizes on the packet, not just on a list. During packing, mistakes happen when sizes are only remembered.
• Look at which variants sell. If M and L sell three times faster than S, buy fewer S next time.
• Don't post photos of sold-out colours without saying they are out of stock.

Returns and cancellations: putting stock back correctly

With cash on delivery, some parcels come back. If you don't add returned items back to stock, your records show less stock than you have, and you might reorder unnecessarily or turn customers away.

A simple returns routine:

1. Log the return as soon as the courier hands it back. Note the order number and date.
2. Open and inspect each item. Is it undamaged, complete, with tags and packaging?
3. Add sellable items back to stock in your master list.
4. Keep damaged items separate, in a "damaged" list with the reason. Decide whether to repair, sell at a discount, or write off.
5. Look for patterns. If the same product keeps coming back, check the photos and description. Maybe the colour looks different in real life, or the size chart is wrong.

Cancelled orders that never left your shop are simpler: put the stock back immediately. A store that restores stock automatically on cancel or return saves you from forgetting.

High returns are also a sign of fake or impulsive orders. Our guide on reducing fake orders with cash on delivery has practical ways to cut them down.

Monthly stock counts: catching mistakes early

Even with good systems, numbers drift: a piece used for a photo shoot, a gift to a relative, a size swapped during packing. A monthly physical count keeps your records honest.

How to count without losing a whole day:

• Pick a quiet day, early in the month, and pause packing for a couple of hours.
• Print or open your stock list sorted by product code.
• Count each item physically and write the real number next to the system number.
• Investigate differences. If the system says 10 and you have 8, check recent orders, returns and exchanges.
• Update the system with the real counts.
• Note slow movers. Anything that hasn't sold in 60 days is a candidate for a discount, a bundle or a "last pieces" post.

Between monthly counts, do a quick weekly count of your top 10 sellers. These are the products where a mistake costs the most.

Know the value of your stock

Multiply each item's quantity by its cost price and add it up. Suppose you have 120 kurtis at a cost of ৳450 each and 60 sarees at ৳1,100 each. Your stock value is ৳54,000 + ৳66,000 = ৳120,000. Watching this number each month shows whether money is growing in stock that doesn't sell.

Common stock management mistakes

• Trusting memory. "I think we have a few left" leads to cancelled orders.
• Separate lists for each channel. Facebook stock, website stock and Daraz stock drift apart quickly.
• Forgetting returns. Parcels pile up in a corner and never get added back.
• Buying more of everything before Eid. Use your sales data. Buy more of what sells, not of what you hope will sell.
• Ignoring dead stock. Clearing it with a discount is better than letting it lock up your cash for a year.
• Not tracking variants. Total stock looks fine while the sizes customers want are gone.

Good product pages also reduce returns. Clear photos and honest descriptions set the right expectations. See how to write product descriptions that sell and product photography with your phone.

Start selling with EasyMall

EasyMall keeps stock and orders in one place:

• Enter a stock quantity for each product; it shows "out of stock" automatically at 0, so customers can't order what you don't have.
• Stock goes down automatically on each order and goes back when an order is cancelled or returned.
• An orders dashboard with pending, confirmed, delivered, cancelled and returned statuses, searchable by name, phone or order number.
• A website chat assistant that answers "Is this in stock?" from your live stock information.

Facebook Messenger, comment and WhatsApp auto-replies are coming soon. You can create your free store website, free forever with no card or bKash needed.