If you run a small business — whether you're selling handmade jewelry on Etsy, flipping vintage finds on eBay, stocking a food truck, or managing job-site supplies as a contractor — you've already dealt with inventory chaos. You know the feeling: a customer orders something you thought you had, you buy supplies you already own, or you waste an entire Saturday counting stock instead of making sales.
The inventory management industry wants to sell you a $50/month subscription. For most small businesses under 1,000 items, that's overkill. This guide covers what actually works at each stage of growth, with specific advice for different business types. No theory. Just the systems that real small business owners use.
Most small businesses start tracking inventory in a spreadsheet or a notebook. That works — until it doesn't. Here are the warning signs that your current system has hit its ceiling:
If two or more of these sound familiar, it's time to level up. But that doesn't mean jumping straight to enterprise software. There's a middle ground that most guides skip over.
Think of inventory systems on a spectrum. The right choice depends on your item count, how many people handle stock, and whether you sell through multiple channels.
A Google Sheets spreadsheet with five columns covers most micro-businesses:
This is completely free and works great for businesses with fewer than 100 distinct items. The weakness: it only works if you religiously update it after every sale and every restock. Most people don't. The spreadsheet gets stale, and then you stop trusting it, and then you stop using it.
If you're just starting out and have a small product line, start here. It costs nothing and teaches you the habits that matter at every level: recording what you have, where it is, and when to reorder.
This is the sweet spot for most small businesses, and it's the level that gets overlooked. The concept is simple: stick a physical QR label on every shelf, bin, drawer, or storage area. Scan the label with your phone to instantly see what's inside — including photos.
The key advantage over a spreadsheet is that you don't need to search for information. Walk up to any bin, scan the label, and you know exactly what's in it. No scrolling through rows. No opening your laptop. Just point your camera and look.
Tools like 2PACK let you stick a QR label on a shelf or bin and instantly pull up photos and item lists from any phone. You can add multiple photos per container, organize by location, and search your entire inventory from a browser. The app is free with no subscription, and label packs start at $5.99.
This level works well from about 100 to 1,000 items. It handles the "where is it?" problem that spreadsheets can't solve, and it's fast enough that you'll actually use it. The physical label is the key — it ties digital records to real-world locations. When you walk into your stockroom, you're not relying on memory or a spreadsheet row number. You're scanning a label that's right there on the shelf.
For a deeper look at choosing the right labels, check our QR storage labels buying guide.
When you have more than 1,000 SKUs, sell through multiple channels (your own website plus Etsy plus Amazon), or run multiple warehouse locations, dedicated software starts to earn its cost. Options include:
The upside of dedicated software is automation: when someone buys on your website, stock counts update instantly. The downside is cost, complexity, and the fact that you're now maintaining a software system on top of running your business. For the full breakdown of free options, read our best free inventory app comparison.
Don't jump to Level 3 until Level 2 feels limiting. Many businesses with 500–800 items run beautifully on QR labels and never need subscription software.
Whether you're starting from zero or rebuilding a system that fell apart, here's how to set up inventory tracking that actually sticks. This works for any small business type.
Before you count anything, decide on your categories. Most small businesses need three:
Keeping these separate matters because they have different reorder cycles, different values, and different tax treatments (more on that below). Don't lump everything into one giant list.
Every item needs an address. Get specific:
Walk through your space and name every storage area. Use a consistent format: Room > Shelf/Rack > Bin/Position. Write it down. This location map is the backbone of your system — without it, you have a list of stuff with no way to find any of it.
If you're using QR labels, each label corresponds to one location. You don't need to memorize or look up addresses. Just scan.
Labels turn a vague storage area into a findable location. At minimum, use a label maker or hand-written tags on each shelf, bin, and drawer. For faster lookup, use QR code labels that link to digital records with photos and item lists.
Label the location, not just the container. If a bin moves, the shelf label still tells you what should be there. If a bin has its own label, even better — you can track it regardless of where it ends up.
For every item you regularly restock, define a reorder point — the quantity at which you need to place an order. Calculate this based on:
Write reorder points directly in your spreadsheet or add them to your QR label notes. When you scan a bin and see you're at or below the reorder quantity, it's time to order.
The best inventory system in the world drifts if you don't verify it. Schedule counts and stick to the schedule:
The rolling approach is less painful than a single massive count and catches errors faster. If you're using a QR system, you can scan bins as you count — it's significantly faster than cross-referencing with a spreadsheet.
Track raw materials and finished products as separate inventories. This is the mistake most craft sellers make — they track what's listed on Etsy but not the supplies needed to make more. When a bestseller sells out, you need to know immediately whether you have materials to make another batch or need to order.
Also track work-in-progress. If you have 10 half-finished items on your workbench, those aren't finished goods yet, and the raw materials used for them shouldn't still appear in your supply counts.
Photo documentation is your inventory system. Every item you buy for resale should be photographed immediately — condition, labels, defects, everything. This serves triple duty: it's your inventory record, your listing photo source, and your proof of condition if a buyer files a dispute.
Use QR labels on your shelving. When it's time to list an item, scan the label and you've got all the photos and notes right there. No digging through camera roll folders trying to remember which shoes were on which shelf. The photo and search features in a tool like 2PACK are built for exactly this workflow.
Your inventory moves. That's the fundamental challenge. Supplies travel from your shop to a job site and back (sometimes). Tools walk off. Partial boxes get left in trucks.
The fix is labeling your vehicle and job-site storage, not just your shop. Put a QR label on each truck toolbox, each job-site bin, and each shop shelf. Before leaving a job site, scan the bins to verify nothing got left behind. This also helps with billing — if you need to charge a client for materials used, the scan history shows exactly what went to their site.
FIFO (first in, first out) is non-negotiable. New stock goes behind old stock. Every container needs a received date and an expiration date. No exceptions.
Use your labeling system to include dates. When you scan a bin, the notes should show when the contents arrived and when they expire. During your weekly count, check for anything approaching its expiration date and move it to a "use first" area. Toss anything expired. Track shrinkage (waste from expired or spoiled inventory) — you'll need that number for tax purposes and for adjusting your order quantities.
These are the reasons most small business inventory systems fail within three months:
Inventory tracking isn't just operational — it directly affects your tax bill. If you sell physical products, the IRS expects you to track cost of goods sold (COGS), and accurate inventory records are the foundation of that calculation.
Here's what matters:
Talk to your accountant about which inventory valuation method (FIFO, LIFO, or average cost) makes sense for your business. But regardless of method, the underlying requirement is the same: you need to know what you had, what you bought, and what you have now.
A Google Sheets spreadsheet with columns for item, quantity, location, and photo link. That's free. When you outgrow it, QR labels (under $10 per pack) paired with a free scanning app like 2PACK give you photo-based inventory tracking with no monthly cost. You can be up and running for under $20 total.
Spot-check your highest-value items weekly (15 minutes). Count one full category monthly on a rotating basis. Do a complete count quarterly. If you use a QR label system, you can do rolling counts by scanning a few bins each day instead of shutting down for a single big count day.
Not until you exceed roughly 1,000 SKUs, sell through multiple online channels, or operate from multiple locations. Below that threshold, a spreadsheet (under 100 items) or a QR label system (100–1,000 items) handles the job without monthly fees. See our free inventory app guide for detailed comparisons.
Add a location field to every item record. In a spreadsheet, that's an extra column. With QR labels, each label is tied to a specific physical spot, so scanning automatically tells you what's at each location. The key is consistency — use the same naming convention everywhere (e.g., "Workshop-A3" and "Storage Unit-B1") so you can filter and search by location.
Ready to organize your business inventory? Try 2PACK free · Get QR labels from $5.99 · Small business features