MedLens

Import drug prices (Excel)

Upload an .xlsx in the supported long format. This updates the database.

Upload Excel

Pharmacy upload uses POST /api/import/prices/xlsx. Include discount_pct (percent off MRP, 0–100) plus mrp_inr and either price_inr or derive price from MRP − discount. Columns: city, state, pharmacy_name, drug_name, strength (form, pack_size optional with defaults); price via price_inr or mrp_inr + discount_pct.
Diagnostics partner upload (lab tests): POST /api/import/lab-prices/xlsx — columns city, state, lab_name, test_id, mrp_inr, discount_pct, price_inr (test_id = lab_tests.id). Use the lab template row 3 as a layout guide.

Upload diagnostics (lab) prices