Archive›Mon Jul 20›Merchandise
Merchandise panel

Merchandise — Monday, July 20, 2026

Category and brand are derived from the SKU, never stored on a fact row
Category exceptionFragrance comps −11.2% against a fleet +5.8% — −17.0 pts adverse.
Category exceptionMakeup comps −2.4% against a fleet +5.8% — −8.2 pts adverse.
Category exceptionHaircare comps −0.4% against a fleet +5.8% — −6.2 pts adverse.

Category grid↑ menu

CategoryBrandNet salesMixCompPlan (derived)% to planPlan coverageUnitsAUR
SkincareLUM$66.7K34.8%+25.9%$54.2K119.7%97.3%2,445$27.28
MakeupATN$51.1K26.7%−2.4%$8.1K107.9%17.1%2,433$21.02
FragranceLUM$38.1K19.9%−11.2%$43.9K84.4%97.3%965$39.45
Tools & AccessoriesBOT$19.3K10.1%+21.1%$4.2K122.1%26.5%659$29.25
HaircareBOT$16.6K8.6%−0.4%$3.9K104.5%24.5%868$19.11
Total$191.8K100.0%+5.8%
$191,761.91 of categories = $191,761.91 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.45$39.452.50$98.49965
Haircare$19.11$19.112.49$47.56868
Makeup$21.02$21.022.54$53.462,433
Skincare$27.28$27.282.50$68.202,445
Tools & Accessories$29.25$29.252.49$72.69659

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$5.1K$0+$5.1Kn/a+3.0%new
Neroli Eau de ToiletteFragrance$2.5K$0+$2.5Kn/a+1.5%161
Tuberose Eau de ToiletteFragrance$3.9K$2.4K+$1.5K+62.5%+0.9%1058
Cedar SerumSkincare$3.0K$2.0K+$984+49.2%+0.6%2469
Juniper ConditionerHaircare$936$0+$936n/a+0.5%91
Halo SerumSkincare$2.4K$1.6K+$792+49.8%+0.5%647
Silk SerumSkincare$2.4K$1.6K+$754+45.9%+0.4%1913
Matte LipstickMakeup$2.1K$1.4K+$739+54.6%+0.4%793
Ceramide CreamSkincare$2.6K$1.9K+$738+39.6%+0.4%1733
Studio PaletteMakeup$2.2K$1.5K+$706+47.3%+0.4%1824

Bottom 10 movers↑ menu

SKUCategoryTYLYΔ% vs LYContributionDays since launch
Blanc Eau de ParfumFragrance$2.8K$4.5K−$1.6K−36.3%−0.9%656
Vetiver Eau de ParfumFragrance$1.7K$3.3K−$1.6K−47.9%−0.9%1519
Iris Eau de ParfumFragrance$541$1.7K−$1.2K−68.8%−0.7%1640
Blanc Eau de ToiletteFragrance$598$1.6K−$994−62.4%−0.6%1130
Fig Leaf Eau de ParfumFragrance$2.4K$3.2K−$817−25.2%−0.5%1988
Bisque LipstickMakeup$1.5K$2.2K−$724−32.8%−0.4%2146
Petal SerumSkincare$1.5K$2.2K−$676−30.6%−0.4%1607
Tuberose Eau de ParfumFragrance$500$1.2K−$670−57.3%−0.4%2219
Santal Eau de ParfumFragrance$1.6K$2.3K−$659−28.6%−0.4%2630
Iris Eau de ToiletteFragrance$1.8K$2.5K−$653−26.3%−0.4%2476
Contributions across every SKU sum to the group's own comp +5.8% — 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.