The problem

An optician in Kenitra sells glasses, then waits. Contact lens wearers run out and reorder anywhere; glasses wearers renew every two or three years wherever they happen to walk in. The client file sleeps in a drawer.

The solution, step by step

  1. Log every sale in Google Sheets: client, phone, product, prescription date, expected renewal (3 months for lenses, 24 months for glasses).
  2. A Zapier zap checks the sheet weekly for due renewals.
  3. Lens wearers get a WhatsApp Business message before running out, with one-tap reorder and home delivery option.
  4. Glasses clients get a message near the two-year mark suggesting a free vision check and showing new frames.
  5. Responses update the sheet; a "do not disturb" tag respects those who opt out.

    6. Result and estimated gains

    • 40 to 60% of lens wearers reorder at the shop instead of drifting away.
    • Renewal sales become a predictable monthly base.
    • The free-check message fills quiet weekday mornings with appointments.