Skip to main content

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:

TagMeaning
TTransferable 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
DESpecific 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​

FileWhat it is
shefa-technical-document.mdThe Shefa technical document (the baseline everything here is compared against)
icon.pngThe "SheFa Tech" logo
shefatechpart1.zip, shefatechdokument2.zip, shefatechdokument3.zipAssumed to be the archives the three folders were extracted from. Not opened

1.2 shefatechpart1/ (10 files)​

FilePagesWhat it is
Description Part 3.pdf6Photographed handwritten Arabic notes describing the intended product ("Shefa Soft"): till, supplier returns, psychotropic register, statistics. See section 4
acetazolamide_arab_propharm.PDF5Arabic patient information leaflet for Diamox SR 250 mg prolonged-release capsules (acetazolamide). See section 3.3
Bestellwesen.pdf8Concepts of the ordering system: order pool, order types, backorders, and the rules that compute reorder point and order quantity
Direktbestellung.pdf10Ordering directly from a manufacturer or its agent
AngeboteAktualisierenAngebotsverwaltung.pdf10Managing wholesaler special offers and comparing them
Bestandskorrektur.pdf6Correcting the stock of a single item outside a stocktake
Abschreibebuch.pdf5Write-off book (stock removed without a sale)
AbschlussMonatJahr.pdf6Month-end and year-end closing run and report
CIS_Flyer.pdf2Marketing flyer for a management KPI report with peer benchmarks
DB_PS_Partner_u_Filialkonzept.pdf2Marketing sheet for multi-branch and partner-pharmacy modules

1.3 shefatechdokument2/ (19 files)​

FilePagesWhat it is
Grosshandelsbestellung.pdf24Ordering from wholesalers, end to end
Wareneingang.pdf15Goods receipt against an order
Lieferantenretoure.pdf12Returns to suppliers
ZugangvonWaren.pdf3Ad-hoc stock addition outside the order flow
UmbuchenvonWaren.pdf3Transfer between storage locations inside one pharmacy
WebserviceGehe.pdf6Real-time availability query against a wholesaler
WebserviceNoweda.pdf6The same for a second wholesaler, with fewer active fields
ZuordnungArtikelnummer.pdf2Mapping a barcode to the national article number
Firmenstamm.pdf5Company master and global settings
Herstellerstamm.pdf3Manufacturer master
Inventur.pdf23Stocktake, including a rolling year-round mode
Kassenstatistik.pdf13Till statistics
FreieAuswertungslisten.pdf10User-defined report builder on the item master
Stockbuch.pdf10Demand-based order proposal for one supplier
TaxeIII.pdf70Drug price list and drug information lookup
Pharmasoft_Gesamtprospekt.pdf7Full product brochure listing every module
VSA_Beratung_Flyer.pdf10Consulting services flyer
VSA_Beratung_Flyer_1.pdf10Byte-identical copy of the flyer above
Pocket Guide to Diagnostic Tests.pdf520English 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)​

FileWhat 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
النشرة الطبية للمادة الفعالة.xlsxEmpty bilingual template: 29 headings of a drug monograph. See section 3.2
المواد الفعالة و أشكالها الصيدلانية عربي انكليزي.xlsxEmpty bilingual template: 23 of the same headings
المواد الفعالة و أشكالها الصيدلانية.xlsxEmpty 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​

ColumnRows filledShare
Public price13,37199%
Arabic trade name2,35217%
Barcode1,99414%
Pill shape1,35810%
Pill colour1,1638%
Splittable9827%
Pharmacist price2842%

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".

BulletinDate on the documentPagesProduct lines (approx.)
F125/6/20201332,191
F22/7/20201913,439
F36/7/202011184
F411/7/2020801,502
F5not found in the extracted text17349
F616/7/202027445
F721/7/202041667
F827/7/202047881
F930/7/202030494
F1016/8/202042669
F117/9/202020336
F1221/9/202020265
F13not found in the extracted text10169
Total66911,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:

  1. Active ingredient
  2. Name of the medicinal product
  3. Qualitative and quantitative composition
  4. Pharmaceutical form
  5. 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
  6. Pharmacological properties
    • Pharmacodynamic properties
    • Pharmacokinetic properties
    • Preclinical safety data
  7. Pharmaceutical particulars
    • List of excipients
    • Incompatibilities
    • Shelf life
    • Special precautions for storage
    • Nature and contents of container
    • Special precautions for disposal and other handling
  8. Marketing authorisation holder
  9. Marketing authorisation number
  10. Date of first authorisation or renewal
  11. 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 notesIn the Shefa technical document
A "not sold because unavailable" mark made by staff at the tillUnmet demand comes only from patient searches in the area
Prescribing doctor recorded on a sale; top prescribers by specialtyThe pharmacy statistics have no doctor dimension. The controlled register stores the doctor's name
Sale classified as with or without prescription, child or adultNot present
Psychotropic register with patient address, phone, ID number, dose, prescription dateThe controlled register stores patient name, doctor and quantity
Expenses and expected cash at the tillShift closing with cash reconciliation, but no expenses
Returns to suppliers tracked as paid or unpaid, with printable listsOne line: "return to the warehouse"
Suggestions at the till ordered by date or by warehouse offersAlternatives are suggested, with no ordering rule
Quantity bought from and returned to each warehouse per periodDebt 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).

AreaFeatures listed
ReceptionAdd, 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 fileAll 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
SecretaryBooking with date and examination time. Edit bookings. Examination and re-examination lists. Visit list and follow-up. Quick booking screen. Printed booking receipt
OperationsRecord 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 accountsOther income and expenses of the clinic or centre. Income and expense reports
Doctors' and assistants' accountsDoctors' 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 companiesAccounts 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
ReportsPatients, 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 termMeaning
SammeltopfOrder pool: one staging area for all pending reorder lines
AMOAverage monthly sales of an item, weighted. Used as the demand figure
BMOOrders per month. Appears to be the variant for systems without a till (inferred)
CitoUrgent order line
DefektA line the supplier reports it cannot deliver
Dispo / NachlieferungBackorder: a line the supplier will deliver later
RückstellmengeQuantity owed to a customer for an item sold or promised while out of stock (interpretation)
StockbuchDemand-based order proposal for one supplier's items
TaxeThe national drug price list and its lookup screen
PZNGerman national article number
AbschreibebuchWrite-off book
NeinverkaufLost sale: a customer asked and the pharmacy could not supply
BtM-BuchNarcotics book
SkontoEarly-payment discount
Item class L / E / AStocked / 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.

IdeaWhat it isSourceTag
Demand figure per itemWeighted 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 lowerBestellwesen p5; Firmenstamm p3–4; Grosshandelsbestellung p10, p20T
Order quantity from coverageQuantity = demand × coverage period, filling to one above minimum stock. Default coverage 28 days for wholesaler orders, 90 days for a direct-supplier proposalBestellwesen p4–6; Stockbuch p2–6T
Self-adjusting minimumMinimum 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 suggestedBestellwesen p5; Firmenstamm p4; Grosshandelsbestellung p23T
Coverage variantsA 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 upBestellwesen p5–6T
Rounding tableProposed quantities are rounded to bundle sizes instead of odd numbers such as 13 or 47 packsBestellwesen p6; Grosshandelsbestellung p10T
Order rasterReusable 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 pharmacyBestellwesen p6–7T
Per-item overridesMaximum order quantity (shelf-space limit), fixed order quantity, fixed minimum stock (for example for a known regular patient)Bestellwesen p7T
Season flagThe 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 p4T
Alarm stockA 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 outBestellwesen p5, p8; Gesamtprospekt p7T
Item class drives reorderingStocked, 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 reorderedBestellwesen p4; Abschreibebuch p2–3; Direktbestellung p6; Grosshandelsbestellung p3, p11; Firmenstamm p4T
Precedence rulesAvailability beats discount. Item-level settings beat global tables. Manual input beats optimisationBestellwesen p4T
Reorder trigger on saleEach sale that takes an item to its reorder point feeds a persistent pool, instead of a list built on demandGrosshandelsbestellung p2, p10T
Quantity on order countsLines already in an open order are excluded from new triggers. Stock is shown as on hand, on order and pre-ordered for a customerGrosshandelsbestellung p20; Wareneingang p6; Angebote p6; TaxeIII p19, p24–25T
"Consider current stock" switchThe proposal can include or ignore current stock, and uses a lead-time tableGrosshandelsbestellung p10, p20T
Slow-mover rule inside orderingFlag an item sold at most once in six months. Bulk orders can filter by average monthly sales so slow movers are not replenishedGrosshandelsbestellung p15, p19T
Bulk stock-up order by selectionFilters: 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 narcoticsGrosshandelsbestellung p18–20T
Overstock viewA "show all" mode in the proposal exposes overstocked items as return candidatesStockbuch p4T

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.

IdeaWhat it isSourceTag
Order poolOne staging area for all pending reorder lines, where quantities are optimised and a supplier is proposed per lineBestellwesen p3; Grosshandelsbestellung p10, p14T
Automatic supplier assignmentEach pool line is pre-assigned to the wholesaler with the best net terms, including tiered and total discounts, with per-item exceptions and user overrideGrosshandelsbestellung p10, p14; Gesamtprospekt p7T
Automatic offer matchingIf 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 quantityGrosshandelsbestellung p14T
Urgent versus replenishment linesLines needed for a specific customer are highlighted and can be pulled into a separate urgent order. Routine lines wait for the consolidated daily orderGrosshandelsbestellung p2, p15–17; Gesamtprospekt p7T
Customer backorderAn 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 referenceBestellwesen p3–4; Grosshandelsbestellung p4–5; Wareneingang p6; AbschlussMonatJahr p5T
Order types with their own termsA supplier defines order types (standard, bulk, stock-up) with different discounts and a minimum order valueBestellwesen p3–4; Grosshandelsbestellung p17–18T
Cut-off and delivery times per supplierOrders 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 dayGrosshandelsbestellung p2, p9, p12T (the time-slot idea; dial-up sending is legacy)
Order splittingOne order split into up to three delivery groups, for example customer pre-orders versus shelf stockGesamtprospekt p7T
Structured shortage handlingPer 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 bufferGrosshandelsbestellung p7–8; Bestellwesen p3–4; Direktbestellung p4T
Backorder bufferLines 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 thereGrosshandelsbestellung p21–22; Bestellwesen p3–4T
Hold item until dateA shortage line can be blocked until a date, then re-enters distributionGrosshandelsbestellung p7, p13T
Successor productThe 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 receiptGrosshandelsbestellung p8; Wareneingang p10–11T
RebookingMove one line, marked lines or a whole order to another supplier or back to the pool. Bulk-edit marked linesDirektbestellung p5–7; Grosshandelsbestellung p4, p6T
Preferred channel per itemDirect preferred, or direct only, with a fixed supplier. Sold items are appended automatically to that supplier's open orderBestellwesen p8; Direktbestellung p2–3; Stockbuch p3–4T
Advance delivery by a repGoods 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 orderDirektbestellung p7T
Order for an off-platform supplierPrint the order list with or without prices, to send by other means. Shefa only records an external purchase after the factDirektbestellung p5T
Off-platform supplier masterDirect suppliers with their own terms, return rules and order types, linked from the manufacturer recordHerstellerstamm p3; Grosshandelsbestellung p7, p18; Lieferantenretoure p2T
Supplier-to-manufacturer linkA supplier or agent is mapped to the manufacturers it represents, which makes per-manufacturer proposals possibleBestellwesen p8; Angebote p1T
Notes on lines and ordersA 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 termsGrosshandelsbestellung p3–5; Stockbuch p7T
Live availability cascadeFor 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 platformWebserviceGehe p5–6T
Availability response fieldsAvailable quantity, backorderable quantity, shortage reason, delivery run. Shefa has a single availability statusWebserviceGehe p4T
Review run for the poolSaved criteria group the proposals (for example all offer items) in a fixed order, for checking and release group by groupGrosshandelsbestellung p14–15T, low priority
Decision line at orderingA month-by-month sales strip (16 months in the sample), last sale date and type, last receipt date and supplier, minimum stock, on-order quantitiesAngebote p6, p8T

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.

IdeaWhat it isSourceTag
Effective purchase price per lineBuilt 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 enteredDirektbestellung p8–9; Wareneingang p13–15; Stockbuch p6–7T (tax handling DE)
Last effective price per supplierShown while building an order, beside current wholesaler offersDirektbestellung p4, p7; Stockbuch p6–7T
Terms entered at order timeThey carry into goods receipt, so goods can be received before the invoice existsDirektbestellung p3, p9; Wareneingang p15T
Selling-price recalculation at receiptFor freely priced items, the selling price is recalculated when the purchase cost changesDirektbestellung p3; Bestellwesen p4; Wareneingang p13T* (depends on which Syrian prices are regulated)
Purchase turnover per supplierIncluding a turnover threshold that unlocks a rebateDirektbestellung p2, p9–10T (also usable as a warehouse-side offer type)
Due-date bookSupplier invoices with due dates and reminders at start-up. Shefa has statement and ageing onlyGesamtprospekt p7T
Purchase controllingReal terms obtained per supplier, discount against volume, return reasons, delivery qualityGesamtprospekt p11T

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.

IdeaWhat it isSourceTag
Future-dated offersNext period's offers are loaded early, beside the current ones, so the buyer can act before a price changeAngebote p1, p9T
Current versus next-period costA cheaper or dearer percentage per item, and a marker in the ordering screen for items that get cheaper next monthAngebote p6, p10T
Stock-up quantityDemand × a chosen stocking period, proposed when a price rise or an offer end is comingAngebote p4, p6T
Saved comparison listsFilters: 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 editedAngebote p3–5T
Cheapest supplier by effective pricePer item and period, including bonus goods (for example 8 + 1 is worth 11.46% in the manual's example). Shefa compares listed prices onlyAngebote p7–8T
Multi-tier quantity scalesSeveral quantity tiers per offer. Shefa's wording implies one tierAngebote p7–8T
Realised savingsA total of what was saved on items ordered through offersAngebote p6, p10T
"Offer exists" flag in searchShown in item search results, with ordering straight from the lookup screenTaxeIII p19, p24–25T
Offer check at receiptA receipt filter that shows only offer lines, to check that the promised offer was deliveredWareneingang p6T

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.

IdeaWhat it isSourceTag
Invoice header with control totalInvoice 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 monthWareneingang p3–4T
Named discrepancy actionsUnder-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–11T
"Missing but invoiced"A return reason that creates a credit claim without touching stockWareneingang p5, p10; Lieferantenretoure p5T
Scan every packReceipt by scanning each pack, capturing expiry in the same step, with a handheld variant so goods go from the box to the shelfWareneingang p2, p8–9T
Several expiry dates per lineUp to three per receipt line, with the remaining quantity pre-filled. Relevant to Shefa's manual purchasesWareneingang p5T
Two-step postingPost quantities now (status "quantity booked") and value laterWareneingang p15; Direktbestellung p3, p9T
Receipt statuses and reopenIn progress, difference found, to post, posted, with a status reset to correct expiry, header or barcodeWareneingang p7–8, p12T
Review filtersShow only offer lines, lines with customer notes, or lines ordered for a partner pharmacyWareneingang p6T
Customer pre-order hintThe receiver is told which items belong to a customer pre-order or a deliveryGesamtprospekt p7, p9; Wareneingang p6T
Local barcode linkingAttach 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 flowWareneingang p7; ZuordnungArtikelnummer p2; Bestellwesen p4; TaxeIII p35–36T
Label quantity per lineN single-pack labels plus one collective label for overstock, on or off per lineWareneingang p6; Firmenstamm p3T, minor
Ad-hoc stock additionAdd stock outside any order: item, quantity per location, expiry, labelsZugangvonWaren p2–3T

6.8 Supplier returns​

Shefa today: "return to the warehouse" in one line, and a "drug payment" (returned goods) that reduces the running account.

IdeaWhat it isSourceTag
Return lifecycleOpen (stock already deducted, goods still on site), returned (shipped), creditedLieferantenretoure p2–3T
Two kinds of returnDelivery returns raised at receipt, and stock-clearance returnsLieferantenretoure p2; Gesamtprospekt p7T
Saleable return stockAn open return line records a still-saleable quantity, and the till warns of it so the pack is sold instead of reorderedLieferantenretoure p2–4T
Return deadline per supplierEach return shows the date by which it must be processed to avoid a loss, with remindersLieferantenretoure p2–3; Gesamtprospekt p7T
Return line fieldsReason code, note, recall flag, batch, handler, original invoice number and dateLieferantenretoure p4–5, p9T
Buy-back requestSend the proposed list to the supplier, who accepts per line. Refused lines go back to stock or to another supplierLieferantenretoure p6, p9T
Credit-note reconciliationEnter 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 supplierLieferantenretoure p7–8T
Uncredited linesMove to another supplier, book back to stock, or write off as destroyedLieferantenretoure p9T
Return poolCollect clearance returns with no supplier chosen, then split by manufacturer or product group, for example for a rep who takes returns for several companiesLieferantenretoure p11–12T
Return price basisDelivery returns at actual cost, clearance returns at list purchase price. A rule to decideLieferantenretoure p11T
Reorder promptWhen a return takes a stocked item to zeroLieferantenretoure p5, p11T
Standard declaration textPrinted on all return documents, for example a statement of proper storageLieferantenretoure p5T, 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.

IdeaWhat it isSourceTag
Write-off reason codesExpired, damaged pack, shrinkage or theft, unsaleable, recall, clearance, gift, own withdrawal, discontinued, other. Each with free text and an editable dateAbschreibebuch p2T
Write-off loss reportBy period, reason and manufacturer, at purchase value, for the accountantAbschreibebuch p3–4T
Single-item stock correctionOutside a stocktake: add or withdraw, choose which expiry lot to reduce. An employee-ID prompt can be off, at the start, or before savingBestandskorrektur p3–5T
Expiry-tracking flag per itemNo expiry, has expiry but not monitored, or monitored. Shefa forces a batch and expiry on everything, including supplies and cosmeticsBestandskorrektur p4; Wareneingang p13; Firmenstamm p3T
Storage locations inside a pharmacyUp 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 listsBestandskorrektur p4; UmbuchenvonWaren p2; ZugangvonWaren p2–3; Inventur p4–5, p18; Angebote p4T
Item journalAll movements of one item over a period, with month-end stock snapshot lines. Shefa has the ledger but no such view or snapshotsBestandskorrektur p6T
Handheld shelf maintenanceScan, then correct stock, reorder, return or print a labelInventur p15–16T
Cold-chain flag and storage conditionsA cold-chain flag on products, used as an order filter, plus storage temperature, light and humidityGrosshandelsbestellung p19; TaxeIII p21–24T
Batch recallReturns carry a recall flag and "recall" is a write-off reason. Shefa has no recall concept at allLieferantenretoure p4–5; Abschreibebuch p2T
Narcotics book with running balanceFed at goods receipt and reduced at dispensing. Shefa's controlled register records sales onlyGesamtprospekt p11T*
Fallback expiry dateIf no expiry is entered, 80% of the standard shelf life is assumed, else today plus one year. Questionable for medicines; listed for completenessWareneingang p13; ZugangvonWaren p2; Firmenstamm p3Not 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.

IdeaWhat it isSourceTag
Rolling countEvery 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 yearInventur p15–22T
Continuous partial listsN items per run, resuming where the last list stopped, so everything is counted once a yearInventur p12–13T
Annual versus partialWith fiscal year and key date. Only the annual one is posted, storing date, quantity, value, factor and price basis per itemInventur p3, p13–14T*
Valuation basisA 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–4T
Write-down rulesWith priorities, reusable from the previous stocktake. Examples: no sale for a year valued at 70%, discontinued at 0, by product groupInventur p10–11T*
Printable count sheetsWith 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 connectionInventur p4–6, p12T
Review filters inside a countUncounted lines, lines above a price or quantity, lines by counterInventur p10T
Exclude one-off itemsAn option to leave one-off items out of valuation and proposalsInventur p4; Stockbuch p4–5T

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.

IdeaWhat it isSourceTag
Lost-sale logOne 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 searchesTaxeIII p11, p45–50; Firmenstamm p3–4T
Transaction and basket figuresCustomer transactions, line items, average basket (total and cash), filterable by time-of-day window and by tillKassenstatistik p4–6T
Activity coefficientNon-prescription sales divided by prescription sales, per employee, as an indicator of counsellingKassenstatistik p5–6T
Profit by dispensing classRevenue and gross profit split by prescription-only, pharmacy-only and other, with profit per pack, margin per pack and share of total profitKassenstatistik p7–9T
Staff load by hour and dayFor shift planning, and commission models per employeeGesamtprospekt p5T
Seller roll-up and exclusionSeller IDs rolled up to a main seller, and a per-seller flag to exclude from statisticsKassenstatistik p11–12T
Parked sale with depositA sale held with or without a deposit and completed later; partial orders. Shefa only has a reservation requested by the patientKassenstatistik p10, p12–13T
Separate fee linesSuch as a night-duty fee or a procurement costKassenstatistik p12T*
Prompts at the tillAdd-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 packGesamtprospekt p5; TaxeIII p28–29, p34–35T
Printed dosing labelsDosing and usage texts printed for the customer, with translationsGesamtprospekt p5T
Customer information at the tillHistory, allergies, doctors and medication shown during the sale. Shefa covers this through the patient record and access grantsGesamtprospekt p5Already covered in part
Customer card and loyaltyCustomer cards with loyalty points, an ABC classification of customers, targeted mailingsGesamtprospekt p11, back pageT
Customer invoicing extrasDelivery notes, collective invoices, reminder letters for overdue debts. Shefa has a debt book onlyGesamtprospekt p11T
Price-check scansScans cancelled at the till must not count as sales in slow-mover statisticsAbschlussMonatJahr p3–4T, minor
Cash bookFed automatically by daily till closingsFirmenstamm p4T

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.

IdeaWhat it isSourceTag
Cost-plus pricingMarkup 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 markupsTaxeIII p9–10, p34, p39–40; Gesamtprospekt p7T* (depends on how much of the assortment is price-regulated)
Promotional priceA pharmacy-side price limited by period, quantity or both, feeding labelsTaxeIII p39; Gesamtprospekt p7T
Central price-update serviceA central price update with a change log per update (added, removed, changed) and scheduled price changesTaxeIII p61–62; Gesamtprospekt p11T
Price history per itemVisible from the item lookupTaxeIIIT

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.

IdeaWhat it isSourceTag
Lifecycle flagsDiscontinued, recalled, successor and predecessor cross-link, archive of deleted items and manufacturersTaxeIII p18–19, p30, p54, p61T
Extra product fieldsStorage conditions, cold-chain flag, shelf life, pack dimensions, excipients, approved indications, hospital pack, manufacturer service linesTaxeIII p21–24T
Dosage form decomposedDispensing form, application form, route and site of action, used in alternative searchTaxeIII p29, p66T
Alternatives by indication or groupSame indication or product group, sorted by price, restricted to items in stock. Shefa matches only substance, strength and formTaxeIII p63–67T
Search prefixesSearch by manufacturer, form, indication, pack size or group through a prefix, with wildcards and a recent-items historyTaxeIII p14–18T
Related pack sizesJump between the pack sizes of the same productTaxeIIIT
Item notes as to-dosBack-office notes on an item with a "done" status, item text blocks, and a text block for a whole manufacturerTaxeIII p26–28, p42–44, p51–53T
Counselling textsTexts for patients by product group or keyword, printableTaxeIII p56–59T
News feedSearchable news: new launches, changes, recalls, regulator noticesTaxeIII p56–59T
Controlled-drug informationMaximum prescribable quantities and dosingTaxeIII p29T*
Manufacturer master extrasCity, free-text note, log of added and deleted manufacturersHerstellerstamm p2–3T, minor
Interaction alerts at the tillListed as a till feature, with drug profiles and dosing, warning and usage notes from licensed databasesGesamtprospekt p5Already 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.

IdeaWhat it isSourceTag
Month and year closing reportA 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 onlyAbschlussMonatJahr p2–6; Gesamtprospekt back page; Firmenstamm p2T
Stock figuresTurnover 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 stockCIS_Flyer p2T
Peer benchmarksEach figure shown against other pharmacies, with a trend arrow. Shefa could do this with anonymised city-level aggregatesCIS_Flyer p1–2; VSA flyer p4–5T
Further analysesProcurement channel (direct versus wholesaler), margin by dispensing category, month and year comparisons, staff performance per manufacturer or assortmentCIS_Flyer p1–2T
Report builderSaved definitions with chosen columns, formulas, sums, duplication and scheduled runsFreieAuswertungslisten p1–7, p10T
Working set with bulk actionsSave 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 changeFreieAuswertungslisten p8–10T
ABC analysisOf items, and of customersGesamtprospekt back pageT
Management figuresTime series, cash flow, break-even, forecast, accountant exportGesamtprospekt p11, back pageT
Shelf-placement analysisSales per shelfGesamtprospekt p11T
Scheduled jobsA scheduler for jobs and backupsGesamtprospektT (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.

IdeaWhat it isTag
Pooled purchasingPartners' needs are aggregated into one central order, goods are picked per partner, and bonus goods are shared out or kept centrallyT
Cross-branch stock checkDuring ordering, with the option to order from the partner when cheaperT
Quick item exchangeAvailability query, reservation, hand-over and automatic invoicing between pharmacies with configurable termsT
Central price maintenanceWith per-branch exceptions, a change journal sent to branches and an automatic relabelling print jobT
Central item master and reportingFor self-created items across the group, plus consolidated reports across branchesT
Shared customers and loyaltyA common customer master and a common bonus schemeT
Returned-goods reuse checkBefore returning to the supplier, check whether a partner can use the itemT

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.

GroupModules
CounsellingCustomer and patient information at the till (history, allergies, doctors, medication). Drug database linked to stock. Dosing, warning and usage notes. Substance profiles
TillTouch 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
OrderingTerms 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 stockGoods 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
ServicesDelivery 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
ManagementTime 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
OtherInvoicing: 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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. Lost-sale button at the till (sections 4 and 6.11), in both the founder's notes and the German software.
  7. 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.
  8. Named receipt discrepancies and a full return lifecycle (sections 6.7 and 6.8), including "missing but invoiced", return deadlines and credit-note reconciliation.
  9. 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.
  10. Prescribing doctor on the sale (section 4): top prescribers by specialty, and sale classification.
  11. Drug monograph per active substance (section 3.2), with a simplified patient version.
  12. Pill identification by shape and colour, and the splittable flag (section 2).
  13. Exchange of near-expiry stock between pharmacies (section 6.15), subject to a legal check.
  14. Anonymised peer benchmarks (section 6.14), a possible paid tier.
  15. 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 questionWhat the material adds
Source of the drug catalogueThe drug bank gives about 13,400 products to start from, with the gaps listed in 2.3
Official pricingThe 2020 bulletins show regulated pharmacist and public prices, updated in frequent batches
CurrencyThe 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 orderThe German "advance delivery" pattern records goods left by a rep on the order line and nets them off at receipt
Revenue modelPeer benchmarks and management reports were sold as a separate paid service in Germany
Legal requirementsThe 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.