Retail Inventory Replenishment Records

This dataset contains detailed records of retail inventory replenishment events, including store location, product details, supplier information, quantities, costs, and stock levels before and after each event. It enables robust inventory management, supply chain analysis, and forecasting of replenishment trends across multiple retail locations.

  • opened 12 times
  • last updated 21 Aug 2025
  • by GoMask
The brief that made it

Inventory optimization and stockout prevention

Sample rows

preview · 8 of 200 rows · all 22 columns
replenishment_idstringreplenishment_methodstringlead_time_daysintegerstore_statestringstore_idstringstore_namestringstore_street_addressstringstore_citystringstore_postal_codestringstore_countrystringproduct_idstringproduct_namestringproduct_categorystringsupplier_idstringsupplier_namestringreplenishment_datedatequantity_replenishedintegerunit_costfloattotal_costfloatstock_level_beforeintegerstock_level_afterintegerreplenishment_statusstring
A9G8K3LQautomatic2ORST101SuperMart Central123 Elm StPortland97201USAPRD1001Green ApplesProduceSUP3021FarmFresh Co.2024-05-01851.25106.2540125completed
B8X2K1ZMautomatic1ILST102Discount Depot456 Maple AveChicago60616USAPRD1002Chicken BreastsMeatSUP3011PoultryDirect2024-05-02603.99239.42585completed
C1T9Q6JUmanual2ENGST103MiniMart22 King StLondonSW1A1AAUKPRD1003Milk 2LDairySUP3045DairyFarm UK2024-05-04181.4926.82321completed
D7J2R5HSscheduled5ENGST104EcoGrocers88 River RdManchesterM13ABUKPRD1004Organic BananasProduceSUP3051Fyffes UK2024-05-07301.2236.6737completed
E5L3P8VNmanual1NSWST105Express Shop9 Pine StSydney2000AustraliaPRD1005Shampoo 400mlPersonal CareSUP3077CleanCo Australia2024-05-08103.6536.5212completed
F3Q7S9DJscheduled14TXST106SuperMart West789 Oak LaneDallas75201USAPRD1006Ice Cream ConeFrozen FoodsSUP3095Sweets4All2024-05-0912000.394682401440completed
G2H4T8ZXscheduled6ONST107Budget Grocery301 Queen StTorontoM5H2N2CanadaPRD1007Almond MilkDairy AlternativesSUP3088NutriCo CA2024-05-11252.7568.75530pending
H7N2V6PWscheduled8BCST108CityCafé Express77 Main StVancouverV5K0A1CanadaPRD1008Espresso BeansCoffee & TeaSUP3120RoastMaster2024-05-12507.8390959pending

What the 200 rows show

from the 200-row sample

Scheduled (replenishment method) stands out: mean lead_time_days is 8.3, against 1.5 for the rest.

  • 2median lead_time_days
  • 3replenishment statuses
  • 6store countries
  • 14product categories
  • 45store cities
  • 38median quantity_replenished
Mean lead_time_days by replenishment_method200 rows
05101.8automatic62 rows1.2manual77 rows8.3scheduled61 rows
lead_time_days200 rows, in bands of 5
07515014344651101530lead_time_days →

Median 2, from 0 to 28.

store_state200 rows · top 10 of 27 values
  1. ENG29
  2. TX20
  3. CA14
  4. IDF14
  5. ON13
  6. NSW10
  7. NY9
  8. VIC9
  9. QC9
  10. BE9
22 columns by typefrom the column list below
  • string 15
  • integer 4
  • float 2
  • date 1

Columns

22 columns in three groups
blueprint · 22 columns
columntypedescriptionexample
Text 15 columns
replenishment_idstringUnique identifier for each inventory replenishment eventuniqueA9G8K3LQ
store_idstringUnique identifier for the retail store where the replenishment occurredST101
store_namestringName of the retail storeSuperMart Central
store_street_addressstringStreet address of the retail store123 Elm St
store_citystringCity where the retail store is locatedPortland
store_statestringState or province of the retail storeOR
store_postal_codestringPostal code of the retail store97201
store_countrystringCountry where the retail store is located6 countriesUSA
product_idstringUnique identifier for the product being replenishedPRD1001
product_namestringName of the product being replenishedGreen Apples
product_categorystringCategory or department of the productProduce
supplier_idstringUnique identifier for the supplier providing the productSUP3021
supplier_namestringName of the supplier providing the productFarmFresh Co.
replenishment_methodstringMethod used for replenishment (e.g., automatic, manual, scheduled)automatic · manual · scheduledautomatic
replenishment_statusstringStatus of the replenishment event (e.g., completed, pending, cancelled)completed · pending · cancelledcompleted
Numbers 6 columns
quantity_replenishedintegerNumber of units replenished in this event1 or more85
unit_costfloatCost per unit of the product replenished0 or more1.25
total_costfloatTotal cost for the replenished quantity (quantity_replenished x unit_cost)0 or more106.25
lead_time_daysintegerNumber of days between order placement and delivery0 or more2
stock_level_beforeintegerStock level of the product at the store before replenishment0 or more40
stock_level_afterintegerStock level of the product at the store after replenishment0 or more125
Dates and times 1 column
replenishment_datedateDate when the replenishment event occurred2024-05-01

15 SQL practice questions for the Retail Inventory Replenishment Records

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    Completed replenishments in Canada

    Return replenishment_id, store_name, product_name and total_cost for every replenishment where store_country is 'Canada' and replenishment_status is 'completed'. Order the results by total_cost from highest to lowest, then by replenishment_id ascending.

    Tables: retail_inventory_replenishment_records · your result: 4 columns, 21 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct product categories

    Return each distinct product_category exactly once, in a single column named product_category, sorted alphabetically.

    Tables: retail_inventory_replenishment_records · your result: 1 columns, 14 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Replenishments per country

    For each store_country, return store_country and the number of replenishment rows as replenishment_count. Order by replenishment_count from highest to lowest, then by store_country ascending.

    Tables: retail_inventory_replenishment_records · your result: 2 columns, 6 rows
  1. 04Total spend by replenishment methodBeginner
  2. 05Spend by category bar chartPower BI
  3. 06Suppliers with slow lead timesIntermediate
  4. 07Order size bucketsIntermediate
  5. 08Monthly spendIntermediate
  6. 09Countries above overall average costIntermediate
  7. 10Cancellation rate by methodPower BI
  8. 11Top product by spend within categoryAdvanced
  9. 12Days since previous replenishmentAdvanced
  10. 13Running total of monthly spendAdvanced
  11. 14Cost outliers within categoryAdvanced
  12. 15Percent of total spend by countryPower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • median lead ti…2200 rowsmean lead time days b…1.8automa…1.2manual8.3schedu…

    A logistics dashboard

    Lead_time_days by replenishment_method and a breakdown of store_state. Excel, Power BI or Tableau.

  • Why do the 61 scheduled rows have a mean lead_time_days of 8.3?

    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 replenishments with store_id, store_name and store_street_address to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 22 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 rows22 columns
Yours1,000 rows22 columnsstore_street_address: UK only

blueprint · retail-inventory-replenishment-records

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 22 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
  • Store and product ID per record
  • Quantity restocked 1-250 units
  • Replenishment frequency varies by product
  • Out-of-stock flag if interval >7 days
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

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

More in Logistics

Browse all
Also in LogisticsSupply Chain Inventory TurnoverLogistics Shipment Delay PredictionWarehouse Inventory Movement DatasetAll 1,966 datasets
In collectionsInventory and Supply Chain Datasets

What should your data show?

Preview 20 rows free
No signup. No card.