You Don't Need a $300/Month Inventory System
Most inventory management software is built for warehouses moving thousands of SKUs a day. If you're a small product-based business with 20-200 products, paying $100-300 per month for enterprise inventory tools is like renting a semi-truck to pick up groceries.
The good news: you can track inventory effectively with tools you already have or can get for free. The method matters more than the software. Here's how to track inventory for a small business without blowing your budget.
Start With a Spreadsheet (Seriously)
A well-organized spreadsheet handles inventory for most small businesses surprisingly well. Google Sheets is free. Excel comes with most computers. Either one works.
Set up your spreadsheet with these columns:
- Product Name - exactly as you list it for sale
- SKU or Product Code - a short code you assign (like CNDL-LVN-8OZ for an 8oz lavender candle)
- Current Stock - how many you have right now
- Par Level - the minimum stock before you reorder
- Reorder Quantity - how many you order each time
- Unit Cost - what each unit costs you to make or buy
- Supplier - where you get it
- Last Restocked - date you last added stock
Update the "Current Stock" column every time you make a sale or receive new inventory. That's it. That's the system.
One tip that makes a big difference: set up conditional formatting so any cell in "Current Stock" turns red when it drops below the par level. In Google Sheets, go to Format > Conditional Formatting and set the rule. Now low-stock items scream at you visually instead of hiding in a list of numbers.
What Are Par Levels and Why Do They Matter?
A par level is the minimum quantity you should have on hand before placing a new order. Setting good par levels is the single most important thing you can do for inventory management, and it costs nothing.
Here's the formula:
Par Level = (Average weekly sales x Lead time in weeks) + Safety stock
An example: You sell about 12 units of a product per week. Your supplier takes 2 weeks to deliver. You want 1 week of safety stock just in case.
Par Level = (12 x 2) + 12 = 36 units
When your stock hits 36, it's time to reorder. You'll have enough to cover the 2-week wait plus a buffer for unexpected demand. If your supplier is reliable, one week of safety stock is fine. If they've been late before, bump it to two weeks.
Physical Tracking vs. Digital Tracking
Some businesses track inventory purely in a spreadsheet. Others use physical methods. The best approach for most small businesses is both.
Physical Methods That Work
The two-bin system: Split your stock into two bins. Pull from the first. When it's empty, that's your signal to reorder. Start selling from the second bin while you wait. This works beautifully for supplies and components, not just finished products.
Labeled shelves: Put a sticky note on each shelf section showing the product name and par level. A pottery studio owner I know uses clothespins on a wire, one per unit, and removes a pin with each sale. When the pins are gone, she reorders.
The reorder box: Keep an empty box near your inventory area. When any product hits its par level, toss a note into the box. At the end of each week, place orders for everything in the box.
When Physical Tracking Falls Short
Physical methods work great when you sell in one location. They break down when you're selling across multiple channels, like an Etsy shop, a website, and weekend markets. If you sell three candles at a farmers market on Saturday and two through Etsy on Sunday, your bin system at home doesn't know. That's where digital tracking becomes necessary, even if it's just updating your spreadsheet at the end of each selling day.
Cycle Counting: The Habit That Prevents Disasters
Full inventory counts are painful and usually happen once a year. By the time you find a discrepancy, you've been selling from wrong numbers for months.
Cycle counting is better. Instead of counting everything at once, you count a small portion on a regular schedule:
- Weekly: Count your top 10 best-selling products (the most transactions means the most likely errors)
- Monthly: Count a different category each month, rotating through everything over a quarter
- After every market or event: Count what you brought versus what you brought back
A cycle count for 10 products takes about 15 minutes. When you find a discrepancy, adjust the spreadsheet and note the difference. If the same product keeps showing discrepancies, you have a process problem, maybe you're forgetting to log sales from a specific channel.
When You've Outgrown the Spreadsheet
Spreadsheets stop working well when one or more of these becomes true:
- You have more than 200 active SKUs
- You're selling on three or more channels simultaneously
- Multiple people need to update inventory at the same time
- You're spending more than 30 minutes a day on inventory updates
At that point, you need something more structured. Order management tools like OrderHelm let you track products and orders in one place so stock levels update as sales come in, without you manually editing cells. The goal is connecting orders to inventory automatically.
Common Inventory Mistakes
Not tracking raw materials
If you make your products, tracking finished goods isn't enough. A soap maker might have 50 bars on the shelf but only enough essential oil to make 20 more. Track your ingredients with the same par level system.
Counting inventory at retail price
Your inventory value should be based on cost, not selling price. If you have 100 items that cost $5 each to produce, your inventory value is $500, not the $2,000 you'd get selling them. This matters for taxes and understanding your cash position.
Holding too much stock
Unsold inventory is cash you cannot spend on anything else. Try to keep no more than 4-6 weeks of supply on hand for each product. Seasonal businesses are the exception.
No system for dead stock
Dead stock is inventory that hasn't sold in 90+ days. Set a rule: if something hasn't moved in 90 days, discount it 25-30%. If it still doesn't sell after 30 more days, bundle it with popular items or donate it for a tax write-off.
Updating inventory "later"
The number one reason counts go wrong is delayed recording. You make a sale and think "I'll update the spreadsheet tonight." Then you forget. Update your numbers as close to real-time as you can. If you're at a market, keep a tally sheet and update the spreadsheet before you unload your car at home.
The 15-Minute Weekly Routine
Here's a weekly habit that keeps your inventory accurate:
- 5 minutes: Cycle count your top 10 products. Fix discrepancies.
- 5 minutes: Check anything highlighted in red (below par level). Add those to your reorder list.
- 5 minutes: Place reorders and update the "Last Restocked" column.
Consistency beats intensity with inventory. A small business owner who spends 15 minutes every Monday on inventory will always have better numbers than one who does a panicked full count once a quarter. Start simple, and upgrade your tools only when the manual version genuinely can't keep up.