Weekly trade summary
Week 38 FY26 · 09 Mar – 15 Mar 2026
Weekly snapshot
Click Generate summary to produce an auto-written trading commentary based on this week's data.
...
Achieved sales
$595k
vs Replan–
vs LW–
vs LY–
GM% rate
74.5%
Target>78%
vs LW–
vs LY–
ASP
$58.68
vs LW–
vs LY–
Units sold
10,167
vs LW–
vs LY–
Weeks of cover · SOH
38.9
Target <20 · 412,519 units
SOH vs LW–
SOH vs LY–
FP / Markdown
76.8% FP
FP $ TW$557k
FP $ vs LW–
MD $ TW$55k
MD $ vs LW–
MD units1,759
MD/total9%
Business ST% rate
3%
Target 6%+
Returns rate
25.3%
Return units2,556
Forecast accuracy MFP
—
Target ±5% · enter in data entry
Discount $ (promo/codes)
—
— of net sales · all promo/code discounts incl. sale
Total discounting applied via promo codes & staff discount
GMROI SA 52wk rolling
—
GP$ return per $1 of avg inventory cost — upload SA CSV for live data
Sales vs benchmarks
Achieved
Replan
Budget
Last year
Category mix — % of weekly total (TW vs LW vs LY)
TW
LW
LY
FP vs markdown — units & sales
Full price — unit mix
5,830 units
$557k sales
vs LW: –
76.8% of all units
Markdown — unit mix
1,759 units
$55k sales
vs LW: –
—
Season to date
Global STD
$26.0M
vs LY –11.9%
AU STD
$7.4M
–US STD
$17.8M
–FP Rev/Option
$137.77
Target ~$700SOH units
412,519
Category detail — TW vs LW vs LY
| Category | TW $ | GM% | Units | vs LW | vs LY | Page views | NCR% |
|---|
Lifecycle management
—
Repeats
—
Holds
—
Kills
Region sales mix
Australia
—
GM%
—
Units
—
vs Replan
–
vs LW
–
vs LY
–
Sales mix
—
United States
—
GM%
—
Units
—
vs Replan
–
vs LW
–
vs LY
–
Sales mix
—
New Zealand
—
GM%
—
Units
—
vs Replan
–
vs LW
–
vs LY
–
Sales mix
—
Regional deep-dive
Week 38 FY26
...
Product insights
Week 38 FY26
...
<
GMROI kill candidates
GMROI <0.3 with SOH >20 — poor return per $1 of stock
| SKU | Product | Category | GMROI | SOH | Sales $ | Wks cvr |
|---|
Back-in-stock demand — unsent notifications
Customers waiting. High unsent + zero SOH = urgent PO.
| SKU | Product | Colour | Unsent | Units TW | SOH | Next recv |
|---|
Weighted size availability
Demand-weighted — more accurate than simple size availability
Overall weighted size avail
—
Core vs non-core
Week 38 FY26 — product status performance
Sales by product status tag
Core % by category — target ~40%
Tag breakdown with sales
Core % by category
| Category | Total $ | Core $ | Core % | Status |
|---|
⚠ Potential new core — non-core top sellers
High-performing styles not yet tagged as Core — consider promoting in SA
—
⚠ High-risk core — elevated returns
Core styles with >25% return rate risk brand perception
—
Weekly sales by category
TW actuals vs LW, LY, Budget & Replan — by category
Performance flags
KPI scorecard vs targets — Week 38
KPI scorecard
Health summary
Stock & coverage
SOH @ cost
$8.0M
Enter LW in data entry
SOH @ retail
$30.8M
—
SOH units
412,519
—
Weeks cover
38.9
—
Target <20
Category KPI flags
✗ Hard fail: GP<55% / sales <−40% LY / WOC>50 / replan <−20%
⚠ 1–2 marginal signals
✓ All OK
Hover status icon for detail
| Category | TW $ | GM% | Wks cover | SOH units | vs LW% | vs LY% | Replan | vs Replan | Budget | Status |
|---|
ℹ How to use this document Click to expand
📁 Files to upload each week
SA Dashboard Dump (TY) — from Saledock/SA: all channels combined, AUD, current week. Replaces per-region files.
SA Dashboard Dump (LY) — same format, same week last year. Gives LY comparisons across all tabs.
SA Rollup (optional) — product-level rollup from SA. Needed for Ranges, Returns 12wk, and RRP analysis.
Note: US/NZ figures in the SA export are already AUD-converted. Do not apply your own FX rate.
⌨ Manual fields to enter (this tab)
• Replan, Budget, LY sales — from MFP / Planning Summary weekly
• Season to date (STD) — from MFP only (SA does not carry cumulative STD)
• SOH LW fields — enter last week's SOH cost, retail and units for WoW stock comparison
• Region replans — AU/US/NZ replan targets if tracked separately
• Return rate (dashboard) — from Planning Summary trade summary tab (more accurate than SA average)
Press Apply after entering to update all cards.
📋 Tab guide
Dashboard — weekly KPIs, benchmarks, trend
Regions — AU/US/NZ deep-dive
Products — top sellers, GMROI, BIS
Product summary — new arrivals, top 30, STD by category
Core — core vs non-core analysis, Prom tiers
Flags — KPI scorecard with red/amber/green status
Traffic — impressions, PV, conversion
Returns — return rate by category, 12wk trend
RRP — price architecture, band performance
Retail — AU and US retail channel
Ranges — multi-colour range performance
Actions — priority actions + team notes
📊 Upload SA files — Week ?
Upload the two SA dashboard dump CSVs to populate all detail tabs. Data is saved in your browser.
TY File (This Year)
Weekly_Dashboard_Data_Dump_WKXX_TY_Sales.csv
No file selected
LY File (Last Year)
Weekly_Dashboard_Data_Dump_WKXX_LY_Sales.csv
No file selected
Sales performance
GM, ASP & units
FP / Markdown
Operational KPIs
Region — weekly
AUSTRALIA
UNITED STATES
NEW ZEALAND
Season to date
Lifecycle & other
Category breakdown — TW actuals + replan/budget
Enter replan and budget per category from MFP. Actuals pulled from SA data.
| Category | Sales $ | Units | GM% | vs LW $ | vs LY $ | Replan $ | Budget $ | vs Replan |
|---|
Import CSV data
TY Sales CSV
LY Sales CSV
Populates all KPIs, region splits, category breakdown and analytics. Only replan & budget need manual entry.
Week details
Week archive
1 week saved
How saving works: Weekly KPIs and actions are saved to this browser automatically.
To share with teammates or move to another device, use Export all weeks — paste the data into any copy of this file.
| Week | Dates | Sales $ | vs LW | vs LY | vs Replan | GM% | Units | ASP | FP mix | WOC | Returns% |
|---|
Sales trend — achieved vs replan vs LW
MFP bridge
Pre-formatted values for your MFP data dump tab
WK38 values
Metric
Value
MFP field
Export
Field mappings
Edit to match your exact MFP column names
Product summary
Week 38 FY26 — from product summary file
New arrivals — WK? launch summary
Styles launched
—
LW: — styles
Total sales $
—
LW: —
Units sold
—
LW: —
Total intake
—
LW: —
Avg ST%
—
LW: —
Production %
93%
of launched styles
AU new reads
— of sales · — of units
—
US new reads
— of sales · — of units
—
NZ new reads
— of sales · — of units
—
— styles launched this week
| SKU | Description | Colour | RRP | Sales $ | Units | Intake | SOH | ST% | Wks cvr | Wk recv | GP% |
|---|
Top 30 performers
| # | SKU | Style name | Colour | RRP | Sales $ | Units | PV | Returns | Ret% | SOH | Wks cvr | IM% | Next recv | Future PO |
|---|
Back in stock performance
— styles · — sales · — units
BIS total sales
—
Upload product summary to populate
Units sold
380
from 382 intake this week
Best BIS style
—
Upload product summary to populate
| SKU | Description | Intake LW | Units sold | Sales $ | ST% | SOH | Wks cvr | Future PO |
|---|
RRP performance — sales, stock-to-sales & sell-through by price point
Where is the business performing? Where is stock sitting?
| RRP band | Styles | Sales $ | Units sold | SOH units | Avail to sell | Wks cover | ST% | Return% | GP% | Page views |
|---|
High availability, low sell-through — stock at risk
Styles with strong availability but <5% sell-through — consider markdown, promo or lifecycle action
| SKU | Product | Colour | Category | RRP | Avail to sell | SOH | ST% | Sales $ | Wks cvr | GP% |
|---|
Season to date — by category (Source: MFP / Planning Summary)
STD units and to-date sell-through by category
| Category | STD units (from SA) | TW sales $ | TW units | STD ST% | SOH | STD sales $ — enter from MFP |
|---|
Traffic & digital
Week 38 FY26
...
YoY by category — sales & GP%
| Category | TW $ | LW $ | LY $ | vs LW% | vs LY% | Replan var | TW GP% | LY GP% | GP pts LY | TW PV | LW PV | PV var% |
|---|
Traffic funnel
GP per 1000 impressions — by category
Traffic by category — TW
| Category | Impressions | Page views | CTR% | Conv% | GP/1k imp | Sales $ |
|---|
Traffic by end use — impressions, conversion & return rate
Key insight: Formal drives highest traffic but lower conversion than Party/Day — review merchandising and imagery
| End use | Impressions | Page views | CTR% | Conv% | Sales $ | GP% | Return% |
|---|
RRP performance — sales, traffic & conversion by price point
| RRP | Styles | Sales $ | Units | ST% | Page views | Conv% | Return% | GP% |
|---|
Top products by page views
| SKU | Product | PV | Impressions | CTR% | Conv% | GP/1k imp | Sales $ | Return% |
|---|
High traffic, low conversion — opportunity styles
Strong traffic but underperforming conversion — review imagery, sizing guidance and copy
| SKU | Product | PV | CTR% | Conv% | Sales $ |
|---|
Returns detail
Week 38 FY26
...
Return rate: this week vs 12-week average — by category
Persistent problems show high 12wk rate regardless of this week. Watch for divergence.
| Category | TW rate | 12-wk avg | LY 12-wk avg | vs LY 12wk | TW vs 12wk trend | Returned |
|---|
Persistent high-return styles (12wk >25%)
Styles with consistently high returns — not just this week
| SKU | Product | Colour | Category | 12wk% | TW% | Trend | Sales $ |
|---|
Return rate by category
| Category | Ret units | Sales units | TW Ret% | LY Ret% | vs LY | Sales $ | vs target |
|---|
Return rate by end use
| End use | Return units | Sales $ | Return rate% | Risk |
|---|
High risk styles — action required
Products with return rate >25% and 3+ returned units this week
| SKU | Product | Colour | Category | End use | Return rate% | Returned TW | All time | Sales $ | GP% | Size avail% | First size broke |
|---|
Actions & follow-ups
Week 38 FY26
...
Auto-generated priority actions
Based on this week's data — click any to add to your action list
Action list — Week 38
| # | Action | Category | Assigned to | Due date | Priority | Status |
|---|
Tab between cells to edit. Changes are saved when you click Save actions.
Team notes & call-outs
Notes auto-save per week · Cmd/Ctrl+Enter to save individual sections
RRP analysis
Week 38 FY26 — price architecture & performance
...
Price architecture — TW vs LY
How sales mix, conversion and ASP have shifted vs last year across price bands
Sales mix shift — TW vs LY
Conversion rate — TW vs LY
ASP vs RRP — TW vs LY discount depth
Revenue per style — productivity
| Band | Sales TW | Sales LY | vs LY | Mix TW | Mix LY | Mix shift | Styles TW | Styles LY | $/style TW | $/style LY | ASP TW | ASP LY | RRP avg | Conv TW | Conv LY | SOH | Wks cvr | GP% TW | GP% LY | Signal |
|---|
Sales performance by RRP band
Stock-to-sales = weeks of SOH at current sell rate · Lower is better
| RRP band | Styles | Sales $ TW | Sales $ LY | Units | Avg RRP | ASP (LY below) | ASP vs RRP | Wks cover | LY woc | GP% TW | GP% LY | FP units | MD units | ST% | Return% | MD mix% | MD depth% | Page views | Conv% |
|---|
Sales by RRP band
Weeks cover by RRP band
GP% & ST% by band
RRP distribution by category
Retail performance
Week 38 FY26 — in-store channels
...
AU vs US retail — sales split
Category breakdown
FP vs MD units — retail
AU Retail
By category
| Category | Sales $ | Units | GP% | MD% | Ret% | Disc $ |
|---|
Top products
| SKU | Product | Colour | Sales | Units | GP% | Ret% | GMROI |
|---|
US Retail
By category
| Category | Sales $ | Units | GP% | MD% | Ret% | Disc $ |
|---|
Top products
| SKU | Product | Colour | Sales | Units | GP% | Ret% | GMROI |
|---|
Ranges by colour family
Week 38 FY26 — multi-colour range performance