Why this topic has become critical specifically for optical shops

Most optical shops in Ukraine go through a similar development path: at first, tracking is done in Excel or even in several separate tables, and as the number of clients grows, data becomes chaotic, recording errors appear, and control over sales is lost.

At first glance, Excel looks like a sufficient tool: it’s free, familiar to staff, and doesn’t require implementation. But in reality, it isn’t designed for business management—especially for an optics business, where there are complex product modifications, repeat sales, and constant work with customers.

That’s why the request CRM for optics Ukraine became one of the most frequent among business owners who have already felt the limitations of manual record-keeping.

How record-keeping works in optical shops with Excel

If you look at the practice of Ukrainian optical shops, most processes in Excel look roughly the same: a separate table for clients, a separate one for products, and another one for orders or appointments.

The problem is that these tables aren’t connected.

For example, a manager may see a customer in one file but not see their purchase history. Or a product is in the Excel warehouse, but has actually already been sold. Or, conversely, the product exists physically but isn’t reflected in the table.

As a result:

  • data is duplicated or lost

  • it’s difficult to control stock levels

  • there’s no single client history

  • the manager doesn’t see the real picture of the business

On average, in such systems, 20–30% of staff time is spent not on selling, but on searching for or уточнення information.

That’s where the first serious problem of client record-keeping for optics Kyiv and other cities arises—lack of a centralized system.

Where the business really loses money

Losses in optics rarely look like large direct losses. It’s always a combination of small losses that accumulate month after month.

The most common scenario is losing a repeat customer. A person buys glasses or lenses, but after 6–12 months, no one reminds them about replacement or another visit. As a result, the customer simply goes to a competitor.

The second type of loss is errors in stock. When records are kept manually, an optical shop can sell a product that’s already out of stock, or, conversely, not use available quantities. This creates direct financial losses and affects reputation.

The third scenario is losses of staff time. When a manager spends 10–15 minutes searching for information about a customer, it directly reduces the number of sales processed per day.

Together, even 10% losses in the customer flow of a medium-sized optics business can significantly affect monthly revenue.

That’s why business automation in Ukraine becomes not a matter of convenience, but a matter of financial efficiency.

CRM vs Excel in optics: the real difference

In terms of functionality, Excel and CRM look like tools for storing data. But in practice, these are two completely different approaches to business management.

Excel is a spreadsheet. CRM is a system.

In Excel:

  • everything is entered manually

  • there are no automatic reminders

  • data is split across files

  • there is no real-time analytics

In CRM:

  • the client has a complete history of interactions

  • the system reminds about repeat sales

  • inventory and sales are linked to each other

  • the manager sees business analytics in real time

That’s why comparing Excel vs CRM in optics is essentially a comparison of manual and system-based business management.

Real business scenarios of losses in optics

One of the most typical scenarios looks like this: a customer comes in, buys glasses, and then they’re simply forgotten. After a year, they turn to another optical shop because no one worked on repeat communication.

Another scenario is chaos in scheduling. In different tables, there may be different versions of the schedule, causing overlaps or loss of customers due to errors in records.

Another common problem is lack of manager control. If the business grows and several managers appear, Excel no longer makes it possible to understand who and how works with customers.

How CRM changes the operating model of an optical shop

Switching to CRM changes not only the tool, but the entire logic of business management.

A single customer database appears, where you can see purchase history, visits, repeat requests, and potential sales. This allows the business to work not with individual sales, but with the customer lifecycle.

As a result, the business starts earning not only from initial sales, but also from repeat ones—lenses, replacements, and preventive visits.

Where MARVI fits into this system

Systems like MARVI appeared precisely as a response to the problems of manual record-keeping in optics.

MARVI allows:

  • to manage clients and their history in a single system

  • to track sales and repeat requests

  • to work with inventory and product modifications

  • to reduce losses caused by chaos in data

In fact, it’s a transition from separate spreadsheets to a managed business system, where each process is connected to the others.

The difference between CRM and Excel in optics is not a question of tools, but a question of business losses.

Excel can work at the start, but as the number of customers grows, it starts creating chaos: lost sales, record-keeping errors, and lack of control.

CRM systems, such as MARVI, allow you to turn this data into a managed business process and reduce losses that accumulate in manual record-keeping.

That’s why the transition from Excel to CRM is not an expense, but a step toward stable growth and control of an optics business.