E-commerce Vendor Fulfillment Anomaly Log
This dataset logs detailed e-commerce order fulfillment anomalies across multiple vendors, including anomaly types, severity, resolution status, and customer impact. It enables supply chain analysts and operations managers to identify bottlenecks, monitor vendor performance, and proactively address fulfillment issues to improve resilience and customer satisfaction.
Sample rows
preview · 8 of 120 rows · all 20 columns| anomaly_idstring | severity_levelstring | order_valuefloat | customer_citystring | order_idstring | vendor_idstring | vendor_namestring | order_datedate | expected_fulfillment_datedate | actual_fulfillment_datedate | anomaly_typestring | detected_datedatetime | resolved_datedatetime | resolution_statusstring | affected_itemsstring | customer_idstring | customer_statestring | customer_countrystring | anomaly_descriptionstring | resolution_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| X9V2K6R1-AB | high | 219.45 | Austin | ORD10345 | VEND-201 | TechZone Inc. | 2023-02-12 | 2023-02-16 | 2023-02-20 | delay | 2023-02-20T11:32:15 | 2023-02-23T09:16:07 | resolved | SKU10294,SKU10923 | CUST-40128 | TX | US | Order experienced a four-day delay due to a warehouse system outage at TechZone Inc. | Issue resolved by reallocating stock and expediting shipment. |
| G5D7L2Q8-MP | critical | 482.6 | Philadelphia | ORD10407 | VEND-187 | HomeMart | 2023-03-22 | 2023-03-25 | blank | missing_item | 2023-03-27T13:09:42 | blank | open | SKU11567 | CUST-40512 | PA | US | Customer reported missing kitchen appliance in the delivered package. | blank |
| X0C8J4E2-WZ | medium | 79.25 | Dallas | ORD10316 | VEND-210 | FastGoods Inc. | 2023-01-30 | 2023-02-02 | 2023-02-02 | incorrect_item | 2023-02-03T15:18:34 | 2023-02-05T10:02:43 | resolved | SKU11324,SKU11019 | CUST-40062 | TX | US | Incorrect item shipped; customer received headphones instead of smart speaker. | Replacement item shipped and customer compensated. |
| V3N6A1Q9-YT | critical | 321.1 | Berlin | ORD10451 | VEND-218 | OfficeDirect | 2023-04-12 | 2023-04-16 | 2023-04-22 | delay | 2023-04-22T10:57:09 | 2023-04-24T08:20:11 | resolved | SKU11827 | CUST-40277 | BE | DE | Fulfillment delayed due to late arrival from supplier, six days past expected. | Supplier issue resolved; fulfillment expedited. |
| Z5T4N2M8-AQ | critical | 512.8 | Singapore | ORD10512 | VEND-222 | GlobalMart | 2023-05-03 | 2023-05-07 | 2023-05-18 | delay | 2023-05-18T09:20:14 | 2023-05-19T15:04:29 | resolved | SKU12017,SKU12018,SKU12019 | CUST-40823 | SG | SG | International shipment delayed at customs, delivery 11 days late. | Customs cleared and order delivered to customer. |
| B7K1P4X9-VF | medium | 62.15 | San Francisco | ORD10297 | VEND-205 | EcoGoods Direct | 2023-01-14 | 2023-01-18 | 2023-01-18 | damaged_item | 2023-01-19T12:04:18 | 2023-01-21T09:19:34 | resolved | SKU10791 | CUST-40003 | CA | US | Customer received damaged eco-friendly storage containers. | Replacement items provided and refund issued. |
| J1V6L4S3-WR | critical | 394.9 | Paris | ORD10388 | VEND-201 | TechZone Inc. | 2023-03-18 | 2023-03-20 | blank | delay | 2023-03-23T16:31:50 | blank | investigating | SKU11562,SKU11015 | CUST-40901 | IDF | FR | Order remains unfulfilled due to ongoing system migration at the vendor. | blank |
| W9Q3T2P5-DC | high | 38.5 | London | ORD10427 | VEND-214 | BookMart | 2023-04-01 | 2023-04-06 | blank | missing_item | 2023-04-09T10:44:11 | blank | open | SKU11711 | CUST-40514 | ENG | GB | One textbook missing from shipment, as reported by the customer. | blank |
| L8N2F7D4-RS | medium | 49.75 | Miami | ORD10332 | VEND-219 | BeautyEssence | 2023-02-05 | 2023-02-07 | 2023-02-08 | other | 2023-02-08T14:28:10 | 2023-02-09T11:23:06 | resolved | SKU10457 | CUST-40097 | FL | US | Order flagged for potential fraud, fulfillment delayed for verification. | Customer verified; order released for delivery. |
| P6R4E8A2-KL | critical | 617.9 | Oslo | ORD10532 | VEND-225 | GadgetWorld | 2023-05-19 | 2023-05-24 | 2023-06-03 | delay | 2023-06-03T13:21:45 | 2023-06-05T08:37:19 | resolved | SKU12202,SKU12204,SKU12205 | CUST-41241 | 03 | NO | International electronics order delayed due to chip shortage. | Vendor sourced alternative chip supplier; order completed. |
| R7X1M3V8-FQ | medium | 86.1 | Chicago | ORD10483 | VEND-206 | OfficeDirect | 2023-04-28 | 2023-05-02 | 2023-05-02 | incorrect_item | 2023-05-03T10:11:58 | 2023-05-05T09:00:13 | resolved | SKU12093,SKU12095 | CUST-41009 | IL | US | Office chair ordered, but customer received a desk lamp. | Correct item shipped and return processed. |
| S5P3B2W4-VC | high | 44.2 | Denver | ORD10375 | VEND-208 | ToyLand | 2023-03-10 | 2023-03-13 | 2023-03-13 | damaged_item | 2023-03-14T11:12:21 | 2023-03-16T08:50:22 | resolved | SKU11478 | CUST-40163 | CO | US | Board game arrived with damaged packaging and missing pieces. | New game shipped to customer; investigation with courier ongoing. |
| Q2L6Z5H9-OP | low | 21.5 | San Diego | ORD10422 | VEND-211 | MedicalPro | 2023-03-29 | 2023-04-02 | 2023-04-03 | other | 2023-04-03T10:16:50 | 2023-04-04T10:41:42 | resolved | SKU11689 | CUST-40617 | CA | US | Order cancelled by customer before fulfillment; process delay noted. | Order successfully cancelled; refund issued. |
| U0D2Y8K5-JC | medium | 38.9 | Boston | ORD10263 | VEND-214 | BookMart | 2023-01-03 | 2023-01-07 | 2023-01-09 | delay | 2023-01-09T09:45:08 | 2023-01-10T13:11:19 | resolved | SKU10612,SKU10613 | CUST-40091 | MA | US | Book shipment delayed due to weather affecting logistics. | Book delivered after weather improved. |
| E3G9S1C4-LP | high | 113.6 | Los Angeles | ORD10499 | VEND-223 | EcoGoods Direct | 2023-05-10 | 2023-05-12 | 2023-05-19 | delay | 2023-05-19T12:18:27 | 2023-05-21T10:18:13 | resolved | SKU12121 | CUST-40392 | CA | US | Order delayed a full week due to supply chain interruptions. | Supplier issues resolved; order shipped. |
| N8V3T4Z6-PE | low | 57.1 | Houston | ORD10511 | VEND-225 | GadgetWorld | 2023-05-02 | 2023-05-07 | 2023-05-12 | incorrect_item | 2023-05-13T13:08:00 | 2023-05-14T15:19:47 | resolved | SKU12197 | CUST-40124 | TX | US | Customer received the wrong color of headphones. | Replacement shipped; return label provided. |
| C2X4R6J8-DF | critical | 401.5 | Paris | ORD10434 | VEND-221 | GlobalMart | 2023-04-04 | 2023-04-11 | 2023-04-19 | delay | 2023-04-19T16:20:00 | 2023-04-20T11:50:34 | resolved | SKU11861,SKU11862 | CUST-40837 | IDF | FR | Customs processing delayed international order by eight days. | Customs paperwork expedited; order delivered. |
| O3H5P2G6-VN | medium | 26.4 | Phoenix | ORD10461 | VEND-220 | ToyLand | 2023-04-13 | 2023-04-16 | 2023-04-16 | damaged_item | 2023-04-17T12:15:58 | 2023-04-20T12:00:01 | resolved | SKU11852 | CUST-40699 | AZ | US | Puzzle pieces arrived broken inside packaging. | Replacement puzzle shipped to customer. |
| F2K7M9S4-TX | low | 18 | Boulder | ORD10523 | VEND-224 | MedicalPro | 2023-05-13 | 2023-05-15 | 2023-05-15 | other | 2023-05-15T17:21:27 | 2023-05-16T10:34:04 | resolved | SKU12214 | CUST-40942 | CO | US | Order placed on hold for manual review due to unusual activity. | Manual review completed; order approved. |
| A6S2N9T3-PQ | medium | 74.3 | Minneapolis | ORD10536 | VEND-226 | KitchenMart | 2023-05-23 | 2023-05-27 | 2023-05-29 | delay | 2023-05-29T14:16:37 | 2023-05-30T11:13:17 | resolved | SKU12221,SKU12222 | CUST-41299 | MN | US | Delay of two days due to vendor inventory replenishment. | Inventory restocked; order shipped. |
What the 120 rows show
from the 120-row sampleCritical (severity level) stands out: mean order_
- 75.2median order_
value - 3resolution statuses
- 5anomaly types
- 7customer countries
- 26customer states
- 34vendor names
Median 75.2, from 17.5 to 618.5.
- string 14
- float 1
- date 3
- datetime 2
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
anomaly_id | string | Unique identifier for each anomaly log entryunique | X9V2K6R1-AB |
order_id | string | Unique identifier for the affected order | ORD10345 |
vendor_id | string | Unique identifier for the vendor responsible for order fulfillment | VEND-201 |
vendor_name | string | Name of the vendor responsible for fulfilling the order | TechZone Inc. |
anomaly_type | string | Type of fulfillment anomaly (e.g., delay, missing item, damaged item, incorrect item)delay · missing_item · damaged_item · incorrect_item · other | delay |
anomaly_description | string | Detailed description of the anomaly encountered | Order experienced a four-… |
severity_level | string | Severity of the anomaly (e.g., low, medium, high, critical)low · medium · high · critical | high |
resolution_status | string | Current status of the anomaly resolution (e.g., open, investigating, resolved, escalated)open · investigating · resolved · escalated | resolved |
resolution_notes | string | Notes or comments regarding the resolution or actions takenoptional | Issue resolved by realloc… |
affected_items | string | Comma-separated list of affected item SKUs or product IDsoptional | SKU10294,SKU10923 |
customer_id | string | Unique identifier for the customer who placed the orderoptional | CUST-40128 |
customer_city | string | City of the customer who placed the orderoptional | Austin |
customer_state | string | State or region of the customer who placed the orderoptional | TX |
customer_country | string | Country of the customer who placed the order7 countries · optional | US |
| Numbers 1 column | |||
order_value | float | Total monetary value of the order affected by the anomaly0 or more · optional | 219.45 |
| Dates and times 5 columns | |||
order_date | date | Date when the order was placed | 2023-02-12 |
expected_fulfillment_date | date | Date when the order was expected to be fulfilled | 2023-02-16 |
actual_fulfillment_date | date | Date when the order was actually fulfilled (if completed)optional | 2023-02-20 |
detected_date | datetime | Timestamp when the anomaly was detected | 2023-02-20T11:32:15 |
resolved_date | datetime | Timestamp when the anomaly was resolved (if applicable)optional | 2023-02-23T09:16:07 |
Use it for
An e-commerce dashboard
Order_
value by severity_ level and a breakdown of customer_ city. Excel, Power BI or Tableau. Why do the 29 critical rows have a mean order_
value of 421.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Anomalies120X9V2K6R1-AB219.45highG5D7L2Q8-MP482.6criticalX0C8J4E2-WZ79.25medium
A software demo
Believable anomalies with order_
id, vendor_ id and vendor_ name to fill a screen in front of a buyer.
This dataset120 rows20 columns
Yours1,000 rows20 columnscustomer_city: UK only
blueprint · e-commerce-vendor-fulfillment-anomaly-log
Behind this dataset
Same schema. As many rows as you need.
These 120 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.
Rules it was built with
- Each row represents a unique order fulfillment event with anomaly status
- Anomalies must be classified (e.g., delay, damaged goods, mislabeling, missing items)
- Order timestamps must be in sequential order per vendor
- Severity scores assigned based on business impact level
- If anomaly is 'delay', must include delay duration (hours)
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-vendor-fulfillment-anomaly-log