How to keep prescription and customer records in an optical shop

A prescription is the most important number in an optical sale and the easiest to get wrong. A sign missed, an axis swapped between eyes or an old reading used by mistake means a remake, a delay and an unhappy customer. Good records prevent most of this and make the customer's next visit faster. This guide covers what to record, how to avoid errors and how to keep the records safe.

What to record for each prescription

For each eye, record sphere, cylinder and axis, and for near or progressive work, the addition. Record the pupillary distance, and for progressives the fitting heights once the frame is chosen. Note the date, who did the test and whether it was done in your shop or brought in from an outside doctor or optometrist.

Save each new prescription as a new dated entry on the same customer. Old prescriptions are useful: they show how the customer's eyes are changing and settle questions when a customer says the new spectacles feel different.

• Right and left eye: sphere, cylinder, axis
• Addition for near and progressive lenses
• Pupillary distance and, for progressives, fitting height
• Date, tester and source of the prescription
• Lens type recommended and notes for the lab

Stop copying errors before they reach the lab

Errors come from copying. The power is written on a slip, copied into a register, copied again onto a lab form and typed by the lab. Every copy is a chance to drop a minus sign or swap the eyes. The cure is to enter the prescription once, check it, and print the job card and any lab form from that same record.

Checks at entry catch the rest. Sphere and cylinder powers come in 0.25 steps, axis runs from 1 to 180 and only has meaning when there is a cylinder, and an addition belongs only on near or progressive prescriptions. A warning when a new reading is identical to one already saved catches double entries. Labs often work in minus cylinder form, so being able to transpose a prescription correctly, with the working shown, avoids another common mistake.

Keep the customer record complete

The prescription is one part of a customer record. The rest is what makes the next visit easy: a working phone number, the frames and lenses bought before, what they paid and still owe, and any notes such as a preference for lightweight frames or a sensitivity to certain coatings.

Search should work by phone number, because names are spelled differently every time. When two records turn up for the same person, merge them so history is not split.

Protect the records

Prescriptions are personal health information. Give each staff member their own login and only the access their work needs. Do not send prescriptions in group chats or leave printed copies on the counter. When a customer wants their prescription, give it to them directly or send it through a secure link.

Keep backups that do not depend on one computer. A register can be lost in a flood and a counter computer can fail; records in an online account with regular backups survive both. Follow the data protection and health record rules that apply in your country, and ask your adviser how long records should be kept.

A worked example: where a remake comes from

A customer is tested at the shop: right eye -2.00 / -0.75 x 180, left eye -1.75 / -1.00 x 10. The reading is written on a slip, copied into the register as -2.00 / -0.75 x 18 because the last zero was unclear, and copied again onto the lab form. The lab makes exactly what the form says. The customer comes back with blurred vision in the right eye, and the shop pays for a remake and loses a week.

The same test entered once into a customer record, checked on entry, and printed straight onto the job sheet would have carried x 180 all the way to the lab. The saving is not one remake; it is every remake caused by copying, every month.

Common mistakes

Watch for overwriting the old prescription with the new one, writing powers without a plus or minus sign, mixing plus and minus cylinder forms between the shop and the lab, recording no date or tester, keeping prescriptions in a register that only one person can read, and sending powers to customers in group chats.

Make the next visit faster

Good records pay off when the customer returns. The last prescription and the last frame are on the screen in seconds, the staff member can compare old and new powers, and the customer feels remembered. The date of the last eye test also tells you when to invite them back, which is where steady repeat business starts.

How Optical Mart handles this

Optical Mart saves every refraction on the customer with its date, checks powers in 0.25 steps and catches duplicate readings. Calculators cover transposition between plus and minus cylinder, spherical equivalent and contact lens power, with the working shown. The lab job sheet prints from the saved record, staff have their own logins and roles, and prescriptions can be sent to the customer as a secure link.