Optical Shop Inventory Management: A Practical Guide for Optical Retailers

Optical shop inventory management is one of the most common sources of lost profit in independent optical retail — and one of the least talked about. Most optical shop owners focus on growing sales, controlling costs, or improving the patient experience. Meanwhile, thousands of dollars sit on the frame board in dead stock that hasn't moved in a year, contact lens boxes accumulate past their use dates, and reorder decisions are made by gut feel rather than data.

This guide covers the practical mechanics of optical inventory management: how to structure your stock, handle frame consignment, set reorder points, run stock takes, and identify the reporting that tells you whether your inventory is working for you or against you.

Why Optical Inventory Management Is Different From General Retail

Generic retail inventory management principles — set a reorder point, use FIFO, do annual counts — apply to optical retail but don't go far enough. Optical shops carry multiple fundamentally different product categories, each with its own inventory dynamics.

Frames: Fashion-Driven, High-Value, Slow-Turning

Frames are closer to fashion retail than general merchandise. A frame collection has:

High per-unit value — frames can cost hundreds of dollars wholesale, tying up significant capital on a single peg
Multi-variant SKUs — the same model in four colors and three sizes is twelve distinct SKUs, each of which can go to zero independently
Fashion cycle risk — a frame collection that was current 18 months ago may now be difficult to sell at full margin
Consignment complexity — many optical shops carry some frames on consignment from suppliers, which requires separate tracking from owned inventory

Contact Lenses: Fast-Moving, Parameter-Sensitive

Contact lenses behave more like FMCG (fast-moving consumer goods) than eyewear. They:

Have multiple parameters per SKU (brand + base curve + diameter + Rx power + cylinder + axis for torics)
Have short shelf lives and expiry dates that require FIFO rotation
Are often reordered predictably, making a just-in-time approach practical
Generate their own P&L that should be tracked separately from frames

Lenses: Made-to-Order, Not Pre-Stocked

Ophthalmic lenses are almost always made to order — your inventory is lens blanks or stock lenses for simple prescriptions, not finished product. The inventory challenge here is more about supplier lead time management and lab order tracking than shelf counts.

The table below summarises the different management approach each category requires:

Category	Turnover	Capital Risk	Key Risk	Recommended Approach
Frames (owned)	Slow (months)	High	Dead stock, fashion obsolescence	Active sell-through tracking, quarterly reviews
Frames (consignment)	Slow (months)	Low	Admin burden, contractual obligations	Separate tracking, regular supplier reconciliations
Contact lenses	Fast (weeks)	Moderate	Expiry waste, stockouts	Just-in-time ordering, FIFO rotation
Accessories	Variable	Low	Slow-moving stock	Semi-annual reviews, small order quantities
Stock lenses	Moderate	Moderate	Overstocking slow Rx ranges	ABC analysis of your patient Rx spread

Structuring Your Frame Inventory

The biggest inventory management mistake in optical retail is treating frames as a single category. Every variant needs its own stock record.

SKU Structure: Brand, Model, Color, Size

A frame like the Ray-Ban RB5154 in black, size 51 is a completely different inventory item from the same model in tortoise or size 53. Your inventory system must support:

Multi-variant SKUs — the model number alone is not enough
Per-variant stock counts — going to zero in one size while having surplus in another is a stockout and a cash problem at the same time
Per-variant reorder rules — your bestselling size gets a higher par level than a slower-moving one

If your inventory software groups variants together or only tracks by model, you are flying blind on your actual stock position.

Owned Stock vs. Consignment: Track Them Separately

Consignment frames are a useful tool for building a broader selection without tying up cash. The tradeoff is more administrative complexity. If you carry consignment stock, your inventory system must:

Flag consignment frames with the supplying vendor and consignment date
Track them separately from your owned inventory in your balance sheet (consignment stock is not your asset)
Generate a consignment report for each supplier showing what you hold, what has sold, and what is being returned
Alert you when consignment frames have been on display beyond the agreed period without selling

Mixing consignment and owned stock in the same ledger leads to phantom assets, incorrect COGS, and disputes with suppliers.

Setting Reorder Points: Stop Guessing

Many optical shops restock by walking the frame board and noticing empty pegs, or by waiting until a patient asks for something you don't have. Both methods are reactive and lead to either stockouts or overordering.

A reorder point is the stock level at which you trigger a replenishment order. For each high-velocity frame SKU, calculate it as:

Reorder point = (average daily sales × supplier lead time) + safety stock

In practice, for most optical shops in Singapore and Southeast Asia:

Average daily sales per frame SKU is low (often less than one unit per week)
Lead time from frame suppliers is typically 1–3 weeks
Safety stock of 1–2 units is usually sufficient for most SKUs

For contact lenses, where turnover is faster and lead times from major suppliers like Alcon, CooperVision, and Johnson & Johnson are predictable, a simple par-level system works well — when the shelf count drops below your par level, place an order.

ABC Analysis: Focus on What Moves

Not every SKU deserves the same monitoring frequency. Apply ABC analysis to your frame inventory:

A items — the 20% of SKUs that generate 80% of your frame revenue. Monitor weekly, tighter reorder points, never let these go to zero.
B items — the middle tier. Monthly review, moderate par levels.
C items — slow-moving or display-only frames. Quarterly review. If they haven't sold in six months, escalate them to the dead stock review process.

Running a Stock Take Without Closing the Shop

Annual stock takes are disruptive. Most independent optical shops can't afford to close for a full day, and full counts often get pushed back indefinitely as a result. A zone-based, rolling stock take approach solves this.

Zone-Based Frame Counts

Divide your frame display into zones (e.g., by brand section, gender section, or display unit). Count one zone per week, rotating through the full shop over a quarter. Each week's count takes 30–60 minutes, can be done before opening or during a quiet period, and keeps your system accurate continuously rather than once a year.

For contact lenses, a monthly count is practical given faster turnover — run it on the last day of each month while checking for approaching expiry dates.

What to Do With Discrepancies

When your physical count doesn't match your system:

Recount before assuming the system is wrong
Check for unprocessed returns or supplier deliveries not yet receipted
Investigate potential shrinkage (missing frames without a sales record)
Adjust the system and document the variance

A pattern of variance in the same SKU or zone is worth investigating further — it may point to a process gap or a systematic scan error.

Identifying and Clearing Dead Stock

Dead stock — frames that have been in your display for six months or more without selling — is a silent cash drain. It ties up capital that could be redeployed into frames that would actually sell, and it ages on your display, reducing the freshness of your overall collection.

Industry benchmarks suggest your cost of goods (COG) should not exceed 30% of gross revenue. If your COG is running higher, dead stock is often a contributing factor. Identifying and clearing it regularly keeps your frame economics in line.

How to Identify Dead Stock

Your inventory software should be able to generate a report showing every frame SKU with zero or near-zero sales in the last 90 and 180 days. If it can't, that's a capability gap worth addressing. Run this report quarterly and review with your buyer or dispensary manager.

How to Clear It

Staff discounts — let staff purchase at cost or near-cost; they become brand ambassadors for the frames they wear
Bundle promotions — pair a dead-stock frame with a popular lens package at a discount
Supplier returns — some suppliers allow returns of unsold frames within a defined window; check your terms and act before the window closes
Write-downs and donation — if frames have been in display for 18+ months with no movement, write them down in your accounts and consider donating to community vision programs

Align Your Selection With Your Patient Demographics

A common cause of dead stock is a frame selection that doesn't match who actually walks through your door. If 70% of your patients are 45 and older, stocking a large range of fashion-forward slim frames for young adults will result in low sell-through.

Review your patient demographics annually and adjust your buying accordingly. The best optical shops treat their frame buying as a merchandising decision informed by data, not just supplier relationships and personal taste.

The Reporting Your Optical Inventory System Should Produce

Poor optical inventory management is often a data problem. If you can't answer the questions below quickly, your reporting is insufficient:

Report	What it tells you	Review frequency
Sell-through rate by brand	Which brands earn their floor space	Monthly
Average days in inventory by SKU	How fast individual frames turn	Quarterly
Dead stock list (no movement 90+ days)	What to clear and what to stop buying	Quarterly
Consignment stock aging by supplier	What's overdue to return	Monthly
Contact lens expiry report	What needs to be rotated or returned	Monthly
Inventory value by category	Your capital exposure across product types	Monthly
COGS as % of gross revenue	Whether your buying is in line with benchmarks	Monthly

A well-configured optical inventory system should make all of these reports accessible in a few clicks, not require exporting to a spreadsheet and calculating manually.

Choosing Optical Inventory Management Software

Generic inventory or retail software — designed for general merchandise retail — can handle basic stock counts, but it doesn't understand optical product structures or workflows. When evaluating optical inventory management software, prioritise these capabilities:

Capability	Why It Matters
Multi-variant SKUs (brand/model/color/size)	Prevents phantom availability — knowing model is in stock but not specific variant
Consignment vs. owned stock distinction	Keeps your balance sheet accurate
Real-time deduction at point of sale	Stock counts update the moment a frame is sold
Contact lens parameter management	Tracks complex CL SKUs without manual parameter entry
Dead stock and aging reports	Built-in, not requiring manual spreadsheet work
Reorder point alerts	Proactive, not reactive restocking
Integration with patient/prescription records	Connects dispensary stock to clinical workflows

A system that handles inventory in isolation from your POS and patient records creates double-entry and delays — you lose the real-time connection between what's sold and what's in stock.

CarrotByte: Optical Inventory Management for Southeast Asia

CarrotByte is an all-in-one optical practice and dispensary platform built for independent optical shops and optometry clinics in Singapore, Malaysia, Indonesia, and across Southeast Asia. Its inventory module is designed specifically for the optical product mix — frames, contact lenses, accessories — with the variant-level SKU tracking and consignment management that generic retail systems don't offer.

Key inventory features:

Frame inventory with multi-variant SKUs — track by brand, model, color, and size as distinct stock items
Consignment tracking — separate consignment from owned stock with per-supplier reconciliation reports
Real-time POS integration — sales deduct inventory instantly, no manual reconciliation
Dead stock and sell-through reports — built-in reporting to identify slow movers without spreadsheet exports
Contact lens inventory — parameter-level tracking with expiry date monitoring
Low-stock alerts — automated alerts when any SKU falls below your reorder threshold
PDPA-compliant — data storage compliant with Singapore's Personal Data Protection Act

Start a free CarrotByte trial — no credit card required, and inventory setup typically takes less than a day.

Summary

Effective optical shop inventory management comes down to five disciplines:

Structure your inventory correctly — frames by variant (brand/model/color/size), contact lenses by full parameter set, consignment tracked separately from owned stock
Set reorder points by data — calculate reorder points from sales velocity and lead time, not from walking the frame board
Run rolling stock takes — zone-based weekly counts are more reliable than annual full counts
Clear dead stock proactively — quarterly reviews and systematic clearance keep your capital deployed in product that moves
Use reporting to manage by metrics — sell-through rate, days in inventory, and COGS as a percentage of revenue are the numbers that matter

Optical inventory is where margin is either made or lost. The shops that manage it systematically consistently outperform those that don't.

Related Articles: