Medicines and stock

The Gestion des Médicaments screen#

The toolbar contains:

• The 🔍 Rechercher par nom, catégorie... (search by name, category) field: instant search across the name, the category and the barcode.
• The type filter: 🏷️ Tout (all), 💊 Médicaments (medicines) or 🌿 Parapharmacie (parapharmacy).
• The stock filter: Tous (all), Stock faible (low stock: positive quantity below the threshold), Rupture de stock (out of stock: zero quantity), Expire bientôt (expiring soon: expiry within the alert period), then the categories: Médicament, Parapharmacie, Cosmétique, Complément alimentaire, Matériel médical, Autre (medicine, parapharmacy, cosmetic, food supplement, medical equipment, other).
• The buttons ➕ Ajouter (add), ✏️ Modifier (edit), 📦 Voir Lots (view batches), 🗑️ Supprimer (delete) and 📥 Importer Excel/CSV/PDF (import).

Columns: ID, Type (💊 or 🌿), Nom, Quantité, Prix Vente (DA), Prix Achat (DA), Date de Péremption, Catégorie, Code-barres, Fournisseur (name, quantity, selling price, purchase price, expiry date, category, barcode, supplier). Clicking a header sorts the column (ascending, then descending). The quantity is shown in red at zero and in orange below the threshold. The number of products displayed appears below the table.

Adding a medicine or product#

1. Click ➕ Ajouter: the Ajouter Médicament (add medicine) window opens.
2. Fill in the fields (table below); those marked with an asterisk are required.
3. Click 💾 Enregistrer (save).

Editing or deleting a product#

• Edit: select the row, then ✏️ Modifier, or double-click it; save with 💾 Enregistrer.
• Delete: select the row, 🗑️ Supprimer, then confirm. Deletion is permanent.

Importing an Excel, CSV or PDF catalogue#

The 📥 Importer Excel/CSV/PDF button opens the Importer Médicaments / Parapharmacie (Excel / CSV / PDF) window:

1. Click 📁 Choisir un fichier (choose a file) and select a .xlsx, .csv or .pdf (the supplier's price list or delivery note).
2. Check the Colonnes détectées (corrigez si besoin) : (detected columns, correct if needed) table. The required fields are marked ⭐: Désignation (nom du produit) (product name), Quantité reçue (quantity received), Prix d'achat HT (unitaire) (unit purchase price excl. tax). Correct them if needed, then click 🔄 Recharger l'aperçu avec ces colonnes (reload the preview with these columns).
3. In the preview, every cell can be edited (name, quantity, purchase price, Prix VENTE (DA) (selling price), expiry); untick the rows you do not want to import.
4. With no selling price in the file: enter a Marge (margin, 30% by default) and click Appliquer (prix achat + marge) (apply purchase price + margin), then optionally round with Arrondir à 5 DA (round to 5 DA), 10 or 50 and the Arrondir (round) button.
5. Check the options Marquer tous les nouveaux produits comme 🌿 Parapharmacie (mark all new products as parapharmacy) and Mettre à jour les produits existants (ajoute au stock + rafraîchit prix) (update existing products: adds to stock and refreshes prices).
6. Click 📥 Importer maintenant (import now). The Import terminé (import finished) window gives the counts of new, updated, skipped and failed products.

• An existing product is recognised by its exact name (case ignored): the imported quantity is added to its stock and its prices are replaced.
• A product with no selling price will be sold at its purchase price; the Prix de vente manquant (missing selling price) window warns you.
• A new product with no expiry date gets 2099-12-31 and does not appear in the alerts.
• A scanned PDF (image) is refused: ask the supplier for an Excel file or a “text” PDF.

Prices, stock threshold and alerts#

• The counter selling price is the Prix Vente (DA). If an active promotion exists for the product (Promotions page, administrator), the price is reduced automatically when it is added to the basket.
• The profit on a sale = (selling price − purchase price) × quantity.
• The low-stock threshold and the expiry alert period are set in Paramètres → Alertes et Seuils (10 and 30 days by default) and apply to all products.
• A product with zero quantity does not appear in the Point de Vente search.

Tips and common mistakes#

• Always write names the same way (e.g. DOLIPRANE 1000MG CP B/8): the import matches products by exact name, so a name written two ways creates two products.
• Fill in the barcode of fast-moving products: at the counter you then just scan and press Enter.
• Use the Rupture de stock filter before ordering, and Expire bientôt every week.
• Do not delete a product sold in the past because it has run out: leave it at zero.