The Customer

Green Medical Cross outside a Pharmacy

In October 2021, some Belgian pharmacies were asked to prepare and deliver COVID-19 vaccines to doctors in their region.

The Challenge

The difficulty for the pharmacists was to optimise the use of vaccine bottles. A bottle of vaccine could be used to make between 5 and 7 injections for adults and between 10 and 12 injections for children.
Of course, doctors could not always book a number of shots to match a round number of bottles. So it was necessary to group shots between doctors to minimise the number of shots lost.

Pharmacists also had to report the name and national number of the patient who received the injection.

In addition, the distribution process was announced only a few weeks before the start of the vaccination campaign.

The Solution

B2CK decided to quickly implement a backend using Tryton that could be deployed for each pharmacy, coupled with a Flask website for doctors to make their reservations.

The requirements for the backend were

  • Define the pharmacy details (such as opening hours, holidays etc.)
  • Define the stock per period
  • Invite doctors to the platform
  • Manage vaccinations
  • Daily reports
  • Forecast injections including second injections (1 month later)
  • Vaccination data to be purged after 90 days

Here are the requirements for the physician website

  • Easy access
  • Book shots for their patients
  • Display remaining shots to complete a bottle
  • Track injections per patient
  • Schedule a second shot for each patient

The Implementation

The main implementation was done over a weekend due to the short time frame.

A Tryton module implemented all the requirements using only built-in modules For ease of use, only 7 menu items were created, each providing only the necessary information. A scheduled task was responsible for removing the booked vaccines after 90 days.

Tryton screen with the pharmavax menu and vaccines tab open

For the website, a Flask application was developed using flask-tryton and Bootstrap. The doctors has access via a secret URL to avoid password management.

Pharmavax website opened to the vaccine booking tab

Docker was used to deploy the solution using a docker-compose file with an entry for each pharmacy.

Results

B2CK hosted the application for some pharmacies for 10 months.
Approximately 100 doctors used the website to book vaccine injections.
Due to the automatic cleaning of the personal data, we do not know how many shots have been prepared.

Using Tryton allowed B2CK to develop a solution quickly and to maintain it without too much effort.

Provider

B2CK provided its development experience with Tryton and Web application