Archive›Sun Jul 12›Merchandise
Merchandise panel

Merchandise — Sunday, July 12, 2026

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

Category grid↑ menu

CategoryBrandNet salesMixCompPlan (derived)% to planPlan coverageUnitsAUR
SkincareLUM$76.2K33.5%+17.0%$67.0K110.3%97.0%2,847$26.75
MakeupATN$64.8K28.5%+1.9%$10.3K94.2%14.9%3,055$21.21
FragranceLUM$45.2K19.9%−13.7%$54.0K81.3%97.1%1,173$38.54
HaircareBOT$21.7K9.5%+1.0%$4.9K95.0%21.6%1,114$19.49
Tools & AccessoriesBOT$19.6K8.6%+0.5%$5.0K91.5%23.4%685$28.60
Total$227.5K100.0%+2.5%
$227,457.54 of categories = $227,457.54 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$38.54$38.542.53$97.411,173
Haircare$19.49$19.492.51$48.931,114
Makeup$21.21$21.212.56$54.193,055
Skincare$26.75$26.752.53$67.772,847
Tools & Accessories$28.60$28.602.51$71.79685

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$7.6K$0+$7.6Kn/a+3.6%new
Neroli Eau de ToiletteFragrance$2.4K$0+$2.4Kn/a+1.2%153
Matte LipstickMakeup$2.9K$1.6K+$1.3K+84.1%+0.6%785
Lustre PaletteMakeup$2.7K$1.6K+$1.1K+66.8%+0.5%1812
Juniper ConditionerHaircare$969$0+$969n/a+0.5%new
Santal Eau de ParfumFragrance$2.9K$2.0K+$951+48.6%+0.5%2622
Ceramide SerumSkincare$3.1K$2.2K+$937+42.6%+0.4%1881
Coastal SerumSkincare$3.2K$2.3K+$886+38.7%+0.4%1841
Ivory SerumSkincare$2.1K$1.3K+$792+61.8%+0.4%2437
Fig Leaf Eau de ToiletteFragrance$3.1K$2.4K+$731+31.1%+0.3%982

Bottom 10 movers↑ menu

SKUCategoryTYLYΔ% vs LYContributionDays since launch
Fig Leaf Eau de ParfumFragrance$2.3K$4.0K−$1.7K−42.1%−0.8%1980
Tuberose Eau de ToiletteFragrance$3.3K$4.7K−$1.4K−29.1%−0.7%1050
Oud Eau de ToiletteFragrance$2.4K$3.6K−$1.2K−32.6%−0.6%1797
Solstice CreamSkincare$2.2K$3.3K−$1.1K−33.1%−0.5%1836
Tuberose Eau de ParfumFragrance$535$1.6K−$1.0K−66.1%−0.5%2211
Bisque LipstickMakeup$2.0K$3.0K−$1.0K−33.2%−0.5%2138
Iris Eau de ParfumFragrance$775$1.8K−$977−55.8%−0.5%1632
Cedar SerumSkincare$2.1K$3.0K−$930−31.1%−0.4%2461
Halo SerumSkincare$1.8K$2.8K−$927−33.5%−0.4%639
Nocturne CreamSkincare$2.0K$2.7K−$762−28.1%−0.4%2292
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.