Post

Retail SKU and Barcode Setup Guide for Small Stores

SKUs and barcodes help staff identify products, but they do different jobs. A retailer controls its internal stock keeping unit, while a manufacturer or standards organization may assign the barcode printed on a product. A dependable catalogue records each identifier against the correct sellable item without treating either one as proof of price, ownership or stock quantity.

Understand the difference between an SKU and a barcode

An SKU is an internal identifier chosen by the business to distinguish products. It may be meaningful to staff, but it does not need to match another retailer’s code. A barcode is a machine-readable representation of an identifier. A printed manufacturer barcode can identify a packaged product, while a merchant may also use internally generated labels where suitable.

Scanning only retrieves the product connected with that recorded value. It does not verify the product description, price, tax treatment or physical quantity. Those fields still require deliberate setup and review.

Decide what counts as one sellable product

Create a separate product record when an item needs its own price, barcode or inventory quantity. Size, colour, flavour, model, capacity and pack quantity commonly create distinct variants. A 500 ml bottle and a one-litre bottle should not share a stock record merely because the brand name is the same.

  • Use one clear record for each sellable unit.
  • Make the differentiating attribute visible in the name.
  • Keep discontinued items distinct from their replacements.
  • Do not rename an old product to represent a new size or model.
  • Define piece, pack and case quantities before receiving stock.

Choose a simple, durable SKU structure

A useful SKU is unique, readable and stable. A small retailer might combine a short category, brand or product reference and variant, but the format should remain manageable as the catalogue grows. Avoid using a price, supplier name or shelf position as the only identifier because those can change while the product remains the same.

What characters should an SKU use?

Use characters supported consistently by the merchant’s systems, exports, scanners and labels. Short letters, numbers and separators are often easier to read than ambiguous punctuation. Avoid codes that differ only by easily confused characters such as the letter O and zero unless staff can distinguish them reliably.

Should an SKU contain the product price?

Usually no. A price can change independently of product identity. Keeping the SKU stable allows earlier sales, purchases and stock movements to remain connected with the same item while the approved selling price is updated through its own process.

Record manufacturer barcodes carefully

Scan or type the barcode into the correct product and test it before using it at the counter. Check the full package and variant because similar-looking items may have different identifiers. Do not copy a barcode from an online listing without confirming that it belongs to the physical product the store carries.

Can two products have the same barcode?

A catalogue should not intentionally connect one active barcode to two different sellable items. When a duplicate appears, inspect both physical products and their packaging. The cause may be a duplicate record, incorrect manual entry, reused internal label or product-data problem requiring supplier clarification.

What if a product has no barcode?

The merchant can still use a clear internal SKU and supported product search. If the business prints its own barcode label, it must choose a value and labelling process that will not collide with recorded manufacturer codes or create misleading product information. SellingIt does not issue globally registered barcode numbers.

Handle packs, cases and individual pieces explicitly

Buying by case and selling by piece requires a known conversion. Record how many sellable pieces are contained in the purchasing unit and verify it during receiving. If both a sealed pack and a single piece are sold to customers, each may require its own product record, price, barcode and stock treatment.

Never assume that the number printed in a description matches the usable quantity received. Damaged, promotional or supplier-specific packs may require separate review.

Prevent duplicate product records

  1. Search by barcode before creating a product.
  2. Search meaningful parts of the name, brand, model and size.
  3. Check inactive products and common spelling differences.
  4. Compare the intended unit and variant.
  5. Create a new record only when the existing one is genuinely different.
  6. Have an authorized person review uncertain matches.

If a duplicate already has transactions, purchases or stock history, do not delete it casually. Decide how future activity will use the correct record and preserve the context required to understand earlier entries.

Test the catalogue at the counter and during receiving

Select representative products: a normal packaged item, a variant, a product sold without a manufacturer barcode and a case-to-piece purchase. Scan or search each item, verify the displayed name and price, complete a test using the permitted process, and confirm that the supported inventory movement affects the intended record.

Then test receiving the same items from a supplier. Counter accuracy and purchasing accuracy depend on the same product identity, even though selling and purchasing units may differ.

Review identifiers when products change

Review the product record when packaging, pack size, barcode, model or selling unit changes. A cosmetic packaging update may retain the same identity, while a different quantity or specification may require a new record. Verify the actual product and supplier information rather than guessing from the name.

Retail SKU and barcode setup checklist

  • Define one record for each distinct sellable item.
  • Choose a unique and stable internal SKU.
  • Keep price and shelf location outside the permanent identity.
  • Record the barcode from the verified physical product.
  • Test that each barcode retrieves only the correct item.
  • Define piece, pack and case conversions.
  • Search active and inactive products before adding another.
  • Preserve history when correcting duplicates.
  • Test representative products at billing and receiving.
  • Assign responsibility for catalogue changes and review.

Connect product identity with SellingIt

Use Product Management for supported product records, POS and Billing for counter identification, Inventory Management for stock context, and Purchase and Supplier Management for purchasing and receiving.

Continue with the retail product catalogue checklist and inventory stock-count checklist. This guide does not provide barcode registration, labelling-law, tax, accounting or product-compliance advice.

Ready to Run Your Business Smarter?

Bring your store operations together with SellingIt.

Start Your Free Trial