Sample sales data
1,000 × 19rows × columns in the 1,000-row file
Updated 3 November 2026. Fictional U.S. businesses and people, generated with a fixed seed.
textnumberdateyes/no
Largest file10,000rows; also 100 and 1,000
Columns19with a data dictionary below
Dates2023-01-04 – 2024-12-31range in the file
LicenceCC0synthetic, free for any use
What is in it
Each row is one order line from a fictional U.S. office-supply retailer: date, ship mode, customer, region, product, quantity, discount, sales and profit. Profit can be negative on heavily discounted lines, as in real retail data.
First rows
point at a column to light it up
| order_idtext | order_datedate | ship_datedate | ship_modetext | customer_idtext | customer_nametext | segmenttext | regiontext | statetext | citytext | categorytext | sub_categorytext | product_nametext | quantitynumber | unit_pricenumber | discountnumber | salesnumber | costnumber | profitnumber |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO-100001 | 2023-03-22 | 2023-03-25 | Second Class | C0266 | Patricia Murphy | Consumer | Northeast | NY | New York | Furniture | Furnishings | Desk Lamp | 9 | 87.18 | 0 | 784.62 | 576.27 | 208.35 |
| SO-100002 | 2024-06-15 | 2024-06-21 | Standard | C0386 | Susan Hill | Consumer | West | CA | Sacramento | Technology | Accessories | USB-C Hub | 2 | 126.39 | 0 | 252.78 | 154.68 | 98.1 |
| SO-100003 | 2024-01-19 | 2024-01-25 | Standard | C0003 | Stephanie Davis | Consumer | Midwest | MN | Minneapolis | Furniture | Tables | Folding Training Table | 1 | 326.87 | 0 | 326.87 | 238.77 | 88.1 |
| SO-100004 | 2023-12-05 | 2023-12-09 | Second Class | C0481 | Donna Jackson | Corporate | South | TX | Dallas | Office Supplies | Appliances | Desk Fan | 1 | 35.16 | 0 | 35.16 | 23.05 | 12.11 |
| SO-100005 | 2023-07-31 | 2023-08-03 | Second Class | C0654 | Diego Hall | Consumer | Midwest | MO | Kansas City | Technology | Machines | Laser Printer | 3 | 473.83 | 0.1 | 1279.34 | 1041.54 | 237.8 |
| SO-100006 | 2024-01-06 | 2024-01-09 | Second Class | C0204 | Charles Robinson | Consumer | Northeast | NY | Buffalo | Office Supplies | Paper | Cardstock 100 Sheets | 9 | 10.7 | 0 | 96.3 | 58.95 | 37.35 |
| SO-100007 | 2024-08-26 | 2024-08-28 | Second Class | C0212 | Ashley Nguyen | Consumer | West | CA | Los Angeles | Furniture | Chairs | Mesh Office Chair | 1 | 288.97 | 0 | 288.97 | 222.81 | 66.16 |
| SO-100008 | 2024-06-02 | 2024-06-06 | Standard | C0724 | Mei Hall | Consumer | Northeast | NY | New York | Technology | Accessories | Noise-Canceling Headset | 5 | 31.86 | 0 | 159.3 | 108 | 51.3 |
| SO-100009 | 2024-08-14 | 2024-08-17 | Second Class | C0198 | Eric Carter | Consumer | Northeast | NJ | Newark | Office Supplies | Paper | Cardstock 100 Sheets | 3 | 10.7 | 0 | 32.1 | 19.65 | 12.45 |
| SO-100010 | 2024-11-21 | 2024-11-21 | Same Day | C0325 | Sandra Gonzalez | Consumer | West | CA | San Francisco | Office Supplies | Art | Dry Erase Markers | 3 | 13.77 | 0 | 41.31 | 23.58 | 17.73 |
Sales by region
USD, 1,000-row file
Show as a table
| region | value |
|---|---|
| South | $299,380 |
| Midwest | $234,802 |
| West | $217,263 |
| Northeast | $204,169 |
Data dictionary
| Column | Type | Meaning |
|---|---|---|
| order_id | text | Order number, unique per row |
| order_date | date | Date the order was placed (2023-2024) |
| ship_date | date | Date shipped, 0-6 days after the order |
| ship_mode | text | Standard, Second Class, First Class or Same Day |
| customer_id | text | Customer number |
| customer_name | text | Fictional customer name |
| segment | text | Consumer, Corporate or Home Office |
| region | text | U.S. Census region of the city |
| state | text | Two-letter state code |
| city | text | City |
| category | text | Product category |
| sub_category | text | Product sub-category |
| product_name | text | Generic product name |
| quantity | integer | Units ordered, 1-14 |
| unit_price | decimal | List price per unit (USD) |
| discount | decimal | Discount rate, 0 to 0.5 |
| sales | decimal | quantity x unit_price x (1 - discount) |
| cost | decimal | quantity x unit cost |
| profit | decimal | sales - cost |
Practice questions
answers checked in SQL and in Python
What are total sales and total profit?
Sales $955,613.76, profit $214,946.97
Excel
=SUM(Q2:Q1001) and =SUM(S2:S1001)SQL
SELECT ROUND(SUM(sales),2), ROUND(SUM(profit),2) FROM sales_ordersFile: sales-orders-1000
Which region has the highest sales?
South, $299,380.41 (Midwest $234,801.89, West $217,262.68, Northeast $204,168.78)
Excel
=SUMIFS(Q:Q,H:H,"South") (one region per cell), or a PivotTable: region in Rows, Sum of sales in ValuesSQL
SELECT region, ROUND(SUM(sales),2) AS total FROM sales_orders GROUP BY region ORDER BY total DESC, regionFile: sales-orders-1000
Profit margin (profit / sales) by category?
Office Supplies 26.98%; Technology 22.32%; Furniture 21.42%
Excel
=SUMIFS(S:S,K:K,"Technology")/SUMIFS(Q:Q,K:K,"Technology")SQL
SELECT category, ROUND(SUM(profit)/SUM(sales)*100,2) AS margin_pct FROM sales_orders GROUP BY category ORDER BY margin_pct DESC, categoryFile: sales-orders-1000
How many orders had a discount of 30% or more, and what was their combined profit?
114 orders, combined profit $-8,060.65
Excel
=COUNTIFS(P:P,">=0.3") and =SUMIFS(S:S,P:P,">=0.3")SQL
SELECT COUNT(*), ROUND(SUM(profit),2) FROM sales_orders WHERE discount >= 0.3File: sales-orders-1000
Which month had the highest sales?
2023-02, $69,236.92
SQL
SELECT substr(order_date,1,7) AS month, ROUND(SUM(sales),2) AS total FROM sales_orders GROUP BY month ORDER BY total DESC LIMIT 1Add a month column (=TEXT(B2,"yyyy-mm") in Excel, or FORMAT in Power BI), then sum sales by it.
File: sales-orders-1000