Retail and consumer dataset

Tesco UK Product Catalogue

The full Tesco UK catalogue: 864,749 products with prices, Clubcard offers, nutrition, ingredients, allergens and barcodes, in linked tables.

  • Warehouse-ready Parquet, CSV, SQLite
  • One row per product, with linked tables for nutrition, allergens, promotions, categories and sellers
864,749
products
10,788
brands
1,107
aisles
100%
with a GTIN barcode

Overview

This dataset is a structured copy of the Tesco UK catalogue : 864,749 products, each with a GTIN barcode, its place in the catalogue, its price and its current offers.

For food and household lines the published product information is included in linked tables: nutrition per 100 g and per serving, allergen declarations and ingredient lists. That supports questions that cut across the range, such as the sugar content of own-label cereals against branded ones, or which products in an aisle carry a Clubcard price.

Everything is delivered as flat, related tables keyed on the product identifier, ready to load into a database or a notebook without parsing.

Coverage

Products 864,749: 30,786 Tesco grocery and household lines, 32,148 F&F clothing items and 801,815 marketplace items from 1,105 partner sellers
Catalogue structure 15 super-departments, 171 departments and 1,107 aisles, with 2.19 million product-to-category links
Prices and offers Price and unit price for 99.8% of products, Clubcard prices on 13,797 and 138,889 promotion records
Food data 198,403 nutrition rows, 26,670 allergen rows and ingredient lists for 38,601 products
Identifiers GTIN, TPNB and TPNC for every product
Editions Supplied as a full catalogue edition. A fresh edition, a grocery-only refresh or recurring captures are produced on request

Data dictionary

products / One row per product. 177 columns.
Field Description
productId, tpnb, tpnc, gtin Retailer identifiers and barcode
title, brandName, description Product name, brand and descriptive content
superDepartmentName, departmentName, aisleName, shelfName Position in the catalogue
price, unitPrice, unitOfMeasure, clubcardPrice Shelf price, unit price and Clubcard price
promotionsText, promotionCount Current offers
rating, reviewCount Customer rating and number of reviews
productKind, sellerName, sellerCount Tesco, F&F or marketplace item, and who sells it
ingredients, storage, netContents Product information as published
linked tables / Joined to products by productId.
Field Description
product_nutrition Nutrition rows as published, for example per 100 g and per serving
product_allergens Allergen declarations
product_promotions Each promotion with its mechanic and dates
product_categories, product_sellers Every category a product sits in and every marketplace offer for it

The full field list is sent with every sample.

Who uses it

  • Consumer goods manufacturers

    Range, price and promotion benchmarks against competing brands, aisle by aisle.

  • Nutrition and public health research

    Nutrient, ingredient and allergen analysis across a full national grocery range.

  • Pricing and category consultancies

    Price architecture, loyalty pricing depth and own-label positioning.

  • Product data and retail technology teams

    A barcode-keyed reference catalogue for matching and enrichment.

  • Newsrooms

    Evidence on loyalty pricing, pack sizes and the composition of everyday products.

Source and definitions

Source and method

Compiled by Direct Dataset from the public Tesco UK website and catalogue, flattened into linked tables and checked for consistency. Direct Dataset is an independent data provider and is not affiliated with Tesco.

Collection, standardisation and quality checks are described in the methodology.

Scope and definitions
  • Each edition is one full capture of the catalogue. Recurring captures build a price history.
  • Nutrition, allergen and ingredient data are included wherever the retailer publishes them: ingredient lists cover 38,601 products.
  • The catalogue has three parts: Tesco grocery and household lines, F&F clothing and marketplace items. Each can be delivered on its own.
  • Prices are the online prices shown at the time of capture.

Samples and licensing

Sample data

A sample file in the delivery format, with the full field list, is available on request. Write to hello@directdataset.com and say which areas, categories or dates you want to check.

Licensing and delivery
  • Quotation: scoped to the period, geography and fields you need.
  • Formats: Parquet, CSV, SQLite. Parquet files load directly into Snowflake, BigQuery, Databricks, DuckDB and pandas.
  • Updates: Full catalogue edition. Fresh editions or recurring captures on request.
  • Licence: internal use as standard. Research, publication and redistribution terms are on the licensing page.

Questions

Can the grocery range be delivered without the marketplace?

Yes. The Tesco grocery and household lines can be delivered alone, or any selection of departments and aisles.

Is price history available?

Yes, through recurring captures. Choose a schedule and each capture adds a dated price point for every product.

Can I get only ingredient or nutrition data?

Yes. Extracts can be cut by department, brand or ingredient, with one row per ingredient or per nutrient.

How to cite

Direct Dataset. Tesco UK Product Catalogue [dataset]. https://directdataset.com/datasets/tesco-uk-product-catalogue. Retrieved [date you received the data].

Guidance for publications and newsrooms is on the citation page. This page is also available as Markdown.

  • 11,682 products

    Sephora US Product Catalogue and Price History

    The Sephora US range as linked tables: 11,682 products from 355 brands with prices, ratings, ingredient lists and categories, and a dated price and rating record for every capture day since February 2026.

  • 4.13M daily prices

    Retail Price History, US and Europe

    The lowest advertised price on each day on record for 7,063 popular consumer products in six countries, with the shop offering it.

  • 4.63M reviews

    Sephora US Customer Reviews

    4.6 million customer reviews of 11,280 beauty products, from 2008 onwards, with rating, full text, reviewer-stated attributes and helpfulness votes.