Merchandise panel

Merchandise — Friday, July 17, 2026

Category and brand are derived from the SKU, never stored on a fact row

Category exceptionFragrance comps −6.6% against a fleet +10.9% — −17.5 pts adverse.

Category exceptionMakeup comps +2.8% against a fleet +10.9% — −8.1 pts adverse.

Category grid↑ menu

Category	Brand	Net sales	Mix	Comp	Plan (derived)	% to plan	Plan coverage	Units	AUR
Skincare	LUM	$97.0K	35.3%	+28.9%	$79.2K	119.1%	97.2%	3,496	$27.75
Makeup	ATN	$74.0K	26.9%	+2.8%	$11.2K	116.5%	17.7%	3,578	$20.69
Fragrance	LUM	$52.9K	19.2%	−6.6%	$59.9K	86.1%	97.5%	1,333	$39.67
Tools & Accessories	BOT	$26.4K	9.6%	+26.6%	$5.6K	128.3%	27.3%	902	$29.25
Haircare	BOT	$24.6K	8.9%	+9.5%	$5.4K	109.9%	24.2%	1,283	$19.16
Total		$274.9K	100.0%	+10.9%

$274,905.49 of categories = $274,905.49 of doors (BR-11)

Category plan is DERIVED, not planned: each DAY-grain entity's day plan is split by that entity's own LY-aligned category mix. `planned_actual` restricts the actual to the same entities, so attainment compares like with like; `plan_coverage` states how much of the category's sales sit inside a plan at all (BR-19).

Category basket — AUR, AUS and UPT↑ menu

Category	AUR	AUS	UPT	AST	Units
Fragrance	$39.67	$39.67	2.48	$98.38	1,333
Haircare	$19.16	$19.16	2.52	$48.25	1,283
Makeup	$20.69	$20.69	2.56	$52.90	3,578
Skincare	$27.75	$27.75	2.49	$69.05	3,496
Tools & Accessories	$29.25	$29.25	2.50	$73.21	902

category transactions are DERIVED by allocating each entity's transactions across categories by unit share; transactions are not captured at SKU grain

Top 10 movers↑ menu

SKU	Category	TY	LY	Δ	% vs LY	Contribution	Days since launch
Halo Cream	Skincare	$10.5K	$0	+$10.5K	n/a	+4.5%	new
Neroli Eau de Toilette	Fragrance	$2.9K	$0	+$2.9K	n/a	+1.2%	158
Amber Serum	Skincare	$4.2K	$2.5K	+$1.7K	+67.4%	+0.7%	611
Petal Serum	Skincare	$3.3K	$1.7K	+$1.7K	+99.1%	+0.7%	1604
Botanica Brush Set	Tools & Accessories	$3.9K	$2.3K	+$1.6K	+70.9%	+0.7%	2218
Field Blending Sponge	Tools & Accessories	$2.9K	$1.7K	+$1.2K	+74.7%	+0.5%	2594
Juniper Conditioner	Haircare	$1.2K	$0	+$1.2K	n/a	+0.5%	new
Chroma Palette	Makeup	$1.1K	$0	+$1.1K	n/a	+0.5%	137
Santal Eau de Parfum	Fragrance	$3.6K	$2.5K	+$1.1K	+41.8%	+0.4%	2627
Opal Palette	Makeup	$2.9K	$1.9K	+$1.0K	+55.2%	+0.4%	948

Bottom 10 movers↑ menu

SKU	Category	TY	LY	Δ	% vs LY	Contribution	Days since launch
Vetiver Eau de Parfum	Fragrance	$2.6K	$4.3K	−$1.8K	−40.6%	−0.7%	1516
Iris Eau de Parfum	Fragrance	$656	$2.1K	−$1.4K	−68.7%	−0.6%	1637
Ceramide Cream	Skincare	$3.2K	$4.4K	−$1.2K	−26.9%	−0.5%	1730
Nocturne Eau de Toilette	Fragrance	$3.2K	$4.2K	−$971	−23.0%	−0.4%	918
Fig Leaf Eau de Toilette	Fragrance	$2.2K	$3.2K	−$968	−30.2%	−0.4%	987
Fig Leaf Eau de Parfum	Fragrance	$3.0K	$4.0K	−$939	−23.6%	−0.4%	1985
Opal Lipstick	Makeup	$1.9K	$2.8K	−$895	−31.5%	−0.4%	1463
Aurora Serum	Skincare	$3.0K	$3.8K	−$830	−21.6%	−0.4%	1420
Bergamot Eau de Toilette	Fragrance	$2.4K	$3.2K	−$786	−24.4%	−0.3%	2590
Rouge Lipstick	Makeup	$2.2K	$3.0K	−$785	−26.5%	−0.3%	2062

Contributions across every SKU sum to the group's own comp +10.9% — the same decomposition discipline the focus panel uses on doors (BR-6).

Colour tokens: gold = an input the business asserted · blue = a figure presented as given · green = calculated here. Dotted underline = hover for the formula.