Five principles for product codes

  • Unique: one code per sellable unit, including colour and size variants.
  • Short: staff should type it without looking.
  • Structured: a category prefix helps sorting and reporting.
  • Stable: never reuse a code for a different product.
  • Searchable: keep common names and aliases alongside the code.

A code such as HW-CB-25-100 is readable: category, product, specification, length. It does not need to encode everything; attributes can hold the rest.

Handling variants

For apparel, use a style code plus colour and size, for example AW24-TS-001-BLK-L. For hardware, use specification suffixes. For electronics, use the manufacturer part number as the primary key and an internal warehouse code as a secondary reference.

  • Generate variants from a matrix to avoid omissions.
  • Assign a barcode per variant.
  • Archive discontinued variants rather than deleting them.
  • Do not change a variant code after stock exists.

Barcode labels and scanning

  • Use Code 128 or EAN-13 depending on your label printer and customer requirements.
  • Print a human-readable code below the bars.
  • Test scan distance and label size in the real environment.
  • Keep the scanner in keyboard wedge mode for invoicing software.
  • Label shelves as well as products for bin picking.

Common coding mistakes

MistakeConsequence
Names instead of codesDuplicate products and failed searches
Encoding price in the codeCode becomes wrong when price changes
Reusing old codesHistory and stock reports mix products
No variant codesStock cannot distinguish colour and size
Barcode on the shelf onlyCounter staff cannot scan the item

Frequently asked questions

Do we need to change all product codes when installing software?

No. Import existing codes if they are unique and stable. Clean duplicates first, then add aliases for common names.

Should the price be part of the barcode?

No. Price changes would make the barcode obsolete. Keep price in the software and the barcode as an identifier.

What barcode format should we use?

Code 128 is flexible for internal labels; EAN-13 is used for retail products with a registered number. Follow your label printer and customer requirements.

Can we print labels from 小企业简单进销存软件?

Label printing uses the Windows printer driver and a label template. Standard label sizes can be configured.

QB
小企业简单进销存软件 editorial teamA content team focused on invoicing, inventory and stock control for small businesses. We test and review common business software.