Inventory Labeling for Small Business: A Simple Spreadsheet Workflow

Why Barcode Labels Matter for Small Business

Manual inventory counts are slow and error-prone. Without labels, staff must visually identify every product, remember where things are stored, and manually record movements. Barcode labels let you scan items in and out with a handheld scanner, find products in seconds, and reduce picking errors — even with a basic USB scanner that costs €15 and a free spreadsheet.

The Core Principle: One Code Per Item

Every product in your inventory should have one consistent code — usually called a SKU (Stock Keeping Unit). This code becomes the value encoded in the barcode. It should be the same code you use in your spreadsheet, your orders, and your receipts. Consistency is what makes a barcode system work: when you scan a label, the same SKU appears everywhere it matters.

Step 1: Build Your Inventory Spreadsheet

• SKU or product code (required — this becomes the barcode value)
• Product name (shown on the label for human readability)
• Category or storage location (helps with picking)
• Current stock quantity (for your records)
• Reorder point (optional, for restocking alerts)
• Supplier or cost price (optional, for purchasing)

Step 2: Assign SKUs Consistently

Create a simple SKU format and stick to it. Common patterns include: category prefix + number (e.g., ELEC-001, SHOE-042), supplier code + item number, or a simple sequential number (001, 002, 003). Avoid spaces, special characters, or very long codes — shorter codes produce narrower barcodes that print more reliably on small labels.

Step 3: Generate Barcode Labels

Export your spreadsheet as CSV (File > Save As > CSV in Excel, or File > Download > CSV in Google Sheets), then upload it to barcodemaker.xyz. Select the SKU column as your barcode value, and optionally display the product name below the barcode for human reference. Click Generate PDF and download your label sheet.

Step 4: Label Everything Consistently

• Shelves and bins — print location labels (e.g., SHELF-A-03-BIN-2) so your scanning system knows where each product lives
• Products themselves — attach a label to every unit or its packaging before it goes on the shelf
• Receiving area — label items as they arrive to log new stock immediately
• Boxes and pallets — for outgoing shipments or storage tracking

Step 5: Maintain Your Label System

A barcode system only works if labels are kept intact and up to date. Replace damaged labels immediately. When you receive new stock, print labels for the new units before they go into inventory. Update your SKU list in the spreadsheet whenever you add a new product. Consider printing a small batch of spare labels for each SKU to replace worn-out ones quickly.

Tools You Need (All Free or Low Cost)

• Spreadsheet: Excel, Google Sheets, or LibreOffice Calc (free)
• Barcode generator: barcodemaker.xyz (free, browser-based)
• Label printer: any laser printer + A4 label sheets (approximately €10 per 100 sheets)
• Barcode scanner: any USB barcode scanner (approximately €15–€30)
• Optional: a mobile app that scans barcodes to log inventory movements

Common Mistakes to Avoid

• Using the same SKU for different product variants (each size or color should have its own SKU)
• Printing labels without testing the scanner first
• Applying labels in positions where they will be worn off or scanned from awkward angles
• Not backing up your master SKU spreadsheet

Start labeling your inventory today — free