TEST COMPANY
Add New
Category
Product
Doctor
Purchase
Sale
Proforma
Purchase Return
Admin
Admin
MyProfile
Logout
My Profile
Logout
Booking
Dashboard
Manage Rooms
Advance Booking
Room Booking
Customers
Monthly
Housekeeping
Night Audit
revenue_analytics
service_billing
guest_history
Appointment
Clinic Dashboard
Doctor Dashboard
New Appointment
Availability Calendar
Manage Doctors
Manage Patients
Item Portals
Dashboard
Retail Items
Pharmacy Items
Optical Items
Retail
Item list
Category
Sub Category
Brand
Garment
Item list
Category
Sub Category
Color
Size
Brand
Pharmacy
Item list
Category
Sub Category
Brand
Optical
Item list
Brand
Pharmacy Directory
Manage drug scheduling, compositions, batches, and expiry warnings
IMPORT EXCEL
ADD MEDICINE
ID
Medicine Name
Category
Cost Price
Sale Price
MRP
Tax (%)
HSN
Action
Add New Medicine
Back To List
Medicine/Item Name
*
:
Salt / Active Composition:
Drug Schedule:
Select Schedule
OTC (Over the Counter)
Schedule G
Schedule H (Prescription Only)
Schedule H1 (Controlled)
Narcotic/NDPS
Category
*
:
Select Category
Sub Category
*
:
Select Sub-Category
Select Tax:
N/A
5%
12%
18%
28%
Unit:
Conv. :
Sub Unit:
MRP (₹):
HSN Code:
Cost Price (₹):
Sale Price (₹)
*
:
Cancel
Submit
Import Medicines from Excel
Choose Excel File (.xlsx, .xls, .csv)
The sheet columns should match:
ITEM_NAME
(required),
SALT_NAME
,
BATCH_NO
,
EXPIRY_DATE
,
DRUG_SCHEDULE
,
CATEGORY
,
COST_PRICE
,
SALE_PRICE
,
MRP
,
TAX
,
HSN
,
STOCK