Archive›Sat Jul 18›Merchandise
Merchandise panel

Merchandise — Saturday, July 18, 2026

Category and brand are derived from the SKU, never stored on a fact row
Category exceptionFragrance comps −14.5% against a fleet +3.2% — −17.6 pts adverse.
Category exceptionTools & Accessories comps −4.0% against a fleet +3.2% — −7.2 pts adverse.

Category grid↑ menu

CategoryBrandNet salesMixCompPlan (derived)% to planPlan coverageUnitsAUR
SkincareLUM$111.0K35.0%+18.4%$94.5K113.6%96.7%4,074$27.26
MakeupATN$87.1K27.5%+1.3%$14.0K94.8%15.2%4,118$21.16
FragranceLUM$61.0K19.2%−14.5%$72.3K82.1%97.3%1,536$39.72
HaircareBOT$30.2K9.5%+10.7%$6.4K105.9%22.4%1,572$19.23
Tools & AccessoriesBOT$27.8K8.8%−4.0%$7.7K87.6%24.4%936$29.68
Total$317.2K100.0%+3.2%
$317,206.94 of categories = $317,206.94 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.72$39.722.49$98.851,536
Haircare$19.23$19.232.51$48.231,572
Makeup$21.16$21.162.54$53.754,118
Skincare$27.26$27.262.50$68.014,074
Tools & Accessories$29.68$29.682.52$74.70936

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$11.7K$0+$11.7Kn/a+4.0%new
Neroli Eau de ToiletteFragrance$3.0K$0+$3.0Kn/a+1.0%159
Juniper ConditionerHaircare$1.9K$0+$1.9Kn/a+0.6%new
Coastal CreamSkincare$4.2K$2.7K+$1.5K+54.1%+0.5%1178
Chroma PaletteMakeup$1.5K$0+$1.5Kn/a+0.5%138
Noir LipstickMakeup$3.9K$2.7K+$1.2K+46.3%+0.4%1923
Nocturne SerumSkincare$2.6K$1.5K+$1.1K+71.5%+0.4%1449
Amber CreamSkincare$3.3K$2.2K+$1.0K+46.5%+0.4%839
Ceramide SerumSkincare$4.1K$3.1K+$957+30.4%+0.3%1887
Rouge LipstickMakeup$3.0K$2.1K+$885+41.6%+0.3%2063

Bottom 10 movers↑ menu

SKUCategoryTYLYΔ% vs LYContributionDays since launch
Blanc Eau de ToiletteFragrance$1.2K$3.6K−$2.4K−66.4%−0.8%1128
Tuberose Eau de ParfumFragrance$517$2.5K−$2.0K−79.6%−0.7%2217
Iris Eau de ParfumFragrance$798$2.7K−$1.9K−70.4%−0.7%1638
Santal Eau de ToiletteFragrance$2.3K$3.9K−$1.5K−40.0%−0.5%1896
Amber SerumSkincare$4.3K$5.5K−$1.2K−22.1%−0.4%612
Bergamot Eau de ToiletteFragrance$2.8K$4.0K−$1.2K−30.3%−0.4%2591
Santal Eau de ParfumFragrance$3.7K$4.9K−$1.2K−24.4%−0.4%2628
Solstice CreamSkincare$3.8K$4.9K−$1.2K−23.5%−0.4%1842
Tuberose Eau de ToiletteFragrance$4.1K$5.0K−$930−18.6%−0.3%1056
Lustre PaletteMakeup$2.9K$3.8K−$881−23.3%−0.3%1818
Contributions across every SKU sum to the group's own comp +3.2% — 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.