Using UPC Barcodes to Speed Up Reseller Inventory (and When Not To)

Not everything a reseller handles is one of a kind. If you deal in media, toys, tools, or anything that came off a retail shelf, the manufacturer already printed a unique code on the box — and using it is the fastest way to both enter an item and find it again months later. Here is how barcodes fit into a reselling workflow, and where they do not.

Your SKU and the maker's barcode are different things

These get confused constantly, and keeping them apart makes everything downstream easier.

A SKU is yours. You issue it, it identifies one specific item you own, and it goes on the tag you print and staple to the piece. No two of your items share one.

A UPC belongs to the product. The manufacturer assigned it, and every copy of that product on earth carries the same code. Four copies of the same DVD share one UPC.

That difference drives everything else. A SKU tells you which item. A UPC tells youwhat product — which is exactly the right question when another one of something you already stock comes through the door.

Where barcodes earn their keep

• Media. Books, DVDs, records, and games are barcoded, frequently duplicated, and miserable to type in by hand.
• Boxed toys and collectibles. Especially sealed items, where the box is the product.
• Tools and hardware. Anything still in packaging.
• Anything you stock more than one of. This is the real payoff — see below.

Where they do not help

A hand-thrown pot from 1940 has no barcode and never will. Neither does most furniture, most glass, most jewelry, or nearly anything genuinely antique. For that inventory your own SKU and a good photo are the identifiers, and a barcode field simply stays empty.

This is worth saying plainly because barcode-driven systems built for retail tend to assume every item has one. A reselling workflow has to work just as well for the pieces that do not.

One row, with a count

The most useful thing a barcode unlocks has nothing to do with scanning speed. It is that multiples stop being a filing problem.

If you take in six of the same item, you do not want six near-identical records. You want one record that says six, so that scanning the box opens it and you can change the number. Then selling one drops the count to five and leaves the rest listed — and each sale is recorded against that product, so over time you can see what the thing actually sells for and how fast.

That history is the part sellers underrate. After a few sales you are not guessing at a price for the next one: you have your own record of what buyers in your market paid, and how long each one took to move.

A workflow that fits how you actually work

The whole point is that it collapses to a few seconds per item:

• First time in: scan the code onto the item as you create it, along with the price and details. This is the only slow one.
• Every time after: scan the same code, land on the item you already have, change the count.
• At the counter: scan it to pull the item up and log the sale against it.
• Looking for something: scan or type the code into search rather than trying to remember what you titled it.

The gotcha nobody mentions

The same product can scan as a different number of digits depending on the scanner. A twelve-digit code read by a scanner expecting thirteen picks up a leading zero. Small packages carry a compressed eight-digit form of the same code. And people typing a code off a label routinely drop a leading zero.

Any system worth using has to treat those as the same product, or you will scan a box you definitely have and be told you have never seen it. If you are evaluating tools, that is a good thing to test on day one: enter an item by scanning, then find it by typing the number off the label.

Start with the shelf that hurts most

You do not need to barcode your whole inventory, and for most local resellers that would be wasted effort — a large share of your stock is one-offs. Start with the category where you hold multiples and hate the data entry. That is usually media or boxed goods. Leave the antiques alone; they were never the problem.