Your Cart
Loading

Sephora US Shampoo & Conditioner Dataset | 620 Products with Ingredients | November 2026 Edition

On Sale
$9.99
$9.99
Added to cart

Every shampoo and conditioner listed on Sephora US, with full ingredient lists, in one Excel workbook.

620 products from 67 brands under Hair > Shampoo & Conditioner, collected at the end of October 2026. One clean row per product, 40 columns, ready to filter and sort.

What's inside

  • Product identity: product ID, SKU, brand, product name and a link to every product page.
  • Categories: every Shampoo & Conditioner sub-category each product is listed in, for example Shampoo (369), Conditioner (263).
  • Pricing: list, sale and value prices as shown, plus numeric minimum and maximum columns. List prices run from $7.99 to $207, median $29.
  • Ratings and popularity: star rating, review count and Loves count. 247,088 reviews counted across the pack, average rating 4.38.
  • Product content: full description, one-line summary, highlights, how to use, and the filter tags Sephora shows (skin or hair type, concerns, formulation, ingredient preferences).
  • Ingredients: the full ingredient list for 612 products (99%).
  • Sizes and shades: variation type, size, number of variants and every shade or size name.
  • Flags: bestseller, new, limited edition, limited-time offer, online only, Sephora exclusive and stock status, as true or false.
  • Images: main image, second image, further image links and the product video link.

Who buys this

  • Haircare brands: benchmark prices, claims and ratings against 67 competing brands.
  • Formulators: compare full ingredient lists and sulfate-free, silicone-free and hair-concern tags across 620 products.
  • Salons and retail buyers: compare professional and prestige lines by price and size.
  • Market researchers: measure brand share, price per size and hair-concern positioning.
  • Data science teams: train ingredient, claim or rating models on a clean, current product set.

Why this dataset

  • Current: prices, ratings and review counts collected October 30, 2026; product details refreshed October 30, 2026 for 615 of 620 products.
  • Complete for the category: every product listed under Hair > Shampoo & Conditioner on Sephora US, not a sample. A product in several sub-categories appears once.
  • Clean structure: one row per product, readable true/false flags, pipe-separated lists, no embedded code or JSON.
  • Analysis-ready prices: the displayed price text is kept, and numeric columns make sorting and averaging easy, including for price ranges.

Why not collect it yourself

  • The category spans 2 sub-category listings, each needing complete page-by-page crawling so no product is missed.
  • Most products sit in several sub-categories at once, so the results need careful de-duplication.
  • Ingredients, descriptions and shade lists live on each product page: 620 separate pages to visit and parse.
  • Prices arrive as display text and ranges, and need parsing before any analysis.
  • Bot checks, layout changes and category reshuffles need ongoing maintenance.

Dataset specs

  • Products: 620 (every product listed in the category on October 30, 2026)
  • Brands: 67
  • Columns: 40
  • Format: Excel (.xlsx) with an About sheet (key numbers and a guide to every column) and a Products sheet
  • Market: United States, prices in USD
  • Edition: November 2026 Edition

Not included

  • Customer review text. This pack has each product's rating and review count; the Sephora US reviews dataset, over 4.3 million reviews, is sold separately.
  • Daily price history. Available separately on request.

Need every Sephora US category? The full catalog of over 10,000 products is available. Email us for a quote.

Columns

productId, skuId, brandName, displayName, productUrl, packCategories, primaryCategory, listPrice, salePrice, valuePrice, listPriceMin, listPriceMax, salePriceMin, salePriceMax, rating, reviews, lovesCount, variationType, size, variantCount, variantsText, quickLookDescription, longDescription, highlightsText, skuRefinementsText, suggestedUsage, ingredientDesc, isBestseller, isNew, isLimitedEdition, isLimitedTimeOffer, isOnlineOnly, isSephoraExclusive, isOutOfStock, heroImage, altImage, alternateImages, productVideoUrl, first_seen_date, detailsCollectedOn

Happy Endpoint is an independent public data provider, not affiliated with Sephora.

📩 Need a Custom Format or Have Questions?

Feel free to reach out:

hello@happyendpoint.com

https://x.com/happyendpointhq

https://happyendpoint.com/

You will get a XLSX (482KB) file