Retail and consumer dataset

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.

  • Warehouse-ready Parquet, CSV, SQLite
  • One row per product, with linked tables for product details and for each product on each capture day
11,682
products
355
brands
1.3M
daily price and rating observations
Daily
recording

Overview

This dataset is a structured record of the Sephora US range: 11,682 products from 355 brands, each with its prices, rating, review count, badges and categories. Linked detail records add the product description, directions for use and the ingredient list.

The catalogue is recorded every day, so each product has a dated series behind it. That supports work beyond the reach of a single price list: measuring how often and how deeply a brand discounts, seeing when a product gains or loses a bestseller badge, or tracking review growth after a launch.

Ingredient lists are held as published and joined to brand, category and price. A team can ask which actives appear in moisturisers at each price band, or compare the formulation of competing products, from one set of tables keyed on the product identifier.

Coverage

Products 11,682 products from 355 brands, carrying 21,279 SKUs across shades and sizes
Product content Detail records for 10,373 products: description, highlights, directions for use and the ingredient list wherever Sephora publishes one
Price and rating history 1,302,916 daily observations of list price, sale price, rating, review count and badges, recorded from 13 February 2026 to present
Categories 278 categories, with each product linked to every category it is shown in
Merchandising flags Bestseller, new, limited-time offer and additional colours, on the product row and in the daily history
Scope options The whole catalogue, a set of brands, a set of categories, a date range, or an ingredient extract

Data dictionary

products / One row per product. 40 columns.
Field Description
productId, skuId, brandName, displayName, targetUrl Identifiers, brand, product name and the address of the product page
listPrice, salePrice, valuePrice US dollar prices exactly as shown on the site, with a range where a product comes in several sizes
rating, reviews Mean customer rating and the number of reviews behind it
isBestseller, isNew, isLimitedTimeOffer, moreColors Badges the retailer places on the product
categoryPath, heroImage Position in the category tree and the lead product image
product details / One row per product. 56 columns. Joined to products by productId.
Field Description
description, highlights, howToUse The long-form text from the product page
ingredients The complete ingredient list, populated wherever the retailer publishes it
filter tags Skin type or hair type, concerns addressed, formulation and ingredient preferences
price history / One row per product per capture day.
Field Description
productId, date The product and the day of the observation
listPrice, salePrice, rating, reviews, isBestseller, isNew Prices, rating, review count and badges as they stood on that day

The full field list is sent with every sample.

Who uses it

  • Beauty brands

    Follow rival list prices, markdowns, ratings and range changes in each category, day by day.

  • Pricing and category consultancies

    Build discount depth and price-band benchmarks across 355 brands from a dated observation series.

  • Formulators and ingredient suppliers

    Compare ingredient lists across thousands of products to see which actives sit in which categories, brands and price bands.

  • Investment and research teams

    Read brand momentum from review growth, rating movement and bestseller badges over time.

  • Data science teams

    Train recommendation and classification models on structured product, ingredient and rating data.

  • Academic research

    Study pricing behaviour and product composition across a national beauty range with a daily panel.

Source and definitions

Source and method

Compiled by Direct Dataset from the public Sephora US website and recorded each day, so that every price, rating and badge is held with the date it was seen. Product content is arranged into linked tables keyed on the product identifier. Direct Dataset is an independent data provider and is not affiliated with Sephora.

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

Scope and definitions
  • Prices are the US dollar prices displayed online on the day of capture. A product sold in several sizes carries the displayed price range.
  • A daily observation is one product on one capture day, with its list price, sale price, rating, review count and badges.
  • The ingredients field is populated wherever the source publishes it. Detail records cover 10,373 products.
  • A product can sit in several categories. The category link records each one, across 278 categories.
  • A narrower cut by brand, category, date range or field is produced on request.

Samples and licensing

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: Recorded daily. One-time delivery, or monthly or quarterly updates.
  • Licence: internal use as standard. Research, publication and redistribution terms are on the licensing page.

Questions

Can the ingredient data be supplied on its own?

Yes. An ingredient extract carries the product, brand, category, size and complete ingredient list. It can cover one category, a list of brands or the whole catalogue.

Is the price history part of the delivery?

Yes. The history table holds one row per product per capture day from 13 February 2026 onwards, with list price, sale price, rating, review count and badges.

Are customer reviews available?

Yes. The rating and review count are on every product row and in the daily history. Review text is supplied as the separate Sephora US customer reviews dataset.

How current is the data?

The catalogue is recorded daily. A delivery includes every observation up to the day your file is produced, and monthly or quarterly updates add the new days in the same columns.

How to cite

Direct Dataset. Sephora US Product Catalogue and Price History [dataset]. https://directdataset.com/datasets/sephora-us-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.

This dataset in use

  • Use case

    Skincare ingredient data from the Sephora US range

    Full ingredient lists turn a product catalogue into formulation data. Across 2,328 Sephora US skincare products, 65.5% contain vitamin E, 46.5% hyaluronic acid and 25.5% niacinamide, and every figure can be cut by category, brand and price.

  • 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.

  • 864,749 products

    Tesco UK Product Catalogue

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