Your Cart
Loading

Sephora US Women's Fragrance Dataset | 1,606 Products with Ingredients | November 2026 Edition

On Sale
$14.99
$14.99
Added to cart

Every women's fragrance listed on Sephora US, with full ingredient lists, in one Excel workbook.

1,606 products from 106 brands under Fragrance > Women, 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 Women sub-category each product is listed in, for example Perfume (1,144), Rollerballs & Travel Size (503).
  • Pricing: list, sale and value prices as shown, plus numeric minimum and maximum columns. List prices run from $15 to $630, median $37.
  • Ratings and popularity: star rating, review count and Loves count. 730,093 reviews counted across the pack, average rating 4.33.
  • 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 1,526 products (95%).
  • 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

  • Fragrance houses: benchmark prices across sizes and concentrations against 106 competing brands.
  • Retailers and resellers: position prices against the Sephora US range for 1,606 fragrances.
  • Product developers: compare scent descriptions, highlights and ingredient lists.
  • Market researchers: measure brand share, price bands, travel sizes and new launches.
  • Data science teams: build recommendation or pricing 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 1,554 of 1,606 products.
  • Complete for the category: every product listed under Fragrance > Women 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: 1,606 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: 1,606 (every product listed in the category on October 30, 2026)
  • Brands: 106
  • 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 (846KB) file