added methods for pharma inventory management