Drugs database

DM+D product search · build 2026-10-27a

— products

Search level

Product name

You can also paste a dm+d code (VTM/VMP/VMPP/AMP/AMPP), PIP code or barcode — the level is detected automatically.

Supplier

Locate special order or imported products by typing "special order" or "imported".

Show invalid Hide discontinued AMPP Hide special order AMP·AMPP Hide imported AMP·AMPP Hide parallel import AMP·AMPP Drug Tariff items only VMPP·AMPP Blacklisted only AMPP Special container only AMPP ACBS only AMPP Hospital only AMPP Nurse formulary AMPP Dental formulary AMPP Personally administered AMPP FP10MDA (instalment) AMPP NMS eligible only VMP·VMPP·AMP·AMPP Broken Bulk claimable AMPP

Broken Bulk status

Special container

NMS condition

Controlled drug VMP↓

Legal category AMP·AMPP

BNF chapter VMP↓

Drug Tariff part VMPP↓

Enter search criteria and press Search

Ready to search

Choose a level, enter a product name or supplier, then press Search

Drop your files here

CSV or Excel files. Add as many as you like — they'll be combined, with a column naming the source. A workbook with several sheets is added as one source per sheet.
Not seeing your file? Show all files

Upload a price file

This file is from

Dated

Drop the price file here

Or click to choose. Phoenix CSV, or the AAH product .xml.

Wholesaler

Product, PIP code or barcode

Show

Order by

Category (wholesaler’s own)

Compare

Price is the wholesaler’s list price before discount or retro. Tariff is gross reimbursement, before dispensing fees and clawback. The gap is indicative, not realised margin.

Refresh reference data

Drop the ApoMed reference extract, the ApoMed trade catalogue, the NHSBSA BNF/SNOMED mapping or the NMS eligible drug list. Only new and changed packs are applied — prices, Drug Tariff and prescribing flags are preserved, and nothing is ever deleted. Wholesaler prices are re-mapped automatically afterwards.

Drop the reference extract here

Or click to choose. ApoMed extract, or NHSBSA BNF/SNOMED mapping (.xlsx or .csv).
Not seeing your file? Show all files

Restrictions analysis

Drop a customer restrictions file to check every restricted pack by PIP code. The ApoMed trade catalogue is checked first; a PIP it does not hold is then looked up in the ApoMed extract, dm+d and the AAH and PHD price files, and the workbook records which source matched. A pack counts as active unless it is invalid in dm+d or was discontinued two or more years ago — packs discontinued more recently are still dispensable in CRM. Restriction codes: A always force this product, B dispense the brand when the brand is prescribed, G show a generic in product choice.

Drop the restrictions file here

Or click to choose. CSV or .xlsx with PipCode and RestrictionCode; other columns are optional.
Not seeing your file? Show all files

PIP code or product name

Supplier

Source

Status

Every PIP code held anywhere — dm+d, the ApoMed trade catalogue, the ApoMed extract (including packs with no AMPP id), and the AAH and PHD price files. A numeric entry matches PIP codes by prefix; anything else matches the product description or the supplier name. Supplier comes from dm+d where a dm+d pack exists, then from the ApoMed catalogue, then from the ApoMed extract — where the extract gives no manufacturer, the supplier named in brackets in the pack description, such as Virtual Generic or Alliance, is used; the 8,071 PIPs known only from a wholesaler price file have no supplier recorded anywhere. Packs with no dm+d entry, including virtual generics and Alliance Specials, appear here and nowhere else in the application.

SB Pharma drugs database

Drop your files here

Upload a price file

Drop the price file here

Refresh reference data

Drop the reference extract here

Restrictions analysis

Drop the restrictions file here