Case Study · Veterinary Pharma Manufacturing
How a Vet Pharma Maker Cut Expired Returns by 40% with Field Automation
Industry
Veterinary Pharma Manufacturing
Revenue Band
₹30-50 Cr annual turnover
Company Size
120-180 employees
Tools Deployed
Zoho CRM, Inventory, Creator, Analytics
The Problem
This veterinary pharma manufacturer runs a field force of 40+ reps covering thousands of dealers across multiple territories. Orders were collected on paper slips during field visits, then manually keyed into Tally at HQ, creating a 3 to 5 day lag between order capture and dispatch.
Paper-Based Field Orders
Reps noted orders on printed slips during dealer visits. Slips were collected weekly, bundled, and couriered to the head office. Handwriting errors and missing SKU codes caused frequent order mismatches, with roughly 12% of slips needing clarification calls before entry.
Batch and Expiry Blind Spots
Warehouse staff had no visibility into which batches were sitting at dealer shelves. Near-expiry stock was dispatched without checking dealer-level inventory, leading to expired product returns worth ₹25L+ annually. Batch recall coordination took 10 to 14 days on average.
Dispatch Lag and Stock Mismatches
The gap between order capture and Tally entry meant dispatch happened 4 to 6 days after the dealer placed the order. By that time, warehouse stock positions had shifted. Dispatchers relied on Excel sheets updated once daily, causing frequent short-shipments and split dispatches.
The Solution Stack
The implementation, led by our Zoho implementation services team, prioritized getting field reps onto a mobile ordering system first, then connecting that flow to batch-tracked inventory and dealer stock dashboards.
Dealer Management and Field Rep Tracking via Zoho CRM
- Dealer master with territory mapping, credit limits, and product-wise pricing tiers
- Field rep check-in/check-out with GPS stamping on each dealer visit
- Automated visit scheduling based on dealer order frequency and territory routes
- Credit hold alerts triggered when dealer outstanding crosses threshold
Batch-Tracked Stock and Dispatch
- Batch-level tracking with manufacturing date, expiry date, and FIFO enforcement on dispatch using Zoho Inventory
- Warehouse bin-level stock positions updated in real time on every inward and outward entry
- Auto-generated pick lists sorted by batch expiry to clear near-expiry stock first
- GST-compliant invoicing with batch details printed on every dispatch note
Mobile Field Order App and Dealer Stock Capture
- Custom mobile app for field reps to place orders with product search, batch selection, and dealer pricing auto-applied
- Dealer shelf-stock capture form: reps log current dealer inventory during each visit
- Offline mode with sync-on-connectivity for reps covering rural territories with patchy network
- Return request workflow with photo upload and batch barcode scan for expired stock
Expiry Risk Dashboards and Sales Intelligence
- Dealer-wise expiry risk dashboard showing stock nearing 60, 90, and 120 day expiry windows
- Territory-level sell-through rate reports for each product SKU
- Field rep performance scorecards: visit frequency, order conversion, return ratio
- Monthly batch wastage report with drill-down by product category and territory
Before vs. After
| Process Area |
Before Zoho |
After Zoho |
| Field Order Capture |
Paper slips, couriered weekly to HQ |
Mobile app, orders sync within minutes |
| Order to Dispatch |
4 to 6 days average lag |
Same day or next day dispatch |
| Batch Tracking |
Manual register at warehouse, no dealer visibility |
Real time batch tracking, warehouse to dealer shelf |
| Expiry Management |
Discovered only when dealers returned stock |
60-day advance alerts with dealer-level stock data |
| Dealer Stock Visibility |
None. Reps estimated during calls |
Captured every visit, visible on central dashboard |
| Return Processing |
Paper forms, 10 to 14 day turnaround |
Photo + barcode scan, processed in 2 to 3 days |
| Sales Reporting |
Monthly Excel compilation by admin team |
Live dashboards with territory and SKU drill-down |
Implementation Phases
01
Discovery & Data Audit Weeks 1-2
- Mapped existing order flow from field slip to Tally entry to dispatch
- Audited dealer master data: 1,800+ dealers across 6 territories
- Catalogued 340+ active SKUs with batch and expiry metadata requirements
- Identified top 5 product categories driving 80% of expired returns
02
Core Setup: CRM & Inventory Weeks 3-6
- Migrated dealer master from Tally with territory, pricing tier, and credit limit mapping
- Configured batch-tracked inventory with FIFO dispatch rules and expiry date fields
- Set up warehouse bin locations and inward/outward workflows
- Built GST-compliant invoice templates with batch details and drug licence numbers
03
Field App Build & Pilot Weeks 7-10
- Built a Zoho Creator mobile app with offline order capture, product search, and batch selection
- Added dealer shelf-stock capture form with barcode scanning
- Piloted with 8 reps in one territory over 3 weeks, iterated on UX based on field feedback
- Integrated order flow: Creator app to CRM deal to Inventory sales order to dispatch
04
Full Rollout & Analytics Weeks 11-14
- Rolled out to all 40+ field reps with on-ground training sessions per territory
- Deployed Analytics dashboards: expiry risk, sell-through rates, rep performance
- Configured automated alerts for batches within 90 days of expiry at dealer locations
- Established monthly review cadence with territory managers using live data
Results
Within 5 months of full rollout, the company saw a measurable drop in expired product returns and a sharp reduction in order-to-dispatch cycle time. Warehouse teams now dispatch based on real batch data instead of guesswork, and field reps capture dealer stock positions on every visit, giving the supply chain team early warning on slow-moving batches.
0%
Fewer expired product returns
0x
Faster field order to dispatch
₹0L
Annual savings on recall waste
Key Metrics: Before vs. After
Expired Return Rate: Month over Month After Go-Live
What This Means for Veterinary Pharma Manufacturers
Vet pharma companies deal with short shelf-life products moving through a fragmented dealer network. The root problem is never just “paper orders.” It is the complete absence of batch-level visibility beyond the factory gate. Once field reps capture dealer stock on every visit and dispatch runs on FIFO batch logic, expired returns stop being a cost of doing business and become an exception.
Frequently Asked Questions
Can field reps place orders in areas with poor mobile connectivity?
Yes. The Creator mobile app works in offline mode, storing orders locally on the device. When the rep moves back into network coverage, all pending orders sync automatically to the central system. During the pilot phase, reps in rural territories tested this extensively, and sync reliability was above 99% across all captured orders.
How does the system handle dealer-level expiry tracking for thousands of SKUs?
Every time a field rep visits a dealer, they log shelf stock using a barcode scanner built into the Creator app. This data feeds into Analytics dashboards that flag batches approaching 60, 90, or 120 day expiry windows. The supply chain team can then push targeted schemes or swap stock before it expires, rather than waiting for the dealer to raise a return.
What was involved in migrating from the existing Tally-based workflow?
The dealer master, product catalogue, and opening stock balances were migrated from Tally during weeks 3 to 6. Batch-level historical data required manual cleanup because Tally did not enforce structured batch fields. The team ran both systems in parallel for one territory during the pilot, then cut over fully once dispatch accuracy matched the old process.
Does this setup support Drug Licence and regulatory compliance for vet pharma products?
Yes. Dealer records in CRM store Drug Licence numbers, and every invoice generated through Inventory prints the relevant licence details alongside batch number, manufacturing date, and expiry date. This ensures dispatch documentation meets the regulatory requirements for veterinary pharmaceutical distribution without manual intervention by the billing team.
