A retailer came to us with what she called "an ordering problem." She was always running out of her top sellers and sitting on too much of everything else. She had about 200 SKUs across two locations.

We asked her how she tracked inventory. She opened a notebook.

Not a spreadsheet. Not an app. A physical notebook with hash marks. She had been running a growing retail operation with 200 SKUs across two locations using a system designed for a lemonade stand.

This is more common than anyone admits. And if you have fewer than 30 SKUs in a single location, a notebook might actually be fine. The moment you cross that threshold, something breaks. Usually quietly. Usually expensively.

Here is the build.

The 30 SKU Threshold

Below 30 SKUs in one location, you can hold the entire inventory picture in your head. You know what is running low because you see it. You know what is not moving because you walk past it every day. Manual tracking works because the complexity is low enough for a human brain to manage.

Above 30 SKUs, or the moment you add a second location, that changes. You cannot see everything. You cannot remember everything. The products you forget about are the ones that cost you money, either because they stock out and you lose sales, or because they sit and tie up cash.

The threshold is not about sophistication. It is about cognitive load. Past 30 SKUs, your brain is not the right tool for the job.

What Inventory Management Actually Is

Most small retailers think inventory management means "counting what I have." It does not. Counting is one task inside a system. Inventory management is the system.

The system answers four questions:

  1. What do I have? Exact quantities, by product, by location, right now.
  2. What is moving? Which products are selling, how fast, and is the rate changing?
  3. What should I order? Based on what is selling and how long it takes to arrive, when do I reorder and how much?
  4. What is costing me money? Which products are sitting, which are stocking out, and what is the cash impact of each?

If your "system" cannot answer all four, it is not a system. It is a count.

Build Options: What Actually Works

There are four realistic options for a small retailer. Each has a ceiling. Pick the one that matches where you are now, not where you hope to be in two years.

Option 1. Excel or Google Sheets

Best for: Under 100 SKUs, one location, one person managing inventory.

What you build: A single spreadsheet with columns for SKU, product name, current quantity, reorder point, reorder quantity, last count date, and supplier lead time. You update it manually every time you receive inventory or notice something sold.

The ceiling: It breaks the moment you have more than one person updating it, more than one location, or more than about 100 SKUs. It also breaks when you forget to update it, which you will, because it is manual.

Real cost: Free, plus your time.

Option 2. Shopify (or equivalent e-commerce platform)

Best for: Retailers who sell both online and in-store and already use Shopify POS.

What you build: You are not building anything. Shopify tracks inventory natively. Every online sale decrements the count automatically. If you use Shopify POS in-store, physical sales decrement it too. You set up low-stock alerts, and the system tells you when to reorder.

The ceiling: Shopify's native inventory works well for single-location DTC brands. It gets messy with multiple locations, complex receiving workflows, or wholesale channels. The reporting is also limited: you can see what you have, but velocity analysis and dead stock identification require workarounds or third-party apps.

Real cost: Included in your Shopify plan (starting at 39 USD/month for Basic).

Option 3. POS System with Inventory Built In

Best for: Brick-and-mortar retailers with one to three locations who want sales and inventory in one place.

What you build: Systems like Square for Retail, Lightspeed, or Clover track inventory at the point of sale. Every transaction updates the count. You enter receiving quantities when stock arrives. The system handles the math.

The ceiling: POS inventory systems are designed for retail, not for complex supply chains. If you manufacture your own products, manage raw materials, or have a significant wholesale business alongside retail, you will outgrow the POS system within a year.

Real cost: 60 to 200 USD/month depending on the system and tier.

Option 4. Standalone Inventory Management Software

Best for: Retailers with 500+ SKUs, multiple locations, or complex supply chains.

What you build: Tools like inFlow, Cin7, or Katana are purpose-built for inventory. They handle multi-location tracking, purchase orders, supplier management, barcode scanning, and reporting. They integrate with your sales channels and your accounting software.

The ceiling: Overkill for most small retailers. The setup takes days, not hours. The monthly cost adds up. And the complexity can create its own problems if you do not have someone on the team who owns it.

Real cost: 100 to 500 USD/month depending on the platform and scale.

For the retailer we worked with, the answer was Option 3. She had two locations, a POS she was already using for sales, and no online store. We turned on the inventory features in her existing POS system and built the process around it.

The Four Pillars of Live Inventory

Regardless of which tool you choose, the system only works if four pillars are in place. We call them the Four Pillars of Live Inventory because the goal is a count that is live, meaning it reflects reality right now, not reality as of the last time someone remembered to update it.

Pillar 1. Setup (Do This Once)

Count everything. Every SKU. Every location. Enter the numbers into your system. This is the baseline. Everything that follows depends on this number being right.

Do not skip this step. Do not estimate. Do not enter the numbers from your last purchase order and assume they are close enough. Count it. Enter it. Verify it.

For the retailer, this took two full days across both locations. It was tedious. It was essential.

Pillar 2. Receiving (Every Time Product Arrives)

When inventory arrives, the count gets updated before the product goes on the shelf. Not after. Not at the end of the day. Before it goes on the shelf.

The process:

  1. Compare the delivery to the purchase order. Flag anything missing or damaged.
  2. Enter the received quantity into the system.
  3. Confirm the system count matches the physical count.
  4. Then, and only then, put the product on the shelf.

This is the single most important habit in inventory management. If receiving is sloppy, every number downstream is wrong.

Pillar 3. Sync (Automatic With Every Sale)

If your system is a POS or an e-commerce platform, sales automatically decrement the count. This is the "live" in live inventory. You do not need to do anything for this step if your system handles it.

If your system is a spreadsheet, you need to update it manually after every sale. This is why spreadsheets break past 100 SKUs. Not because they cannot hold the data, but because nobody updates them fast enough.

Pillar 4. Reconcile (Weekly)

Once a week, pick 10-15 SKUs at random and count them. Compare the physical count to the system count. If they match, good. If they do not, investigate why.

Common causes of drift: theft, damage not logged, returns processed incorrectly, receiving errors, and products given away as samples without updating the system.

The weekly reconciliation is not a full inventory count. It is a spot check. Its purpose is to catch drift before it compounds. A 2-unit discrepancy this week is an annoyance. That same 2-unit discrepancy compounding over three months is a 50-unit gap and a 1,200-dollar problem.

What Changes After Setup

Within the first month, three things happen:

You stop running out of your best sellers. Because you can see the count and the trend, you reorder before you hit zero. The retailer we worked with went from 5-6 stockouts per month to zero in the first 30 days. Her revenue on those products increased 22% just from availability.

You see the dead stock. Products that have not moved in 90 days become visible. The retailer found 11,000 in inventory that had not sold a single unit in four months. She ran a clearance event and recovered 6,500 in cash.

You make better purchasing decisions. Instead of ordering based on gut feel ("I think we are running low on this"), you order based on data. Reorder points are set for each SKU based on sales velocity and supplier lead time. The system tells you when to order and how much. Overordering dropped by roughly 30%.

None of this required expensive software. It required a process that was followed consistently.

The Monday Morning Ask

Here is the weekly practice that holds the system together. Every Monday morning, answer three questions:

  1. What is at or below its reorder point? Place those purchase orders today.
  2. What has not sold a single unit in the last 30 days? Flag it. If it has not sold in 60 days, it goes on the clearance plan.
  3. Did the weekly reconciliation spot check pass? If not, investigate the discrepancies before they compound.

Fifteen minutes. Monday morning. Non-negotiable.

The retailer with the notebook now runs her entire inventory operation in those fifteen minutes plus the daily habit of logging receiving. She went from "I think we have some of those in the back" to "we have 14 units across both locations, selling 3 per week, reorder triggers in 4 days." That is the difference between managing inventory and guessing.

Ops Intel

Signals we are tracking this week:

Shopify Q1 2026 earnings showed GMV (gross merchandise volume) up 23% year-over-year. More interesting for retailers: Shopify reported that merchants using their inventory management features had 15% lower stockout rates than those who did not. The tool is free if you are already paying for Shopify. Turn it on.

Cocoa prices remain elevated above 8,000 USD per metric ton. If you are a retailer carrying chocolate or cocoa-based products, your suppliers are absorbing cost increases. Expect wholesale price adjustments. Update your cost sheets and margin models before the invoices arrive.

SMB tariff exposure is widening. The latest round of tariff adjustments affects imported consumer goods across multiple categories. If your suppliers import raw materials or finished products, your landed cost is changing. Ask your suppliers directly: "Have your costs changed in the last 90 days?" If they say no, ask again in 30 days.

Drewry's World Container Index continues to trend upward. Shipping costs from Asia to North America are 12-15% higher than six months ago. Every retailer who sources products internationally is feeling this in their landed cost. If you have not renegotiated freight terms since last year, do it now.

The NRF (National Retail Federation) reported that retail shrinkage hit 112 billion in 2023, up from 94 billion the year before. Shrinkage includes theft, damage, and administrative errors. For small retailers, administrative errors (receiving mistakes, miscounts, returns processed wrong) are the largest category. The Four Pillars of Live Inventory address every one of them.