How to manage frame and lens stock in an optical shop

Frames are small, valuable and easy to lose track of. A shop with a few hundred frames on display and more in drawers can drift a long way from its records in a few months, and once staff stop trusting the stock figures, they stop using them. Good optical inventory management is mostly a routine, not a product. This guide gives a routine that keeps frame and lens stock accurate without an annual stock-taking marathon.

Start with codes and labels

Every frame needs its own identity before it goes on display: a code that tells you brand, model, colour and size, and a label carrying that code as a barcode or QR along with the price. Frames of the same model and colour can share a code; a different colour or size needs a different one. Small tags that hang from the temple or stick inside it work for most frames.

Labelling takes time on delivery day, but it pays back at the counter. A scanned code cannot be mistyped, it picks the right price, and it takes the right frame out of stock. Unlabelled frames are where stock errors begin.

Record every movement, not just sales

Sales are recorded because someone has to make a bill. The movements that break stock are the others: a frame broken during fitting, a box returned to the supplier, frames sent to another branch, a display piece given away, a frame taken home to show a relative. Each must be recorded with a reason, at the time it happens.

Reasons matter because they turn missing stock into information. If most losses are fitting damage, you have a training issue; if they are unexplained, you have a control issue. Where staff can change stock, it helps if large or unusual changes need the owner's approval.

When stock arrives, record it against the supplier's bill, item by item. That one habit keeps both the stock and the supplier account correct, and makes returns to the supplier straightforward.

Count a little, often

A full stock count once a year finds problems twelve months after they started. Instead, divide the shop into sections, such as a wall unit, a brand drawer or the sunglasses stand, and count one section each week. Compare the count with the screen, investigate differences the same day, and correct the record with a reason.

Over a quarter, every section is counted at least once, nobody loses a whole day to stock-taking, and differences are found while staff still remember what happened.

• Pick one section a week and count it before opening
• Scan labels rather than reading codes aloud
• Investigate each difference the same day
• Correct the record with a reason, never silently

Lenses and contact lenses need their own rules

Stock spectacle lenses are best seen as a grid: sphere power down one side, cylinder across the top, and the quantity in each cell. Empty cells show at a glance which powers to reorder, and adding a new lens type in every power becomes one step instead of hundreds. Set a minimum quantity for your fast-moving powers so you reorder before you run out.

Contact lenses and solutions carry lot numbers and expiry dates. Record both when stock arrives, sell the oldest first, and check every month for stock approaching expiry so it can be sold, returned or written off with a record.

A worked example: finding a stock difference

On a Tuesday count of the sunglasses stand, the screen says 42 pieces and the stand has 39. The person counting scans every label and finds the three missing items are the same model in one colour. The stock history shows two were sold on Saturday, but only one bill carries that model; the other sale was billed with a similar model by mistake. The third piece is found in the fitting drawer with a broken temple, never recorded as damaged.

Two corrections follow, each with a reason: one wrong-item billing and one fitting damage. The stand now matches, the staff member who billed the wrong model knows why scanning matters, and the damage shows up in the month's report instead of disappearing. Ten minutes on Tuesday did what a whole day of year-end counting would have done too late.

Common mistakes

The usual causes of bad stock are frames displayed before they are labelled, typing codes instead of scanning, correcting the count without recording why, supplier deliveries entered as one total instead of item by item, and contact lenses received without lot and expiry.

Deal with old stock deliberately

Every shop has frames that have sat on the display for a year or more. They tie up cash and space, and they hide newer stock. Once a quarter, list frames by how long they have been in stock and decide what to do with the oldest: move them to a better position, offer them in a clearly priced range, return them to the supplier if your terms allow, or bundle them with lenses. Make the decision on purpose rather than letting the stock age further.

How Optical Mart handles this

Optical Mart keeps frames and lenses with stock movements and reasons, prints Code 128, EAN-13 or QR labels on sheets, rolls and frame tags, and shows stock lenses as a sphere and cylinder power grid. Contact lenses carry lot and expiry, oldest first. Staff stock changes can need the owner's approval, and stock can be imported from Excel. Supplier returns create a debit note.