Step by step
- Open Inventory > Medicines (Pharmacy). The pharmacy pages show only when the Pharmacy app is on for your business.
- Use the filters: Show (All products, Medicines (details filled), Generic not set, Batch & expiry off, Prescription (Rx), Controlled drugs), Generic, Company and Dosage Form. The line above the table counts the products, those with a generic and those with batch and expiry on.
- Click the edit icon of a product to open Medicine Details. Type or pick the Generic Name and fill Strength, Dosage Form and DAR No.
- Enter Strip / Pack Size (how many tablets or pieces are in one strip) and Strips In A Box. Pack units like "Strip (10)" and "Box (10x10)" are added to the product.
- Set Prescription to Required (Rx) and Controlled Drug to Yes where needed. Set Batch & Expiry to Yes when purchases must ask for a batch and expiry date. Press Save.
- To fill many products press Download: you get a CSV file of every product with its current details. Fill the columns in Excel without changing Product Code.
- Press Import, choose the filled file (.csv, .xlsx or .xls) and press Import. The message tells how many products were updated and which codes were not found.
- Excel and Print export the list.
Good to know
- Company is the Brand of the product; change it on the product form.
- The import matches rows by Product Code. An empty cell clears that detail; a column that is not in the file is left as it is. Up to 30,000 rows and 10 MB per file.
- Pack units are added only when the unit of the product is a base unit (Tab, Cap, Pcs). Stock is always kept in that unit; a strip of 10 is sold as 10 of it.
- A new Generic Name typed here is added to Generics by itself.
- Typing a generic name in the POS or Add Sale search lists every brand of that medicine.
- The same details are on Add Product and Edit Product too, in the Medicine Information card.