What should an optical shop SKU look like?

Short enough to type, structured enough to read. A common pattern is brand code, model, colour and size, for example RB-2140-BLK-52. What matters most is that one physical frame maps to exactly one SKU, and that colour and size are part of it — two colours of the same model are two different products commercially.

Do I need barcodes for frames?

You do not need them, but they pay for themselves quickly. A scanner at the counter removes typing errors during billing and makes a physical stock count several times faster. Printing your own barcode labels also solves the problem of supplier labels that peel, differ between brands, or are missing entirely.

How do I know which frames are dead stock?

Sort by the date each item last sold, not by quantity on hand. Anything with no movement in six months is a candidate, and nine to twelve months with no sale in a fashion category is dead. The point is not to feel bad about it — it is to convert it into cash for stock that moves.

How often should I do a physical stock count?

A full count once or twice a year, plus rolling counts of one section a week. Rolling counts catch drift early, take fifteen minutes, and mean the annual count contains no nasty surprises.

Why does my system stock never match the shelf?

Usually one of four causes: sales that did not decrement stock, returns and exchanges handled informally, frames taken for display or repair without a record, or two staff editing the same quantity at once. Fix the process for each rather than repeatedly correcting the number.

Frame inventory management for optical shops

6 min read · Last updated 4 September 2026

Frames are the biggest single block of capital in an optical shop, and the easiest to lose track of. A thousand small items, most of them one piece deep, in dozens of colours and sizes, handled by customers all day. This guide is the practical system: how to code them, photograph them, reorder them, spot the dead ones, and count them without closing the shop.

1. Why frame stock is harder than it looks

A grocery shop sells the same fifty items over and over. An optical shop holds several hundred distinct frames, and a large share of them exist in exactly one piece. That single fact causes most of the difficulty:

Every sale is a stock-out. Sell the one piece and the model is gone until you reorder — so the reorder decision has to be made from a single data point.
Colour and size are separate products. The same model in black and in tortoise sell at completely different rates, and treating them as one SKU hides that entirely.
Customers handle the stock. Frames get tried on, moved, put back in the wrong slot, and occasionally walk out.
Fashion decays. A frame that did not sell in a year will probably not sell in the second year at full price.
Display and repair pieces leave the shelf without being sold — the most common silent source of a mismatch.

None of this needs sophisticated software. It needs one discipline: every physical movement, in or out, is recorded at the moment it happens.

2. SKUs and barcodes that survive contact with staff

A SKU is the shop’s own name for a product, and it needs to be readable by a person and unique to a single physical thing.

Part	Example	Why
Brand code	RB	Groups the wall and speeds up supplier reconciliation
Model	2140	The supplier's own reference — keep it, do not invent one
Colour	BLK	Two colours sell differently; they are two products
Size	52	Eye size. A customer asking for "the same but wider" needs this

Put together, RB-2140-BLK-52. Whatever scheme you pick, apply it to everything from day one and write it on a card by the computer. A scheme that half the staff follow is worse than no scheme, because it looks reliable.

Barcodes

Print your own labels rather than depending on supplier stickers, which peel off, differ by brand and are frequently absent. A hand scanner costs little, and it changes two jobs: billing stops involving typing (and therefore stops involving typos), and a stock count becomes a walk along the wall with a scanner instead of a two-person calling exercise.

Label placement matters more than people expect: on the temple arm, always the same side, always the same way round. Consistency is what makes scanning fast.

3. Photograph every frame

The single highest-value habit in optical inventory, and the one most shops skip. Photograph each frame as it comes into stock — front on, plain background, decent light, thirty seconds per frame.

Staff can find it. A new employee cannot picture “RB-2140-BLK-52”. They can recognise it instantly from a photo.
You can send it on WhatsApp. “We have this one in stock, would you like me to keep it aside?” with a picture converts.
The bill carries proof. A photo of the frame on the invoice settles warranty questions a year later without argument.
Reordering gets easier. Looking at the fifteen frames that sold fastest is far more informative as pictures than as a list of codes.
Insurance and theft claims. A photographed inventory is a documented one.

Take the photo at the moment of receiving, not later. “I will photograph the new stock this weekend” is how shops end up with 600 frames and 40 pictures.

4. Low-stock thresholds and reordering

With single-piece depth, a classic reorder point does not apply to individual frames. It applies to categories and price bands, which is how customers actually shop.

Set a floor per section. “At least 40 men’s metal frames between ₹1,500 and ₹3,000.” When the section drops below its floor, you buy — whichever specific models you choose.
Reorder proven models on sight. A frame that sold within a few weeks of arriving is telling you something. Reorder it before the season ends.
Watch the price bands, not the average. If your ₹2,000 to ₹3,000 wall keeps emptying while the ₹5,000 shelf sits full, your buying mix is wrong, not your total.
Keep accessories on a simple minimum. Cases, cloths, solutions and screws are consumables — a fixed reorder level works fine.
Buy against lead time. If a distributor takes three weeks, your floor has to hold three weeks of selling, not one.

5. Finding and clearing dead stock

Dead stock is not just money sitting still; it is money that could have been the frames people are asking for. Find it by date of last sale — the number of pieces on hand tells you nothing about whether they move.

Age since last movement	Read it as	Action
0-3 months	Healthy	Reorder what sold fast
3-6 months	Watch	Move it to a better shelf, brief staff to show it
6-9 months	Slow	Discount, bundle with lenses, or offer it back to the supplier
9+ months	Dead	Clear it — a sale at cost beats a shelf at zero

Three ways to clear it that work better than a plain markdown. Bundle it: frame plus lenses at a single attractive price, which protects the frame’s perceived value. Use it as a second-pair offer, where a discount reads as generosity rather than desperation. Or ask the supplier — many distributors will exchange slow-moving models for current ones, and the ones that will are worth buying more from.

Do this quarterly, on a fixed date. Dead stock reviews that happen “when there is time” never happen.

6. Supplier and purchase tracking

Every frame should be traceable back to the purchase it arrived on. That gives you three things you cannot get any other way: real margin per item, a returns conversation backed by records, and input credit that reconciles.

Record cost price at the time of purchase. Without a cost, your gross profit report is decoration. And if the same model was bought twice at different prices, the cost on the sale must be the one that actually applied.
Keep supplier GSTIN and invoice numbers. Chasing them at filing time is a bad use of a week.
Track lead time per supplier. The distributor who is a little cheaper but takes a month is not cheaper.
Log returns and exchanges. An informal “he took it back” is how stock quantities become fiction.
Review by supplier once a year. Which one’s frames sell fastest, which one’s sit longest, and who actually honours exchanges.

7. Counting stock without closing the shop

A full physical count in one go means shutting for a day, which most shops cannot afford and therefore never do. Rolling counts solve it.

Divide the shop into sections — one wall, one display case, one drawer per section.
Count one section a week, first thing in the morning before customers arrive. Fifteen minutes with a scanner.
Investigate every difference. A missing piece is either a sale that did not decrement, a repair loan, a display piece, or a loss — and each has a different fix. Just correcting the number teaches you nothing.
Record the adjustment with a reason. “Damaged”, “display” and “not found” are three different business problems.
Do one full count a year anyway, ideally close to your financial year end.

And insist on the rule that makes all of it work: stock moves only through the bill or through a recorded adjustment, never through someone changing a number because it looked wrong. A quantity edited without a reason is an audit trail deleted.

The same principle applies to lenses, though the shape of the data differs — see stocking lenses power-wise for holding stock lenses as an SPH × CYL grid.

LensVerge keeps the shelf and the system together. Frames carry photos and printable barcode labels, every sale decrements stock automatically, adjustments are logged with a reason and a name, low-stock alerts and a stock-value summary run over your whole catalogue, and supplier records carry cost and stock history per product. See the billing software, compare the options, or start a 14-day free trial.