Cloud Based Automation Software for Pharma Industry

Cloud Based Automation Software for Pharma Industry

1,2,3,4B. Tech, Student Department of Computer Engineering, Vishwakarma Institute of Technology, Pune, Maharashtra, India

5Professor, Department of Computer Engineering, Vishwakarma Institute of Technology, Pune, Maharashtra, India

Abstract - This system demonstrates the concept and implementation of a pharmaceutical management system with an inventory alert system. The main purpose is to improve accuracy, labor saving, labor saving, safety and efficiency improvement in the pharmaceutical business. This is the web platform for B2B consumer as well as medical stores that sells numerous pharma merchandise like ethical, surgical, generic, homeopathic merchandise now no longer at once to give up customers however to different corporations or retail scientific stores. System will get rid of conventional enterprise version with the aid of using the usage of the shop clerk or middleman & makes it fast, costefficient, & it available (24*7) & it deliver drug treatments from producer to retailer (no middle-man) throughout pan India. This System will offer computerized invoice generator, stock control, close to expiry notifications, POS systems to the medical owners & distributors & it is most effective for each retailers & distributors only. As a datapushed version, each selection making at software program is constantly primarily based totally on data.

Key Words: Pharma Products, Reduce Manpower, Inventory Management, Accuracy, Expiry notification

1. INTRODUCTION

The Pharmacy Management System is a complete pharmacy workflow management system designed to improve accuracy, reduce manpower, time and costs, and improve safety and efficiency. In of the Most Pharmacy store still traditional model is followed i.e. salesman’s are used for ordering new products. This traditional system requiresapharmacistorsalespersontomanuallymonitor theentireprocess,confirmingthepresenceofeachdrugin thepharmacysothatthoseproductscanberestocked.

Therefore, while brand new capsules or new batches of medicinearriveatpharmacies,accesstoguidesisthrough theregistrywiththehelpofmedical guides.Andthisgoes along while the drug is being administered to every patient.Attheendofthemonth,thepharmacyclerkmust manually create a pharmacy drug list or record. These records are kept to maintain necessary inventories at the pharmacy. This software program can be used to provide product expiration notifications as well as an automated invoice generator for inventory retention. This allows

pharmacy users to handle entrances and exits easier and better.

2. Problem Statement

Pharmacy dealers need to keep paper files in folders. Managing very large pharmacies with paper records can be cumbersome, and based on over-the-counter drugrelated inventory, expiry dates, categories, and salt formulas, including substitutes, it can be difficult to track the amount. Pharmacists need to order medicines to replenish alreadydeclining supplies.Moreover,ordersfor medicines are made in a conventional way, without the help of intermediaries and sellers. Creating a purchase ordertakesalotoftimeasthepharmacisthastocheckthe inventory and roughly estimate the order quantity. Additionally, a significant amount of money is spent to give the fictitious salesman time to order new items. Notify the pharmacist of stocks that are close to the expiration date and prevents them from being sold out. This project reduces middlemen. Eliminating vendor and chain blocks that can be used to order new inventory reduces costs and time and helps solve the above problems

3. Objective

a)RemovetheSalesRepresentativeandMRrolesfromthe system.

b) Providing data analytics to healthcare owners and distributors.

c)facilitateaccesstomerchantdata;

d) change the database and make it ready for immediate use.

e)Allowseveraluserstobeactiveatthesametime.

f) You will be notified about medications that are nearing/expiringorbelowthreshold.

g) You will receive an inventory notification that the inventoryhasbeencompleted

Volume: 10 Issue: 01 |

Literature Survey

1 Designing a Computerized Pharmacy Management System with Inventory Stock AlertSystem

2 Design an Information Management System foraPharmacy

2016 Asst.Lect. Asan Baker Kanbar, Hawbir Latif Abdulqadir, Rezhan MohammadAhmed

2018 Hewa Majeed Zangana

In this Paper, the system manages most of the pharmacy-related activities at the pharmacy. The main goal of is to improve precision, safety and efficiency in the pharmaceutical business. The projectcanalsoincludebarcodefunctionalitywitha barcode reader that recognizes expiry dates and otherinformationabouttheassociateddrug.

Inthispapera systemis essentially a computerized system that helps pharmacists improve inventory management, costs, medical safety, and more. The system allows users to enter manufacturing dates and expiry dates for specific products or pharmaceuticalsduringinventoryopeningandsales transactions. Before the products finally expire, the system also publishes a report showing the list of products that will expireafter a certain date. It also includes manual entry when new batches of medicine arrive and when medicines are shipped fromthepharmacyforaspecifiedperiodoftime.

3 Building IT-based Pharmacy: Computerized Pharmacy Management

2020 B Kurniawan* and MIkhsan

The purpose of this research paper is to develop a computer-basedsystemthatenablespharmaciststo perform their drug administration tasks. This study useddescriptivemethodstoanalyzehowthe Farma pharmacy handled drug supply, sales transactions, drug purchases, and manual reporting administrativeactivities.

2020

This paper includes information technology and databases as a repository of information useful for hospital management, and various tools necessary to build a trustworthy system, and this document addressestheseconcerns.increase.Dataenrichment andcompliancewithautomatedmanualdrugsupply activitiescompletethisbriefreview.However,there are various challenges regarding the interests of bothinternalandexternalhospitals.

This pharmacy management software is an integrated system that manages goods and medicinesandautomaticallyperformstaskssuchas checking inventory, checking medicines, and managing bills and reports. The software provides pharmacies with a complete view of their business operations and an overview of costs, revenues and sales

5. Proposed System

The methodology used in designing and developing this system is through react JS, HTML5, CSS3, Bootstrap5, DjangothedatabaseMYSQLwillbeusedforstoringClient Details. The Registration processes for each user will be done through a webpage that will store Email ID, Password and other such details in a Mongo DB database table.Adminhashisowncredentialsthroughwhichhecan addcategoriesaswellasproducts.Similarly,clienthashis own credentials through which he/she can access all the products&orderthem.

5.1 Admin Module

Oncetheadminloginintosystemhewillbeabletosee receivedordertilldate,expirydatesofproductsaswellas productswhicharegoingtobefinished.Hewillbeableto addnewcategoryofproducts,editaswellasdeletethem. Admincanaddnewproducts,editanddeletethemasper the requirements of users. After receiving the orders admin can track them and edit order status for delivering ofthoseproducts.

5.2 Client Module

Clientcanloginintosystem usingvalidcredentialsi.e., emailidandpassword.Aftersuccessfulloginclientwillbe able to see all the products. This module is basically designed for providing easy access to order products. Client can easily order products, he/she will get notifications about the products going to be expired as wellasproductsgoingtobefinishedfromstalkssothathe willbeabletoorderthemagainwithoutanydifficulties.

6. Results & Discussions:

7. TOOLS & TECHNOLOGY USED

• Operating System: Windows10

• IDE: VisualStudioCode

• Front End: ReactJSHTML5,CSS3,Bootstrap5

• Back End: Django(Python)

• Database: MYSQL

• Technology: WebDevelopment

8. ACKNOWLEDGEMENT

Prof. Dr. S.T. Patil is appreciated for his invaluable assistance in guiding us throughout the project and looking into it as necessary. We also acknowledge the Pythoncommunityfortheircomprehensiblelibraries

9. CONCLUSION

AnEffectiveimplementationofthissoftwarecaneasily and effectively store information about activities in a particular area, thus fulfilling all the basic needs of retailers. This achieves system design goals. This automatedsystemhelpsretailersprocessnewrecipesand replenish inventory quickly and easily with a few keystrokes. You will receive notifications of discontinued products and stem processed products, so reordering is easy. It also saves you time and money as there are no middlemen. You can easily track your inventory with the helpofthissoftware.

10. FUTURE SCOPE

Our present application may be having less functionalityorlessproblemswesolvedinthehealthcare sector. But we believe in future we will be capture all the problemsfacedbyindustryinourresearch&wealsotried to give the best tech solution for this industry, by using artificial Intelligence, data analytics, machine learning, image processing like new technologies with greater accuracy because they are capable of doing best solution forourapplication.

11. REFERENCES

[1] Asst.Lect. Asan Baker Kanbar, Hawbir Latif Abdulqadir, Rezhan Mohammad Ahmed “Designing a Computerized Pharmacy Management System with InventoryStockAlertSystem”,InternationalJournalof Emerging Trends & Technology in Computer Science, Volume5,Issue5,September-October2016

[2] Hewa Majeed Zangana “Design an Information Management System for a Pharmacy”, International Journal of Advanced Research in Computer and Communication Engineering Vol. 7, Issue 10, October 2018

[3] B Kurniawan* and M Ikhsan “Building IT-based Pharmacy:ComputerizedPharmacyManagement”IOP Conference Series: Materials Science and Engineering,2020.

[4]MahyuddinK. M.Nasution , Shahrul Azman Mohd Noah , Urip Harahap ”Overview of The Pharmacy Management System in a Hospital”, A multifaceted review journal in the field of pharmacy, Vol 11, Issue 11,Nov-Dec2020.

[5]MadhaviMali,Sandhya Alibade,RajdeepParbhane, Aparna Awade, Aruna Yadav “Survey on Pharmacy Management System”, International Research Journal of Modernization in Engineering Technology & Science,Vol:03,Issue:12,December-2021