Archive›Tue Jul 21›Merchandise
Merchandise panel

Merchandise — Tuesday, July 21, 2026

Category and brand are derived from the SKU, never stored on a fact row
Category exceptionFragrance comps −12.2% against a fleet +5.0% — −17.2 pts adverse.
Category exceptionMakeup comps −0.4% against a fleet +5.0% — −5.4 pts adverse.

Category grid↑ menu

CategoryBrandNet salesMixCompPlan (derived)% to planPlan coverageUnitsAUR
SkincareLUM$62.7K35.8%+22.5%$52.9K115.2%97.1%2,314$27.11
MakeupATN$48.0K27.4%−0.4%$7.5K95.1%14.9%2,280$21.03
FragranceLUM$33.3K19.0%−12.2%$39.5K82.4%97.6%849$39.24
HaircareBOT$16.3K9.3%+6.4%$3.8K99.4%23.0%858$18.98
Tools & AccessoriesBOT$15.0K8.6%+5.7%$3.9K95.5%24.8%517$29.05
Total$175.3K100.0%+5.0%
$175,307.27 of categories = $175,307.27 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

CategoryAURAUSUPTASTUnits
Fragrance$39.24$39.242.51$98.63849
Haircare$18.98$18.982.52$47.87858
Makeup$21.03$21.032.56$53.792,280
Skincare$27.11$27.112.52$68.322,314
Tools & Accessories$29.05$29.052.53$73.50517

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

SKUCategoryTYLYΔ% vs LYContributionDays since launch
Halo CreamSkincare$6.5K$0+$6.5Kn/a+4.1%new
Neroli Eau de ToiletteFragrance$1.6K$0+$1.6Kn/a+1.0%162
Amber SerumSkincare$2.9K$1.7K+$1.3K+75.8%+0.8%615
Petal SerumSkincare$2.3K$1.2K+$1.0K+86.1%+0.7%1608
Atelier Brush SetTools & Accessories$2.2K$1.3K+$889+67.2%+0.6%1616
Silk SerumSkincare$2.2K$1.4K+$752+53.1%+0.5%1914
Matte LipstickMakeup$2.1K$1.3K+$750+56.7%+0.5%794
Nocturne CreamSkincare$2.2K$1.4K+$748+53.0%+0.5%2301
Lumen SerumSkincare$1.7K$973+$728+74.8%+0.5%731
Noir PaletteMakeup$2.0K$1.3K+$728+55.3%+0.5%2701

Bottom 10 movers↑ menu

SKUCategoryTYLYΔ% vs LYContributionDays since launch
Tuberose Eau de ToiletteFragrance$2.1K$3.8K−$1.6K−42.9%−1.0%1059
Santal Eau de ParfumFragrance$1.2K$2.4K−$1.2K−48.6%−0.7%2631
Santal Eau de ToiletteFragrance$1.2K$2.1K−$842−40.9%−0.5%1899
Nocturne Eau de ToiletteFragrance$1.8K$2.6K−$788−30.1%−0.5%922
Studio PaletteMakeup$1.4K$2.2K−$738−34.2%−0.5%1825
Blanc Eau de ToiletteFragrance$665$1.4K−$722−52.1%−0.5%1131
Tuberose Eau de ParfumFragrance$427$1.1K−$688−61.7%−0.4%2220
Botanica Brush SetTools & Accessories$1.6K$2.3K−$651−28.3%−0.4%2222
Rouge LipstickMakeup$1.2K$1.8K−$648−35.3%−0.4%2066
Iris Eau de ParfumFragrance$462$1.1K−$626−57.6%−0.4%1641
Contributions across every SKU sum to the group's own comp +5.0% — 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.