Dark Mode
E-commerce Transaction History UK
E-commerce & Online Transactions
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
This dataset captures e-commerce sales transactions for a UK-based online retail business over a one-year period. E-commerce serves as a vital channel for business development, offering broader market reach and efficient distribution. It has also transformed consumer shopping habits, with many customers now ordering goods online for home delivery. The dataset provides valuable insights into the sales performance of a London-based shop, established in 2007, which sells gifts and homewares to a global customer base. Customers primarily make direct purchases, though small businesses also buy in bulk for resale through other retail channels. Analysing this data is key for businesses to acquire, store, and effectively use information to thrive in a competitive landscape.
Columns
- TransactionNo (categorical): A unique six-digit number assigned to each transaction. A "C" in the code signifies a cancelled transaction.
- Date (numeric): The specific date on which each transaction was generated.
- ProductNo (categorical): A unique five or six-digit code used to identify a specific product.
- Product (categorical): The name of the product or item.
- Price (numeric): The price of each product per unit, expressed in pound sterling (£).
- Quantity (numeric): The quantity of each product included in a transaction. Negative values indicate cancelled transactions.
- CustomerNo (categorical): A unique five-digit number that identifies each customer.
- Country (categorical): The name of the country where the customer resides.
Distribution
The dataset is typically provided in a CSV file format, named
Sales Transaction v.4a.csv. It contains approximately 500,000 rows and 8 distinct columns, with a total file size of 43 MB. This is a tabular dataset.Usage
This dataset is ideal for various analytical applications and use cases, including:
- Analysing sales trends over different months.
- Identifying the most frequently purchased products.
- Determining the average number of products customers purchase in each transaction.
- Segmenting customers to identify the most profitable groups.
- Formulating data-driven strategies to enhance business profitability.
Coverage
The dataset focuses on a UK-based e-commerce business. While the shop is located in London, its customer base spans all over the world, with the United Kingdom accounting for approximately 90% of customers. The data covers a one-year period, specifically from 1st December 2018 to 9th December 2019. The products sold are gifts and homewares, catering to both adults and children. It also includes transactions from small businesses purchasing in bulk. A minor portion of the dataset includes order cancellations, predominantly due to products being out of stock, leading customers to cancel orders if they prefer all items delivered simultaneously.
License
CC0: Public Domain
Who Can Use It
This dataset is suitable for a wide range of users, including:
- Business Analysts: To understand sales patterns, customer behaviour, and market performance.
- Data Scientists: For developing predictive models, customer segmentation, and market basket analysis.
- E-commerce Managers: To inform marketing strategies, inventory management, and product development.
- Students and Researchers: For academic projects, case studies, and understanding retail analytics.
- Entrepreneurs: To gain insights into online retail operations and customer engagement.
Dataset Name Suggestions
- UK E-commerce Sales Transactions 2018-2019
- Online Retail Data UK
- British E-commerce Sales Insights
- Gifts and Homewares UK Sales
- E-commerce Transaction History UK
Attributes
Original Data Source:E-commerce Transaction History UK
QUALITY