Shefa reference materials: what they contain and what we can use
Compiled 2026-11-16 from everything in docs/ other than shefa-technical-document.md.
This file records, in detail, what the collected reference files contain and which ideas in them are not yet in the Shefa technical document. It is a knowledge base to pick from later, not a plan. Nothing here has been decided.
How to read this file
- Section 1 lists every file and what it is.
- Sections 2 to 5 cover the Syrian material: the drug bank, the price bulletins, the leaflet templates, the handwritten product notes and the clinic feature list.
- Section 6 is the bulk: everything learned from the German pharmacy software manuals, grouped by business area and compared with Shefa's current design.
- Section 7 lists what is specific to Germany and should not be copied.
- Section 8 is a shortlist of the ideas that look most valuable.
- Section 9 says what was not read or is uncertain.
Each idea from the German manuals carries a tag and a source:
| Tag | Meaning |
|---|---|
| T | Transferable to a Syrian pharmacy or warehouse as is |
| T* | The concept transfers, but the rules behind it are local and must be defined for Syria |
| DE | Specific to Germany (insurance, national price list, legal) |
Sources are given as the manual's file name and page, for example "Bestellwesen p5". Page numbers are PDF pages, except for Inventur, Kassenstatistik, FreieAuswertungslisten, Stockbuch, TaxeIII and the Gesamtprospekt, where they are the page numbers printed in the manual.
1. File inventory
1.1 Top level
| File | What it is |
|---|---|
shefa-technical-document.md | The Shefa technical document (the baseline everything here is compared against) |
icon.png | The "SheFa Tech" logo |
shefatechpart1.zip, shefatechdokument2.zip, shefatechdokument3.zip | Assumed to be the archives the three folders were extracted from. Not opened |
1.2 shefatechpart1/ (10 files)
| File | Pages | What it is |
|---|---|---|
Description Part 3.pdf | 6 | Photographed handwritten Arabic notes describing the intended product ("Shefa Soft"): till, supplier returns, psychotropic register, statistics. See section 4 |
acetazolamide_arab_propharm.PDF | 5 | Arabic patient information leaflet for Diamox SR 250 mg prolonged-release capsules (acetazolamide). See section 3.3 |
Bestellwesen.pdf | 8 | Concepts of the ordering system: order pool, order types, backorders, and the rules that compute reorder point and order quantity |
Direktbestellung.pdf | 10 | Ordering directly from a manufacturer or its agent |
AngeboteAktualisierenAngebotsverwaltung.pdf | 10 | Managing wholesaler special offers and comparing them |
Bestandskorrektur.pdf | 6 | Correcting the stock of a single item outside a stocktake |
Abschreibebuch.pdf | 5 | Write-off book (stock removed without a sale) |
AbschlussMonatJahr.pdf | 6 | Month-end and year-end closing run and report |
CIS_Flyer.pdf | 2 | Marketing flyer for a management KPI report with peer benchmarks |
DB_PS_Partner_u_Filialkonzept.pdf | 2 | Marketing sheet for multi-branch and partner-pharmacy modules |
1.3 shefatechdokument2/ (19 files)
| File | Pages | What it is |
|---|---|---|
Grosshandelsbestellung.pdf | 24 | Ordering from wholesalers, end to end |
Wareneingang.pdf | 15 | Goods receipt against an order |
Lieferantenretoure.pdf | 12 | Returns to suppliers |
ZugangvonWaren.pdf | 3 | Ad-hoc stock addition outside the order flow |
UmbuchenvonWaren.pdf | 3 | Transfer between storage locations inside one pharmacy |
WebserviceGehe.pdf | 6 | Real-time availability query against a wholesaler |
WebserviceNoweda.pdf | 6 | The same for a second wholesaler, with fewer active fields |
ZuordnungArtikelnummer.pdf | 2 | Mapping a barcode to the national article number |
Firmenstamm.pdf | 5 | Company master and global settings |
Herstellerstamm.pdf | 3 | Manufacturer master |
Inventur.pdf | 23 | Stocktake, including a rolling year-round mode |
Kassenstatistik.pdf | 13 | Till statistics |
FreieAuswertungslisten.pdf | 10 | User-defined report builder on the item master |
Stockbuch.pdf | 10 | Demand-based order proposal for one supplier |
TaxeIII.pdf | 70 | Drug price list and drug information lookup |
Pharmasoft_Gesamtprospekt.pdf | 7 | Full product brochure listing every module |
VSA_Beratung_Flyer.pdf | 10 | Consulting services flyer |
VSA_Beratung_Flyer_1.pdf | 10 | Byte-identical copy of the flyer above |
Pocket Guide to Diagnostic Tests.pdf | 520 | English medical reference on laboratory tests (Nicoll et al., McGraw-Hill, 2001). Copyrighted |
The German manuals are for Pharmasoft (CSE GmbH / VSA ApothekenSysteme), dated 2002 to 2014. It is software for a single pharmacy, seen from the pharmacy's buying side. None of the manuals describes wholesaler-side software.
1.4 shefatechdokument3/ (18 files)
| File | What it is |
|---|---|
بنك الأدوية.xlsx ("Drug bank") | 13,413 products in 114 sheets. See section 2 |
معامل F1.pdf to معامل F13.pdf ("Factories F1 to F13") | 13 official price bulletins from mid-2020, 669 pages. See section 3.1 |
النشرة الطبية للمادة الفعالة.xlsx | Empty bilingual template: 29 headings of a drug monograph. See section 3.2 |
المواد الفعالة و أشكالها الصيدلانية عربي انكليزي.xlsx | Empty bilingual template: 23 of the same headings |
المواد الفعالة و أشكالها الصيدلانية.xlsx | Empty template with two column headers: active ingredient, dosage form |
برنامج الاطباء.docx ("Doctors program") | Feature list of a clinic management program. See section 5 |
2. The drug bank (بنك الأدوية.xlsx)
This is the strongest candidate for seeding Shefa's central drug catalogue, and it bears directly on the open question "source of the drug catalogue" in the technical document.
2.1 Shape
- 114 sheets, one per manufacturer or importer, plus one sheet named "اكسسوارات" (accessories).
- 13,413 product rows in total. One row is one product in one pack size, so the same product appears several times with different packs.
- Columns: barcode, Arabic trade name, English trade name, manufacturer, composition, strength, dosage form, pack, public price, pharmacist price, pill shape, pill colour, splittable.
- Largest sheets: آسيا (851 rows), ابن حيان (554), ابن الهيثم (545), الفا (519), السعد (512), ميديكو (489), شركة شفا (463), اكسسوارات (441), اوبري (426), يونيفارما (398).
- The accessories sheet holds non-drug items (herbal teas, honey and similar) and has no composition or strength columns.
- A few sheets are warehouses listing products imported on their behalf, for example supplements made by a foreign manufacturer.
2.2 How complete each column is
| Column | Rows filled | Share |
|---|---|---|
| Public price | 13,371 | 99% |
| Arabic trade name | 2,352 | 17% |
| Barcode | 1,994 | 14% |
| Pill shape | 1,358 | 10% |
| Pill colour | 1,163 | 8% |
| Splittable | 982 | 7% |
| Pharmacist price | 284 | 2% |
Other measurements:
- 1,580 distinct composition strings. These are whole strings such as "METFORMIN+PIOGLITAZONE", so the number of distinct single substances is lower.
- 223 distinct spellings of dosage form. The most common are أقراص ملبسة (coated tablets, 3,738 rows), أقراص (tablets, 2,344), محافظ (capsules, 1,303), شراب (syrup, 594) and محلول للحقن/حبابات (injection ampoules, 582).
- 30 different header layouts across the sheets. Column names vary (for example "قابلة للقسمة" and "قابلة للكسر" for splittable), so an import needs a mapping per layout.
2.3 What it gives Shefa and what it lacks
What it gives:
- English trade name, manufacturer, composition, strength, dosage form and pack for about 13,400 products. This covers the catalogue structure Shefa defines: substance, manufacturer, product, composition, form, strength and pack size.
- Pill shape, colour and splittability for about a tenth of the products. Shefa's catalogue has no such fields today.
What it lacks or needs:
- Barcodes for 86% of rows. The catalogue will have to collect barcodes from pharmacies as they scan.
- Arabic names for 83% of rows.
- A normalised dosage-form list. The 223 spellings must be mapped to a controlled list.
- Splitting composition strings into individual substances with a strength each, to fill Shefa's product-to-substance link.
- Dispensing restriction (over the counter, prescription, controlled), ATC class and product type. None of these is in the file.
- Current prices. The prices look like 2020 values.
3. Other Syrian drug material
3.1 Price bulletins (معامل F1 to F13)
Thirteen official pricing bulletins for locally manufactured medicines. Each is a numbered table with: item number, product name, manufacturer, dosage form, strength, composition, pack, pharmacist price, public price. The earlier ones are headed "تسعير" (pricing) and the later ones "محضر تسعير" (pricing minutes). F3's price columns are headed "new pharmacist price" and "new public price".
| Bulletin | Date on the document | Pages | Product lines (approx.) |
|---|---|---|---|
| F1 | 25/6/2020 | 133 | 2,191 |
| F2 | 2/7/2020 | 191 | 3,439 |
| F3 | 6/7/2020 | 11 | 184 |
| F4 | 11/7/2020 | 80 | 1,502 |
| F5 | not found in the extracted text | 17 | 349 |
| F6 | 16/7/2020 | 27 | 445 |
| F7 | 21/7/2020 | 41 | 667 |
| F8 | 27/7/2020 | 47 | 881 |
| F9 | 30/7/2020 | 30 | 494 |
| F10 | 16/8/2020 | 42 | 669 |
| F11 | 7/9/2020 | 20 | 336 |
| F12 | 21/9/2020 | 20 | 265 |
| F13 | not found in the extracted text | 10 | 169 |
| Total | 669 | 11,591 |
Line counts are approximate: they count lines that contain a pack description.
What these tell us:
- Regulated prices existed in two tiers in 2020: a pharmacist (purchase) price and a public (selling) price per product and pack. This is evidence for the open question "is there a binding official price", though it only shows the situation in 2020.
- Prices change by bulletin. Thirteen bulletins in three months means repricing is frequent and arrives in batches. A pharmacy system in this market needs a fast way to apply a bulletin.
- The markup is not flat. In the few rows sampled, the public price was 11% to 24% above the pharmacist price, lower for expensive items (for example 496 to 600, 1,433 to 1,750, 21,371 to 23,750). This was not checked across the lists.
- Pharmacist price is here, not in the drug bank. The drug bank has it for 2% of rows; the bulletins have it for every line.
Practical notes for anyone who wants to import them:
- The PDFs have a text layer, so no OCR is needed for Latin text. Product names, strengths, compositions, packs and prices extract cleanly.
- Much of the Arabic text extracts as garbled glyphs (a font-mapping problem), so Arabic manufacturer names and dosage forms would need OCR or a glyph map.
- The prices are from 2020 and are useful for structure and margin logic, not as current prices.
3.2 Drug monograph templates
Two spreadsheets hold only headings, in Arabic and English. They follow the standard structure of a Summary of Product Characteristics:
- Active ingredient
- Name of the medicinal product
- Qualitative and quantitative composition
- Pharmaceutical form
- Clinical particulars
- Therapeutic indications
- Posology and method of administration
- Contraindications
- Special warnings and precautions for use
- Interaction with other medicinal products
- Fertility, pregnancy and lactation
- Effects on ability to drive and use machines
- Undesirable effects
- Overdose
- Pharmacological properties
- Pharmacodynamic properties
- Pharmacokinetic properties
- Preclinical safety data
- Pharmaceutical particulars
- List of excipients
- Incompatibilities
- Shelf life
- Special precautions for storage
- Nature and contents of container
- Special precautions for disposal and other handling
- Marketing authorisation holder
- Marketing authorisation number
- Date of first authorisation or renewal
- Date of revision of the text
The third spreadsheet has just two column headers (active ingredient, dosage form) and no data.
The intent seems to be a structured information sheet per active substance. Shefa's catalogue currently stores names, composition, restrictions and an interactions table, but no clinical text.
3.3 Patient leaflet example
acetazolamide_arab_propharm.PDF is a five-page Arabic patient information leaflet for Diamox SR 250 mg. It has the usual six parts: what the medicine is and what it is used for, before you take it, how to take it, possible side effects, how to store it, further information. It is an example of the patient-facing counterpart to the monograph in 3.2.
3.4 Pocket Guide to Diagnostic Tests
A 520-page English reference book on laboratory and diagnostic tests (McGraw-Hill, 2001). Only the opening pages were looked at. It is copyrighted, so its content cannot be copied into the product. Its presence suggests interest in laboratory tests, and the laboratory is a party that does not appear anywhere in Shefa's list of roles.
4. Handwritten product notes (Description Part 3.pdf)
Six photographed notebook pages in Arabic, numbered 1 to 6, describing the intended behaviour of "Shefa Soft". The file name says this is part 3; parts 1 and 2 are not in the folder. The summary below is a reading of the handwriting, and a few words are uncertain. Page 4 has a single line.
4.1 Till (pages 1 and 2)
- The user enters an item at the till from the stored item list.
- When a drug is entered, the user sees the alternatives available in the pharmacy, and whether the substance or the drug is available at the warehouses the pharmacy has a contract with.
- Selecting the drug shows its properties from the stored drug information bank.
- The user can raise or lower the price easily, and replace, remove or change the quantity of a line.
- From the till the user can see the day's sales in full or broken down, for example with a prescription, without one, for children, for adults.
- The user can enter an item by hand that is not in the drug lists, to make searching and selling easier.
- Access to the till follows staff permissions. The pharmacist can see the quantity and types of drugs sold, the expenses, and the cash that should be in the drawer.
- Returning a drug, an item or money is allowed only for staff with a specific permission.
- Everything entered at the till must later feed statistics: best-selling drugs, the doctors who prescribe most, and so on, with the aim of adjusting the pharmacy's assortment to what is actually consumed.
- When a drug is entered, the program should suggest drugs automatically, ordered by date or by the offers the warehouses have given the pharmacist.
4.2 Returns section (pages 3 and 4)
- This section covers returns to warehouses and drug companies, not customer returns at the till.
- It shows what has been returned and what is still to be returned, with the reasons.
- It distinguishes returns that reached the warehouse and were paid from returns that are still outstanding and unpaid.
- Every list must be printable, with the value of the return, the warehouse's address, the pharmacy's address, the quantity, the date and other required details.
- The user can also create a return manually, entering the reason for the return.
4.3 Psychotropic drugs register (page 5)
- Everything written in the paper psychotropic drugs book is stored electronically.
- Psychotropic items go into the register section automatically.
- When one is dispensed, the system stores: patient name, address, phone number and ID number; the prescribing doctor; the scientific and trade name of the drug, its strength and dose; the number of units; the date the doctor wrote the prescription; and the date the drug was taken.
4.4 Statistics and monitoring (pages 5 and 6)
- The user builds lists for a chosen period.
- Lists include: sales volume, profit, drugs expired in the period, and the most prescribed drugs with the doctors prescribing them, by specialty.
- The quantity of goods bought from each warehouse and the quantity returned in the period.
- Drugs that customers asked for and the pharmacy did not have, where the employee marked the drug as "not sold because unavailable".
- Sales and activity per employee, and whether each sale was made with or without a prescription.
4.5 What the notes ask for that the technical document does not have
| In the notes | In the Shefa technical document |
|---|---|
| A "not sold because unavailable" mark made by staff at the till | Unmet demand comes only from patient searches in the area |
| Prescribing doctor recorded on a sale; top prescribers by specialty | The pharmacy statistics have no doctor dimension. The controlled register stores the doctor's name |
| Sale classified as with or without prescription, child or adult | Not present |
| Psychotropic register with patient address, phone, ID number, dose, prescription date | The controlled register stores patient name, doctor and quantity |
| Expenses and expected cash at the till | Shift closing with cash reconciliation, but no expenses |
| Returns to suppliers tracked as paid or unpaid, with printable lists | One line: "return to the warehouse" |
| Suggestions at the till ordered by date or by warehouse offers | Alternatives are suggested, with no ordering rule |
| Quantity bought from and returned to each warehouse per period | Debt per warehouse is reported; purchase and return volumes are not |
5. Clinic program feature list (برنامج الاطباء.docx)
A short feature list of a clinic management program. The wording reads like marketing copy from an existing product. It matters for Shefa's later phases (doctor, medical centre).
| Area | Features listed |
|---|---|
| Reception | Add, edit, search and delete patient records. Full patient file with history. Patient account: debts and payments. Sales invoices per patient. Quick examination and prescription printing |
| Patient file | All patient data. Current and past prescriptions, imaging and lab tests. Accounts. Past operations and the doctor's notes. Invoices for past prescriptions. All past visits. A full printable report. Before-and-after view for imaging, operations and lab tests |
| Secretary | Booking with date and examination time. Edit bookings. Examination and re-examination lists. Visit list and follow-up. Quick booking screen. Printed booking receipt |
| Operations | Record the operation: patient, doctor, cost, imaging, lab tests. Expenses for the operation on the same screen. Issue medical supplies inside the operating room. Operation report that can be reopened to add results and complications. Referral letters. Before-and-after images |
| Clinic accounts | Other income and expenses of the clinic or centre. Income and expense reports |
| Doctors' and assistants' accounts | Doctors' salaries, percentages and tiers. More than one method of computing a doctor's share. Reports on services provided and number of examinations. Final settlement per doctor for a period. Cash boxes |
| Insurance and contract companies | Accounts per insurance company and per private contract, each with a discount rate. Custom discount rates per service for each company or contract. Reports on services provided to patients under each company |
| Reports | Patients, doctors, clinic, item quantities, bookings, imaging and lab tests, receipts, per user |
Compared with Shefa's later-phase description (record access by permission, unified visit report, digital prescription, appointment calendar, shifts in medical centres), this list adds:
- Clinic money: patient accounts and debts, clinic income and expenses, doctor shares and settlements.
- Insurance and contract companies with discount rates per service. Shefa has no insurer or contract party anywhere, for clinics or pharmacies.
- Operations with their own costs and supplies consumed.
- Imaging and lab results attached to the file, with before-and-after comparison.
- Referral letters.
- Re-examination as a distinct visit type.
6. Knowledge from the German pharmacy software
6.1 Terms used in the manuals
| German term | Meaning |
|---|---|
| Sammeltopf | Order pool: one staging area for all pending reorder lines |
| AMO | Average monthly sales of an item, weighted. Used as the demand figure |
| BMO | Orders per month. Appears to be the variant for systems without a till (inferred) |
| Cito | Urgent order line |
| Defekt | A line the supplier reports it cannot deliver |
| Dispo / Nachlieferung | Backorder: a line the supplier will deliver later |
| Rückstellmenge | Quantity owed to a customer for an item sold or promised while out of stock (interpretation) |
| Stockbuch | Demand-based order proposal for one supplier's items |
| Taxe | The national drug price list and its lookup screen |
| PZN | German national article number |
| Abschreibebuch | Write-off book |
| Neinverkauf | Lost sale: a customer asked and the pharmacy could not supply |
| BtM-Buch | Narcotics book |
| Skonto | Early-payment discount |
| Item class L / E / A | Stocked / one-off, ordered on demand / discontinued |
6.2 What each manual documents
Ordering and purchasing
- Bestellwesen (8 p.) explains the ordering concepts without screen-by-screen steps: order pool, timed, urgent and special wholesaler orders, direct orders, backorder buffer, goods receipt, and the rules and parameters behind reorder point and order quantity.
- Grosshandelsbestellung (24 p.) covers wholesaler ordering. Items sold into negative stock or ordered for a specific customer go straight into the next timed order as urgent lines. Everything else lands in the order pool, where the system proposes a quantity and the cheapest wholesaler, and the user reviews and distributes it into one order per wholesaler. Statuses: open, ready, sent, shortages reported, goods receipt. It also covers shortage handling, urgent orders, special order types and a backorder buffer.
- Direktbestellung (10 p.) covers ordering from a manufacturer or its agent. Choose the supplier, add items by hand or from a sales-based proposal, enter discounts, compare with wholesaler terms, send or print, then book into goods receipt.
- Stockbuch (10 p.) builds the proposal. Pick a direct supplier (and up to five more), set the coverage period (default 90 days), the demand reference period and filters. The system lists that supplier's items with stock, sales history, average monthly demand, proposed quantity and coverage days. The user accepts or edits quantity, bonus packs and line discount, and pushes marked lines into a direct order. A stock book can be saved, printed, sent to partner pharmacies or copied.
- AngeboteAktualisierenAngebotsverwaltung (10 p.) manages wholesaler special offers. Import each wholesaler's offer file (next month's can sit beside the current one), run a processing job, then build saved comparison lists of items getting cheaper or dearer. Work through a list, order from it, and print it with the cheapest wholesaler and total savings.
- WebserviceGehe and WebserviceNoweda (6 p. each) describe a real-time availability query against a wholesaler for one item or a whole list. The answer gives available quantity, backorderable quantity and shortage reason. An automatic mode asks wholesalers in priority order and passes only the shortages to the next one. The second manual has only yes/no availability and shortage reason active.
Receiving, returns and stock
- Wareneingang (15 p.) covers goods receipt against an order, by manual check, pack-by-pack scanning or handheld. Enter the invoice header, check quantities, free goods, cost price and expiry, resolve each discrepancy through a fixed set of actions, and post to stock. It also covers discount calculation and posting quantity now and value later.
- Lieferantenretoure (12 p.) covers returns to suppliers. There are two kinds: delivery returns raised at receipt, and stock-clearance returns. The lifecycle is open (goods still in the pharmacy), returned (shipped), credited. It includes credit-note reconciliation, a buy-back request to the wholesaler, and a pool for returns with no supplier chosen yet.
- ZugangvonWaren (3 p.) is an ad-hoc stock addition outside the order flow: scan the item, enter quantity per storage location (up to three), expiry and number of labels.
- UmbuchenvonWaren (3 p.) transfers stock between storage locations inside one pharmacy, such as overstock to main shelving. Sales always deduct from location 1.
- Bestandskorrektur (6 p.) corrects one item's stock. Pick the item, choose withdrawal or addition, enter quantity per storage location and choose or enter the expiry date. It can require an employee ID. An item journal shows all movements over a period.
- Abschreibebuch (5 p.) is the write-off book. Pick an item, enter a quantity (never more than stock), choose a reason code, add free text and a date. Stock drops with no sale recorded. Deleting an entry books the stock back. It is searchable and printable by date, reason and manufacturer as a yearly loss list.
- Inventur (23 p.) covers stocktake. Create an inventory file (fiscal year, annual or partial, valuation price basis, key date, scope by storage location or alphabet range) and print count sheets. Correct stock or enter counted quantities; several staff and workstations can work at once, each edit tagged with a user code. Apply write-down factors, print the valuation list and summary, then post. An alternative rolling mode checks items all year on a handheld: each check stamps the item, and "not yet checked" and "already checked" lists close the year.
Master data and settings
- Firmenstamm (5 p.) is the company master and global switches: identity, business month and closings, label and expiry settings, reorder-calculation switches and six-month weighting factors, tax keys, co-payments.
- Herstellerstamm (3 p.) is the manufacturer master, mostly read-only and fed by the national price list: search by name or city, list a manufacturer's articles, link to its direct-supplier record, free-text note, log of added and deleted manufacturers.
- ZuordnungArtikelnummer (2 p.) maps a barcode to the national article number so that packs can be scanned at sale while orders still carry the supplier's number.
- TaxeIII (70 p.) is the drug price list and information lookup. Search by name, code, barcode or prefixed criteria (manufacturer, form, indication, dispensing status, pack size, product group, substance), with wildcards and history. The detail view has sections for general data, manufacturer, service lines, texts, ingredients, legal, price, packaging and storage, distribution, and other. Per-item functions include text blocks, notes, related pack sizes, pack splitting, barcode linking, stock correction, net price calculation, price history and partner-pharmacy inquiry. General functions include lost-sale logging, an archive of deleted items, counselling texts and a news feed. Alternative searches run by same substance, same substance and quantity, same indication, product group and manufacturer.
Reporting and closing
- Kassenstatistik (13 p.) covers till statistics. Filter by date range, time-of-day window, employee and till. It shows customer transactions, line items, average basket value, an "activity coefficient", and totals by sale type. A detail view splits revenue and gross profit by payer and dispensing class, with profit and margin per pack, then lists line by line.
- FreieAuswertungslisten (10 p.) is a report builder. Define a named list with up to 15 columns from about 300 item fields, formulas, up to 10 combined criteria, sorting, sum columns, header and footer. Print it, or save the result as a working set on which bulk actions can run.
- AbschlussMonatJahr (6 p.) is the month and year closing. Run on the last day of the month, it writes the month's sales into statistics and produces a closing report. Anyone can run it, only the owner can view or print it, and at least 15 days must pass between closes.
- CIS_Flyer (2 p.) and VSA_Beratung_Flyer (10 p.) are marketing. The product-relevant part is a monthly or quarterly KPI report (sales, margin, stock, procurement channels, staff) with benchmarks against other pharmacies.
Whole-product overview
- DB_PS_Partner_u_Filialkonzept (2 p.) describes multi-branch and partner-pharmacy modules: pooled purchasing, central item master, prices and customers, cross-branch stock check, inter-branch exchange and invoicing, consolidated reporting.
- Pharmasoft_Gesamtprospekt (7 p.) is the full brochure. Its module list is in section 6.16.
6.3 Reorder logic
Shefa today: a static minimum per item, an alert when stock falls below it, and a shortage list that turns into a purchase order with one click.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Demand figure per item | Weighted average monthly sales, used as the trend value for ordering. Weights cover the last six months, with the current month at 1 and older months lower | Bestellwesen p5; Firmenstamm p3–4; Grosshandelsbestellung p10, p20 | T |
| Order quantity from coverage | Quantity = demand × coverage period, filling to one above minimum stock. Default coverage 28 days for wholesaler orders, 90 days for a direct-supplier proposal | Bestellwesen p4–6; Stockbuch p2–6 | T |
| Self-adjusting minimum | Minimum stock derived from the demand figure through a lookup table and recalculated at every sale. When average sales cross a threshold, the minimum is updated or a new reorder point is suggested | Bestellwesen p5; Firmenstamm p4; Grosshandelsbestellung p23 | T |
| Coverage variants | A table that shortens coverage through the month so goods sell before the supplier bill is due (never below 10 days). A fixed coverage per item (short for expensive items, long for direct-order items). An overrun factor for special offers, such as twice the coverage, to stock up | Bestellwesen p5–6 | T |
| Rounding table | Proposed quantities are rounded to bundle sizes instead of odd numbers such as 13 or 47 packs | Bestellwesen p6; Grosshandelsbestellung p10 | T |
| Order raster | Reusable templates of minimum stock, minimum order quantity and maximum order quantity, assigned to groups of items. Meant for a new installation with no sales history, so it is useful for onboarding a pharmacy | Bestellwesen p6–7 | T |
| Per-item overrides | Maximum order quantity (shelf-space limit), fixed order quantity, fixed minimum stock (for example for a known regular patient) | Bestellwesen p7 | T |
| Season flag | The proposal uses the same period of the previous year, or a chosen past period such as October to March (flu, allergy, sun care) | Bestellwesen p7; Direktbestellung p2; Stockbuch p4 | T |
| Alarm stock | A second threshold below the minimum. If an item is waiting on a slow direct order and stock hits the alarm level, a bridging order goes to a wholesaler for the difference. The brochure also describes it as stopping reserved items from being sold out | Bestellwesen p5, p8; Gesamtprospekt p7 | T |
| Item class drives reordering | Stocked, one-off (order on demand) or discontinued. Only stocked items reorder automatically. When stock hits zero and the user declines to reorder, the system offers to convert the item to one-off. A separate switch decides whether discontinued items are reordered | Bestellwesen p4; Abschreibebuch p2–3; Direktbestellung p6; Grosshandelsbestellung p3, p11; Firmenstamm p4 | T |
| Precedence rules | Availability beats discount. Item-level settings beat global tables. Manual input beats optimisation | Bestellwesen p4 | T |
| Reorder trigger on sale | Each sale that takes an item to its reorder point feeds a persistent pool, instead of a list built on demand | Grosshandelsbestellung p2, p10 | T |
| Quantity on order counts | Lines already in an open order are excluded from new triggers. Stock is shown as on hand, on order and pre-ordered for a customer | Grosshandelsbestellung p20; Wareneingang p6; Angebote p6; TaxeIII p19, p24–25 | T |
| "Consider current stock" switch | The proposal can include or ignore current stock, and uses a lead-time table | Grosshandelsbestellung p10, p20 | T |
| Slow-mover rule inside ordering | Flag an item sold at most once in six months. Bulk orders can filter by average monthly sales so slow movers are not replenished | Grosshandelsbestellung p15, p19 | T |
| Bulk stock-up order by selection | Filters: supplier, stock range, monthly-sales range, purchase-price range, line value, coverage days, target order value, with exclusions for offer items, cold-chain items and narcotics | Grosshandelsbestellung p18–20 | T |
| Overstock view | A "show all" mode in the proposal exposes overstocked items as return candidates | Stockbuch p4 | T |
6.4 Order handling
Shefa today: the pharmacy builds a basket from a warehouse catalogue or the shortage list, compares an item's price between warehouses by hand, and sends. The warehouse confirms fully or partly, or rejects with a reason.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Order pool | One staging area for all pending reorder lines, where quantities are optimised and a supplier is proposed per line | Bestellwesen p3; Grosshandelsbestellung p10, p14 | T |
| Automatic supplier assignment | Each pool line is pre-assigned to the wholesaler with the best net terms, including tiered and total discounts, with per-item exceptions and user override | Grosshandelsbestellung p10, p14; Gesamtprospekt p7 | T |
| Automatic offer matching | If the proposed quantity equals an offer quantity, the offer and its supplier are applied. Lines with an unaccepted offer are flagged. Ordering beyond the coverage period is allowed in order to reach an offer quantity | Grosshandelsbestellung p14 | T |
| Urgent versus replenishment lines | Lines needed for a specific customer are highlighted and can be pulled into a separate urgent order. Routine lines wait for the consolidated daily order | Grosshandelsbestellung p2, p15–17; Gesamtprospekt p7 | T |
| Customer backorder | An item sold or reserved while out of stock creates an order line carrying the customer or prescription reference and the reserved quantity. It joins the next urgent order, and for stocked items the order is the owed quantity plus the normal refill. Whoever receives the goods sees the reference | Bestellwesen p3–4; Grosshandelsbestellung p4–5; Wareneingang p6; AbschlussMonatJahr p5 | T |
| Order types with their own terms | A supplier defines order types (standard, bulk, stock-up) with different discounts and a minimum order value | Bestellwesen p3–4; Grosshandelsbestellung p17–18 | T |
| Cut-off and delivery times per supplier | Orders are slotted by each supplier's collection and delivery times. Lines can go to the next-collecting or next-delivering supplier. After the last slot they roll to the next day | Grosshandelsbestellung p2, p9, p12 | T (the time-slot idea; dial-up sending is legacy) |
| Order splitting | One order split into up to three delivery groups, for example customer pre-orders versus shelf stock | Gesamtprospekt p7 | T |
| Structured shortage handling | Per line, the supplier answers with a reason: not deliverable, temporarily missing, direct-only, replaced by successor, backorder, or available from another branch. The pharmacy's actions: rebook to another supplier (last choice remembered), delete, hold, or move to the backorder buffer | Grosshandelsbestellung p7–8; Bestellwesen p3–4; Direktbestellung p4 | T |
| Backorder buffer | Lines the supplier will deliver later wait outside any order and are booked straight into a new goods receipt when they arrive. Phone orders can be added there | Grosshandelsbestellung p21–22; Bestellwesen p3–4 | T |
| Hold item until date | A shortage line can be blocked until a date, then re-enters distribution | Grosshandelsbestellung p7, p13 | T |
| Successor product | The old product is marked discontinued and linked to the new one, sales statistics carry over, and the order line is swapped. The same action exists at receipt | Grosshandelsbestellung p8; Wareneingang p10–11 | T |
| Rebooking | Move one line, marked lines or a whole order to another supplier or back to the pool. Bulk-edit marked lines | Direktbestellung p5–7; Grosshandelsbestellung p4, p6 | T |
| Preferred channel per item | Direct preferred, or direct only, with a fixed supplier. Sold items are appended automatically to that supplier's open order | Bestellwesen p8; Direktbestellung p2–3; Stockbuch p3–4 | T |
| Advance delivery by a rep | Goods a rep leaves before the order is booked are recorded on the order line with quantity and expiry, then netted off at goods receipt. This bears on Shefa's open question about reps delivering without a prior order | Direktbestellung p7 | T |
| Order for an off-platform supplier | Print the order list with or without prices, to send by other means. Shefa only records an external purchase after the fact | Direktbestellung p5 | T |
| Off-platform supplier master | Direct suppliers with their own terms, return rules and order types, linked from the manufacturer record | Herstellerstamm p3; Grosshandelsbestellung p7, p18; Lieferantenretoure p2 | T |
| Supplier-to-manufacturer link | A supplier or agent is mapped to the manufacturers it represents, which makes per-manufacturer proposals possible | Bestellwesen p8; Angebote p1 | T |
| Notes on lines and orders | A line hint sent to the supplier, a line note that travels to the receiver, free text per order, and a free-text line for an item with no catalogue number. A standing supplier note shown at every order to that supplier, for agreed terms | Grosshandelsbestellung p3–5; Stockbuch p7 | T |
| Live availability cascade | For a list at ordered quantities, ask suppliers in priority order, pass only the unavailable lines to the next, and show which supplier can deliver each line. Simpler in Shefa because all warehouses are on one platform | WebserviceGehe p5–6 | T |
| Availability response fields | Available quantity, backorderable quantity, shortage reason, delivery run. Shefa has a single availability status | WebserviceGehe p4 | T |
| Review run for the pool | Saved criteria group the proposals (for example all offer items) in a fixed order, for checking and release group by group | Grosshandelsbestellung p14–15 | T, low priority |
| Decision line at ordering | A month-by-month sales strip (16 months in the sample), last sale date and type, last receipt date and supplier, minimum stock, on-order quantities | Angebote p6, p8 | T |
6.5 Purchase cost and terms
Shefa today: one purchase price per batch. The document does not say how a bonus such as 10 + 2 changes the cost of the batch.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Effective purchase price per line | Built from list purchase price, bonus goods, line discount, order-level discount (percent or amount), order-level bonus goods spread over all lines, delivery cost, tax and early-payment discount. Entering a net price back-calculates the discount percentage; discount and net price cannot both be entered | Direktbestellung p8–9; Wareneingang p13–15; Stockbuch p6–7 | T (tax handling DE) |
| Last effective price per supplier | Shown while building an order, beside current wholesaler offers | Direktbestellung p4, p7; Stockbuch p6–7 | T |
| Terms entered at order time | They carry into goods receipt, so goods can be received before the invoice exists | Direktbestellung p3, p9; Wareneingang p15 | T |
| Selling-price recalculation at receipt | For freely priced items, the selling price is recalculated when the purchase cost changes | Direktbestellung p3; Bestellwesen p4; Wareneingang p13 | T* (depends on which Syrian prices are regulated) |
| Purchase turnover per supplier | Including a turnover threshold that unlocks a rebate | Direktbestellung p2, p9–10 | T (also usable as a warehouse-side offer type) |
| Due-date book | Supplier invoices with due dates and reminders at start-up. Shefa has statement and ageing only | Gesamtprospekt p7 | T |
| Purchase controlling | Real terms obtained per supplier, discount against volume, return reasons, delivery quality | Gesamtprospekt p11 | T |
6.6 Offers
Shefa today: a warehouse offer is a percentage discount or a bonus such as 10 + 2, or a package of items at one price, with a validity period, an optional total quantity cap, and optional targeting of pharmacies or cities.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Future-dated offers | Next period's offers are loaded early, beside the current ones, so the buyer can act before a price change | Angebote p1, p9 | T |
| Current versus next-period cost | A cheaper or dearer percentage per item, and a marker in the ordering screen for items that get cheaper next month | Angebote p6, p10 | T |
| Stock-up quantity | Demand × a chosen stocking period, proposed when a price rise or an offer end is coming | Angebote p4, p6 | T |
| Saved comparison lists | Filters: supplier and up to five manufacturers; item class; product group, include or exclude; demand above a value; savings above or below a percentage; reorder need within N days; storage location; only own-assortment items, or only items already on order. Lists can be duplicated and edited | Angebote p3–5 | T |
| Cheapest supplier by effective price | Per item and period, including bonus goods (for example 8 + 1 is worth 11.46% in the manual's example). Shefa compares listed prices only | Angebote p7–8 | T |
| Multi-tier quantity scales | Several quantity tiers per offer. Shefa's wording implies one tier | Angebote p7–8 | T |
| Realised savings | A total of what was saved on items ordered through offers | Angebote p6, p10 | T |
| "Offer exists" flag in search | Shown in item search results, with ordering straight from the lookup screen | TaxeIII p19, p24–25 | T |
| Offer check at receipt | A receipt filter that shows only offer lines, to check that the promised offer was delivered | Wareneingang p6 | T |
6.7 Goods receipt
Shefa today: the pharmacy matches quantities, batches and expiry dates against the warehouse order; differences are logged and reported to the warehouse. Stock enters with its batches without re-entry.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Invoice header with control total | Invoice number, date and net amount. The difference to the summed line value is shown and must reach zero before posting. The invoice date decides the statistics month | Wareneingang p3–4 | T |
| Named discrepancy actions | Under-delivered: accept, reorder the difference, return as "missing but invoiced", or successor. Over-delivered: book as free goods, return, correct the scan, or raise the order quantity. Not on the order: add, successor, return, free goods, or "belongs to another delivery" | Wareneingang p9–11 | T |
| "Missing but invoiced" | A return reason that creates a credit claim without touching stock | Wareneingang p5, p10; Lieferantenretoure p5 | T |
| Scan every pack | Receipt by scanning each pack, capturing expiry in the same step, with a handheld variant so goods go from the box to the shelf | Wareneingang p2, p8–9 | T |
| Several expiry dates per line | Up to three per receipt line, with the remaining quantity pre-filled. Relevant to Shefa's manual purchases | Wareneingang p5 | T |
| Two-step posting | Post quantities now (status "quantity booked") and value later | Wareneingang p15; Direktbestellung p3, p9 | T |
| Receipt statuses and reopen | In progress, difference found, to post, posted, with a status reset to correct expiry, header or barcode | Wareneingang p7–8, p12 | T |
| Review filters | Show only offer lines, lines with customer notes, or lines ordered for a partner pharmacy | Wareneingang p6 | T |
| Customer pre-order hint | The receiver is told which items belong to a customer pre-order or a delivery | Gesamtprospekt p7, p9; Wareneingang p6 | T |
| Local barcode linking | Attach an unknown scanned barcode to the product during receipt or in a mapping screen, with a flag saying whether the link is manual or from the catalogue. Shefa only has central barcodes and the proposal flow | Wareneingang p7; ZuordnungArtikelnummer p2; Bestellwesen p4; TaxeIII p35–36 | T |
| Label quantity per line | N single-pack labels plus one collective label for overstock, on or off per line | Wareneingang p6; Firmenstamm p3 | T, minor |
| Ad-hoc stock addition | Add stock outside any order: item, quantity per location, expiry, labels | ZugangvonWaren p2–3 | T |
6.8 Supplier returns
Shefa today: "return to the warehouse" in one line, and a "drug payment" (returned goods) that reduces the running account.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Return lifecycle | Open (stock already deducted, goods still on site), returned (shipped), credited | Lieferantenretoure p2–3 | T |
| Two kinds of return | Delivery returns raised at receipt, and stock-clearance returns | Lieferantenretoure p2; Gesamtprospekt p7 | T |
| Saleable return stock | An open return line records a still-saleable quantity, and the till warns of it so the pack is sold instead of reordered | Lieferantenretoure p2–4 | T |
| Return deadline per supplier | Each return shows the date by which it must be processed to avoid a loss, with reminders | Lieferantenretoure p2–3; Gesamtprospekt p7 | T |
| Return line fields | Reason code, note, recall flag, batch, handler, original invoice number and date | Lieferantenretoure p4–5, p9 | T |
| Buy-back request | Send the proposed list to the supplier, who accepts per line. Refused lines go back to stock or to another supplier | Lieferantenretoure p6, p9 | T |
| Credit-note reconciliation | Enter credit date and amount, tick the lines it covers while a running total approaches the amount, adjust a line's price to what was credited or leave the difference. Returned versus credited value is reported per supplier | Lieferantenretoure p7–8 | T |
| Uncredited lines | Move to another supplier, book back to stock, or write off as destroyed | Lieferantenretoure p9 | T |
| Return pool | Collect clearance returns with no supplier chosen, then split by manufacturer or product group, for example for a rep who takes returns for several companies | Lieferantenretoure p11–12 | T |
| Return price basis | Delivery returns at actual cost, clearance returns at list purchase price. A rule to decide | Lieferantenretoure p11 | T |
| Reorder prompt | When a return takes a stocked item to zero | Lieferantenretoure p5, p11 | T |
| Standard declaration text | Printed on all return documents, for example a statement of proper storage | Lieferantenretoure p5 | T, minor |
6.9 Stock, corrections and write-offs
Shefa today: every quantity belongs to a batch with expiry and purchase price. Every change is an immutable movement: purchase, sale, return, stocktake adjustment, destruction. Sub-stores exist for warehouses only. Adjustment is described only through stocktake approval, although a permission named inventory.adjust exists.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Write-off reason codes | Expired, damaged pack, shrinkage or theft, unsaleable, recall, clearance, gift, own withdrawal, discontinued, other. Each with free text and an editable date | Abschreibebuch p2 | T |
| Write-off loss report | By period, reason and manufacturer, at purchase value, for the accountant | Abschreibebuch p3–4 | T |
| Single-item stock correction | Outside a stocktake: add or withdraw, choose which expiry lot to reduce. An employee-ID prompt can be off, at the start, or before saving | Bestandskorrektur p3–5 | T |
| Expiry-tracking flag per item | No expiry, has expiry but not monitored, or monitored. Shefa forces a batch and expiry on everything, including supplies and cosmetics | Bestandskorrektur p4; Wareneingang p13; Firmenstamm p3 | T |
| Storage locations inside a pharmacy | Up to three per item, such as sales shelving, overstock and cold room, each with its own quantity. Sales deduct only from location 1, and a transfer screen moves stock between them. The location code also scopes and sorts stocktakes and filters lists | Bestandskorrektur p4; UmbuchenvonWaren p2; ZugangvonWaren p2–3; Inventur p4–5, p18; Angebote p4 | T |
| Item journal | All movements of one item over a period, with month-end stock snapshot lines. Shefa has the ledger but no such view or snapshots | Bestandskorrektur p6 | T |
| Handheld shelf maintenance | Scan, then correct stock, reorder, return or print a label | Inventur p15–16 | T |
| Cold-chain flag and storage conditions | A cold-chain flag on products, used as an order filter, plus storage temperature, light and humidity | Grosshandelsbestellung p19; TaxeIII p21–24 | T |
| Batch recall | Returns carry a recall flag and "recall" is a write-off reason. Shefa has no recall concept at all | Lieferantenretoure p4–5; Abschreibebuch p2 | T |
| Narcotics book with running balance | Fed at goods receipt and reduced at dispensing. Shefa's controlled register records sales only | Gesamtprospekt p11 | T* |
| Fallback expiry date | If no expiry is entered, 80% of the standard shelf life is assumed, else today plus one year. Questionable for medicines; listed for completeness | Wareneingang p13; ZugangvonWaren p2; Firmenstamm p3 | Not recommended |
6.10 Stocktake
Shefa today: open a full or partial count (shelf, company, category), count by barcode from several devices at once, review differences by quantity and value, the manager approves, and adjustment movements are created.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Rolling count | Every item carries a "last checked" stamp, set even when the quantity is confirmed unchanged. "Not yet counted this year" and "already counted" lists, with a cut-off date, close the year | Inventur p15–22 | T |
| Continuous partial lists | N items per run, resuming where the last list stopped, so everything is counted once a year | Inventur p12–13 | T |
| Annual versus partial | With fiscal year and key date. Only the annual one is posted, storing date, quantity, value, factor and price basis per item | Inventur p3, p13–14 | T* |
| Valuation basis | A choice of list price, stock-weighted average cost, average of the last six receipts, invoice cost including bonus goods, or net effective cost. Shefa only says "stock value" | Inventur p3–4 | T |
| Write-down rules | With priorities, reusable from the previous stocktake. Examples: no sale for a year valued at 70%, discontinued at 0, by product group | Inventur p10–11 | T* |
| Printable count sheets | With barcode, sorted by location, with filters such as stock above N, zero stock or discontinued, plus a summary sheet and valuation list. A paper fallback, since Shefa's stocktake needs a connection | Inventur p4–6, p12 | T |
| Review filters inside a count | Uncounted lines, lines above a price or quantity, lines by counter | Inventur p10 | T |
| Exclude one-off items | An option to leave one-off items out of valuation and proposals | Inventur p4; Stockbuch p4–5 | T |
6.11 Sales, till and customers
Shefa today: scan or search, optional link to a patient, prescription checks, substitution logging, discount, return, credit sales with a customer debt book, shift closing with cash reconciliation, receipts and barcode labels. Statistics by day, item, company and employee.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Lost-sale log | One key at the counter: quantity and a reason from standard texts. After a set number of refusals, a "consider stocking" hint appears at the next order. Period statistics. Shefa's unmet demand comes only from patient searches | TaxeIII p11, p45–50; Firmenstamm p3–4 | T |
| Transaction and basket figures | Customer transactions, line items, average basket (total and cash), filterable by time-of-day window and by till | Kassenstatistik p4–6 | T |
| Activity coefficient | Non-prescription sales divided by prescription sales, per employee, as an indicator of counselling | Kassenstatistik p5–6 | T |
| Profit by dispensing class | Revenue and gross profit split by prescription-only, pharmacy-only and other, with profit per pack, margin per pack and share of total profit | Kassenstatistik p7–9 | T |
| Staff load by hour and day | For shift planning, and commission models per employee | Gesamtprospekt p5 | T |
| Seller roll-up and exclusion | Seller IDs rolled up to a main seller, and a per-seller flag to exclude from statistics | Kassenstatistik p11–12 | T |
| Parked sale with deposit | A sale held with or without a deposit and completed later; partial orders. Shefa only has a reservation requested by the patient | Kassenstatistik p10, p12–13 | T |
| Separate fee lines | Such as a night-duty fee or a procurement cost | Kassenstatistik p12 | T* |
| Prompts at the till | Add-on sale hints per item. Pack-size comparison with unit price and the customer's saving. Most economical pack, and profit or loss of splitting a pack | Gesamtprospekt p5; TaxeIII p28–29, p34–35 | T |
| Printed dosing labels | Dosing and usage texts printed for the customer, with translations | Gesamtprospekt p5 | T |
| Customer information at the till | History, allergies, doctors and medication shown during the sale. Shefa covers this through the patient record and access grants | Gesamtprospekt p5 | Already covered in part |
| Customer card and loyalty | Customer cards with loyalty points, an ABC classification of customers, targeted mailings | Gesamtprospekt p11, back page | T |
| Customer invoicing extras | Delivery notes, collective invoices, reminder letters for overdue debts. Shefa has a debt book only | Gesamtprospekt p11 | T |
| Price-check scans | Scans cancelled at the till must not count as sales in slow-mover statistics | AbschlussMonatJahr p3–4 | T, minor |
| Cash book | Fed automatically by daily till closings | Firmenstamm p4 | T |
6.12 Pricing
Shefa today: an optional reference price in the catalogue. Selling and purchase prices are kept per facility. Bulk percentage updates on all items, a company, a category or a selection, with preview, a rounding rule, a change log and undo of the last bulk update.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Cost-plus pricing | Markup global or per product group, a choice of cost basis (the brochure mentions five), a rounding table, markup caps per group, a "margin below X%" warning flag, and a quick table of 12 markups | TaxeIII p9–10, p34, p39–40; Gesamtprospekt p7 | T* (depends on how much of the assortment is price-regulated) |
| Promotional price | A pharmacy-side price limited by period, quantity or both, feeding labels | TaxeIII p39; Gesamtprospekt p7 | T |
| Central price-update service | A central price update with a change log per update (added, removed, changed) and scheduled price changes | TaxeIII p61–62; Gesamtprospekt p11 | T |
| Price history per item | Visible from the item lookup | TaxeIII | T |
6.13 Catalogue and drug information
Shefa today: substance with ATC class, manufacturer, product (Arabic and English trade name, form, strength, pack size, sub-units, barcodes), composition, dispensing restriction, type, alternatives by same substance, strength and form, an interactions table, and a proposal flow for missing items.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Lifecycle flags | Discontinued, recalled, successor and predecessor cross-link, archive of deleted items and manufacturers | TaxeIII p18–19, p30, p54, p61 | T |
| Extra product fields | Storage conditions, cold-chain flag, shelf life, pack dimensions, excipients, approved indications, hospital pack, manufacturer service lines | TaxeIII p21–24 | T |
| Dosage form decomposed | Dispensing form, application form, route and site of action, used in alternative search | TaxeIII p29, p66 | T |
| Alternatives by indication or group | Same indication or product group, sorted by price, restricted to items in stock. Shefa matches only substance, strength and form | TaxeIII p63–67 | T |
| Search prefixes | Search by manufacturer, form, indication, pack size or group through a prefix, with wildcards and a recent-items history | TaxeIII p14–18 | T |
| Related pack sizes | Jump between the pack sizes of the same product | TaxeIII | T |
| Item notes as to-dos | Back-office notes on an item with a "done" status, item text blocks, and a text block for a whole manufacturer | TaxeIII p26–28, p42–44, p51–53 | T |
| Counselling texts | Texts for patients by product group or keyword, printable | TaxeIII p56–59 | T |
| News feed | Searchable news: new launches, changes, recalls, regulator notices | TaxeIII p56–59 | T |
| Controlled-drug information | Maximum prescribable quantities and dosing | TaxeIII p29 | T* |
| Manufacturer master extras | City, free-text note, log of added and deleted manufacturers | Herstellerstamm p2–3 | T, minor |
| Interaction alerts at the till | Listed as a till feature, with drug profiles and dosing, warning and usage notes from licensed databases | Gesamtprospekt p5 | Already planned in Shefa as a later phase |
6.14 Reporting, closing and management
Shefa today: sales and profit by day, item, company and employee; best sellers, slow movers and stock turnover; stock value and value expiring within 90 days; patient counts per drug; unmet demand; debts. Statistics are built from events into summary tables.
| Idea | What it is | Source | Tag |
|---|---|---|---|
| Month and year closing report | A frozen snapshot per period. Contents: inventory value; items and value not sold for a year; stocked items with zero stock; one-off items still holding stock; discontinued items with stock; quantities owed to customers not covered by any order; turnover; list versus effective purchase value and the discount achieved; orders not yet booked. A simulation mode exists. Shefa has shift closing only | AbschlussMonatJahr p2–6; Gesamtprospekt back page; Firmenstamm p2 | T |
| Stock figures | Turnover rate by value and by packs over 12 months, days of stock cover, stock as a share of sales, slow-mover value and share of stock | CIS_Flyer p2 | T |
| Peer benchmarks | Each figure shown against other pharmacies, with a trend arrow. Shefa could do this with anonymised city-level aggregates | CIS_Flyer p1–2; VSA flyer p4–5 | T |
| Further analyses | Procurement channel (direct versus wholesaler), margin by dispensing category, month and year comparisons, staff performance per manufacturer or assortment | CIS_Flyer p1–2 | T |
| Report builder | Saved definitions with chosen columns, formulas, sums, duplication and scheduled runs | FreieAuswertungslisten p1–7, p10 | T |
| Working set with bulk actions | Save a result as a selection, deactivate rows, then run bulk actions: mass field change (manager only), order, price calculation, labels and shelf cards, switch expiry monitoring, hand over to returns or write-off. Shefa's only bulk action is a percentage price change | FreieAuswertungslisten p8–10 | T |
| ABC analysis | Of items, and of customers | Gesamtprospekt back page | T |
| Management figures | Time series, cash flow, break-even, forecast, accountant export | Gesamtprospekt p11, back page | T |
| Shelf-placement analysis | Sales per shelf | Gesamtprospekt p11 | T |
| Scheduled jobs | A scheduler for jobs and backups | Gesamtprospekt | T (Shefa's background worker covers the mechanism) |
6.15 Multi-branch and partner pharmacies
Shefa today: no concept of a group. Each pharmacy is a standalone organisation, and pharmacies do not trade with each other.
All items are from DB_PS_Partner_u_Filialkonzept p1–2, with mentions in Gesamtprospekt p9, Stockbuch p3, p6, p10 and TaxeIII p40.
| Idea | What it is | Tag |
|---|---|---|
| Pooled purchasing | Partners' needs are aggregated into one central order, goods are picked per partner, and bonus goods are shared out or kept centrally | T |
| Cross-branch stock check | During ordering, with the option to order from the partner when cheaper | T |
| Quick item exchange | Availability query, reservation, hand-over and automatic invoicing between pharmacies with configurable terms | T |
| Central price maintenance | With per-branch exceptions, a change journal sent to branches and an automatic relabelling print job | T |
| Central item master and reporting | For self-created items across the group, plus consolidated reports across branches | T |
| Shared customers and loyalty | A common customer master and a common bonus scheme | T |
| Returned-goods reuse check | Before returning to the supplier, check whether a partner can use the item | T |
Whether the group features apply depends on whether Syrian rules allow one owner to run several pharmacies. This was not checked. The stock check, the item exchange and the reuse check also make sense between independent pharmacies.
6.16 Module list from the product brochure
The brochure gives one-line descriptions, not workflows.
| Group | Modules |
|---|---|
| Counselling | Customer and patient information at the till (history, allergies, doctors, medication). Drug database linked to stock. Dosing, warning and usage notes. Substance profiles |
| Till | Touch till with interaction alerts, add-on sale hints, dosing texts in seven languages and a most-economical-pack hint. Separate advice and payment tills. Till statistics and staff statistics. Real-time wholesaler availability. Customer cards. Loyalty points |
| Ordering | Terms and order-quantity optimisation, including tiered discounts and offers. Dynamic reorder point. Order splitting into up to three delivery groups. Urgent items now, the rest with the main order. Backorder management |
| Receiving and stock | Goods receipt by hand, scanner or handheld, multi-user. Returns management with deadlines. Stock maintenance with saved selections for expiry, returns and slow movers. Write-off book. Due-date book for invoices. Net price calculation on five cost bases with promotional prices |
| Services | Delivery service with tours and packing slips. Partner and branch concept. Blister packs for care homes and individual patients. Electronic prescription. Web shop and clinic shop. Picking-robot interface |
| Management | Time series, cash flow, break-even and forecast. Purchase controlling and sales controlling. Shelf-placement analysis and market trend benchmark. KPI report interface. Export manager. Scheduler. Month closing with simulation. ABC analysis. Standard lists |
| Other | Invoicing: open items, debt book, delivery notes, collective invoices, reminder letters. Compounding pricing. Laboratory program. Narcotics book. Add-ons: staff manager, hazardous substances, finance centre. Online manual |
Whole modules that Shefa lacks and that could apply:
- Compounding: ingredient and container pricing, stock deduction, saved formulas, labels, test protocols. T.
- Delivery tours: tour planning with packing slips and tour settlement. Shefa lists delivery as a later phase with no detail. T.
- Care-home supply and patient-individual blister packs. T*.
- Web shop. T*.
- Quality-management handbook software and a staff roster manager. T*.
7. Germany-specific: not worth carrying over
- National article numbers (PZN) and the national price list feed. The nearest Shefa equivalent is the optional reference price.
- Statutory and private insurance payer splits, co-payments, insurer rebates, reference-price differences and zero prescriptions.
- Substitution price corridors per federal state, parallel-import comparisons and import quotas.
- Aid and dressing codes, payer-specific price formulas.
- The licensed German drug databases.
- Order transmission identifiers and dial-up sending, with their order-type codes.
- Offer files on floppy disk.
- Card-based ordering for systems without stock tracking.
- The hazardous-substances module.
- Reconciliation with the German tax adviser's statement, and the fiscal and tax lines of the closing report.
- Automatic shutdown hardware and VPN or ISDN networking.
8. Shortlist: what looks most valuable
These are the candidates that stood out, in rough order of value. They are suggestions, not decisions.
- Seed the central catalogue from the drug bank (section 2), and collect the missing barcodes from pharmacies at first scan through the existing proposal flow.
- A price-bulletin engine (section 3.1): the catalogue carries pharmacist and public price with an effective date; importing a new bulletin tells each pharmacy which of its items changed and lets it apply the change in one step.
- Demand-based order proposal (section 6.3) in place of a static minimum: weighted average sales, coverage days, self-adjusting minimum, season flag, quantity on order.
- Effective purchase cost and automatic cheapest warehouse (sections 6.5 and 6.6): fold bonus goods and discounts into batch cost, and compare warehouses on that cost. A 10 + 2 bonus is a 16.7% discount; comparing listed prices hides it, and profit figures are wrong without it.
- Batch recall (section 6.9): the platform knows every pharmacy holding a batch and every patient it was dispensed to, and can notify them. No single-pharmacy system can do this.
- Lost-sale button at the till (sections 4 and 6.11), in both the founder's notes and the German software.
- Customer backorder (section 6.4): reserve an out-of-stock item for a patient, order it as an urgent line, alert the receiver, notify the patient.
- Named receipt discrepancies and a full return lifecycle (sections 6.7 and 6.8), including "missing but invoiced", return deadlines and credit-note reconciliation.
- Psychotropic register with the full field list and a running balance (sections 4.3 and 6.9), subject to the legal review already listed as an open question.
- Prescribing doctor on the sale (section 4): top prescribers by specialty, and sale classification.
- Drug monograph per active substance (section 3.2), with a simplified patient version.
- Pill identification by shape and colour, and the splittable flag (section 2).
- Exchange of near-expiry stock between pharmacies (section 6.15), subject to a legal check.
- Anonymised peer benchmarks (section 6.14), a possible paid tier.
- Smaller additions: write-off reason codes, month closing report, rolling stocktake, storage locations inside the pharmacy, cold-chain flag, expiry-tracking flag for non-drug items, till expenses and cash book, report builder, loyalty card, compounding.
For later phases: clinic finances, insurance and contract companies, operations, imaging and lab results (section 5), and the laboratory as a possible new party (section 3.4).
Open questions in the technical document that this material touches:
| Open question | What the material adds |
|---|---|
| Source of the drug catalogue | The drug bank gives about 13,400 products to start from, with the gaps listed in 2.3 |
| Official pricing | The 2020 bulletins show regulated pharmacist and public prices, updated in frequent batches |
| Currency | The price data is from 2020. As far as known at the time of writing, Syria introduced a redenominated pound (two zeros removed) at the start of 2026; this should be confirmed, and price history should be able to carry a currency change |
| Rep delivery without a prior order | The German "advance delivery" pattern records goods left by a rep on the order line and nets them off at receipt |
| Revenue model | Peer benchmarks and management reports were sold as a separate paid service in Germany |
| Legal requirements | The founder's notes list the fields the paper psychotropic book holds |
9. What was not read or is uncertain
- German manuals: read from extracted text. Most screenshots were not looked at, so content that exists only in screenshots is missing. A few screens were checked visually (the manufacturer menu, the order overview and settings, the receipt posting dialog).
- Formulas: the manuals describe the reorder and supplier-terms optimisation through their switches and inputs. The weighting formula and the contents of the minimum-stock, coverage, rounding and raster tables are not given.
- Interpretations: the meanings given for BMO and Rückstellmenge in 6.1 are inferred, as noted there. "Main order" is mentioned in the manuals without explanation; it is read here as the consolidated daily order of non-urgent lines.
- Brochure text: the extracted brochure text is scrambled across columns in places, so some module descriptions were reconstructed from context. Marketing sheets list capabilities without workflows.
- Dates: the German manuals date from 2002 to 2014. Their legal details are historical.
- Web-service manuals: both mark several response fields as "currently not active".
- Handwritten notes: read by eye; a few words are uncertain. Parts 1 and 2 of the description are not in the folder.
- Price bulletins: only the opening rows of some bulletins were read. Line counts are approximate, the dates of F5 and F13 were not found, and the markup observation rests on a handful of rows.
- Drug bank: statistics were computed over all sheets, but rows were only spot-checked. The data was not validated for duplicates or errors.
- Pocket Guide to Diagnostic Tests: only the opening pages were looked at.
- Zip files: not opened.
- Legal points: whether one owner may run several pharmacies in Syria, and whether pharmacies may sell stock to each other, were not checked.