Sales Transactions

This dataset provides granular, line-item records of point-of-sale transactions, including product details, quantities, pricing, discounts, payment methods, and references to customers and store locations. It is ideal for retail analytics, sales performance tracking, and customer behavior analysis, enabling businesses to optimize inventory, marketing, and operational strategies.

  • opened 5 times
  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Sales performance and trend analysis across products and stores

Sample rows

preview · 8 of 200 rows · all 13 columns
transaction_idstringpayment_methodstringunit_pricefloattransaction_notesstringtransaction_datetimedatetimecustomer_idstringproduct_idstringproduct_namestringquantityintegerdiscount_amountfloattotal_pricefloatcashier_idstringstore_idstring
TXN000001credit_card23.5First-time customer2023-01-02T09:12:36CUST1023PROD-1001Standard Widget2047EMP-101STORE-01
TXN000002cash2.99Cash transaction, no loyalty2023-01-05T11:45:22blankPROD-1002Promo Mug102.99EMP-102STORE-03
TXN000003debit_card249.99blank2023-01-09T16:50:13CUST2104PROD-1003Premium Headphones120229.99EMP-103STORE-02
TXN000004mobile_payment0.2Wholesale order2023-01-15T13:30:00CUST3778PROD-1004Bulk Pen Pack2001525EMP-104STORE-04
TXN000005cash5.99blank2023-01-23T19:15:47blankPROD-1005Standard Notebook105.99EMP-105STORE-06
TXN000006credit_card399VIP customer, major discount2023-02-01T08:20:14CUST4102PROD-1006Premium Smartwatch150349EMP-106STORE-02
TXN000007gift_card4.99Promotional free item2023-02-04T21:59:59blankPROD-1007Promo Tote Bag14.990EMP-107STORE-07
TXN000008credit_card1975.5Large discount, premium2023-02-10T17:05:32CUST5913PROD-1008Luxury Watch25003451EMP-108STORE-05

What the 200 rows show

from the 200-row sample

Credit_card (payment method) stands out: mean unit_price is 276.8, against 28.4 for the rest.

  • 9.5median unit_price
  • 21stores
  • 1median quantity
  • 5.0median discount_amount
  • 25.0median total_price
Mean unit_price by payment_method200 rows
02004002.3cash49 rows276.8credi…53 rows87.5debit…41 rows13.1mobil…27 rows4.9gift_…23 rows1.3other7 rows
unit_price200 rows, in bands of 200
090180175134311200101,0002,000unit_price →

Median 9.5, from 0.05 to 1,976.

transaction_notes126 rows with a value · 74 left blank
  1. VIP customer, major discount18
  2. Bulk group purchase17
  3. Large discount, premium13
  4. Wholesale order12
  5. First-time customer11
  6. Regular purchase10
  7. Promotional free item9
  8. Zero bill, promo gift8
  9. Cash transaction, no loyalty6
  10. Edge: large quantity, low price4
13 columns by typefrom the column list below
  • string 8
  • integer 1
  • float 3
  • datetime 1

Columns

13 columns in three groups
blueprint · 13 columns
columntypedescriptionexample
Text 8 columns
transaction_idstringUnique identifier for each sales transactionuniqueTXN000001
customer_idstringUnique identifier for the customer involved in the transactionoptionalCUST1023
product_idstringUnique identifier for the product sold in the transactionPROD-1001
product_namestringName of the product soldStandard Widget
payment_methodstringPayment method used for the transaction6 valuescredit_card
cashier_idstringIdentifier for the cashier or employee who processed the transactionoptionalEMP-101
store_idstringIdentifier for the store or location where the transaction occurredoptionalSTORE-01
transaction_notesstringAdditional notes or comments related to the transactionoptionalFirst-time customer
Numbers 4 columns
quantityintegerNumber of units of the product sold1 or more2
unit_pricefloatPrice per unit of the product at the time of sale0 or more23.5
discount_amountfloatTotal discount applied to the product in this transaction0 or more · optional0
total_pricefloatTotal price for this product line after discounts (quantity * unit_price - discount_amount)0 or more47
Dates and times 1 column
transaction_datetimedatetimeDate and time when the transaction occurred2023-01-02T09:12:36

Use it for

  • median unit pr…9.5200 rowsmean unit price by pa…2.3cash276.8cred…87.5debi…13.1mobi…

    An e-commerce dashboard

    Unit_price by payment_method and a breakdown of transaction_notes. Excel, Power BI or Tableau.

  • Why do the 53 credit_card rows have a mean unit_price of 276.8?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable transactions with transaction_datetime, customer_id and product_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 13 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 rows13 columns
Yours1,000 rows13 columns

blueprint · sales-transactions

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 13 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
  • Transaction date within business hours
  • Payment methods: cash, credit, debit, mobile
  • Discounts between 0-50% of original price
  • Each transaction has 1-10 line items
  • Total amount equals sum of line items
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
sales-transactions

More in E-commerce

Browse all
Also in E-commerceOrder HistoryE-commerce Packaging Sustainability IndexE-Commerce Cart Abandonment DataAll 1,954 datasets
In collectionsExcel Practice DatasetsRetail and E-commerce Sales DatasetsSQL Practice Datasets

What should your data show?

Preview 20 rows free
No signup. No card.