Pharmacy Inventory Forecasting

This dataset provides a comprehensive view of pharmacy inventory, combining historical sales and replenishment data with predictive stock needs for each product and location. It enables pharmacies to optimize inventory levels, reduce stockouts, and improve operational efficiency by leveraging data-driven forecasting. The dataset includes detailed product, supplier, and location information for robust analytics and compliance.

  • opened 33 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Inventory optimization and reduction of stockouts in pharmacies

Sample rows

preview · 8 of 200 rows · all 28 columns
inventory_idintegerpharmacy_countrystringstock_on_handintegeris_otcbooleanproduct_categorystringpharmacy_idintegerpharmacy_namestringpharmacy_street_addressstringpharmacy_citystringpharmacy_statestringpharmacy_postal_codestringproduct_idintegerproduct_namestringproduct_unitstringbatch_numberstringexpiration_datedateminimum_stock_levelintegermaximum_stock_levelintegerhistorical_sales_quantityintegerhistorical_sales_period_startdatehistorical_sales_period_enddatehistorical_replenishment_quantityintegerforecasted_stock_needintegerforecast_period_startdateforecast_period_enddatelast_replenishment_datedatesupplier_idintegersupplier_namestring
1USA8750trueAnalgesic101Central City Pharmacy123 Main StNew YorkNY100012001Acetaminophen Extra StrengthtabletACE-21NY2025-09-2012012000183002023-01-012023-12-312000095002024-01-012024-06-302024-01-10501PharmaDirect Inc.
2USA450trueSupplement102Riverside Wellness Rx45 Riverside DrChicagoIL606012002Vitamin D3 2000 IUbottleblankblank6070012002023-02-012023-12-3111006002024-01-152024-07-15blankblankblank
3USA55falseAntidiabetic103MountainView Rx312 Aspen RdBoulderCO803012003Metformin HydrochloridetabletMET-24CO2026-01-1510901202023-03-012023-12-31130602024-02-012024-08-012024-02-08502GlucoseCare Pharma
4USA2300trueAnalgesic104Sunrise Drugs19 Sunrise WayMiamiFL331012004Ibuprofen 400mgtabletIBU-23FL2025-05-22200400034002023-04-012023-12-31370017002024-02-102024-07-302024-02-15503Allergy Relief Labs
5UK320trueSupplement105Global Pharmacy88 King StLondonGreater LondonSW1A2AB2005Omega-3 Fish Oilboxblankblank405409002023-01-152023-12-158504502024-01-202024-07-20blankblankblank
6France610trueSleep Aid106Wellness Pharmacy11 Rue de l'ÉgliseParisÎle-de-France750082006Melatonin Sleep AidboxMEL-22FR2025-08-30120100014002023-05-012023-12-3115007002024-02-052024-08-052024-02-10504Sleep Solutions Ltd.
7USA40trueAntihypertensive107ElderCare Pharmacy790 Elm StPhoenixAZ850012007Losartan PotassiumtabletLOS-25AZ2026-02-121080802023-06-012023-12-3185452024-02-182024-08-182024-02-22505Hypertension Meds LLC
8USA97falseThyroid108MetroMed Pharmacy456 Market BlvdSan FranciscoCA941032008Levothyroxine SodiumtabletLEV-20CA2025-11-10221801502023-07-012023-12-31160752024-02-252024-08-252024-02-28506Thyroid Health Inc.

What the 200 rows show

from the 200-row sample

Singapore (pharmacy country) stands out: 16 of its 16 rows have is_otc = true, against 106 of 184 for the rest.

  • 61%is_otc = true
  • 235median stock_on_hand
  • 6product units
  • 44pharmacy states
  • 59pharmacy cities
  • 30median minimum_stock_level
Is otc rate by pharmacy_countryis_otc = true
0%50%100%55%USA80 of 1…59%UK13 of 22100%Singap…16 of 1691%France10 of 1160%Canada3 of 5
stock_on_hand200 rows, in bands of 1,000
085170162891033013105,00010kstock_on_hand →

Median 235, from 12 to 9,900.

product_category200 rows · top 10 of 17 values
  1. Supplement59
  2. Analgesic31
  3. Antihypertensive14
  4. Lipid-lowering14
  5. Antidiabetic13
  6. Antihistamine12
  7. Sleep Aid10
  8. Respiratory9
  9. Thyroid7
  10. Opioid7
28 columns by typefrom the column list below
  • string 11
  • integer 10
  • date 6
  • boolean 1

Columns

28 columns in four groups
blueprint · 28 columns
columntypedescriptionexample
Text 11 columns
pharmacy_namestringName of the pharmacyup to 100Central City Pharmacy
pharmacy_street_addressstringStreet address of the pharmacyup to 150123 Main St
pharmacy_citystringCity where the pharmacy is locatedup to 50New York
pharmacy_statestringState or province of the pharmacyup to 50NY
pharmacy_postal_codestringPostal code of the pharmacyup to 2010001
pharmacy_countrystringCountry where the pharmacy is locatedup to 50 · 5 countriesUSA
product_namestringName of the product or medicationup to 100Vitamin D3 2000 IU
product_categorystringCategory of the product (e.g., antibiotic, analgesic, OTC)up to 50Analgesic
product_unitstringUnit of measurement for the product (e.g., tablet, bottle, box)up to 20 · 6 unitstablet
batch_numberstringBatch or lot number for the productup to 50 · optionalACE-21NY
supplier_namestringName of the supplierup to 100 · optionalPharmaDirect Inc.
Numbers 10 columns
inventory_idintegerUnique identifier for each inventory recordunique · 1 or more1
pharmacy_idintegerUnique identifier for the pharmacy location1 or more101
product_idintegerUnique identifier for the product/medication1 or more2001
stock_on_handintegerCurrent quantity of product in stock0 or more8750
minimum_stock_levelintegerMinimum quantity of product to maintain in inventory0 or more120
maximum_stock_levelintegerMaximum quantity of product to maintain in inventory0 or more · optional12000
historical_sales_quantityintegerTotal quantity of product sold in the selected historical period0 or more18300
historical_replenishment_quantityintegerTotal quantity of product replenished in the selected historical period0 or more20000
forecasted_stock_needintegerPredicted quantity of product needed for the upcoming period0 or more9500
supplier_idintegerUnique identifier for the supplier1 or more · optional501
Dates and times 6 columns
expiration_datedateExpiration date of the product batchoptional2025-09-20
historical_sales_period_startdateStart date of the historical sales period2023-01-01
historical_sales_period_enddateEnd date of the historical sales period2023-12-31
forecast_period_startdateStart date of the forecasted period2024-01-01
forecast_period_enddateEnd date of the forecasted period2024-06-30
last_replenishment_datedateDate of the most recent replenishment for this productoptional2024-01-10
True or false 1 column
is_otcbooleanIndicates if the product is over-the-counter (OTC)true

Use it for

  • is otc61%122 of 200 rowsmean stock on hand by…823.1USA942.1UK640.9Sing…2.1kFran…

    A healthcare dashboard

    The is_otc rate, stock_on_hand by pharmacy_country and a breakdown of product_category. Excel, Power BI or Tableau.

  • Why do 122 of 200 rows have is_otc = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable rows with pharmacy_id, pharmacy_name and pharmacy_street_address to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 28 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows28 columns
Yours1,000 rows28 columnspharmacy_street_address: UK only

blueprint · pharmacy-inventory-forecasting

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 28 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Track product SKU and expiration dates
  • Include sales and restock events
  • Flag out-of-stock occurrences
  • Account for seasonal demand
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
pharmacy-inventory-forecasting

More in Healthcare

Browse all
Also in HealthcarePharmacy Inventory Demand ForecastClaims Denials and Rejection ManagementEmergency Department Triage PatternsAll 1,954 datasets
In collectionsPharmacy and Prescription Datasets

What should your data show?

Preview 20 rows free
No signup. No card.