Total Secondary Sales
—
DP value this month
Achievement
—
MRs on target: —
Active Doctors
—
Across all territories
Visits Today
—
Active Chemists: —
MR Performance Snapshot
| MR Name | Territory | Target (DP) | Achieved | % | Doctor Visits | Chemist Visits | Orders |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Doctor CRM
Loading...
All Doctors
Top Prescribers
Performance
| Doctor Name | Specialty | Territory | Chemist Links | Month Attributed | Achievement | MR Assigned | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading... | ||||||||
Chemist CRM
Mapped to distributors
| Chemist Name | Area | Distributor | Linked Doctors | Last Order | Monthly Purchases | Status | Actions |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Distributor Management
Active distributors across territories
| Distributor | Territory | Chemists | Last Upload | Sales Value | Contact | GST Number | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading... | ||||||||
Product Master
| Product Name | Composition | Pack Size | MRP | DP | Category | Status | Actions |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Territory Management
Territory Overview
| Territory | MRs | Doctors | Chemists | Month Sales | Actions |
|---|---|---|---|---|---|
| Loading... | |||||
Territory Achievement
Loading...
Excel Upload Engine
Secondary sales attribution pipeline
Attribution Pipeline
○ Read Excel rows (Chemist Name · Product · Qty)
○ Fuzzy-match chemist name
○ Fetch linked doctors for chemist
○ Look up product DP value
○ Split attribution across linked doctors
○ Update MR target achievement
○ Recalculate commissions
Required Excel Format
| Chemist Name | Product Name | Quantity |
|---|---|---|
| Sai Medical Store | Amoxycillin 500 | 50 |
| Krishna Medicals | Metformin 1g | 100 |
| Apex Pharmacy | Atorvastatin 20 | 30 |
Note: Chemist and Product names must match records in the system. Fuzzy matching is applied.
Recent Uploads
| Filename | Distributor | Total Rows | Processed | DP Value | Status | Date | Errors |
|---|---|---|---|---|---|---|---|
| No uploads yet | |||||||
Import / Export
Bulk upload or download your master data
⬆ Import
⬇ Export
Step 1 — Download Sample File
Choose what you want to import, download the sample Excel, fill it in, then upload below.
Tips:
• Do not change column headers
• For Doctors: Territory name must match an existing territory
• For MRs: Territory name must match an existing territory
• Leave the ID column blank — it's auto-generated
• Do not change column headers
• For Doctors: Territory name must match an existing territory
• For MRs: Territory name must match an existing territory
• Leave the ID column blank — it's auto-generated
Step 2 — Upload & Import
Visit Logs & GPS
Field visit tracking
Recent Visits
| Date | MR | Contact | Type | Remarks | Duration | GPS | Status | Action |
|---|---|---|---|---|---|---|---|---|
| Loading... | ||||||||
MR Visit Summary — This Month
Loading...
Order Entry
Primary sales orders from chemists via MR
Total Orders
—
Order Value
—
Pending
—
Fulfilled
—
Payment Due
—
💡 Marking an order DELIVERED automatically updates secondary sales, target achievement and commission.
| Order ID | Date | Bill To (Distributor) | Ship To (Chemist) | MR | Items | Value | Payment | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|
| Loading... | |||||||||
Sample Inventory Tracking
Physician samples distributed by MRs
Sample Stock by Product
| Product | Allocated | Distributed | Balance | Status | Action |
|---|---|---|---|---|---|
| Loading... | |||||
MR-wise Sample Distribution
| MR | Issued | Given to Drs | Balance |
|---|---|---|---|
| Loading... | |||
Attendance Management
Punch In/Out with GPS verification
Today's Summary
—
Present
—
Absent
—
Attendance %
Loading monthly stats...
Today's Punch Log
Loading...
Target Management
DP Value Based Monthly Targets
Company Target
—
Achievement
—
— achieved
Days Remaining
—
MRs On Target
—
MR-wise Target vs Achievement
| MR | Target (DP) | Achieved | % | Gap | Trend |
|---|---|---|---|---|---|
| Loading... | |||||
Commission Engine
Monthly commission calculation & approval
Total Calculated
—
Approved
—
Pending Approval
—
Total Paid
—
Commission Ledger
| MR Name | Achievement | Rule | Base (DP) | Rate | Commission | Status | Action |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Company Settings
Business profile used on invoices, cash memos and bills
Company Identity
Licences & Registrations
Bank Details (shown on invoice for NEFT/RTGS)
Preview — Bill Header
—
—
—
💡 These details appear on every Cash Memo and invoice generated from the system.
Stock Inventory
Product stock levels, receipts and movements
| Product | Category | Pack | MRP | DP | Stock | Min Stock | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading... | ||||||||
User Role Control
3 roles: Admin · Manager · MR
| Name | Role | Territory | Last Login | Status | Actions | |
|---|---|---|---|---|---|---|
| Loading... | ||||||
📱 PharmaOps MR Mobile App
Share this URL with MRs · Works offline · Add to Home Screen for native feel
Loading URL...
📱
Loading MR data...
📱 How to Use as Mobile App
Android / iPhone:
1. Open this URL in Chrome or Safari
2. Tap browser menu (⋮)
3. Select "Add to Home Screen"
4. It installs like a native app
⚡ MR Quick Actions
Quarterly Sales Report
Target vs Achievement — Quarter-wise
Q Target
—
Q Achieved
—
Achievement %
—
Total Commission
—
MR Performance — Quarter
| MR Name | Territory | M1 Target | M1 Achieved | M2 Target | M2 Achieved | M3 Target | M3 Achieved | Q Total Target | Q Achieved | % | Gap | Visits | Orders | Commission |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Select year & quarter then click Load | ||||||||||||||
GST & Invoices
GSTR-1 summary and invoice management
Taxable Value
—
Total GST
—
Invoice Total
—
Total Invoices
—
B2B Supplies (Chemists with GSTIN)
| Invoice No | Date | Party | GSTIN | Taxable | CGST | SGST | Total | Action |
|---|---|---|---|---|---|---|---|---|
| Select month and click Load | ||||||||
B2C Supplies (Unregistered)
| Invoice No | Date | Party | Taxable | GST | Total | Action |
|---|---|---|---|---|---|---|
| Select month and click Load | ||||||