Networked Pharmacy POS with Reporting

@SkillCrafts

I have successfully deployed several networked retail systems where real-time synchronization and data integrity were paramount, particularly in environments requiring strict inventory oversight like a pharmacy. For a rollout of this nature, my focus is on building a robust back-end that handles concurrent transactions across multiple terminals without latency or database locks. I recently completed a similar project for a multi-lane retail outlet where we implemented a centralized SQL architecture paired with offline-first synchronization to ensure the shop remains fully operational even during local network blips. Your pharmacy requires that same level of "zero-downtime" reliability, ensuring that prescription tracking and sales data are always accurate and synchronized across all your workstations in real-time. To execute this, I will implement a high-performance client-server architecture using a PostgreSQL backend, ensuring full ACID compliance for every transaction. The application front-end will be developed using a lightweight framework like C#/.NET or Python to ensure smooth performance on standard pharmacy hardware. My approach includes a modular reporting engine capable of generating real-time inventory alerts, daily sales reconciliations, and regulatory-compliant audit trails in PDF and Excel formats.

@proggon

Hi there, I understand that you’re looking to develop a comprehensive point-of-sale application for your pharmacy that caters to the unique needs of pharmacists, cashiers, and managers while ensuring seamless multi-terminal functionality. It’s crucial that the system runs efficiently on both Windows and Mac workstations, maintains real-time data integrity, and automates reporting to enhance overall operational efficiency. To meet your requirements, I propose a robust solution utilizing proven technologies that ensure a secure backend and responsive user interfaces. I’ll build core modules for inventory management with features like batch and expiry tracking, real-time sales updates, and user-role configurations for tailored access. I’ll ensure that the database syncs smoothly across all workstations without data corruption, and I’ll implement automated email notifications for scheduled reports. The configuration screens will be user-friendly, allowing your management team to adjust settings without technical intervention easily. What specific features would you prioritize in the reporting aspect to best suit your management needs? https://www.freelancer.com/u/proggon Best regards, Wahaj Barlas.

@sergiom17

Hi, I have extensive experience in building similar POS and inventory systems for retail environments where multiple terminals need to stay perfectly synchronized. My background is in Node.js/PHP backend systems, real-time databases, and multi-terminal applications, so I’m comfortable designing a cross-platform POS that runs smoothly on both Windows and macOS. I’ve previously implemented systems that handled live inventory updates, receipt printing, role-based permissions, and automated reporting, which fits well with your pharmacy workflow. My approach would be: • Build a central database service (PostgreSQL/MySQL) with safe transactions so inventory updates instantly across all tills without data corruption. • Develop a cross-platform desktop app (Electron or similar) for pharmacists, cashiers, and managers with role-based access. • Implement inventory tracking with batch & expiry alerts, real-time sales, receipt printing, and customer history. • Configure automated email reports (Z-reports, inventory summaries, monthly sales) sent as PDF/CSV on schedule. • Deliver installers for Windows & macOS, sample data, setup scripts, and a clear user manual. I’ll also test the system using two connected machines to confirm synchronization and automated emails before delivery. Estimated timeline: 2 weeks for a stable production-ready system. Happy to discuss architecture and workflow details. Regards, Sergio