Inventory Management for Small Business: A Working System

Inventory management for a small store comes down to three questions you should be able to answer at any moment: what do I have, where is it, and when do I need more? Everything else (software, barcodes, warehouses) exists to answer those three questions faster and with fewer mistakes.

This guide lays out a system that works for a store with 20 SKUs in a spare room and still holds at 2,000 SKUs across a warehouse and a 3PL. It has seven parts. You can build the first four in a weekend.

The system on one page

Skip any part and the others start to fail. Reorder points are useless if the stock record is wrong, and the stock record will be wrong if nobody counts.

Part 1: Build a clean item master

The item master is the list of everything you sell, one row per variant. Each row needs at least:

• SKU. One code per variant, never reused. If yours grew up messy, our guide to creating SKU numbers gives a format that scales.
• Description a picker can recognize.
• Unit of measure. Each, pack of 6, case of 24. Decide what one “unit” means and stick to it.
• Landed unit cost. Supplier price plus freight, duties and other costs to get it to your shelf. Our landed cost formula walks through what belongs in it.
• Supplier, supplier SKU, minimum order quantity.
• Lead time in days, measured from your past orders.
• Bin or shelf location.
• Status: active, discontinued, seasonal.

Most stock errors trace back to this list. Two variants sharing a SKU, a pack counted as a single unit, a product sold on two channels under two codes: fix these first.

Part 2: Keep one stock record

You need exactly one place that holds the true quantity of each SKU. For many stores that’s the ecommerce platform. If you sell on several channels, it’s whichever system syncs stock out to the others. Every other number is a copy.

Learn what your system means by “quantity”. Shopify, for example, splits stock into inventory states: On hand is everything at a location, made up of Available, Committed (set aside for things like unfulfilled orders) and Unavailable (held for reasons such as damage, quality control or safety stock), while Incoming is stock on its way that isn’t sellable until received. Shopify’s inventory reports page says that from 1 October 2026 its inventory reports measure stock by On hand rather than Available, so reported quantities can look higher than before that date. If you compare this month’s report with last spring’s, keep that in mind.

Rules that keep the record honest:

1. Every movement gets recorded. Receipts, sales, returns, damages, samples, giveaways, transfers. If stock leaves the shelf without a record, the count drifts.
2. Adjustments carry a reason. “Damaged”, “count correction”, “sample”. Review the reasons monthly; patterns point at problems.
3. One person owns the record. Others can sell and pick. One person approves adjustments.
4. Sync before you sell on a new channel. Overselling usually starts the week a second channel goes live.

Channel buffers for multichannel stores

When the same stock sells on your site, a marketplace and a social shop, each channel learns about a sale a little later than the one that took it. Two customers can buy the last unit within a minute of each other. A simple fix is a buffer: show each channel a little less than you hold, for example on hand minus 2 for A items. The cost is a few units you can’t sell on the last day; the benefit is fewer cancelled orders, which marketplaces can count against your seller account. Set buffers per SKU, starting with the fast sellers, and remove them for slow items where oversells never happen.

Part 3: Receive stock properly

Receiving is where supplier mistakes become your mistakes. A short routine:

1. Match the delivery to the purchase order before you sign, where you can.
2. Count every carton and every unit, by SKU. Don’t trust the packing slip.
3. Note shortages, overages and damage on the PO and photograph damage.
4. Label or bin the stock in its location.
5. Mark the units received in your stock record so they become sellable.
6. Email the supplier about any discrepancy the same day.

Track how many days stock sits between arriving and becoming sellable. That gap is part of your lead time, and it’s the part you control.

Part 4: Count little and often

A full stock count once a year is still worth doing, and your accountant will want the number. But a yearly count only tells you how wrong you were. Cycle counting catches errors weekly.

Cycle counting means counting a small set of SKUs on a schedule so that every SKU gets counted several times a year. To decide how often, rank SKUs with ABC analysis.

ABC analysis, worked through

Example numbers, not benchmarks. Ten SKUs ranked by last year’s revenue:

A common split: A covers roughly the first 80% of revenue, B the next 15%, C the rest. Here three SKUs bring in 77.7% of revenue. You could rank by gross profit instead of revenue if margins vary a lot between products.

Then set the counting rhythm:

Track count accuracy as the share of SKUs counted with no variance:

Count accuracy = SKUs counted with no variance / SKUs counted
Example: 47 / 50 = 94%

Investigate every variance on an A item. A recurring gap on the same SKU usually means a process problem (bundles not deducting components, returns not added back) rather than theft.

Part 5: Set reorder rules

Two questions: when to order and how much.

When: the reorder point

Reorder point = (average daily demand x lead time in days) + safety stock

Order when on hand plus on order, minus units committed to open orders, falls to this number. Safety stock covers the days when demand runs above average. Our worked example of the reorder point formula with safety stock takes one SKU through every step, including how to choose a service level.

How much: economic order quantity as a starting point

The classic economic order quantity (EOQ) balances the fixed cost of placing an order against the cost of holding stock:

EOQ = √(2 x D x S / H)

D = annual demand in units
S = fixed cost per order (admin time, fixed freight, inspection)
H = holding cost per unit per year (storage, capital tied up, shrink)

Example numbers, not benchmarks: D = 6,000 units, S = $50 per order, H = $2 per unit per year.

EOQ = √(2 x 6,000 x 50 / 2)
    = √300,000
    = 548 units (rounded)

Orders per year = 6,000 / 548 = about 11

Treat EOQ as a starting point. Round it to the supplier’s case pack, then check it against their minimum order quantity, price breaks, your cash and your shelf space. If the supplier’s MOQ is 1,000, the math above tells you how much that MOQ costs you in extra holding, which is useful when you negotiate.

Part 6: Watch five numbers

You don’t need a dashboard of 40 metrics. These five tell you whether inventory is working.

1. Inventory turnover. How many times a year you sell through your average stock.

Turnover = cost of goods sold / average inventory value at cost
Average inventory = (beginning + ending) / 2

Example: COGS $180,000; inventory $40,000 at start, $50,000 at end
Average = $45,000; turnover = 4.0

2. Days of inventory. The same idea in days.

Days of inventory = 365 / turnover
Example: 365 / 4.0 = 91 days

3. Weeks of cover per SKU. How long current stock lasts at the current sales rate.

Weeks of cover = units on hand / average weekly unit sales
Example: 600 / 75 = 8 weeks

Compare weeks of cover with lead time in weeks. Cover far beyond lead time plus safety stock means cash is sitting on a shelf.

4. Sell-through rate. Shopify’s report definition is units sold divided by units sold plus units still in stock at the end of the period.

Sell-through = units sold / (units sold + units remaining)
Example: 120 / (120 + 280) = 30%

5. Stockouts. Count the days each A item was out of stock last month. Even one is worth a look, because a stockout on a best seller also costs the sales you never see.

Part 7: Deal with dead stock on a schedule

Every quarter, list SKUs with no sales in 90 days or with more than a set number of weeks of cover (pick a threshold that fits your category). For each one, choose:

• Bundle it with a fast seller.
• Mark it down in steps, with an end date.
• Return it to the supplier if your terms allow.
• Liquidate to a jobber or outlet channel.
• Donate or write off and free the space.

Then stop reordering it. Mark the SKU as discontinued in the item master so nobody buys more by accident.

Tools: what you need at each stage

You don’t need dedicated inventory software on day one. A rough guide by complexity, not by revenue:

Shopify, for one, now includes reports such as ABC product analysis, sell-through rate and days of inventory remaining on that same reports page, so check what your platform already does before adding an app. If you’re weighing a 3PL, see our shortlist of 3PLs for small business; if you mostly need labels and order routing, compare ShipStation alternatives.

The accounting side

Your year-end count isn’t only an ops number. Ending inventory feeds cost of goods sold, which feeds taxable profit. The IRS covers inventory rules, cost methods such as FIFO, LIFO and specific identification, and an exception for small business taxpayers in Publication 538. This is not tax advice; agree a costing method and a count date with your accountant, and keep your count sheets.

An inventory calendar you can copy

Daily: receive deliveries same day; process returns into stock; check for oversells.

Weekly: cycle count A items due this week; review SKUs at or below reorder point and place POs; reconcile with your 3PL if you use one.

Monthly: recalculate reorder points for A items; review adjustment reasons; check turnover, weeks of cover and stockout days.

Quarterly: rerun ABC analysis; recalculate B and C reorder points; dead stock review; supplier lead time review.

Yearly: full physical count; agree valuation with your accountant; clean discontinued SKUs out of the item master.

Common questions

Do I need barcodes? Not to start. You need SKUs. Barcodes speed up receiving, picking and counting once volume makes typing codes slow and error-prone, and some retailers and marketplaces require UPCs for listing.

How accurate does my stock record need to be? Accurate enough that you never oversell an A item. Track count accuracy monthly and aim to push it up every quarter.

Spreadsheet or software? A spreadsheet is fine for the reorder math at almost any size. It struggles as the live stock record once you sell on more than one channel, because nothing syncs automatically.

How often should I recalculate reorder points? Monthly for fast movers and before any seasonal peak; quarterly for the rest.

Start with Part 1 this week. A clean item master makes every later step easier, and it’s the one part nobody can do for you.