E-Commerce-Logistics Inventory Integration

This dataset integrates e-commerce product demand with logistics fulfillment and shipping timelines, providing a unified view of inventory levels, order status, and shipment tracking across warehouses and suppliers. It enables detailed supply chain analysis, demand forecasting, and operational optimization for e-commerce logistics teams. The flat structure supports easy integration with analytics tools and supply chain management systems.

  • last updated 29 Jul 2025
  • by GoMask
The brief that made it

Real-time inventory tracking and stockout prevention

Sample rows

preview · 8 of 200 rows · all 29 columns
inventory_record_idstringshipment_statusstringaverage_daily_demandfloatwarehouse_idstringproduct_idstringproduct_namestringskustringwarehouse_namestringwarehouse_citystringwarehouse_statestringwarehouse_countrystringinventory_quantityintegerinventory_last_updateddatetimepending_ordersintegerfulfilled_ordersintegerreorder_pointintegersupplier_idstringsupplier_namestringshipment_idstringshipment_expected_departuredatetimeshipment_actual_departuredatetimeshipment_expected_arrivaldatetimeshipment_actual_arrivaldatetimeshipping_carrierstringshipping_methodstringshipping_tracking_numberstringdestination_citystringdestination_statestringdestination_countrystring
INV-00001blank42.5WH-01PRD-001Digital Gift Card $25GC-25-0001Cloud Distribution HubVirtualblankCloud5000002024-05-11T10:15:00Z0205000SUP-0001Self-Generatedblankblankblankblankblankblankblankblankblankblankblank
INV-00002in_transit7.2WH-02PRD-002Reusable Stainless Water Bottle 750mlWTR-BTL-7502Ohio Fulfillment CenterColumbusOHUSA3122024-06-14T15:22:00Z9248048SUP-0202HydroFlow ImportsSHP-00012024-06-12T13:00:00Z2024-06-12T14:15:00Z2024-06-16T19:00:00ZblankFedExgroundFX1234567890ChicagoILUSA
INV-00003delivered1.2WH-03PRD-003Wireless Bluetooth Earbuds XE200EB-XE200-BLKLondon Central StorageLondonblankUK42024-06-13T11:03:00Z11122SUP-0034AudioNext EuropeSHP-00022024-06-10T08:00:00Z2024-06-10T08:12:00Z2024-06-13T09:00:00Z2024-06-13T09:18:00ZRoyal MailexpressRMX23456712ManchesterblankUK
INV-00004pending4.3WH-04PRD-004Classic Mug 400mlMUG-400CL-04Toronto DistributionTorontoONCanada1282024-06-11T17:41:00Z7120020SUP-0110Maple Ceramics Ltd.SHP-00032024-06-16T10:30:00Zblank2024-06-19T14:45:00ZblankPurolatorgroundblankCalgaryABCanada
INV-00005blank24.7WH-05PRD-005eBook: Business Strategy 2024EBK-BS-2024Virtual Book HubVirtualblankCloud9999992024-06-01T09:00:00Z0423500SUP-0001Self-Generatedblankblankblankblankblankblankblankblankblankblankblank
INV-00006in_transit110.7WH-06PRD-006A4 Printer Paper 5,000 SheetsPPR-A4-5000Berlin Paper StorageBerlinBEGermany246002024-06-14T08:11:00Z112286003000SUP-0231Papierhaus GmbHSHP-00042024-06-12T07:00:00Z2024-06-12T07:45:00Z2024-06-15T16:00:00ZblankDHLgroundDHL89321345MunichBYGermany
INV-00007delivered3.7WH-07PRD-007Cotton T-Shirt Unisex XLTS-UNXL-COT07Sydney Apparel CenterSydneyNSWAustralia792024-05-27T13:38:00Z11135018SUP-0901WestWear ImportsSHP-00052024-05-23T06:00:00Z2024-05-23T06:22:00Z2024-05-26T17:00:00Z2024-05-26T17:33:00ZAustralia PostgroundAUPST984623MelbourneVICAustralia
INV-00008pending8.1WH-08PRD-002Reusable Stainless Water Bottle 750mlWTR-BTL-7502Los Angeles HubLos AngelesCAUSA02024-06-14T09:17:00Z16265056SUP-0202HydroFlow ImportsSHP-00062024-06-16T17:00:00Zblank2024-06-18T18:00:00ZblankFedExgroundblankSan DiegoCAUSA

What the 200 rows show

from the 200-row sample
  • 3.2median average_daily_demand
  • 4shipping methods
  • 10destination countries
  • 11shipping carriers
  • 12warehouse countries
  • 27warehouse states
shipment_status173 rows by value
0357035pending18%68in_trans…34%66delivered33%4delayed2%
average_daily_demand199 rows, in bands of 50
0851701692232120150300average_daily_demand →

Median 3.2, from 0.04 to 260.3.

warehouse_id199 rows with a value · 1 left blank
  1. WH-1314
  2. WH-1211
  3. WH-1511
  4. WH-0510
  5. WH-049
  6. WH-099
  7. WH-119
  8. WH-078
  9. WH-088
  10. WH-228
29 columns by typefrom the column list below
  • string 19
  • integer 4
  • float 1
  • datetime 5

Columns

29 columns in three groups
blueprint · 29 columns
columntypedescriptionexample
Text 19 columns
inventory_record_idstringUnique identifier for each inventory integration recorduniqueINV-00001
product_idstringUnique identifier for the productPRD-001
product_namestringName of the productDigital Gift Card $25
skustringStock Keeping Unit identifier for the productGC-25-0001
warehouse_idstringUnique identifier for the warehouse storing the inventoryWH-01
warehouse_namestringName of the warehouseoptionalCloud Distribution Hub
warehouse_citystringCity where the warehouse is locatedoptionalVirtual
warehouse_statestringState or province where the warehouse is locatedoptionalOH
warehouse_countrystringCountry where the warehouse is located12 countries · optionalCloud
supplier_idstringUnique identifier for the supplier of the productoptionalSUP-0001
supplier_namestringName of the supplieroptionalSelf-Generated
shipment_idstringUnique identifier for the shipment related to this inventory recordoptionalSHP-0001
shipment_statusstringCurrent status of the shipment (e.g., pending, in_transit, delivered, delayed, cancelled)pending · in_transit · delivered · delayed · cancelled · optionalin_transit
shipping_carrierstringName of the shipping carrier handling the shipment11 carriers · optionalFedEx
shipping_methodstringType of shipping method used (e.g., ground, air, sea, express)ground · air · sea · express · optionalground
shipping_tracking_numberstringTracking number for the shipmentoptionalFX1234567890
destination_citystringDestination city for the shipmentoptionalChicago
destination_statestringDestination state or province for the shipmentoptionalIL
destination_countrystringDestination country for the shipment10 countries · optionalUSA
Numbers 5 columns
inventory_quantityintegerCurrent quantity of the product in the warehouse0 or more500000
pending_ordersintegerNumber of outstanding orders for this product at this warehouse0 or more · optional0
fulfilled_ordersintegerNumber of orders fulfilled from this warehouse for this product0 or more · optional20500
average_daily_demandfloatAverage daily demand for this product (units per day)0 or more · optional42.5
reorder_pointintegerInventory level at which a reorder should be triggered0 or more · optional0
Dates and times 5 columns
inventory_last_updateddatetimeTimestamp of the last inventory update2024-05-11T10:15:00Z
shipment_expected_departuredatetimeExpected departure date and time for the shipmentoptional2024-06-12T13:00:00Z
shipment_actual_departuredatetimeActual departure date and time for the shipmentoptional2024-06-12T14:15:00Z
shipment_expected_arrivaldatetimeExpected arrival date and time for the shipmentoptional2024-06-16T19:00:00Z
shipment_actual_arrivaldatetimeActual arrival date and time for the shipmentoptional2024-06-13T09:18:00Z

Use it for

  • median average…3.2199 rowsmean average daily de…3.3pend…18.1in_t…27.2deli…1.1dela…

    A logistics dashboard

    Average_daily_demand by shipment_status and a breakdown of warehouse_id. Excel, Power BI or Tableau.

  • What pattern can you find in 200 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

    Believable inventory records with product_id, product_name and sku to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 29 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 rows29 columns
Yours1,000 rows29 columnswarehouse_city: UK only

blueprint · e-commerce-logistics-inventory-integration

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 29 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
  • Each record links order to shipment
  • Stock availability affects fulfillment time
  • Shipping delays linked to carrier events
  • Returns and refunds tracked
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
e-commerce-logistics-inventory-integration

More in Logistics

Browse all
Also in LogisticsPharmaceutical Inventory Supply ChainsDelivery Route Optimization DatasetSupply Chain Inventory MovementsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.