A ready-made medicine list for your pharmacy, ready to import
A ready-made Excel list of 18,567 products for a pharmacy, with names and most prices filled in, and cost and opening stock left for the shop to set.
Short answer The medicine list in Excel format is a workbook of 18,567 products for a pharmacy: 17,819 medicines, 391 brand-free generic supplies and 357 other goods. Products > Import reads it, and its rows wait in the Catalogue library until the shop adds them as products and sets each price, cost and stock in Bulk edit. It needs Basic or Professional.
A pharmacy on SellyPOS does not have to type thousands of medicines into the till by hand. The medicine list in Excel format is one workbook of 18,567 products; the shop adds what it stocks.
What is in the medicine list in Excel format?
The medicine list in Excel format is a workbook of 18,567 products: 17,819 medicines, 391 brand-free generic supplies and 357 other goods. It has 1,149 different generic names, and its products come from 623 makers and brands.
Medicines are marked prescription (12,423) or over-the-counter (5,396) by their category, following the source’s flag. Tablets, injections, capsules, suspensions, syrups, drops, creams and ointments cover 94% of the medicines, and 17,433 products carry a strength.
The row below is invented.
| What the row holds | Invented example |
|---|---|
| Name | Example 500 mg tablet |
| Generic name | Examplamine |
| Strength | 500 mg |
| Dosage form | Tablet |
| Category | Prescription medicines |
| Price and MRP | Filled, tax included, per tablet |
| Pack level | A strip of ten tablets |
| Cost, opening stock and tax group | Empty, for the shop to set |
9,472 products have a strip level and 5,758 a box level, each a pack level of the same product.
Are the prices and MRPs already filled in?
Yes, in the file: each price and MRP is filled in for medicines and other goods, tax included, as a retailer’s shelf price on 5 November 2026. The 391 generic supplies have no price, so the shop prices them before selling.
When a medicine is added to your products, its MRP and pack levels come with it, but its selling price and pack prices are left empty for you to type. The MRP is a ceiling: no price above it is sold, and no setting or approval lifts that limit.
What happens to the rows when I import the file?
Products > Import reads the file and sends its rows to the Catalogue library, because the file has no opening stock. A row becomes one of your products only when you add it, and you then set its price, cost and stock.
The Catalogue library sits on the main computer only, not on client tills. Its items stay out of every search and list until you add them. Search, filter or scan the library, tick the items you stock and press Add to my products. They join your products flagged as incomplete, with no selling price, stock or cost, and Bulk edit opens on them so you type those in.
An import only adds products. A row whose name, SKU or main barcode matches a product already in the shop is skipped, not updated.
How do I get the medicine list?
You get the medicine list from Selly Systems on WhatsApp, after you have bought a licence. Reach Selly Systems through the contact page. It imports on Basic or Professional, so compare the editions on the pricing page first.
Can I sell a medicine from the list straight away?
A medicine from the list cannot be sold until it is in your products and has a price. The counter refuses a product with no price, and the list’s prices are a starting point that the shop checks.
- Open Products > Import and choose the file. Match its columns, choose the products, check the rows and import them. The chosen rows wait in the Catalogue library.
- Open Products > Catalogue library, tick the medicines you stock and press Add to my products. Bulk edit opens on them.
- In Bulk edit, type each price, pack price, cost and opening stock.
In a pharmacy shop the medicine card holds the generic name, strength, dosage form and storage conditions. They are asked for and never required.
What does Lite leave out?
Lite holds 20 products, so it cannot take this list. It also has no import, no Catalogue library, no lots or expiry dates and no alerts.
What the list does not do
- The prescription and over-the-counter marks follow the source’s flag and are not a pharmacist’s ruling. Check any marking you rely on with your pharmacist and the authority that issued your drug licence.
- SellyPOS has no drug-interaction checks or dosage warnings.
- SellyPOS does not keep prescriptions or a controlled-drug register.
- Ringing up single tablets does not switch the sale to the box price.
For example
For example, the owner imports the list, adds only the medicines the shop stocks, then types each price in Bulk edit.
Next
For the steps, read how to import products from an Excel file and import products from Excel. For the whole counter, see pharmacy POS software and expiry date tracking. Then download SellyPOS and compare the editions and prices.
Questions people ask
What is the ready-made medicine catalogue?
The ready-made medicine catalogue is a workbook of 18,567 products: 17,819 medicines, 391 brand-free generic supplies and 357 other goods, from 623 makers and brands. Prices and MRP are filled; cost, opening stock and tax group are left for the shop, so its rows wait in the library. The file comes from Selly Systems on WhatsApp after a licence is bought. Basic and Professional only.
How many medicines can I add to SellyPOS?
Lite holds up to 20 products, and a medicine counts as one of them. Basic and Professional do not have that 20-product cap, and no other product limit is stated here. The ready-made medicine file holds 17,819 medicines, and Basic and Professional can import that file once the shop has it. See the pricing page for what each edition includes.
How much does pharmacy software cost?
SellyPOS Lite is free for ever, with no trial and no licence. It holds up to 20 products, and a pharmacy usually stocks more medicines than that. Basic and Professional each start with a 7-day free trial, then a one-time payment for the licence. The amounts are on the pricing page. Batch and expiry tracking, which a pharmacy needs, are in Basic and Professional.