How to Switch Optical Software Without Losing a Single Patient Record

Optical shops stay on legacy systems for one reason: switching feels risky. The data is old, the export format is unknown, and a single lost invoice feels like a reputation hit. But the cost of staying on outdated tools is invisible - every day, manual workarounds, slow checkouts, and missing data add up to hours that a modern system would save automatically.

The trigger is usually one of three things: the old system raised its price (common with Eyefinity, My Vision Express, and Crystal PM), the support got worse, or the shop finally wants features like AI prescription scanning, barcode labels, or a modern interface that the legacy vendor does not offer. That is the moment when the risk of switching becomes smaller than the cost of staying. If you are comparing options before you switch, our optical shop software comparison walks through the honest pros and cons of the main contenders.

The good news: shifting from any system to a modern one follows the same safe pattern, and you can do it without losing a single record. This guide walks through the exact steps.

Before installing anything new, get your data out of the old system. You need:

• Patient records - name, phone, notes, and prescription history. Most systems export these as CSV or Excel.
• Invoice history - date, patient, products sold, prices, and amounts. At least the last 12 months.
• Inventory - frame names, brands, quantities, and cost prices. If barcodes exist, export those too.

Check your vendor's export tool. Some systems (Eyefinity, My Vision Express) have a built-in export function. Others may require a support ticket or charge a fee for a data dump - start this process early because it can take a few days. If your system supports CSV export, that is the most portable format.

Install the new software on a separate machine or a dedicated folder. Do not uninstall the old system yet - the safety net is that both systems work simultaneously.

Visilion installs on Windows, macOS, and Linux, runs fully offline, and stores all data in a local SQLite database on your machine. To set it up:

• Download and install the application.
• Open Settings and configure your country, currency, tax rate, and decimal separator.
• Set up your lens brands and product catalog using the starter templates or the Lens Options wizard.
• Enable automatic backup in Settings - this creates a .sqlite copy of your database after every sale, so you always have a recent restore point.

The entire setup takes under an hour. You do not need to enter any data yet - the parallel-run phase will build it invoice by invoice.

This is the most important phase. For 1-2 weeks, enter every new invoice and patient in both systems. The old system stays the source of truth. The new system is being tested day by day.

At the end of each day, compare the totals: the number of invoices, the total revenue, the list of patients seen. If anything does not match, investigate immediately. The parallel-run catches configuration errors, missing settings, and workflow differences before they affect real operations.

Most shops find that after 3-5 days, the new system is accurate and they are ready to cut over earlier than planned. The remaining days of the parallel-run build confidence. Use the extra time to train staff on the new interface.

When you are confident - typically after 1-2 weeks of matching totals - stop using the old system. Do not delete it. Create a final backup of the old database and store it somewhere safe (external drive, cloud folder). This is your read-only archive for historical lookups.

On the new system, create a backup immediately after the last parallel entry. This becomes your first clean backup. Visilion's backup and restore uses standard .sqlite and .db files, so you can restore the entire database on any machine running the software.

Not every field from every system can be imported perfectly. Some systems store data in proprietary formats that do not export cleanly. The practical approach is:

• Import what you can. Patient names, phone numbers, and last visit dates are the most valuable.
• Keep the old system as a reference. It stays installed and accessible for lookups.
• Do not let perfect data migration delay the switch. A month of using the new system is worth more than a year of waiting for a perfect import.

Visilion stores your data locally, so you never face a vendor lock-in situation again. If you ever want to switch away, you have the entire database as a standard .sqlite file that any SQLite tool can read.