Archive›Mon Jul 13›Merchandise
Merchandise panel

Merchandise — Monday, July 13, 2026

Category and brand are derived from the SKU, never stored on a fact row
Category exceptionFragrance comps −12.3% against a fleet +2.5% — −14.8 pts adverse.

Category grid↑ menu

CategoryBrandNet salesMixCompPlan (derived)% to planPlan coverageUnitsAUR
SkincareLUM$62.7K34.0%+13.9%$55.8K109.0%96.9%2,311$27.15
MakeupATN$51.3K27.8%+0.3%$8.2K104.2%16.7%2,423$21.19
FragranceLUM$36.9K20.0%−12.3%$42.8K83.8%97.2%932$39.55
Tools & AccessoriesBOT$16.8K9.1%+6.3%$4.0K112.0%26.4%576$29.22
HaircareBOT$16.6K9.0%+7.2%$3.5K110.2%23.5%847$19.65
Total$184.4K100.0%+2.5%
$184,416.29 of categories = $184,416.29 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.55$39.552.49$98.51932
Haircare$19.65$19.652.46$48.40847
Makeup$21.19$21.192.53$53.612,423
Skincare$27.15$27.152.51$68.022,311
Tools & Accessories$29.22$29.222.45$71.67576

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$4.8K$0+$4.8Kn/a+2.8%new
Neroli Eau de ToiletteFragrance$2.3K$0+$2.3Kn/a+1.3%154
Coastal SerumSkincare$2.3K$1.5K+$866+58.9%+0.5%1842
Tuberose Eau de ToiletteFragrance$3.4K$2.6K+$773+30.0%+0.5%1051
Juniper ConditionerHaircare$742$0+$742n/a+0.4%new
Halo SerumSkincare$2.4K$1.7K+$711+42.6%+0.4%640
Noir FoundationMakeup$2.1K$1.4K+$681+47.4%+0.4%826
Lumen SerumSkincare$1.6K$926+$665+71.8%+0.4%723
Coastal CreamSkincare$2.2K$1.6K+$654+42.0%+0.4%1173
Chroma PaletteMakeup$623$0+$623n/a+0.4%133

Bottom 10 movers↑ menu

SKUCategoryTYLYΔ% vs LYContributionDays since launch
Iris Eau de ParfumFragrance$393$1.8K−$1.4K−78.1%−0.8%1633
Fig Leaf Eau de ParfumFragrance$1.9K$3.0K−$1.1K−35.4%−0.6%1981
Santal Eau de ToiletteFragrance$1.1K$1.9K−$791−42.5%−0.5%1891
Bisque LipstickMakeup$1.4K$2.2K−$764−35.3%−0.4%2139
Atelier FoundationMakeup$1.2K$1.9K−$762−39.5%−0.4%1417
Nocturne Eau de ToiletteFragrance$2.6K$3.3K−$734−22.1%−0.4%914
Blanc Eau de ToiletteFragrance$522$1.2K−$722−58.0%−0.4%1123
Oud Eau de ToiletteFragrance$2.4K$3.1K−$697−22.5%−0.4%1798
Blanc Eau de ParfumFragrance$3.0K$3.7K−$691−18.7%−0.4%649
Tuberose Eau de ParfumFragrance$416$1.0K−$608−59.4%−0.4%2212
Contributions across every SKU sum to the group's own comp +2.5% — 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.