Barcode and SKU Systems for Coin Inventory

Q: Should I use certification numbers as SKUs for graded coins?

Yes, certification numbers make excellent SKUs for certified coins. They're already unique, enable direct verification with grading services, and customers recognize them. Add a prefix to indicate the service (PCGS-12345678, NGC-1234567001) for clarity. The main limitation is that this approach only works for certified coins—you'll need a different scheme for raw coins and bullion.

Q: What's the best barcode type for coin inventory?

Code 128 is the best choice for most coin dealer operations. It supports alphanumeric characters, is widely compatible with scanners, and handles SKU-length identifiers well. For customer-facing applications like linking to certification verification, QR codes work better since customers can scan them with smartphones. Many dealers use Code 128 internally and QR codes externally.

Q: How do I label coins without damaging them?

Never apply adhesive directly to coins. For certified coins, label the holder edge (using removable adhesive), use a flip insert around the holder, or label the storage location instead of the coin. For raw coins in flips, label the flip rather than the coin. Consider using certification numbers directly (already printed on holders) to avoid labeling altogether.

Q: What scanner should I buy for a small coin business?

For a small operation (under 500 SKUs), start with smartphone scanning apps or a single wired handheld scanner ($50-150). Smartphone scanning costs nothing extra and handles occasional use well. As volume grows, add a wireless handheld scanner for mobility during counting and a wired scanner at your packing station. Don't over-invest initially—upgrade as needs become clear.

Q: How should I structure SKUs for raw coins?

Use a hybrid approach combining category information with a unique sequence: [CATEGORY]-[SERIES]-[DATE][MINT]-[SEQUENCE]. Example: RAW-MOR-1889O-0042 for a raw Morgan dollar, 1889-O, item #42 in that category. This encodes useful information while maintaining uniqueness through the sequence number. Keep consistent length for easier handling.

Q: How do I handle SKUs for bullion with multiple identical units?

For fungible bullion (identical items), use quantity-based SKUs rather than individual identification. Create one SKU for "1 oz American Silver Eagle" and track quantity. For premium bullion or when individual tracking matters, add sequence numbers: GOLD-AGE-1OZ-0156. Label tubes or containers rather than individual coins for efficiency.

Q: What label printer should I use?

For small operations, a standard inkjet/laser printer with sheet labels works fine for occasional needs. For regular labeling, a thermal label printer (like DYMO or Zebra) is more efficient—no ink to replace and faster printing. Direct thermal is cheaper but labels can fade; thermal transfer produces more durable labels. Match investment to volume.

Q: How do I migrate existing inventory to a SKU system?

Several approaches work: "as-touched" (label items when handling them anyway), category-by-category systematic migration, or new-items-only (label only incoming inventory, existing migrates over time). Avoid "big bang" unless you can dedicate significant time. Most dealers find category-by-category works well, starting with highest-value or highest-velocity categories.

Q: What if my barcode won't scan?

Common causes: damaged or dirty label, insufficient contrast, label too small, no quiet zone (clear space around barcode), or scanner not configured for barcode type. Try cleaning the label and scanner window, checking label quality, and verifying scanner settings. Have a backup process for manual SKU entry when scanning fails. Replace damaged labels promptly.

Q: How do I keep my SKU system organized over time?

Establish governance: limit who can create new SKUs, enforce format through system validation, prevent duplicates, document the SKU structure, and conduct periodic audits for duplicates, orphaned SKUs, and format violations. Train new staff on proper SKU use. Review and update documentation when making changes to the structure.

A well-designed SKU system is the backbone of efficient inventory management. When every item has a unique identifier that can be quickly scanned or referenced, operations accelerate: picking becomes faster, counting becomes more accurate, errors decrease, and tracking becomes automatic. For coin dealers managing hundreds or thousands of unique items, the difference between a thoughtful SKU system and a haphazard approach shows up in every operational activity.

This comprehensive guide covers SKU design principles specifically adapted for numismatic inventory, barcode technology options, labeling strategies for different coin types, scanning hardware selection, and implementation approaches. Whether you're establishing a SKU system for the first time or redesigning an existing one that's grown unwieldy, these principles help you create an identification system that serves your business for years to come.

SKU System Fundamentals

Before diving into design specifics, understand what makes SKU systems effective and why they matter for coin dealers.

What is a SKU?

A Stock Keeping Unit (SKU) is a unique identifier for a specific item in your inventory. Unlike UPCs (Universal Product Codes) which identify products globally, SKUs are internal to your business and can be designed to serve your specific needs.

Identifier Type	Scope	Who Assigns	Best Use
SKU	Your business only	You	Internal inventory management
UPC	Global	GS1 organization	Retail scanning, Amazon
PCGS/NGC Cert #	Global	Grading service	Authentication, verification
Model #	Manufacturer	Product maker	Identifying product type

Why SKUs Matter for Coin Dealers

Effective SKU systems enable multiple operational benefits:

Unique identification: Every item has one identifier that can't be confused
Scanning capability: Barcodes enable rapid, error-free data capture
Cross-platform consistency: Same identifier across website, eBay, shows, accounting
Search and retrieval: Quickly find items in system and physical location
Transaction tracking: Every sale, receipt, adjustment tied to specific item
Reporting: Analyze performance by product, category, or time period

SKU vs Certification Number

For certified coins, a key decision: use certification numbers as SKUs or create your own?

ℹ️ Cert Number as SKU

Advantages:

Already unique—no assignment needed
Enables direct verification with grading service
Customer recognition and trust
No label required—number on holder

Disadvantages:

Only works for certified coins
Long numbers (8-10+ digits)
No encoded information (category, value, etc.)
Mixed formats between services (PCGS vs NGC)

Recommendation: Use certification numbers as primary identifier for certified coins, but consider a prefix to indicate grading service (PCGS-12345678, NGC-1234567001).

Designing SKUs for Coin Inventory

Well-designed SKUs encode useful information while remaining manageable. Several design approaches exist.

Intelligent vs Non-Intelligent SKUs

The fundamental design choice:

Approach	Description	Example	Pros/Cons
Intelligent SKU	Encodes product information	US-MOR-1889O-MS64	Informative but complex; can run out of codes
Non-intelligent SKU	Sequential or random identifier	00012847	Simple, unlimited; requires lookup for info
Hybrid	Category prefix + sequential	MOR-00842	Some info encoded; manageable complexity

SKU Structure Components

For intelligent or hybrid SKUs, consider these components:

Category code: Type of item (US, WLD, BUL for US coins, world, bullion)
Series code: Specific series (MOR, PEA, WLK for Morgan, Peace, Walking Liberty)
Date: Year of coin (1889, 1921, etc.)
Mint mark: Mint indicator (S, O, D, CC, P)
Grade: Condition designation (MS64, AU55, VF30)
Grading service: PCGS, NGC, RAW
Sequence: Unique number for items that otherwise match

SKU Design Best Practices

💡 SKU Design Guidelines

Consistent length: Easier to work with and display
No special characters: Avoid spaces, slashes, symbols that cause system issues
Case insensitive: Design assuming systems may change case
Memorable pattern: Staff can recognize category from SKU
Room to grow: Leave space for new categories and sequences
Avoid confusion: No O/0 or I/1 ambiguity in critical positions

Sample SKU Structures

For certified coins:

Format: [SERVICE]-[CERT NUMBER]
Examples:
  PCGS-12345678     (PCGS certified coin)
  NGC-1234567001    (NGC certified coin)
  ANACS-98765432    (ANACS certified coin)

For raw coins:

Format: [CATEGORY]-[SERIES]-[DATE][MINT]-[SEQUENCE]
Examples:
  RAW-MOR-1889O-0042    (Raw Morgan dollar, 1889-O, item #42)
  RAW-WLK-1943S-0008    (Raw Walking Liberty, 1943-S, item #8)
  RAW-GLD-1927-0003     (Raw $20 gold, 1927, item #3)

For bullion:

Format: [METAL]-[TYPE]-[WEIGHT]-[SEQUENCE]
Examples:
  GOLD-AGE-1OZ-0156     (1 oz American Gold Eagle, item #156)
  SILV-GEN-1OZ-0847     (1 oz generic silver round, item #847)
  SILV-AGE-1OZ-0312     (1 oz American Silver Eagle, item #312)

Barcode Types and Technologies

Once you have SKUs, barcodes enable rapid scanning. Several barcode types serve different purposes.

1D Barcodes (Linear)

Traditional barcodes with vertical lines:

Type	Capacity	Best For
Code 128	~20 characters	General purpose, most flexible
Code 39	~15 characters	Alphanumeric, widely compatible
UPC-A	12 digits	Retail scanning, requires GS1 registration
EAN-13	13 digits	International retail

Recommendation for coin dealers: Code 128 offers the best balance of capacity, compatibility, and flexibility for internal SKUs.

2D Barcodes

Matrix patterns that store more information:

Type	Capacity	Best For
QR Code	~3,000 alphanumeric	Customer-facing, smartphone scanning, URLs
Data Matrix	~2,000 alphanumeric	Small labels, industrial use
PDF417	~1,800 alphanumeric	IDs, shipping labels, large data

Choosing Between 1D and 2D

ℹ️ When to Use Each Type

1D (Code 128): Internal operations, standard scanning, simple labels
2D (QR Code): Customer-facing uses, linking to web pages, mobile scanning
2D (Data Matrix): Very small labels where space is limited

Many dealers use 1D for internal operations and QR codes for customer-facing applications like linking to certification verification pages.

Barcode Generation

Ways to create barcodes from your SKUs:

Label printing software: Dedicated barcode label programs
Inventory management systems: Built-in barcode generation
Online generators: Web tools for occasional needs
Spreadsheet add-ins: Excel/Google Sheets barcode functions
E-commerce platforms: Some platforms generate product barcodes

Labeling Strategies for Coins

Applying labels to coin inventory requires strategies that work with the physical nature of numismatic items.

Labeling Certified Coins

Coins in holders present specific labeling considerations:

Holder label: Small label on holder edge or back (doesn't obscure coin)
Flip insert: Label inside protective flip around holder
Storage location label: Label the storage slot rather than the coin
No label needed: Use certification number directly (printed on holder)

⚠️ Labeling Precautions

Never apply adhesive directly to coin surface
Avoid labels that could damage holder finish
Use removable adhesive if labeling holders
Consider customer presentation—labels visible to buyers?

Labeling Raw Coins

Strategies for coins not in certified holders:

Flip label: Label on the 2x2 flip containing the coin
Envelope label: For coins in paper envelopes
Tray position: Label the tray slot, not the coin/holder
Tag attachment: Small tag on protective packaging

Labeling Bullion

Bullion items often come in tubes, rolls, or bulk:

Tube labels: Label on coin tube with SKU and quantity
Roll wraps: Printed wrapper with identification
Bin/box labels: Label storage container rather than individual items
Individual labels: For premium bullion (numismatic gold, etc.)

Label Specifications

Technical requirements for scannable labels:

Specification	Recommendation	Notes
Minimum size	1D: at least 1" wide; 2D: at least 0.5"	Smaller = harder to scan reliably
Contrast	Black on white preferred	High contrast ensures scan reliability
Quiet zone	Clear space around barcode	Required for scanner recognition
Material	Durable, non-smearing	Thermal or laser printed labels

Label Printer Options

Thermal transfer: Durable labels, higher cost per label
Direct thermal: Lower cost, labels can fade over time
Laser: Sheet labels, good for batches
Inkjet: Occasional use, may smear if wet

Scanning Hardware Selection

The right scanning hardware matches your volume, environment, and operational style.

Scanner Types

Type	Best For	Price Range
Handheld wired	Stationary workstation, high volume	$50-200
Handheld wireless	Mobility, warehouse counting	$100-400
Presentation scanner	Hands-free, checkout counter	$150-500
Mobile device + app	Flexibility, occasional use	Free-$50 (app cost)
Mobile computer	Enterprise, rugged environment	$500-2,000+

Key Scanner Features

Features to consider when selecting scanners:

1D vs 2D capability: 2D scanners read both types; 1D only reads linear
Scan distance: How far can scanner be from barcode?
Scan speed: Scans per second for high-volume operations
Connectivity: USB, Bluetooth, WiFi options
Durability: Drop rating for warehouse use
Ergonomics: Comfortable for extended use

Smartphone Scanning

Modern smartphones can serve as scanners:

💡 Smartphone Scanning

Advantages:

No additional hardware cost
Always available
Can run inventory apps directly
Camera improves with each generation

Limitations:

Slower than dedicated scanners
Battery drain with heavy use
May struggle with damaged/poor barcodes
Awkward for high-volume scanning

Scanner Recommendations by Operation Size

Small dealer (< 500 SKUs): Smartphone scanning or single handheld wired scanner
Medium dealer (500-5,000 SKUs): Wireless handheld for mobility + wired for workstation
Large dealer (5,000+ SKUs): Multiple wireless scanners, mobile computers for warehouse

System Integration and Software

Scanners and labels are only useful when integrated with your inventory management systems.

Integration Points

Where scanning connects to your systems:

Receiving: Scan incoming items to add to inventory
Picking: Scan to confirm correct item picked for orders
Packing: Scan to verify items before shipping
Counting: Scan during inventory audits for accuracy
Point of sale: Scan to add items to transaction
Location tracking: Scan item and location to record placement

Software Requirements

Your inventory system should support:

Barcode field: Store barcode/SKU for each item
Scan input: Accept scanner input into search/entry fields
Label generation: Create labels from inventory data
Mobile access: If using smartphone scanning, mobile-friendly interface
Batch processing: Handle multiple scans efficiently

E-commerce Platform Integration

Connect SKUs to your selling platforms:

Platform	SKU Field	Notes
WooCommerce	SKU field in product data	Native support, searchable
Shopify	SKU in inventory section	Per-variant SKUs supported
BigCommerce	SKU field in product details	Required for inventory tracking
eBay	Custom label (SKU) field	Helps with inventory reconciliation

Implementation Process

Rolling out a SKU/barcode system requires careful planning, especially for existing inventory.

Planning Phase

Audit current state: How is inventory currently identified?
Define SKU format: Design the structure you'll use
Select technology: Barcode type, scanners, labels, printers
Map workflows: Where will scanning happen?
Plan migration: How will existing inventory get SKUs/labels?

Pilot Implementation

💡 Start Small

Before full rollout, pilot with a subset of inventory:

Select one category (e.g., Morgan dollars)
Assign SKUs to items in that category
Create and apply labels
Test scanning workflows
Identify issues before scaling

Existing Inventory Migration

Approaches for applying SKUs to existing inventory:

Big bang: Label everything at once (requires significant effort)
As-touched: Label items when they're handled for other reasons
Category by category: Systematic migration through inventory segments
New items only: Only new inventory gets labels; old items migrated over time

Training

Train staff on new processes:

SKU understanding: What SKUs mean and how to interpret them
Scanner operation: How to use scanning hardware properly
Workflow changes: New steps in receiving, picking, counting
Troubleshooting: What to do when scans fail
Label handling: How to create and apply labels correctly

Maintenance and Governance

SKU systems require ongoing maintenance to remain effective.

SKU Assignment Governance

Establish rules for SKU creation:

Who can create: Limit SKU creation to trained personnel
Format enforcement: System validates SKU format
Duplicate prevention: System checks for existing SKUs
Category codes: Maintain approved list of category codes
Documentation: Keep SKU structure documentation current

Label Maintenance

Keep labels readable and current:

Regular inspection: Check labels during handling for wear
Replacement protocol: Process for replacing damaged labels
Label quality: Use durable materials appropriate for storage conditions
Updated information: Replace labels if item information changes

Scanner Maintenance

Regular cleaning: Scanner windows need periodic cleaning
Battery management: Charging protocols for wireless scanners
Firmware updates: Keep scanner software current
Replacement planning: Budget for scanner replacement

System Audits

Periodically verify system integrity:

Duplicate SKUs: Scan for accidentally duplicated codes
Orphaned SKUs: SKUs in system without physical items
Missing SKUs: Items without assigned SKUs
Format compliance: SKUs that don't follow standard format

🎯 Key Takeaways

SKUs provide unique identification enabling scanning, tracking, and cross-platform consistency
For certified coins, certification numbers make excellent SKUs (with service prefix)
SKU design should balance information encoding with simplicity and room for growth
Code 128 barcodes work well for internal operations; QR codes for customer-facing uses
Label certified coins carefully—holder edge labels or location-based labeling work best
Match scanner hardware to your operation size and mobility needs
Integration with inventory management and e-commerce platforms is essential
Implement gradually—pilot with one category before full rollout
Establish governance for SKU creation and maintain labels and scanners over time

Streamline Your Inventory Identification

SyncAuction integrates with your SKU and barcode systems to maintain consistent product identification across all your sales channels. Track every item from acquisition through sale.

Request a Demo →

Frequently Asked Questions

Should I use certification numbers as SKUs for graded coins?