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 & Solution
- 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.
Key Results & Commercial Impact
Technology Stack & Tools
Have a similar project in mind?
We specialize in custom AI systems, clinical data licensing pipelines, and scalable web apps. Let's build something exceptional together.
Explore More Projects
Google Health Partnership
Packaged clinical content as LLM training data, including drug monographs, DDI data, disease content, and regulatory safety data, in a B2B monetization deal.
Samsung Health API Integration
Real-time API integration spanning 600K+ SKUs, 50+ attributes, and a 200K-interaction DDI tool, enabling in-app discovery and routing cart/checkout to Tata 1mg.
Elsevier Clinical Monograph API Partnership
Tata 1mg's first clinical content licensing deal. Delivered 1,500 structured drug monographs over 9 months and built the CMS & API infrastructure.