E-commerce Micro-Fulfillment Movement Log
This dataset provides granular logs of inventory movements across regional micro-fulfillment centers, including product details, movement types, quantities, timestamps, and fulfillment center information. It enables deep analysis of supply chain efficiency, bottlenecks, and responsiveness for SMB e-commerce operations, supporting last-mile logistics optimization and demand forecasting.
Sample rows
preview · 8 of 130 rows · all 20 columns| movement_idstring | movement_typestring | quantityinteger | source_center_idstring | product_idstring | product_namestring | skustring | uomstring | source_center_namestring | destination_center_idstring | destination_center_namestring | movement_statusstring | initiated_bystring | initiated_atdatetime | completed_atdatetime | expected_delivery_atdatetime | carrier_namestring | tracking_numberstring | movement_reasonstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A1F7G9-KT8B | inbound | 420 | blank | P1042 | EcoFlex Bamboo Paper Towels 8-Pack | ECO-PT-2024-8 | units | blank | MFC-SEA-03 | Seattle Micro-Fulfillment Center | completed | system_auto_inbound | 2024-04-09T13:20:00Z | 2024-04-09T15:46:00Z | 2024-04-10T12:00:00Z | GreenWay Freight | GW-98327-240409 | restock | blank |
| K98X7Q2J | outbound | 24 | MFC-ATL-12 | P1005 | SmartPlug WiFi Outlet US | SP-WIFI-US-2023 | units | Atlanta Micro-Fulfillment Center | blank | blank | pending | sales_team | 2024-06-01T09:03:00Z | blank | 2024-06-02T13:00:00Z | blank | blank | order fulfillment | blank |
| MFC-TX-20-TRF-6B2 | transfer | 530 | MFC-HOU-20 | P1077 | FreshBrew Organic Coffee 2lb Bag | FB-COF-2LB-2024 | cases | Houston Micro-Fulfillment Center | MFC-DAL-07 | Dallas Micro-Fulfillment Center | in_transit | transfer_bot | 2024-05-22T15:32:00Z | blank | 2024-05-23T12:00:00Z | SpeedyHaul | SH-DAL-0522-530 | inventory balancing | blank |
| TRF-CHI-02-ATL-07-23 | transfer | 210 | MFC-CHI-02 | P1091 | ReNu Recycled Glass Tumbler Set | RN-TMB-GL-2024 | cases | Chicago Micro-Fulfillment Center | MFC-ATL-07 | Atlanta Micro-Fulfillment Center | completed | mdiaz | 2024-04-15T10:15:00Z | 2024-04-15T17:00:00Z | 2024-04-16T11:00:00Z | EcoShip Logistics | ES-CHIATL-0415 | seasonal reallocation | blank |
| ADJ-SEA-11-77B | adjustment | 8 | blank | P1056 | BioClean Multipurpose Cleaner 32oz | BC-MPC-32OZ-2024 | units | blank | MFC-SEA-11 | Seattle Micro-Fulfillment Center | completed | inventory_audit | 2024-05-25T08:20:00Z | 2024-05-25T08:22:00Z | blank | blank | blank | cycle count correction | Adjustment after cycle count: 8 units found over expected. |
| INB-MIA-22-FF7C | inbound | 300 | blank | P1013 | HydroSteel Insulated Water Bottle 16oz | HS-WB-16OZ-2023 | units | blank | MFC-MIA-22 | Miami Micro-Fulfillment Center | pending | receiving | 2024-05-31T12:10:00Z | blank | 2024-06-01T10:00:00Z | blank | blank | restock | blank |
| OBD-HOU-13-9G4E | outbound | 11 | MFC-HOU-13 | P1049 | SnapFresh Silicone Food Covers | SF-SFC-SET-2024 | units | Houston Micro-Fulfillment Center | blank | blank | completed | user | 2024-05-28T14:44:00Z | 2024-05-28T16:16:00Z | 2024-05-29T13:00:00Z | ParcelJet | PJ-49038-HOU | order fulfillment | blank |
| MFC-LA-06-OBD-0H7 | outbound | 49 | MFC-LA-06 | P1066 | BrightPack Reusable Grocery Bags Set | BP-RGB-SET-2023 | units | Los Angeles Micro-Fulfillment Center | blank | blank | in_transit | b2b_portal | 2024-04-21T09:30:00Z | blank | 2024-04-22T15:00:00Z | UrbanExpress | UE-LA-0421-49 | wholesale order | blank |
| ADJ-NYC-02-D3J | adjustment | 2 | blank | P1028 | SustainLight LED Bulb E26 | SL-LED-E26-2023 | units | blank | MFC-NYC-02 | New York Micro-Fulfillment Center | completed | qc_lead | 2024-06-02T07:40:00Z | 2024-06-02T07:41:00Z | blank | blank | blank | quality inspection adjustment | QC found 2 bulbs with packaging damage, removed from active stock. |
| INB-ATL-12-8A2R | inbound | 480 | blank | P1078 | QuickCharge USB-C Cable 3ft | QC-USBC-3FT-2024 | units | blank | MFC-ATL-12 | Atlanta Micro-Fulfillment Center | completed | system_auto_inbound | 2024-05-20T10:54:00Z | 2024-05-20T13:15:00Z | 2024-05-21T12:00:00Z | ParcelJet | PJ-ATL-0520-480 | bulk order restock | blank |
| TRF-LA-06-SF-14-96U | transfer | 630 | MFC-LA-06 | P1069 | CleanSweep Microfiber Mop | CS-MOP-MF-2024 | cases | Los Angeles Micro-Fulfillment Center | MFC-SF-14 | San Francisco Micro-Fulfillment Center | pending | system_scheduler | 2024-06-09T13:11:00Z | blank | 2024-06-11T16:00:00Z | blank | blank | inventory balancing | blank |
| OBD-DEN-19-1K2T | outbound | 38 | MFC-DEN-19 | P1011 | FlexiPrint Recycled Paper A4 | FP-RP-A4-2024 | units | Denver Micro-Fulfillment Center | blank | blank | completed | user | 2024-05-18T08:17:00Z | 2024-05-18T10:03:00Z | 2024-05-19T09:00:00Z | EcoShip Logistics | ES-DEN-0518-38 | retail replenishment | blank |
| ADJ-SEA-03-9E0 | adjustment | 3 | blank | P1042 | EcoFlex Bamboo Paper Towels 8-Pack | ECO-PT-2024-8 | units | blank | MFC-SEA-03 | Seattle Micro-Fulfillment Center | pending | audit_team | 2024-06-10T11:45:00Z | blank | blank | blank | blank | shrinkage adjustment | Possible shrinkage—3 units unaccounted for in cycle count. |
| INB-NYC-02-5B2Z | inbound | 120 | blank | P1028 | SustainLight LED Bulb E26 | SL-LED-E26-2023 | units | blank | MFC-NYC-02 | New York Micro-Fulfillment Center | completed | system_auto_inbound | 2024-05-01T14:40:00Z | 2024-05-01T16:10:00Z | 2024-05-02T10:00:00Z | GreenWay Freight | GW-NYC-0501-120 | restock | blank |
| OBD-SEA-11-8T7F | outbound | 5 | MFC-SEA-11 | P1056 | BioClean Multipurpose Cleaner 32oz | BC-MPC-32OZ-2024 | units | Seattle Micro-Fulfillment Center | blank | blank | completed | user | 2024-06-03T16:37:00Z | 2024-06-03T17:06:00Z | 2024-06-04T11:00:00Z | UrbanExpress | UE-SEA-0603-5 | order fulfillment | blank |
| TRF-MIA-22-NYC-02-1A0 | transfer | 410 | MFC-MIA-22 | P1028 | SustainLight LED Bulb E26 | SL-LED-E26-2023 | cases | Miami Micro-Fulfillment Center | MFC-NYC-02 | New York Micro-Fulfillment Center | completed | transfer_bot | 2024-05-10T13:28:00Z | 2024-05-10T19:30:00Z | 2024-05-11T11:00:00Z | SpeedyHaul | SH-NYC-0510-410 | emergency transfer | blank |
| OBD-DAL-07-2D5V | outbound | 16 | MFC-DAL-07 | P1077 | FreshBrew Organic Coffee 2lb Bag | FB-COF-2LB-2024 | units | Dallas Micro-Fulfillment Center | blank | blank | pending | sales_team | 2024-06-08T11:00:00Z | blank | 2024-06-09T14:00:00Z | blank | blank | order fulfillment | blank |
| INB-SF-14-1Q7S | inbound | 175 | blank | P1069 | CleanSweep Microfiber Mop | CS-MOP-MF-2024 | units | blank | MFC-SF-14 | San Francisco Micro-Fulfillment Center | completed | system_auto_inbound | 2024-03-21T09:05:00Z | 2024-03-21T11:22:00Z | 2024-03-22T10:00:00Z | EcoShip Logistics | ES-SF-0321-175 | restock | blank |
| TRF-DEN-19-CHI-02-6T1 | transfer | 320 | MFC-DEN-19 | P1091 | ReNu Recycled Glass Tumbler Set | RN-TMB-GL-2024 | cases | Denver Micro-Fulfillment Center | MFC-CHI-02 | Chicago Micro-Fulfillment Center | in_transit | system_scheduler | 2024-06-07T12:30:00Z | blank | 2024-06-09T16:00:00Z | ParcelJet | PJ-CHI-0607-320 | seasonal reallocation | blank |
| OBD-HOU-13-7D8B | outbound | 26 | MFC-HOU-13 | P1049 | SnapFresh Silicone Food Covers | SF-SFC-SET-2024 | units | Houston Micro-Fulfillment Center | blank | blank | in_transit | b2b_portal | 2024-06-03T10:44:00Z | blank | 2024-06-04T14:00:00Z | SpeedyHaul | SH-HOU-0603-26 | wholesale order | blank |
What the 130 rows show
from the 130-row sampleTransfer (movement type) stands out: mean quantity is 372.9, against 93.8 for the rest.
- 71median quantity
- 3uoms
- 4movement statuses
- 16movement reasons
- 17carrier names
- 18initiated_
by values
Median 71, from 1 to 700.
- string 16
- integer 1
- datetime 3
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 16 columns | |||
movement_id | string | Unique identifier for each inventory movement eventunique | A1F7G9-KT8B |
product_id | string | Unique identifier for the product being moved | P1042 |
product_name | string | Name or description of the product | SmartPlug WiFi Outlet US |
sku | string | Stock Keeping Unit code for the product | ECO-PT-2024-8 |
movement_type | string | Type of inventory movement (e.g., inbound, outbound, transfer, adjustment)inbound · outbound · transfer · adjustment | inbound |
uom | string | Unit of measure for the quantity (e.g., units, cases, pallets)3 uoms | units |
source_center_id | string | Unique identifier of the source micro-fulfillment center (if applicable)optional | MFC-ATL-12 |
source_center_name | string | Name of the source micro-fulfillment centeroptional | Chicago Central MFC |
destination_center_id | string | Unique identifier of the destination micro-fulfillment center (if applicable)optional | MFC-SEA-03 |
destination_center_name | string | Name of the destination micro-fulfillment centeroptional | Denver Fulfillment Hub |
movement_status | string | Current status of the movement (e.g., pending, in_transit, completed, cancelled)pending · in_transit · completed · cancelled | completed |
initiated_by | string | Identifier or name of the user/system that initiated the movement | system_auto_inbound |
carrier_name | string | Name of the carrier or logistics provider handling the movementoptional | GreenWay Freight |
tracking_number | string | Tracking number provided by the carrier (if applicable)optional | GW-98327-240409 |
movement_reason | string | Reason for the movement (e.g., restock, order fulfillment, inventory balancing, return)optional | restock |
notes | string | Additional notes or comments about the movementoptional | Adjustment after cycle co… |
| Numbers 1 column | |||
quantity | integer | Number of units moved in this event1 or more | 420 |
| Dates and times 3 columns | |||
initiated_at | datetime | Timestamp when the movement was initiated | 2024-04-09T13:20:00Z |
completed_at | datetime | Timestamp when the movement was completed (if applicable)optional | 2024-04-09T15:46:00Z |
expected_delivery_at | datetime | Expected delivery or arrival time at the destination (if applicable)optional | 2024-04-10T12:00:00Z |
Use it for
A logistics dashboard
Quantity by movement_
type and a breakdown of source_ center_ id. Excel, Power BI or Tableau. Why do the 30 transfer rows have a mean quantity of 372.9?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Movements130A1F7G9-KT8B420inboundK98X7Q2J24outboundMFC-TX-20-TRF-6B2530transfer
A software demo
Believable movements with product_
id, product_ name and sku to fill a screen in front of a buyer.
blueprint · e-commerce-micro-fulfillment-movement-log
Behind this dataset
Same schema. As many rows as you need.
These 130 rows came out of a blueprint — 20 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.
- Each row represents a unique inventory movement between micro-fulfillment centers.
- Timestamp, product SKU, origin and destination center IDs, and movement type (restock, transfer, urgent, or return) are included.
- Quantity moved must be a positive integer and always less than or equal to current stock level at origin.
- Status field tracks completion, in-progress, or delayed, with delays requiring a valid reason (e.g., shortage, system error).
- Critical product SKUs (marked as 'priority') cannot have more than two consecutive delays.
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
- e-commerce-micro-fulfillment-movement-log