Online Retail Transaction Data

UK Online Retail Sales and Customer Transaction Data

By UCI [source]

About this dataset

Comprehensive Dataset on Online Retail Sales and Customer Data

Welcome to this comprehensive dataset offering a wide array of information related to online retail sales. This data set provides an in-depth look at transactions, product details, and customer information documented by an online retail company based in the UK. The scope of the data spans vastly, from granular details about each product sold to extensive customer data sets from different countries.

This transnational data set is a treasure trove of vital business insights as it meticulously catalogues all the transactions that happened during its span. It houses rich transactional records curated by a renowned non-store online retail company based in the UK known for selling unique all-occasion gifts. A considerable portion of its clientele includes wholesalers; ergo, this dataset can prove instrumental for companies looking for patterns or studying purchasing trends among such businesses.

The available attributes within this dataset offer valuable pieces of information:

• InvoiceNo: This attribute refers to invoice numbers that are six-digit integral numbers uniquely assigned to every transaction logged in this system. Transactions marked with 'c' at the beginning signify cancellations - adding yet another dimension for purchase pattern analysis.

• StockCode: Stock Code corresponds with specific items as they're represented within the inventory system via 5-digit integral numbers; these allow easy identification and distinction between products.

• Description: This refers to product names, giving users qualitative knowledge about what kind of items are being bought and sold frequently.

• Quantity: These figures ascertain the volume of each product per transaction – important figures that can help understand buying trends better.

• InvoiceDate: Invoice Dates detail when each transaction was generated down to precise timestamps – invaluable when conducting time-based trend analysis or segmentation studies.

• UnitPrice: Unit prices represent how much each unit retails at — crucial for revenue calculations or cost-related analyses.

Finally,

• Country: This locational attribute shows where each customer hails from, adding geographical segmentation to your data investigation toolkit.

This dataset was originally collated by Dr Daqing Chen, Director of the Public Analytics group based at the School of Engineering, London South Bank University. His research studies and business cases with this dataset have been published in various papers contributing to establishing a solid theoretical basis for direct, data and digital marketing strategies.

Access to such records can ensure enriching explorations or formulating insightful hypotheses about consumer behavior patterns among wholesalers. Whether it's managing inventory or studying transactional trends over time or spotting cancellation patterns - this dataset is apt for multiple forms of retail analysis

How to use the dataset

1. Sales Analysis:

Sales data forms the backbone of this dataset, and it allows users to delve into various aspects of sales performance. You can use the Quantity and UnitPrice fields to calculate metrics like revenue, and further combine it with InvoiceNo information to understand sales over individual transactions.

2. Product Analysis:

Each product in this dataset comes with its unique identifier (StockCode) and its name (Description). You could analyse which products are most popular based on Quantity sold or look at popularity per transaction by considering both Quantity and InvoiceNo.

3. Customer Segmentation:

If you associated specific business logic onto the transactions (such as calculating total amounts), then you could use standard machine learning methods or even RFM (Recency, Frequency, Monetary) segmentation techniques combining it with 'CustomerID' for your customer base to understand customer behavior better. Concatenating invoice numbers (which stand for separate transactions) per client will give insights about your clients as well.

4. Geographical Analysis:

The Country column enables analysts to study purchase patterns across different geographical locations.

Practical applications

Understand what products sell best where - It can help drive tailored marketing strategies. Anomalies detection – Identify unusual behaviors that might lead frau...

Overview:

This dataset contains 1000 rows of synthetic online retail sales data, mimicking transactions from an e-commerce platform. It includes information about customer demographics, product details, purchase history, and (optional) reviews. This dataset is suitable for a variety of data analysis, data visualization and machine learning tasks, including but not limited to: customer segmentation, product recommendation, sales forecasting, market basket analysis, and exploring general e-commerce trends. The data was generated using the Python Faker library, ensuring realistic values and distributions, while maintaining no privacy concerns as it contains no real customer information.

Data Source:

This dataset is entirely synthetic. It was generated using the Python Faker library and does not represent any real individuals or transactions.

Data Content:

Potential Use Cases (Inspiration):

Customer Segmentation: Group customers based on demographics, purchasing behavior, and preferences.

Product Recommendation: Build a recommendation system to suggest products to customers based on their past purchases and browsing history.

Sales Forecasting: Predict future sales based on historical trends.

Market Basket Analysis: Identify products that are frequently purchased together.

Price Optimization: Analyze the relationship between price and demand.

Geographic Analysis: Explore sales patterns across different cities.

Time Series Analysis: Investigate sales trends over time.

Educational Purposes: Great for practicing data cleaning, EDA, feature engineering, and modeling.

Online Retail Sales and Customer Data

Transactional Data with Product and Customer Details in Online Retail

By Marc Szafraniec [source]

About this dataset

The InvoiceNo column holds unique identifiers for each transaction conducted. This numerical code serves a twofold purpose: it facilitates effortless identification of individual sales or purchases while simultaneously enabling treasury management by offering a repository for record keeping.

In concordance with the invoice number is the InvoiceDate column. It provides a date-time stamp associated with every transaction, which can reveal patterns in purchasing behaviour over time and assists with record-keeping requirements.

The StockCode acts as an integral part of this dataset; it encompasses alphanumeric sequences allocated distinctively to every item in stock. Such a system aids unequivocally identifying individual products making inventory records seamless.

The Description field offers brief elucidations about each listed product, adding layers beyond just stock codes to aid potential customers' understanding of products better and make more informed choices.

Detailed logs concerning sold quantities come under the Quantity banner - it lists the units involved per transaction alongside aiding calculations regarding total costs incurred during each sale/purchase offering significant help tracking inventory levels based on products' outflow dynamics within given periods.

Retail isn't merely about what you sell but also at what price you sell- A point acknowledged via our inclusion of unit prices exerted on items sold within transactions inside our dataset's UnitPrice column which puts forth pertinent pricing details serving as pivotal factors driving metrics such as gross revenue calculation etc

Finally yet importantly is our dive into foreign waters - literally! With impressive international outreach we're looking into segmentation bases like geographical locations via documenting countries (under the name Country) where transactions are conducted & consumers reside extending opportunities for businesses to map their customer bases, track regional performance metrics, extend localization efforts and overall contributing to the formulation of efficient segmentation strategies.

All this invaluable information can be found in a sortable CSV file titled online_retail.csv. This dataset will prove incredibly advantageous for anyone interested in or researching online sales trends, developing customer profiles, or gaining insights into effective inventory management practices

How to use the dataset

Identifying Products: StockCode is the unique identifier for each product. You can use it to identify individual products, track their sales, or discover patterns related to specific items.

Assessing Sales Volume: Quantity column tells you about the number of units of a product involved in each transaction. Along with InvoiceNo, you can analyze overall sales volume or specific purchases throughout your selected period.

Observing Price Fluctuations: By using the UnitPrice, not only can the total cost per transaction be calculated (by multiplying with Quantity), but also insightful observations like price fluctuations over time or determining most profitable items could be derived.

Analyzing Description Patterns/Trends: The Description field sheds light upon what kind of products are being traded. This could provide some inspiration for text analysis like term frequency-inverse document frequency (TF-IDF), sentiment analysis on descriptions, etc., to figure out popular trends at given times.

Analysing Geographical Trends: With the help of Country column, geographical trends in sales volumes across different nations can easily be analyzed i.e., which location has more customers or which country orders more quantity or expensive units based on unit price and quantity columns respectively.

Keep in mind that proper extraction and transformation methodology should be applied while handling data from different columns as per their datatypes (textual/alphanumeric/numeric) requirements.

This dataset not only allows retailers to gain an immediate understanding into their operations but could also serve as a base dataset for those interested in machine learning regarding predicting future transactions

Research Ideas

• Inventory Management: By tracking the 'Quantity' and 'StockCode' over time, a business could use this data to notice if certain products are frequently purchased together or in specific seasons, allowing them to better stock their inventory.
• Pricing Strategy:...

Online Retail Transaction Records

Online Retail Sales: Product Transactions and Customer Details

By Ali Prasla [source]

About this dataset

The Online Retail Sales Dataset, often referred to as the Online Retail.csv file, is an extensive and comprehensive collection of data points relating to e-commerce transactions. This dataset provides a detailed view of sales activities within the online retail sector, covering numerous essential attributes necessary for a quantitative understanding of consumer behavior and the overall business performance.

One of the key elements covered in this dataset is 'InvoiceNo', which is a unique identifier for each transaction taking place in this retail environment. Given its uniqueness, it serves as a primary key for distinguishing individual transactions. It's worthwhile to note that these Invoice Numbers are numerical values.

Another important attribute included here is 'StockCode'. Each product listed or sold on this online retail platform has been assigned with its unique identification code or StockCode. These codes are also numerical values that offer another layer to clearly classify items and distinguish one from another.

For further understanding, every product comes with a basic description noted under the 'Description' column. In textual form, these descriptions provide insights into what exactly each product item entails. Aside from aiding identification efforts, they can potentially open avenues for text-based analysis such as sentiment analysis or keyword flagging based on product trends.

'Moving onto details about transactions themselves', we have two crucial columns: 'Quantity' and 'UnitPrice'. As their names suggest, these show respectively how many particular units of an item were sold per transaction and at what price per unit was sold at.

Further adding detail to our transactions information comes 'InvoiceDate', which records when each separate purchase occurred down to accurate date & time records. This data can be pivotal in recognizing sales patterns throughout different periods or predicting future trends based on historical timing behavior.

Finally yet importantly comes our global indicator - The ‘Country’ column specifies various countries where customers reside who interacts with this particular online platform regularly by making purchases. This application allows us insights into the geographical dispersion of user base across various countries, potentially providing us insights into regional preferences or global market segmentation.

Ith such a wealth of detailed transaction records and customer information, the Online Retail.csv dataset stands as an invaluable tool for those looking to delve deep into online retail sales data analysis. The possibilities with this dataset are vast, ranging from shaping efficient marketing strategies based on geographical data to predicting sales & growth metrics using historical behavior and much more

How to use the dataset

Here's how to make best use of this dataset:

Getting Started Before you start analyzing your data – you'll have to load it into statistical software such as Python (using pandas library) or R. The dataset is saved in .csv file format which supports easy reading into most data manipulation software.

Understand The Fields

• InvoiceNo: Each transaction made has an associated unique numerical identifier called InvoiceNo. Consider it like a receipt code - these allow for tracking individual transactions.

• StockCode: To identify each product uniquely during analysis, refer to each StockCode value which is essentially a product identification code.

• Description: A brief textual description about each product that can be invaluable when dealing with categories for market-basket type analysis.

• Quantity: Each row lists out how many units of a particular item were involved in a single transaction - watch out for very large values as they might represent bulk orders.

• decode 3

• code point 747

• hidden fields exercise difficulty

• coding dictionary letters

• decipher hidden message codes

• dictionary letters python

• a word scramble solution .

• hidden language symbols

• unscramble words solver codes

• descriptions quizlet game zones

• hidden words gameplay notes

• name that symbol solutions pack.

11.russian alphabet chart deciphered key .

12.writing numbers in words worksheets grade 1 difficulty

13.cool letter symbols copy and paste trick

14.solve the equation by factoring puzzle answers...

Context

E-commerce has become a new channel to support businesses development. Through e-commerce, businesses can get access and establish a wider market presence by providing cheaper and more efficient distribution channels for their products or services. E-commerce has also changed the way people shop and consume products and services. Many people are turning to their computers or smart devices to order goods, which can easily be delivered to their homes.

Content

This is a sales transaction data set of UK-based e-commerce (online retail) for one year. This London-based shop has been selling gifts and homewares for adults and children through the website since 2007. Their customers come from all over the world and usually make direct purchases for themselves. There are also small businesses that buy in bulk and sell to other customers through retail outlet channels.

The data set contains 500K rows and 8 columns. The following is the description of each column. 1. TransactionNo (categorical): a six-digit unique number that defines each transaction. The letter “C” in the code indicates a cancellation. 2. Date (numeric): the date when each transaction was generated. 3. ProductNo (categorical): a five or six-digit unique character used to identify a specific product. 4. Product (categorical): product/item name. 5. Price (numeric): the price of each product per unit in pound sterling (£). 6. Quantity (numeric): the quantity of each product per transaction. Negative values related to cancelled transactions. 7. CustomerNo (categorical): a five-digit unique number that defines each customer. 8. Country (categorical): name of the country where the customer resides.

There is a small percentage of order cancellation in the data set. Most of these cancellations were due to out-of-stock conditions on some products. Under this situation, customers tend to cancel an order as they want all products delivered all at once.

Inspiration

Information is a main asset of businesses nowadays. The success of a business in a competitive environment depends on its ability to acquire, store, and utilize information. Data is one of the main sources of information. Therefore, data analysis is an important activity for acquiring new and useful information. Analyze this dataset and try to answer the following questions. 1. How was the sales trend over the months? 2. What are the most frequently purchased products? 3. How many products does the customer purchase in each transaction? 4. What are the most profitable segment customers? 5. Based on your findings, what strategy could you recommend to the business to gain more profit?

Photo by CardMapr on Unsplash

During the first quarter of 2025, *** mergers and acquisitions (M&A) transactions were completed in the online retail sector in Europe and North America, down from the previous quarters in 2024.

Graph and download economic data for E-Commerce Retail Sales as a Percent of Total Sales (ECOMPCTSA) from Q4 1999 to Q2 2025 about e-commerce, retail trade, percent, sales, retail, and USA.

In 2024, *** mergers and acquisitions (M&A) transactions in the online retail sector were completed in Europe and North America. In 2022, over one thousand transactions were closed, making it the year with the highest number of M&A deals in the retail sector in the last eight years.

Online retail in the United Kingdom has been gaining ground in the past decade. With the onset of the coronavirus (COVID-19) crisis, the value of online retail sales in the United Kingdom peaked at around 129.5 billion British pounds in 2021. In 2022, the figure decreased to ***** billion British pounds. However, they then went through another recovery and achieved around ***** billion British pounds in 2024. What ranks high in UK e-commerce? In the United Kingdom, clothing and household goods were the most popular retail items consumers purchased through the internet in 2020. Data published by the Office for National Statistics (UK) showed that other leisure activities and services such as booking holiday accommodations, travel arrangements and event tickets were other areas consumers depended on the internet to buy. German e-commerce market The UK might have the highest share of online sales in retail trade, but other European countries such as Germany and France have had impressive track records over the years as well. According to the forecasts provided by German E-commerce and Distance Selling Trade Association (bevh), the market volume of Germany’s e-commerce sector was projected to see over ** billion euros in 2021.

Internet sales in Great Britain by store type, month and year.

his dataset simulates online retail sales transactions from multiple Indian cities. Each record represents a single customer order containing details about product, price, payment method, and delivery.

In 2023, the largest share of China's total online retail sales came from clothing and textile-related products, amounting to around ** percent. Among all categories, ******* had the highest annual growth rate that year.

In 2024, it was estimated that roughly *** percent of online retail sales in the United States were generated using social networks as a channel. With the number of social commerce buyers expected to increase over the next few years, this segment is forecast to account for about *** percent of total e-commerce retail sales in the U.S. market by 2028.

Internet sales have played an increasingly significant role in retailing. In 2025, e-commerce accounted for over ***percent of retail sales worldwide. Forecasts indicate that by 2030, the online segment will make up ***percent of total global retail sales. Retail e-commerce Online shopping has grown steadily in popularity in recent years. In 2024, global e-commerce sales amounted to over ************ U.S. dollars, a figure expected to approach * trillion U.S. dollars by 2030. Digital development boomed during the COVID-19 pandemic, generating unprecedented e-commerce growth in various economies across the globe. This trend correlates strongly with the constantly improving online access, especially in "mobile-first" online communities, which have long struggled with traditional commercial fixed broadband connections due to financial or infrastructure constraints but enjoy the advantages of cheap mobile broadband connections. M-commerce on the rise The order share of online shopping via smartphones and tablets now outperforms traditional e-commerce via desktop computers. As such, e-retailers around the world have caught up in mobile e-commerce sales. Online shopping via smartphones is particularly prominent in Asia. By the end of 2023, South Korea was the top digital market based on the percentage of the population that had purchased something by phone, with nearly ** percent having made a weekly mobile purchase. Malaysia, UAE, and Turkey completed the top of the ranking.

China Online Retail Sales: YoY: Year to Date: Goods data was reported at 5.700 % in Mar 2025. This records an increase from the previous number of 5.000 % for Feb 2025. China Online Retail Sales: YoY: Year to Date: Goods data is updated monthly, averaging 19.900 % from Jun 2014 (Median) to Mar 2025, with 115 observations. The data reached an all-time high of 49.900 % in Sep 2014 and a record low of 3.000 % in Feb 2020. China Online Retail Sales: YoY: Year to Date: Goods data remains active status in CEIC and is reported by National Bureau of Statistics. The data is categorized under China Premium Database’s Consumer Goods and Services – Table CN.HA: Online Retail Sales.

Snapshot img

E-Commerce Retail Market Size 2025-2029

The e-commerce retail market size is forecast to increase by USD 4,833.5 billion at a CAGR of 12% between 2024 and 2029.

The market is experiencing significant growth, driven by the advent of personalized shopping experiences. Consumers increasingly expect tailored recommendations and seamless interactions, leading retailers to integrate advanced technologies such as Artificial Intelligence (AI) to enhance the shopping journey. However, this market is not without challenges. Strict regulatory policies related to compliance and customer protection pose obstacles for retailers, requiring continuous investment in technology and resources to ensure adherence.
Retailers must navigate these challenges to effectively capitalize on the market's potential and deliver value to customers. By focusing on personalization and regulatory compliance, e-commerce retailers can differentiate themselves, build customer loyalty, and ultimately thrive in this dynamic market. Balancing the need for innovation with regulatory requirements is a delicate task, necessitating strategic planning and operational agility. Fraud prevention and customer retention are crucial aspects of e-commerce, with payment gateways ensuring secure transactions.

What will be the Size of the E-Commerce Retail Market during the forecast period?

Explore in-depth regional segment analysis with market size data - historical 2019-2023 and forecasts 2025-2029 - in the full report.
Request Free Sample

In the dynamic market, shopping carts and checkout processes streamline transactions, while sales forecasting and marketing automation help businesses anticipate consumer demand and optimize promotions. SMS marketing and targeted advertising reach customers effectively, driving sales growth. Warranty claims and customer support chatbots ensure post-purchase satisfaction, bolstering customer loyalty. Retail technology advances, including sustainable packaging, green logistics, and mobile optimization, cater to environmentally-conscious consumers. Legal compliance, data encryption, and fraud detection safeguard businesses and consumer trust. Product reviews, search functionality, and personalized recommendations enhance the shopping experience, fostering customer engagement.
Dynamic pricing and delivery networks adapt to market fluctuations and consumer preferences, respectively. E-commerce software integrates various functionalities, from circular economy initiatives and website accessibility to email automation and real-time order tracking. Overall, the e-commerce landscape continues to evolve, with businesses adopting innovative strategies to meet the needs of diverse customer segments and stay competitive.

How is this E-Commerce Retail Industry segmented?

The e-commerce retail industry research report provides comprehensive data (region-wise segment analysis), with forecasts and estimates in 'USD billion' for the period 2025-2029, as well as historical data from 2019-2023 for the following segments.

Product

  Apparel and accessories
  Groceries
  Footwear
  Personal and beauty care
  Others


Modality

  Business to business (B2B)
  Business to consumer (B2C)
  Consumer to consumer (C2C)


Device

  Mobile
  Desktop


Geography

  North America

    US
    Canada


  Europe

    France
    Germany
    Italy
    UK


  APAC

    China
    India
    Japan
    South Korea


  Rest of World (ROW)

By Product Insights

The apparel and accessories segment is estimated to witness significant growth during the forecast period. The market for apparel and accessories is experiencing significant growth, fueled by several key trends. Increasing consumer affluence and a shift toward premiumization are driving this expansion, with the organized retail sector seeing particular growth. Influenced by social media trends, the Gen Z demographic is a major contributor to this rise in online shopping. This demographic is known for their preference for the latest fashion trends and their willingness to invest in premium products, making them a valuable market segment. Machine learning and artificial intelligence are increasingly being used for returns management and personalized recommendations, enhancing the customer experience.

Ethical sourcing and supply chain optimization are also essential, as consumers demand transparency and sustainability. Cybersecurity threats continue to pose challenges, requiring robust strategies and technologies. B2C and C2C e-commerce are thriving, with influencer marketing and e-commerce analytics playing significant roles. Customer reviews are essential for building trust and brand loyalty, while reputation management and affiliate marketing help expand reach. Sustainable e-commerce and b2b e-commerce are also gaining traction, with third-party logistics and social commerce offering new opportunities. Augment

China Online Retail Sales: YoY: Year to Date: Goods and Service data was reported at 7.900 % in Mar 2025. This records an increase from the previous number of 7.300 % for Feb 2025. China Online Retail Sales: YoY: Year to Date: Goods and Service data is updated monthly, averaging 17.100 % from Feb 2015 (Median) to Mar 2025, with 112 observations. The data reached an all-time high of 44.600 % in Feb 2015 and a record low of -3.000 % in Feb 2020. China Online Retail Sales: YoY: Year to Date: Goods and Service data remains active status in CEIC and is reported by National Bureau of Statistics. The data is categorized under China Premium Database’s Consumer Goods and Services – Table CN.HA: Online Retail Sales.

Dataset from Singapore Department of Statistics. For more information, visit https://data.gov.sg/datasets/d_65e4d47c3616d251f9a84ec1ad28f43c/view

E-commerce product recommendation is a feature commonly used in online retail to suggest products to customers based on various factors, including their browsing history, purchase behavior, product preferences, and other users' similar actions. This technique is pivotal in personalizing the shopping experience and increasing customer engagement and sales.

Australia Online Retail Sales data was reported at 4,207.200 AUD mn in Mar 2025. This records an increase from the previous number of 3,758.800 AUD mn for Feb 2025. Australia Online Retail Sales data is updated monthly, averaging 1,659.100 AUD mn from Mar 2013 (Median) to Mar 2025, with 145 observations. The data reached an all-time high of 5,349.400 AUD mn in Dec 2024 and a record low of 417.400 AUD mn in Mar 2013. Australia Online Retail Sales data remains active status in CEIC and is reported by Australian Bureau of Statistics. The data is categorized under Global Database’s Australia – Table AU.H020: Online Retail Sales. [COVID-19-IMPACT]