Ulta Beauty Shade-Level Catalogue, Pricing & Reviews Dataset
Beauty is a shade business, and this Ulta file is built that way — 32 columns capturing every shade of every product with price, discount, stock flag, size in ounces, review count and rating.
Three foundations produced 50 distinct shade rows, with shade names that carry the undertone — “Fair Ivory (fairest warm with yellow undertones)” — on products holding up to 21,980 reviews.
The file already exists, because this pipeline runs once a month whether you buy it or not. Most vendors start collecting after you order — which is why they quote a lead time. Here the most recent file is in your account within minutes of payment, with an API key issued at the same time.
What you get, in plain terms
Four things. Cosmetics captured at the level shade ranges are actually judged on.
One row per shade
Colour holds the shade name in full, including the undertone description, so a brand's shade range can be counted, compared and tracked as it expands.
Size in ounces
Size records the fill — “0.4 oz” travel, “1.08 oz” full size — so travel and full sizes of the same formula stay separate.
Ratings next to availability
Num Ratings and Average Ratings sit on the row, so a style's popularity can be read against what is left in each size.
List price and final price side by side
Price is the list price, Final Price what a shopper pays and Discount the saving in dollars, so markdown depth is a subtraction, not a guess.
Fields included in this dataset
All 32 columns, in the exact order they appear in the file — taken straight from the sample, not from a brochure. The free sample ships with a data dictionary giving an example value for each one.
Sample rows from the real file
Real rows from the sample file, not an illustration. The supplied sample has 50 shade rows with all 32 columns.
Coverage
Captured monthly across ulta.com. One row is one shade-size variant, identified by its SKU, with the product in PID.
| Metric | In the supplied sample | What it tells you |
|---|---|---|
| Shade rows | 50 across 3 products | Foundations and CC creams |
| Distinct shades | 50 | Undertone named in each |
| Brands | IT Cosmetics 46 · Clinique 4 | Prestige beauty |
| Price | $19 · $39 · $45 | Travel and full sizes |
| Discounted rows | 16 of 50 | $39 → $27.30, 30% off |
| Reviews | Up to 21,980 on one product | Ratings 4.1 – 4.3 |
Only tracking a brand, a category or the shade ranges alone? Send the list and we will price a narrower file.
Historical data
The last 30 days come with the dataset. Beyond that we hold Ulta Beauty records from February 2025 onwards.
Ask about historical dataNeed more data points?
We can extend this dataset beyond the standard 32 columns — undertone and depth split out of the shade name is the most requested addition, along with full review text.
Request custom fields“Shade range is the whole conversation in foundation. Having every shade as a row, with the undertone written out, is exactly the file we wanted.”
What people use this dataset for
Retail and brand pricing teams
Benchmark list prices, markdown depth and timing against a competitor's live catalogue.
Merchandising and planning
See assortment width, size depth and what is already out of stock, category by category.
Marketplace and resale sellers
Track which styles, colours and sizes disappear first to shape your own buys.
Data and AI teams
Train product matching, attribute extraction and pricing models on clean, structured catalogue data.
About Ulta Beauty catalogue data
Ulta Beauty is the largest US beauty specialty retailer, carrying prestige and mass brands in one assortment. For a beauty brand, its site is where shade range, size ladder and promotional depth are all visible at once.
Shade is the variant
Three sampled products produced 50 shade rows, each with the full shade name and undertone. Counting shades, tracking new additions and comparing ranges between brands all become straightforward once the data is at this level.
Travel sizes tracked separately
Size gave “0.4 oz”, “1.08 oz” and “1.4 oz”, so the $19 mini and the $39 full size of the same formula never collapse into one price. Sixteen rows were discounted 30%, from $39 to $27.30.
Two things to plan for
Keywords, Manufacturer, UPC or EAN, Others and Gender came through empty, and page_save_id is our internal reference to the stored copy of the page, which we strip on request. The sample covers three complexion products; ask for a wider one to see the full range.
Is collecting this data legal?
Collecting publicly visible product and price information is generally lawful in most jurisdictions. Actowiz collects only public pages, respects robots.txt and platform terms, holds no personal data, and aligns with GDPR and CCPA. We are ISO 9001 and ISO 27001 certified, and this dataset carries documented provenance so your legal team can review the source before you buy.
Frequently asked questions
Num Ratings and Average Ratings are on every row, up to 21,980 reviews on a single product. Full review text can be added on a custom feed.
