Industries

Inventory optimisation for pharmacy and parapharmacy chains

Lots, expiry dates, OTC seasonality and automatic replenishment

Parapharmacy, OTC and dermo-cosmetics carry lots and expiry dates, seasonal peaks and strict traceability. IRIS tracks stock by lot, warns before expiry, and replenishes each pharmacy from the forecast.

Categories covered
  • Parapharmacy
  • OTC
  • Dermo-cosmetics
  • Baby care
  • Vitamins and supplements
  • Medical devices

Typical network

Points of sale
10 to 100 pharmacies
SKUs
3,000 to 30,000
Categories
Parapharmacy, OTC, dermo-cosmetics
Constraints
Lots, expiry, seasonality

Challenges we see in the sector

Expiry loss

Lots expire in the back office while the same reference is out of stock two pharmacies away.

OTC seasonality

Cold season, allergy season, sun care and back-to-school peaks handled by instinct.

Traceability

Lot numbers must be followed from supplier to shelf; spreadsheets do not do that.

Many small orders

Dozens of pharmacies each ordering weekly from a stale stock export.

How IRIS answers

  • Stock by lot

    Lot and expiry-date tracking per pharmacy, with alerts before a lot becomes unsellable.

  • Transfers before expiry

    IRIS proposes a transfer to the pharmacy that will sell the lot in time.

  • Seasonal profiles per category

    OTC and sun-care seasonality learned from history and adjusted by the planner.

  • Replenishment per pharmacy

    Order proposals per point of sale, validated and created in the ERP with the IRIS reference.

IRIS batch and expiry tracking screen

A week with IRIS

  1. 1

    Monday: review

    Lots expiring within twelve weeks, stock-outs on OTC seasonal products, pharmacies below coverage.

  2. 2

    Tuesday: validate

    Proposals per pharmacy with lot-aware quantities, transfers before purchases, created in the ERP.

  3. 3

    Wednesday: transfers

    Near-expiry lots moved to the pharmacies that will sell them in time.

  4. 4

    Friday: measure

    Expiry loss, service level and coverage per pharmacy for the purchasing review.

In the product

01

Batch and expiry tracking

Lots with expiry dates, near-expiry counters and value at risk per pharmacy.

Batch and expiry tracking
02

Stock-out management

Current and critical stock-outs with lost revenue estimate and root cause.

Stock-out management

Results distributors target

-30 to -50 %

expiry loss

Per lot

traceability from supplier to shelf

Weekly

proposals per pharmacy, automatically

[TESTIMONIAL TO BE VALIDATED] Quote from the purchasing manager of a parapharmacy chain.

Questions from the sector

Ready to see your own numbers in IRIS?

Send us an anonymised sales export. We show you your forecasts and order proposals within 10 days.