Complete Guide to Generating and Printing Barcodes in Bulk
Managing an inventory of several hundred or thousand stock keeping units (SKUs) requires moving beyond one-by-one label printing. Whether you are stocking a growing e-commerce warehouse, cataloging a retail department, or labeling manufactured assemblies, generating barcodes in bulk saves countless hours of repetitive data entry. Our bulk tool allows you to transform standard tabular data—exported directly from Excel, Google Sheets, Shopify, or ERP platforms—into print-ready multi-page label documents within seconds.
1. Preparing Your Spreadsheet (CSV Formatting Guidelines)
The bulk engine accepts standard comma-separated values (CSV) or tab-delimited text. For seamless mapping, structure your spreadsheet with columns corresponding to the following fields:
| Column Field | Accepted Header Names | Required? | Example Value | Formatting Notes |
|---|---|---|---|---|
| Barcode / Code | code, sku, barcode, id, upc, ean |
Yes | SKU-WHT-XL or 012345678905 |
Must match the symbology rules. Numeric only for UPC/EAN; alphanumeric for Code 128 / Code 39. |
| Product Title | title, name, description, product |
Optional | Organic Linen Shirt Light Blue |
Truncated automatically in small label templates to prevent overlap. |
| Price / Subtext | price, cost, mrp, variant |
Optional | $29.99 or ₹1,499.00 |
Displayed below the barcode bars along with currency symbol. |
2. Solving the Dreaded "Dropped Leading Zero" Problem in Excel
The single most frequent pitfall when preparing bulk retail barcodes (UPC-A and EAN-13) in Microsoft Excel is automated number coercion. When you type or paste a 12-digit UPC like 012345678905 into a default Excel cell, Excel interprets it as a mathematical integer and strips the initial zero, resulting in 12345678905 (only 11 digits). Because an 11-digit UPC cannot be rendered legally, barcode generation will fail.
How to Fix Excel Dropped Zeroes Before Export:
- Method A (Text Formatting): Select the barcode column, right-click, choose Format Cells → Text, and only then paste your barcode numbers.
- Method B (Apostrophe Prefix): Prepend an apostrophe before the leading zero (e.g.,
'012345678905). Excel treats the cell as raw string text while keeping the zero intact. - Method C (Formula Reconstruction): If zeroes are already stripped, reconstruct them in an adjacent column using the formula
=TEXT(A2, "000000000000")for 12-digit UPCs, or=TEXT(A2, "0000000000000")for 13-digit EANs.
3. Browser-Side Chunked Processing: Why Speed and Privacy Matter
Traditional web-based bulk generators require you to upload your confidential spreadsheet to remote third-party cloud servers. This presents severe data privacy risks for merchants whose internal wholesale costs, unreleased product codes, and customer SKU lists are exposed to external databases. Furthermore, server-side PDF compilation frequently throttles batches, imposes paywalls after 25 items, or experiences server timeouts when processing 1,000 items.
Our generator utilizes a modern asynchronous chunking pipeline. By processing rows in non-blocking 50-item micro-batches inside your browser's JavaScript event loop, your computer renders hundreds of high-resolution vector and canvas barcodes smoothly without causing browser UI freezes or memory crashes. Crucially, zero bytes of your catalog ever leave your device.
4. Matching Your Batch to the Right Label Sheet Template
When mass-printing labels, selecting the correct die-cut paper template ensures that your barcodes print centered without bleeding off the label boundary:
- Avery 5160 / 8160 (Letter 30-up, 2.625 × 1 inch): The industry-standard size for Amazon FBA FNSKU item labeling, e-commerce polybags, and retail merchandise tags across North America.
- Avery 5163 (Letter 10-up, 4.0 × 2.0 inches): Perfect for warehouse master cartons, secondary packaging, and pallet shipping labels where larger human-readable text is required.
- Avery 5167 (Letter 80-up, 1.75 × 0.5 inches): Ultra-compact return-address size designed for small hardware, cosmetics, jewelry tags, and electronic components.
- A4 24-up Standard (70 × 37 mm): The universal retail and logistics standard across Europe, the United Kingdom, India, and Southeast Asia. Fits European standard A4 desktop laser and inkjet printers.
- A4 65-up Small (38.1 × 21.2 mm): Widely deployed in retail pharmacies, grocery kirana stores, and stationery outlets for individual price tagging.
5. Essential Printer Settings to Prevent Misalignment
Even with mathematically accurate PDF sheets, incorrect physical printer settings will cause creeping vertical alignment drift across multi-page batches. Always apply these three rules before clicking print:
- Set Scaling to 100% or "Actual Size": Never select "Fit to Printable Area", "Scale to Fit", or "Shrink Oversized Pages". These options introduce a 3% to 5% dimensional distortion that causes barcodes to drift off the die-cut labels near the bottom of the sheet.
- Always Print a Plain Paper Test Sheet First: Print one test page on ordinary, inexpensive copier paper. Hold the printed test page directly over an actual sticker sheet against a bright window or lamp to verify that all barcode rectangles align with the die cuts.
- Use the Straight-Through Bypass Tray: Standard multi-purpose trays bend thick sticker paper around internal rollers, which can cause label peeling and heat-induced paper curl in laser printers. Use the manual bypass feed tray whenever possible.
Frequently Asked Questions (FAQ)
What is the maximum number of barcodes I can generate in a single batch?
You can generate up to 1,000 to 1,500 barcodes per batch on most modern laptops and desktops. Because the entire compilation occurs inside local browser memory, performance depends on your device's available RAM. For catalogs containing 10,000+ items, we recommend generating in batches of 500 to 1,000 rows to ensure optimal browser responsiveness.
Is any of my inventory or pricing data sent to your web servers?
Never. All CSV parsing, barcode generation, and PDF document creation happen strictly inside your client browser. Your product descriptions, internal SKUs, and pricing details remain entirely confidential on your local machine.
Can I mix different barcode symbologies in one CSV file?
In the current version, all items in a single batch are rendered using the symbology selected in the "Symbology Format" dropdown (e.g. Code 128 for mixed SKUs or UPC-A for retail items). If you need distinct symbologies, split your CSV into separate files for each format.
Why does the generated PDF have empty label spaces at the end?
Standard die-cut sheets contain fixed counts per page (e.g., 30 labels on Avery 5160). If you generate 45 barcodes, page 1 will contain 30 labels and page 2 will contain 15 labels followed by 15 blank positions. This preserves full alignment for standard sheet stock.
How do I export my inventory from Shopify or WooCommerce into this tool?
In Shopify, navigate to Products → Export → All Products (CSV). In WooCommerce, go to Products → Export. Open the downloaded CSV, ensure the "SKU" or "Barcode" column is present, and either upload the file directly or copy the relevant columns into the text input area.
Are the generated bulk barcodes scannable on mobile phones and laser scanners?
Yes. All linear symbologies (Code 128, UPC-A, EAN-13) and 2D matrices (QR, Data Matrix) follow strict ISO/IEC optical specifications. When printed with standard black toner or ink at 100% scale, they achieve Grade A scannability on all handheld CCD, laser, and 2D image scanners.