Back to Products & Projects
ComplianceRegulatoryData ManagementPlatforms
Scheduled P — Storage Temperature Compliance System
- •Led the mapping of Tata 1MG's drug database to Schedule P of the Drugs and Cosmetics Act — which governs storage temperature requirements for medicines.
- •The exercise identified drugs requiring cold chain (2-8 degrees C), cool storage (below 25 degrees C), or controlled room temperature.
- •Collaborated with the warehouse, retail operations, and catalog teams to execute bulk updates.
The Challenge
- Storage temperature data was inconsistently tagged across the platform.
- Bulk implementation across warehouses, retail stores, and hospital supply nodes required cross-functional coordination at scale.
- New SKUs added to the platform needed a forward-looking review pipeline.
The Approach
- Mapped 500+ drugs to Schedule P requirements, establishing a standardised storage classification.
- Built a bulk update pipeline for legacy SKUs and a review process for new additions.
- Defined the grey zone protocol for ambiguous storage conditions.
- Coordinated implementation rollout with warehouse and retail operations teams.
Results
Storage temperature accuracy improved from 64% to 93%.
500+ drugs mapped to Schedule P requirements.
Storage-related escalations reduced by 25% following implementation.
Forward-looking review pipeline established for new SKU additions.
Tech Stack
PythonSQLExcelInternal CMS