Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Can an Independent Optician Tell Which Frames Sell and Which Have Been on the Boards Too Long?
Problems We Solve

How Can an Independent Optician Tell Which Frames Sell and Which Have Been on the Boards Too Long?

Opticians' frame stock builds up with dead frames while good sellers run out. We link sales and stock by supplier so you can see what to reorder or return.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Frame stock is hard to manage because sales are recorded in the practice system, stock is counted on the boards and purchasing happens with the rep in the room. We link them so every frame has an age and a sale history, and give you a pre-visit report for each supplier showing what sold, what has not moved and what to consider returning or exchanging.

The rep is here on Thursday

A frame rep visits with a new collection. You like several styles. Before ordering, you want to know what sold from their last collection, what is still sitting on the boards after a year, and whether your exchange allowance with them is worth using. The answers are somewhere in the practice system's sales records, the frame drawer and the last delivery notes, and there is no time to pull them together before the rep arrives.

So the order is made on instinct. Good sellers are sometimes missed. Frames that never move stay on the boards because nobody is sure they are dead.

Why frames are hard to track

  • Frames are identified by supplier, model, colour and size, and small inconsistencies in how these are entered break any report.
  • Stock is physical and counted infrequently, so the system's stock figure and the boards drift apart.
  • Some suppliers offer consignment stock or exchange arrangements, each with its own terms and dates.
  • Sales data is in the practice system, but purchasing decisions are made in a conversation with a rep.
  • Nobody records when a frame arrived, so its age on the board is unknown.

What that does to the business

Frame stock is one of the largest amounts of money an independent practice holds. Slow frames tie up cash and board space. Popular frames sell out and are not reordered promptly. Exchange allowances go unused because nobody tracked what could be sent back. And the boards gradually fill with frames that patients walk past.

QuestionWithout dataWith a frame report
What sells from this supplier?Best guessSales by model over a period
What has not moved in a year?UnknownA list with arrival date
What can we exchange?Check the terms againEligible frames listed against terms
Where are the gaps on the boards?Walk the boardsMissing styles, colours or sizes flagged

How we build the frame report

  1. We read frame sales and stock records from your practice management system, and clean up inconsistent entries of supplier, model and colour with you.
  2. A quick stock take, using barcode labels or a phone scanner, gives every frame on the boards a verified entry and, for new deliveries, an arrival date.
  3. Each frame's age and sales history build up from then on, updated automatically as sales happen.
  4. Supplier terms, such as consignment arrangements and exchange allowances, are recorded against each supplier.
  5. Before a rep visit, you open a one-page report for that supplier: what sold, what has not moved, what is eligible for exchange and which styles you have run out of.
  6. A monthly overview shows stock value by supplier and age, so you can see where cash is tied up.

We do not advise on which frames to buy or how to price them. The report puts your own sales and stock in front of you when it matters.

What changes on the shop floor

Rep visits become a conversation based on your data. Dead stock is identified and dealt with, through exchange, a sale rail or a return, as you decide. Good sellers are reordered before they run out. The boards look fresher because frames that do not move are rotated off. And the stock figure in the system starts to match what is on the wall.

Is this your frame room?

  • Frame orders are made on instinct during rep visits.
  • You are not sure which frames have been on the boards over a year.
  • Exchange allowances go unused.
  • Good sellers sometimes run out before anyone notices.
  • The system's stock figure does not match the boards.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Do we need to relabel all our frames?

A one-off labelling during the first stock take makes everything after it much easier. After that, new deliveries are labelled on arrival.

Does this work with our practice system?

It reads sales and stock from it by API or export. We check what yours provides.

Can it handle consignment stock?

Yes. Consignment frames are tracked separately so they are not counted as your stock.

Is this a full stock control system?

It can be as simple as a supplier report or as full as live stock tracking. We start with what solves your problem.

Keep reading

More on Problems We Solve

Start here

Tell us where your practice loses time

Walk us through a patient's journey from booking to collection, and name the practice system, labs and suppliers you use. We will tell you what we would build and what we would leave alone, and if a smaller change would fix it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →