Collections ยท Included with a Data Pass
A complete online store, four years of orders deep.
A made-up shop with 1,364 products, 168,314 orders and 340,002 order lines from 2022 through 2025. The customers are the people in our People collection, so every order has a name and address to join to. Sales grow each year and jump on Black Friday and Cyber Monday, and there are promo codes, returns and cancellations along the way.
- Rows
- 509,680
- Files
- 3
- Formats
- CSV, JSON, XML
As of: Orders from January 1, 2022 to December 31, 2025. Fixed. It was generated once, so your results stay the same every time you load it.
Preview
A few real rows
| SKU | ProductName | Category | Color | UnitPrice | LaunchDate |
|---|---|---|---|---|---|
| EL-HE-00010 | Halcyon & Co. Over-Ear Headphones | Electronics | Red | 114.99 | 2020-04-15 |
| EL-HE-00020 | Ironbark Sport Earbuds | Electronics | Blue | 124.99 | 2018-09-12 |
| EL-HE-00030 | Pinehaven Noise-Cancelling Headphones | Electronics | Green | 62.99 | 2021-04-23 |
| EL-HE-00040 | Sparrow Studio Noise-Cancelling Headphones | Electronics | Charcoal | 109.99 | 2020-06-09 |
| EL-HE-00050 | Alder Supply Wireless Earbuds | Electronics | White | 19.49 | 2022-12-27 |
| EL-HE-00060 | Copperline Over-Ear Headphones | Electronics | Olive | 35.99 | 2018-08-25 |
| EL-SP-00070 | Ironbark Waterproof Speaker | Electronics | White | 71.49 | 2020-02-11 |
| EL-SP-00080 | Larkspur Smart Speaker XL | Electronics | Sand | 30.99 | 2018-12-16 |
| OrderNumber | OrderDate | Channel | Status | PromoCode | ItemCount | OrderTotal |
|---|---|---|---|---|---|---|
| SO-1160964 | 2025-12-01 | Mobile App | Delivered | BFCM25 | 2 | 92.38 |
| SO-1160965 | 2025-12-01 | Web | Delivered | BFCM25 | 1 | 44.35 |
| SO-1160966 | 2025-12-01 | Web | Delivered | 4 | 87.96 | |
| SO-1160967 | 2025-12-01 | Web | Delivered | BFCM25 | 6 | 114.35 |
| SO-1160968 | 2025-12-01 | Web | Returned | 2 | 58.44 | |
| SO-1160969 | 2025-12-01 | Mobile App | Delivered | 1 | 149.99 | |
| SO-1160970 | 2025-12-01 | Web | Delivered | BFCM25 | 2 | 29.17 |
| SO-1160971 | 2025-12-01 | Mobile App | Delivered | BFCM25 | 1 | 55.55 |
| OrderID | LineNumber | ProductID | Quantity | UnitPrice | DiscountPercent | LineTotal |
|---|---|---|---|---|---|---|
| 500 | 1 | 292 | 1 | 114.99 | 0 | 114.99 |
| 1000 | 1 | 416 | 1 | 42.49 | 0 | 42.49 |
| 1000 | 2 | 236 | 1 | 76.99 | 0 | 76.99 |
| 1500 | 1 | 1329 | 2 | 29.95 | 10 | 53.91 |
| 2000 | 1 | 1237 | 3 | 10.95 | 0 | 32.85 |
| 2500 | 1 | 1294 | 1 | 17.49 | 0 | 17.49 |
| 2500 | 2 | 1290 | 1 | 11.99 | 0 | 11.99 |
| 3000 | 1 | 622 | 1 | 17.95 | 0 | 17.95 |
Field guide
What's in each file
Products StoreProducts
The product
SKU, name, brand, category and color. A product sold in several colors has a row for each.
SKU ProductName Brand Category Subcategory Color
Price and life
Today's price and cost, the launch date, and the date it was discontinued (empty while it is still sold).
UnitPrice UnitCost LaunchDate DiscontinuedDate
Orders StoreOrders
The order
Order number and date, where it was placed (Web, Mobile App or Phone), and whether it was delivered, returned or cancelled.
OrderNumber OrderDate Channel Status PromoCode
Customer
The person who placed it. Join to ID in the People collection.
PersonID
Totals
Item count, subtotal, discount, shipping and the order total.
ItemCount Subtotal DiscountAmount ShippingAmount OrderTotal
Shipping and returns
When it shipped, arrived and came back. Empty when that didn't happen.
ShipDate DeliveryDate ReturnDate
Order lines StoreOrderItems
The line
The order and product it belongs to (join to ID in Orders and Products), quantity, price paid, discount and line total.
OrderID LineNumber ProductID Quantity UnitPrice DiscountPercent LineTotal
Good to know
Before you use it
- PersonID in Orders is the ID in the People collection, which is included with the same pass.
- Prices rose about 3% a year, so each order line keeps the price paid that year.
- Shipping is free when an order comes to $50 or more after discounts. There is no sales tax.
- In every format, dates are written as yyyy-MM-dd, and yes/no values as true or false. An empty value means nothing was recorded.
Source
Generated by MySafeInfo. The brands and products are invented.
Free to use with your pass
Where it comes in handy
What people build with it
- Learning SQL. Practice joins, grouping and window functions on data with real shape to it.
- Dashboards. Build sales, product and customer reports with growth and holiday peaks to show.
- Demo apps. Fill an online store or an order system with believable orders.
- Analytics practice. Work out repeat customers, return rates, promo lift and seasonality.
Access
Try it free. Get all of it with a pass.
Free sample
- Products: every tenth product
- Orders: every 500th order
- Order lines: the lines of the sample orders
- A README with the field guide and source
Data Pass $39
- All 509,680 rows of Sample store
- One ZIP in CSV, JSON or XML, with a README
- Also every other collection and the whole dataset catalog, for 365 days
Already have a pass?
Your key is used for this request and is not saved by this page.
Using it in a product or service for others? That needs a Commercial Pass.