msupply-foundation / unified-codes

Provides a curated, searchable list of pharmaceutical products, each with an immutable code. A GraphQL API, a REST API and website are available for interaction with the database.
https://codes.msupply.foundation
2 stars 0 forks source link

551 duplicate names in dataloaded data #562

Closed jmbrunskill closed 8 months ago

jmbrunskill commented 8 months ago

Fixes #551

Description

Two products had the same product name but different codes, this seems to be the case all the way back to 4.3 version spreadsheets. I've updated to use one (effectively deleting a code, but unlikely to be being used anywhere)

Wrote a quick python script to check for others product name code miss matches, but seems ok.