Faisal Optical Service

Overview

Built for: Eyewear shoppers in Pakistan buying frames, sunglasses, prescription lenses and contact lenses online, and the store staff who manage catalog, orders and pricing.

Main features

• Four-step lens configurator

  Customers choose a vision need, enter a prescription, add coatings or tints and pick a lens package, with a running total for frame, lenses and coatings. Steps are skipped when the chosen usage does not need them.

• Prescription entry with validation

  Customers can type a prescription, upload a file, load one saved in their account or send it later. The form checks axis range, requires ADD power for progressive and bifocal lenses, and supports single or dual PD and optional prism.

• High-prescription lens guard

  The configurator reads the strongest sphere and cylinder values across both eyes. When the prescription is high, only lens packages marked as suitable for it can be selected.

• Lens Engine and pricing matrix

  Admins manage usages, lens packages, add-on groups, add-ons, tint colors and the prism price. A pricing matrix sets the price of each package per vision type, with auto-fill and per-usage availability.

• Shareable catalog filters

  Shoppers filter by gender, category, brand, frame shape, style, material, face shape, color, size, price and lens width. Every filter is kept in the URL, so a filtered view can be bookmarked or shared.

• Contact lens shopper

  A separate contact lens catalog lets customers set power, base curve, diameter and quantity for each eye, with a same-for-both-eyes option and live totals.

• Checkout, coupons and stock sync

  Checkout supports bank transfer and cash on delivery, validates coupons against minimum cart, discount caps, dates and usage limits, and queues an order confirmation email. Stock is deducted on purchase and restored if an order is cancelled.

• Admin dashboard and exports

  Admins see revenue and order totals for a chosen period with growth against the previous one, plus low-stock alerts across frames and contact lenses. Customer lists and customer order history can be exported to Excel.

• Verified-buyer reviews

  Only customers with a shipped or delivered order for a product can review it. Reviews start as pending for moderation, and a scheduled job approves any still pending after 24 hours.

• Customer account and invoices

  Customers get a dashboard with their order history and saved prescription details, and can download PDF invoices. A wishlist and a public order tracking page sit alongside it.

Development and architecture

Business rules as data

Lens prices are read from a package by usage matrix, falling back to a base price plus a usage adjustment. I chose this so the optician can update the price list from the admin panel instead of asking for a code change.

One component for the configurator

Step skipping, prescription validation, high-prescription detection and the prism surcharge all live in a single Livewire component, which keeps the ordering rules in one place and easy to check against the optician's workflow.

Stock tied to order status

Stock changes follow order status transitions in both directions: cancelling restores stock and reinstating a cancelled order deducts it again, at variant level for frames and product level for contact lenses.

Reusable Excel export

A single export class takes a model, date column, filters and joins, so new exports in the admin panel do not need their own code.

Built for shared hosting

Migrations check for existing tables before running, file serving has a fallback for hosts that block storage symlinks, and the Lens Engine fails safely if a migration is still pending.

Email, invoices and scheduling

Order and contact emails go through SMTP, with the order confirmation sent from a queue, invoices are rendered to PDF with DomPDF, and the review auto-approval runs as an hourly scheduled command.

Technology

• Laravel
• PHP
• Livewire
• MySQL
• Tailwind CSS
• Alpine.js
• Vite
• Laravel Breeze
• DomPDF
• Laravel Excel