Automation

Automated online order processing system for pharmacy network

16.06.2020

A universal automation system has been developed for a large pharmacy chain, ensuring quick order processing, real-time stock updates, and effective interaction between pharmacies, operators, and customers.

Key Features of the System

🔹 Automated Order Processing
  • The network consists of more than 17 pharmacies, and customers can place orders through the online store, selecting any of these pharmacies.
  • Once an order is placed, the system automatically checks product availability, reserves items, and sends an SMS notification to the customer.
🔹 Transparency for Pharmacists
  • All incoming orders are displayed in real-time in the relevant pharmacy.
  • Pharmacists can view the order status at every stage: "created," "being processed," "at the pharmacy," "with the operator," etc.
🔹 Operator Handling for Complex Orders
  • If an order cannot be processed automatically due to stock issues, insufficient quantities, or other reasons, it is transferred to the operator.
  • The operator contacts the customer, offers alternatives, additions, or changes, and then redirects the modified order to the pharmacy for final approval.
  • In case of issues, the pharmacy can send the order back to the operator with comments.
🔹 Automatic Status Updates & Fiscalization
  • All order statuses are updated automatically, with final fiscalization (sale) at the cash register.
🔹 Database Integration & Optimization
  • Over 50,000 products in the online store are synchronized with pharmacy stock, preventing out-of-stock sales.
  • Prices are updated every 3 hours, with over 670,000 records synced.
  • Thanks to the optimized algorithm, data transfer between 1C and the website’s database takes only 50 seconds.
🔹 Pharmacist Testing System
  • The built-in system for professional competency testing:
  • The customer service department creates questions and sets test times.
  • Pharmacists can take the test from their workstations, ensuring a fast and convenient process.
🔹 24/7/365 System Operation
  • The system operates continuously.
  • Any downtime can result in stuck orders (>10 per minute) and dissatisfied customers.
This solution significantly enhances the efficiency of pharmacy operations and improves customer service quality.

Client:

DENDI Pharm
(viridis.ua)

Used:

  • PHP, MariaDB, Redis, Boostrap, 1C, API

Share